exploring JSON

now i'm exploring json. storing this url for future reference:

http://www.learn-ajax-tutorial.com/Json.cfm
http://www.w3schools.com/jsref/jsref_encodeuricomponent.asp
http://www.php.net/manual/en/function.json-decode.php

mysql storage engine

searching for memory storage engine

storing this for future reference;
http://jonathanhui.com/mysql-storage-engine

[Howto] Astro Beyond Remote Control

Do you know that your white astro remote control able to control power off and volume control?
Here you go:

i'm taking this article from other website for my reference and faster search also.

1. Press power button + OK until remote indicator light blink twice. (Edit Mode)
2. Enter 4 digit TV Codes (Refer tables)
3. To reset, enter Edit Mode (1) and press 977

Astro Beyond TV Codes

SAMSUNG	0060 0812 0618 0178 0587 0009 0093 0556 1235 0108 0037 0217 0264 0370 0072 0156 1208 0766 0814 0216 0290 0821 0163
SONY	1825 1505 0011 1651 0036 0650 1010 0037 0056 0093 0170 0074
PHILIPS	0037 0556 1744 0772 1246 1304 0178 0108 0195 0087 0374 0760 0343 0595 0009 0200 0361 1521
PANASONIC	0650 0226 1650 1636 0108 1310 0037 0556 0163 1208 0508 0896 0361 0853 1335 0367 0516 0548 0001
TOSHIBA	1508 (MY TV) 0508 0060 0009 0714 0036 0156 1656 0070 0093 2060 0264 1935 0412 1164 0618 1582 0650 0821 1704 0217 0109 1457 1916 1908 0698 0037 0736 1556 1037
LG	1423 0001 0178 0037 0556 0876 0370 1768 0377 0009 0714 0060 0217 0108 0216 0290 0163 0606 0109 0689 0715 0823 0829 1556 1191 0247 0367 1681 1539
PIONEER	1260 0760 0011 1070 1457 0698 0109 0037 0287 0556 0428 0370 0343 0361 0486 0512
SHARP	0093 0009 1393 0036 0491 0818 0256 1819 0650 0294 0653 0412 0516 0200 0760 2214
JVC	0653 1818 0036 1153 0606 1653 0371 0508 0731 0683 0192 0218 0418 0093 0650

 

Alternatively:

To control volume press OK + Vol Up to control TV volume

or OK + Vol Down to use default astro setting.

article ref: http://stinkyfruit.wordpress.com/2010/02/13/astro-b-yond-volume-control/

jquery selector

http://www.w3schools.com/jquery/jquery_ref_selectors.asp

exploring jquery selector. storing for future reference.

mysql index technique

http://www.w3schools.com/sql/sql_create_index.asp

My idea; field index just for frequently used table for searching. since updating is slow, (see note) no index for frequently updated data .

Indexes allow the database application to find data fast; without reading the whole table.


Note: Updating a table with indexes takes more time than updating a table without (because the indexes also need an update). So you should only create indexes on columns (and tables) that will be frequently searched against.