{"id":23362,"date":"2019-06-29T08:18:00","date_gmt":"2019-06-29T01:18:00","guid":{"rendered":"http:\/\/tom.ji42.com\/?p=23362"},"modified":"2019-06-29T08:18:00","modified_gmt":"2019-06-29T01:18:00","slug":"%e0%b8%9b%e0%b8%b1%e0%b8%8d%e0%b8%ab%e0%b8%b2%e0%b8%a0%e0%b8%b2%e0%b8%a9%e0%b8%b2%e0%b9%84%e0%b8%97%e0%b8%a2-php-%e0%b8%81%e0%b8%b1%e0%b8%9a-mysql","status":"publish","type":"post","link":"https:\/\/tom.tomwork.net\/?p=23362","title":{"rendered":"\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22 PHP \u0e01\u0e31\u0e1a MySQL ??????????"},"content":{"rendered":"<p><strong>\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21 PHP &amp; MySQL<\/strong><\/p>\n<div class=\"code\"><span class=\"notranslate\"><span class=\"fontcode\"><a href=\"https:\/\/www.thaicreate.com\/php\/php-mysql.html\" target=\"blank\" rel=\"noopener noreferrer\">https:\/\/www.thaicreate.com\/php\/php-mysql.html<\/a><\/span><\/span><\/div>\n<p>\u0e40\u0e2b\u0e15\u0e38\u0e1c\u0e25\u0e17\u0e35\u0e48\u0e1c\u0e21\u0e17\u0e33\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21\u0e19\u0e35\u0e49\u0e02\u0e36\u0e49\u0e19\u0e01\u0e47\u0e01\u0e47\u0e40\u0e1e\u0e23\u0e32\u0e30\u0e21\u0e35\u0e01\u0e23\u0e30\u0e17\u0e39\u0e49\u0e16\u0e32\u0e21\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e01\u0e31\u0e1a\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22 ?????? \u0e17\u0e38\u0e01\u0e27\u0e31\u0e19\u0e04\u0e23\u0e31\u0e1a \u0e41\u0e25\u0e30\u0e40\u0e1b\u0e47\u0e19\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e17\u0e35\u0e48\u0e41\u0e01\u0e49\u0e44\u0e21\u0e48\u0e08\u0e1a\u0e0b\u0e30\u0e17\u0e35\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e1c\u0e39\u0e49\u0e17\u0e35\u0e48 \u0e01\u0e33\u0e25\u0e31\u0e07\u0e40\u0e23\u0e34\u0e48\u0e21\u0e40\u0e02\u0e35\u0e22\u0e19\u00a0<strong>MySQL<\/strong>\u00a04.1.x \u0e41\u0e25\u0e30 5.0.x \u0e02\u0e36\u0e49\u0e19\u0e44\u0e1b \u0e40\u0e1e\u0e23\u0e32\u0e30\u0e43\u0e19\u0e40\u0e27\u0e2d\u0e23\u0e4c\u0e0a\u0e31\u0e48\u0e19\u0e43\u0e2b\u0e21\u0e48\u0e19\u0e35\u0e49 \u0e17\u0e32\u0e07\u00a0<strong>MySQL<\/strong>\u00a0\u0e44\u0e14\u0e49\u0e43\u0e2b\u0e49\u0e04\u0e27\u0e32\u0e21\u0e2a\u0e33\u0e04\u0e31\u0e0d\u0e01\u0e31\u0e1a Charset \u0e21\u0e32\u0e01\u0e02\u0e36\u0e49\u0e19\u0e01\u0e27\u0e48\u0e32\u0e40\u0e27\u0e2d\u0e23\u0e4c\u0e0a\u0e31\u0e48\u0e19 \u0e40\u0e14\u0e34\u0e21 \u0e46 \u0e01\u0e48\u0e2d\u0e19\u0e2b\u0e19\u0e49\u0e32\u0e19\u0e35\u0e49\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32 \u0e46 \u0e43\u0e0a\u0e49 latin1 \u0e43\u0e19\u0e01\u0e32\u0e23\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22\u0e0b\u0e36\u0e48\u0e07\u0e08\u0e30\u0e21\u0e35\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e04\u0e48\u0e2d\u0e19\u0e02\u0e49\u0e32\u0e07\u0e1a\u0e48\u0e2d\u0e22\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e01\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e41\u0e2a\u0e14\u0e07\u0e1c\u0e25\u0e17\u0e35\u0e48\u0e1c\u0e34\u0e14\u0e40\u0e1e\u0e35\u0e49\u0e22\u0e19 \u0e01\u0e32\u0e23\u0e08\u0e31\u0e14\u0e40\u0e23\u0e35\u0e22\u0e07\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e16\u0e39\u0e01\u0e15\u0e49\u0e2d\u0e07 \u0e41\u0e25\u0e30\u0e04\u0e27\u0e32\u0e21\u0e08\u0e33\u0e01\u0e31\u0e14\u0e17\u0e32\u0e07\u0e14\u0e49\u0e32\u0e19\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e2b\u0e25\u0e32\u0e22 \u0e46 \u0e20\u0e32\u0e29\u0e32 \u0e17\u0e31\u0e49\u0e07\u0e19\u0e35\u0e49\u0e1c\u0e21\u0e04\u0e34\u0e14\u0e27\u0e48\u0e32\u0e01\u0e32\u0e23\u0e19\u0e33 Chatset \u0e21\u0e32\u0e43\u0e0a\u0e49 \u0e17\u0e32\u0e07 mySQL \u0e40\u0e2d\u0e07\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e41\u0e01\u0e49\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e17\u0e35\u0e48\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e02\u0e49\u0e2d\u0e07\u0e01\u0e31\u0e1a\u0e20\u0e32\u0e29\u0e32\u0e01\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19 Application \u0e2d\u0e37\u0e48\u0e19 \u0e46 \u0e17\u0e35\u0e48\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e23\u0e39\u0e1b\u0e41\u0e1a\u0e1a\u00a0<strong>UTF-8<\/strong>\u00a0\u0e44\u0e1b\u0e2b\u0e21\u0e14\u0e41\u0e25\u0e49\u0e27 \u0e04\u0e07\u0e08\u0e30\u0e40\u0e2b\u0e25\u0e37\u0e2d\u0e41\u0e15\u0e48\u0e04\u0e19\u0e44\u0e17\u0e22\u0e2a\u0e48\u0e27\u0e19\u0e21\u0e32\u0e01\u0e17\u0e35\u0e48\u0e22\u0e31\u0e07\u0e04\u0e07\u0e22\u0e36\u0e14\u0e15\u0e36\u0e14\u0e01\u0e31\u0e1a\u00a0<strong>TIS-620<\/strong>\u00a0\u0e16\u0e36\u0e07\u0e04\u0e23\u0e32\u0e27\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e08\u0e30\u0e15\u0e49\u0e2d\u0e07\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e21\u0e32\u0e43\u0e0a\u0e49 UTF-8 \u0e01\u0e31\u0e19\u0e44\u0e14\u0e49\u0e41\u0e25\u0e49\u0e27\u0e04\u0e23\u0e31\u0e1a \u0e41\u0e25\u0e30\u0e1c\u0e21\u0e01\u0e25\u0e49\u0e32\u0e23\u0e31\u0e1a\u0e1b\u0e23\u0e30\u0e01\u0e31\u0e19\u0e40\u0e25\u0e22\u0e04\u0e23\u0e31\u0e1a\u0e27\u0e48\u0e32 \u0e21\u0e31\u0e19\u0e14\u0e35\u0e01\u0e27\u0e48\u0e32\u0e40\u0e14\u0e34\u0e21 \u0e08\u0e30\u0e0a\u0e48\u0e27\u0e22\u0e25\u0e14\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e15\u0e48\u0e32\u0e07 \u0e46 \u0e17\u0e35\u0e48\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e01\u0e31\u0e1a\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22\u0e44\u0e14\u0e49\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e2b\u0e21\u0e14\u0e40\u0e01\u0e25\u0e35\u0e49\u0e22\u0e07 \u0e04\u0e23\u0e31\u0e1a<\/p>\n<p><!--more--><br \/>\n\u0e16\u0e36\u0e07\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21\u0e19\u0e35\u0e49\u0e08\u0e30\u0e21\u0e35\u0e43\u0e2b\u0e49\u0e40\u0e25\u0e37\u0e2d\u0e01\u0e43\u0e0a\u0e49\u0e17\u0e31\u0e49\u0e07\u00a0<strong>TIS-620 \u0e41\u0e25\u0e30 UTF-8<\/strong>\u00a0\u0e41\u0e15\u0e48\u0e1c\u0e21\u0e22\u0e31\u0e07\u0e41\u0e19\u0e30\u0e19\u0e33\u0e43\u0e2b\u0e49\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e43\u0e2b\u0e49\u0e40\u0e1b\u0e47\u0e19\u00a0<strong>UTF-8<\/strong>\u00a0\u0e43\u0e2b\u0e49\u0e2b\u0e21\u0e14\u0e04\u0e23\u0e31\u0e1a<\/p>\n<p><u><strong>1. \u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22\u0e01\u0e31\u0e1a TIS-620<\/strong><\/u><\/p>\n<p>\u0e43\u0e19\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u00a0<strong>Collation<\/strong>\u00a0\u0e02\u0e2d\u0e07\u00a0<strong>TIS-620<\/strong>\u00a0\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e2b\u0e23\u0e37\u0e2d\u0e41\u0e21\u0e49\u0e41\u0e15\u0e48\u0e1f\u0e34\u0e27\u0e2a\u0e4c\u0e43\u0e2b\u0e49\u0e43\u0e0a\u0e49\u0e40\u0e1b\u0e47\u0e19\u00a0<strong>tis620_thai_ci<\/strong>\u00a0\u0e41\u0e25\u0e30\u0e43\u0e19\u0e01\u0e32\u0e23 Import \u0e2b\u0e23\u0e37\u0e2d Export \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e01\u0e47\u0e08\u0e30\u0e15\u0e49\u0e2d\u0e07\u0e43\u0e0a\u0e49\u0e40\u0e1b\u0e47\u0e19\u00a0<strong>tis620<\/strong>\u00a0\u0e40\u0e0a\u0e48\u0e19\u0e40\u0e14\u0e35\u0e22\u0e27\u0e01\u0e31\u0e19\u0e04\u0e23\u0e31\u0e1a \u0e15\u0e32\u0e21\u0e23\u0e39\u0e1b\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e04\u0e23\u0e31\u0e1a<\/p>\n<p><img decoding=\"async\" class=\"resize\" title=\"PHP MySQL (Thai)\" src=\"https:\/\/www.thaicreate.com\/upload\/community\/tis620-1.jpg?v=1001\" alt=\"PHP MySQL (Thai)\" border=\"0\" \/><\/p>\n<p><strong>\u0e01\u0e33\u0e2b\u0e19\u0e14 Collation \u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07<\/strong><\/p>\n<p><img decoding=\"async\" class=\"resize\" title=\"PHP MySQL (Thai)\" src=\"https:\/\/www.thaicreate.com\/upload\/community\/tis620-2.jpg?v=1001\" alt=\"PHP MySQL (Thai)\" border=\"0\" \/><\/p>\n<p><strong>\u0e01\u0e33\u0e2b\u0e19\u0e14 Collation \u0e02\u0e2d\u0e07\u0e1f\u0e34\u0e27\u0e2a\u0e4c<\/strong><\/p>\n<p><img decoding=\"async\" class=\"resize\" title=\"PHP MySQL (Thai)\" src=\"https:\/\/www.thaicreate.com\/upload\/community\/tis620-4.jpg?v=1001\" alt=\"PHP MySQL (Thai)\" border=\"0\" \/><\/p>\n<p><strong>\u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e21\u0e35\u0e01\u0e32\u0e23 import \u0e2b\u0e23\u0e37\u0e2d Export \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e43\u0e2b\u0e49\u0e40\u0e25\u0e37\u0e2d\u0e01\u0e40\u0e1b\u0e47\u0e19 tis620<\/strong><\/p>\n<p><strong>1.2<\/strong>\u00a0\u0e01\u0e33\u0e2b\u0e19\u0e14 Header \u0e43\u0e2b\u0e49\u0e43\u0e0a\u0e49\u0e40\u0e1b\u0e47\u0e19 tis-620<\/p>\n<div class=\"code\"><span class=\"notranslate\"><span class=\"fontcode\">&lt;meta http-equiv=Content-Type content=&#8221;text\/html; charset=tis-620&#8243;&gt;<\/span><\/span><\/div>\n<p><strong>1.3<\/strong>\u00a0\u0e01\u0e33\u0e2b\u0e19\u0e14\u0e43\u0e19\u0e2a\u0e48\u0e27\u0e19\u0e02\u0e2d\u0e07 Connection<\/p>\n<div class=\"code\"><span class=\"notranslate\"><span class=\"fontcode\">&#8211; \u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 Collation \u0e40\u0e1b\u0e47\u0e19 tis620_thai_ci \u0e43\u0e2b\u0e49\u0e43\u0e0a\u0e49<br \/>\n$objConnect = mysql_connect(&#8220;localhost&#8221;,&#8221;root&#8221;,&#8221;root&#8221;) or die(&#8220;Error Connect to Database&#8221;);<br \/>\n$objDB = mysql_select_db(&#8220;mydatabase&#8221;);<br \/>\n<strong>mysql_query(&#8220;SET NAMES TIS620&#8221;);<\/strong><\/p>\n<p>&#8211; \u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 Collation \u0e2d\u0e37\u0e48\u0e19 \u0e46 \u0e43\u0e2b\u0e49\u0e43\u0e0a\u0e49<br \/>\n$objConnect = mysql_connect(&#8220;localhost&#8221;,&#8221;root&#8221;,&#8221;root&#8221;) or die(&#8220;Error Connect to Database&#8221;);<br \/>\n$objDB = mysql_select_db(&#8220;mydatabase&#8221;);<br \/>\n<strong>mysql_query(&#8220;SET character_set_results=tis620&#8221;);<br \/>\nmysql_query(&#8220;SET character_set_client=tis620&#8221;);<br \/>\nmysql_query(&#8220;SET character_set_connection=tis620&#8221;);<\/strong><\/span><\/span><\/div>\n<p><strong>\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 Code \u0e40\u0e15\u0e47\u0e21 \u0e46 \u0e04\u0e23\u0e31\u0e1a<\/strong><\/p>\n<div id=\"highlighter_139964\" class=\"syntaxhighlighter \">\n<div class=\"lines\">\n<div class=\"line alt1\"><code class=\"number\">01.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;html&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">02.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;head&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">03.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;title&gt;ThaiCreate.Com PHP &amp; TIS-620&lt;\/title&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">04.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;meta http-equiv=Content-Type content=<\/code><code class=\"string\">\"text\/html; charset=tis-620\"<\/code><code class=\"plain\">&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">05.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/head&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">06.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;body&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">07.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;?php\u00a0\u00a0\u00a0<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">08.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/*** Connect ***\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">09.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$objConnect<\/code>\u00a0<code class=\"plain\">= mysql_connect(<\/code><code class=\"string\">\"localhost\"<\/code><code class=\"plain\">,<\/code><code class=\"string\">\"root\"<\/code><code class=\"plain\">,<\/code><code class=\"string\">\"root\"<\/code><code class=\"plain\">)\u00a0<\/code><code class=\"keyword\">or<\/code>\u00a0<code class=\"keyword\">die<\/code><code class=\"plain\">(<\/code><code class=\"string\">\"Error Connect to Database\"<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">10.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$objDB<\/code>\u00a0<code class=\"plain\">= mysql_select_db(<\/code><code class=\"string\">\"mydatabase\"<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">11.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">mysql_query(<\/code><code class=\"string\">\"SET NAMES TIS620\"<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">12.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/*<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">13.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/\/ Or \/\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">14.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">mysql_query(\"SET character_set_results=tis620\");<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">15.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">mysql_query(\"SET character_set_client=tis620\");<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">16.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">mysql_query(\"SET character_set_connection=tis620\");<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">17.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">*\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">18.<\/code><span class=\"content\"><span class=\"block\">\u00a0<\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">19.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/***\u00a0 Add Record ***\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">20.<\/code><span class=\"content\"><span class=\"block\"><code class=\"keyword\">if<\/code><code class=\"plain\">(<\/code><code class=\"variable\">$_GET<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"Action\"<\/code><code class=\"plain\">]==<\/code><code class=\"string\">\"Save\"<\/code><code class=\"plain\">)<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">21.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">{<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">22.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$strSQL<\/code>\u00a0<code class=\"plain\">=\u00a0<\/code><code class=\"string\">\"INSERT INTO mydata_tis620 (NAME,SURNAME) VALUES ('\"<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"txtName\"<\/code><code class=\"plain\">].<\/code><code class=\"string\">\"','\"<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"txtSurname\"<\/code><code class=\"plain\">].<\/code><code class=\"string\">\"')\"<\/code><code class=\"plain\">;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">23.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">mysql_query(<\/code><code class=\"variable\">$strSQL<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">24.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">}<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">25.<\/code><span class=\"content\"><span class=\"block\">\u00a0<\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">26.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/*** List Record ***\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">27.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$strSQL<\/code>\u00a0<code class=\"plain\">=\u00a0<\/code><code class=\"string\">\"SELECT * FROM mydata_tis620\"<\/code><code class=\"plain\">;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">28.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$objQuery<\/code>\u00a0<code class=\"plain\">= mysql_query(<\/code><code class=\"variable\">$strSQL<\/code><code class=\"plain\">)\u00a0<\/code><code class=\"keyword\">or<\/code>\u00a0<code class=\"keyword\">die<\/code>\u00a0<code class=\"plain\">(<\/code><code class=\"string\">\"Error Query [\"<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$strSQL<\/code><code class=\"plain\">.<\/code><code class=\"string\">\"]\"<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">29.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">?&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">30.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;table width=<\/code><code class=\"string\">\"498\"<\/code>\u00a0<code class=\"plain\">border=<\/code><code class=\"string\">\"1\"<\/code><code class=\"plain\">&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">31.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">32.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;th width=<\/code><code class=\"string\">\"87\"<\/code><code class=\"plain\">&gt; &lt;div align=<\/code><code class=\"string\">\"center\"<\/code><code class=\"plain\">&gt;UID &lt;\/div&gt;&lt;\/th&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">33.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;th width=<\/code><code class=\"string\">\"145\"<\/code><code class=\"plain\">&gt; &lt;div align=<\/code><code class=\"string\">\"center\"<\/code><code class=\"plain\">&gt;NAME &lt;\/div&gt;&lt;\/th&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">34.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;th width=<\/code><code class=\"string\">\"244\"<\/code><code class=\"plain\">&gt; &lt;div align=<\/code><code class=\"string\">\"center\"<\/code><code class=\"plain\">&gt;SURNAME &lt;\/div&gt;&lt;\/th&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">35.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">36.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;?php<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">37.<\/code><span class=\"content\"><span class=\"block\"><code class=\"keyword\">while<\/code><code class=\"plain\">(<\/code><code class=\"variable\">$objResult<\/code>\u00a0<code class=\"plain\">= mysql_fetch_array(<\/code><code class=\"variable\">$objQuery<\/code><code class=\"plain\">))<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">38.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">{<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">39.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">?&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">40.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">41.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;div align=<\/code><code class=\"string\">\"center\"<\/code><code class=\"plain\">&gt;&lt;?php\u00a0<\/code><code class=\"functions\">echo<\/code>\u00a0<code class=\"variable\">$objResult<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"UID\"<\/code><code class=\"plain\">];?&gt;&lt;\/div&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">42.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;?php\u00a0<\/code><code class=\"functions\">echo<\/code>\u00a0<code class=\"variable\">$objResult<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"NAME\"<\/code><code class=\"plain\">];?&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">43.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;?php\u00a0<\/code><code class=\"functions\">echo<\/code>\u00a0<code class=\"variable\">$objResult<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"SURNAME\"<\/code><code class=\"plain\">];?&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">44.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">45.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;?php<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">46.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">}<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">47.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">?&gt;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">48.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;form name=<\/code><code class=\"string\">\"frmMain\"<\/code>\u00a0<code class=\"plain\">method=<\/code><code class=\"string\">\"post\"<\/code>\u00a0<code class=\"plain\">action=<\/code><code class=\"string\">\"?Action=Save\"<\/code><code class=\"plain\">&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">49.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">50.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">51.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">52.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;input name=<\/code><code class=\"string\">\"txtName\"<\/code>\u00a0<code class=\"plain\">type=<\/code><code class=\"string\">\"text\"<\/code>\u00a0<code class=\"plain\">id=<\/code><code class=\"string\">\"txtName\"<\/code><code class=\"plain\">&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">53.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;input name=<\/code><code class=\"string\">\"txtSurname\"<\/code>\u00a0<code class=\"plain\">type=<\/code><code class=\"string\">\"text\"<\/code>\u00a0<code class=\"plain\">id=<\/code><code class=\"string\">\"txtSurname\"<\/code><code class=\"plain\">&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">54.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;input name=<\/code><code class=\"string\">\"btnSubmit\"<\/code>\u00a0<code class=\"plain\">type=<\/code><code class=\"string\">\"submit\"<\/code>\u00a0<code class=\"plain\">id=<\/code><code class=\"string\">\"btnSubmit\"<\/code>\u00a0<code class=\"plain\">value=<\/code><code class=\"string\">\"Submit\"<\/code><code class=\"plain\">&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">55.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">56.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/form&gt;\u00a0\u00a0\u00a0\u00a0<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">57.<\/code><span class=\"content\"><span class=\"block\">\u00a0<\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">58.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/table&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">59.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;?php<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">60.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">mysql_close(<\/code><code class=\"variable\">$objConnect<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">61.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">?&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">62.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/body&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">63.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/html&gt;<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<p><u><strong>Output<\/strong><\/u><\/p>\n<p><img decoding=\"async\" class=\"resize\" title=\"PHP MySQL (Thai)\" src=\"https:\/\/www.thaicreate.com\/upload\/community\/tis620-3.jpg?v=1001\" alt=\"PHP MySQL (Thai)\" border=\"0\" \/><\/p>\n<div class=\"box effect7\"><center><\/p>\n<p><\/center><\/div>\n<p><u><strong>2. \u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22\u0e01\u0e31\u0e1a UTF-8<\/strong><\/u><\/p>\n<p>\u0e43\u0e19\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u00a0<strong>Collation<\/strong>\u00a0\u0e02\u0e2d\u0e07\u00a0<strong>UTF-8<\/strong>\u00a0\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07\u0e2b\u0e23\u0e37\u0e2d\u0e41\u0e21\u0e49\u0e41\u0e15\u0e48\u0e1f\u0e34\u0e27\u0e2a\u0e4c\u0e43\u0e2b\u0e49\u0e43\u0e0a\u0e49\u0e40\u0e1b\u0e47\u0e19\u00a0<strong>utf8_unicode_ci<\/strong>\u00a0\u0e41\u0e25\u0e30\u0e43\u0e19\u0e01\u0e32\u0e23 Import \u0e2b\u0e23\u0e37\u0e2d Export \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e01\u0e47\u0e08\u0e30\u0e15\u0e49\u0e2d\u0e07\u0e43\u0e0a\u0e49\u0e40\u0e1b\u0e47\u0e19\u00a0<strong>utf8<\/strong>\u00a0\u0e40\u0e0a\u0e48\u0e19\u0e40\u0e14\u0e35\u0e22\u0e27\u0e01\u0e31\u0e19\u0e04\u0e23\u0e31\u0e1a \u0e15\u0e32\u0e21\u0e23\u0e39\u0e1b\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e04\u0e23\u0e31\u0e1a<\/p>\n<p><img decoding=\"async\" class=\"resize\" title=\"PHP MySQL (Thai)\" src=\"https:\/\/www.thaicreate.com\/upload\/community\/utf8-1.jpg?v=1001\" alt=\"PHP MySQL (Thai)\" border=\"0\" \/><\/p>\n<p><strong>\u0e01\u0e33\u0e2b\u0e19\u0e14 Collation \u0e02\u0e2d\u0e07\u0e15\u0e32\u0e23\u0e32\u0e07<\/strong><\/p>\n<p><img decoding=\"async\" class=\"resize\" title=\"PHP MySQL (Thai)\" src=\"https:\/\/www.thaicreate.com\/upload\/community\/utf8-2.jpg?v=1001\" alt=\"PHP MySQL (Thai)\" border=\"0\" \/><\/p>\n<p><strong>\u0e01\u0e33\u0e2b\u0e19\u0e14 Collation \u0e02\u0e2d\u0e07\u0e1f\u0e34\u0e27\u0e2a\u0e4c<\/strong><\/p>\n<p><img decoding=\"async\" class=\"resize\" title=\"PHP MySQL (Thai)\" src=\"https:\/\/www.thaicreate.com\/upload\/community\/utf8-4.jpg?v=1001\" alt=\"PHP MySQL (Thai)\" border=\"0\" \/><\/p>\n<p><strong>\u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e21\u0e35\u0e01\u0e32\u0e23 import \u0e2b\u0e23\u0e37\u0e2d Export \u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e43\u0e2b\u0e49\u0e40\u0e25\u0e37\u0e2d\u0e01\u0e40\u0e1b\u0e47\u0e19 utf8<\/strong><\/p>\n<p><strong>2.2<\/strong>\u00a0\u0e01\u0e33\u0e2b\u0e19\u0e14 Header \u0e43\u0e2b\u0e49\u0e43\u0e0a\u0e49\u0e40\u0e1b\u0e47\u0e19 utf-8<\/p>\n<div class=\"code\"><span class=\"notranslate\"><span class=\"fontcode\">&lt;meta http-equiv=Content-Type content=&#8221;text\/html; charset=<strong>utf-8<\/strong>&#8220;&gt;<\/span><\/span><\/div>\n<p><strong>2.3<\/strong>\u00a0\u0e01\u0e33\u0e2b\u0e19\u0e14\u0e43\u0e19\u0e2a\u0e48\u0e27\u0e19\u0e02\u0e2d\u0e07 Connection<\/p>\n<div class=\"code\"><span class=\"notranslate\"><span class=\"fontcode\">&#8211; \u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 Collation \u0e40\u0e1b\u0e47\u0e19 utf8_unicode_ci \u0e43\u0e2b\u0e49\u0e43\u0e0a\u0e49<br \/>\n$objConnect = mysql_connect(&#8220;localhost&#8221;,&#8221;root&#8221;,&#8221;root&#8221;) or die(&#8220;Error Connect to Database&#8221;);<br \/>\n$objDB = mysql_select_db(&#8220;mydatabase&#8221;);<br \/>\n<strong>mysql_query(&#8220;SET NAMES UTF8&#8221;);<\/strong><\/p>\n<p>&#8211; \u0e01\u0e23\u0e13\u0e35\u0e17\u0e35\u0e48\u0e01\u0e33\u0e2b\u0e19\u0e14 Collation \u0e2d\u0e37\u0e48\u0e19 \u0e46 \u0e43\u0e2b\u0e49\u0e43\u0e0a\u0e49<br \/>\n$objConnect = mysql_connect(&#8220;localhost&#8221;,&#8221;root&#8221;,&#8221;root&#8221;) or die(&#8220;Error Connect to Database&#8221;);<br \/>\n$objDB = mysql_select_db(&#8220;mydatabase&#8221;);<br \/>\n<strong>mysql_query(&#8220;SET character_set_results=utf8&#8221;);<br \/>\nmysql_query(&#8220;SET character_set_client=utf8&#8221;);<br \/>\nmysql_query(&#8220;SET character_set_connection=utf8&#8221;);<\/strong><\/span><\/span><\/div>\n<p><strong>\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 Code \u0e40\u0e15\u0e47\u0e21 \u0e46 \u0e04\u0e23\u0e31\u0e1a<\/strong><\/p>\n<div id=\"highlighter_736175\" class=\"syntaxhighlighter \">\n<div class=\"lines\">\n<div class=\"line alt1\"><code class=\"number\">01.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;html&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">02.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;head&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">03.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;title&gt;ThaiCreate.Com PHP &amp; UTF-8&lt;\/title&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">04.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;meta http-equiv=Content-Type content=<\/code><code class=\"string\">\"text\/html; charset=utf-8\"<\/code><code class=\"plain\">&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">05.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/head&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">06.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;body&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">07.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;?php\u00a0\u00a0\u00a0<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">08.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/*** Connect ***\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">09.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$objConnect<\/code>\u00a0<code class=\"plain\">= mysql_connect(<\/code><code class=\"string\">\"localhost\"<\/code><code class=\"plain\">,<\/code><code class=\"string\">\"root\"<\/code><code class=\"plain\">,<\/code><code class=\"string\">\"root\"<\/code><code class=\"plain\">)\u00a0<\/code><code class=\"keyword\">or<\/code>\u00a0<code class=\"keyword\">die<\/code><code class=\"plain\">(<\/code><code class=\"string\">\"Error Connect to Database\"<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">10.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$objDB<\/code>\u00a0<code class=\"plain\">= mysql_select_db(<\/code><code class=\"string\">\"mydatabase\"<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">11.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">mysql_query(<\/code><code class=\"string\">\"SET NAMES UTF8\"<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">12.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/*<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">13.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/\/ Or \/\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">14.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">mysql_query(\"SET character_set_results=utf8\");<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">15.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">mysql_query(\"SET character_set_client=utf8\");<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">16.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">mysql_query(\"SET character_set_connection=utf8\");<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">17.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">*\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">18.<\/code><span class=\"content\"><span class=\"block\">\u00a0<\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">19.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/***\u00a0 Add Record ***\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">20.<\/code><span class=\"content\"><span class=\"block\"><code class=\"keyword\">if<\/code><code class=\"plain\">(<\/code><code class=\"variable\">$_GET<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"Action\"<\/code><code class=\"plain\">]==<\/code><code class=\"string\">\"Save\"<\/code><code class=\"plain\">)<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">21.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">{<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">22.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$strSQL<\/code>\u00a0<code class=\"plain\">=\u00a0<\/code><code class=\"string\">\"INSERT INTO mydata_utf8 (NAME,SURNAME) VALUES ('\"<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"txtName\"<\/code><code class=\"plain\">].<\/code><code class=\"string\">\"','\"<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$_POST<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"txtSurname\"<\/code><code class=\"plain\">].<\/code><code class=\"string\">\"')\"<\/code><code class=\"plain\">;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">23.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">mysql_query(<\/code><code class=\"variable\">$strSQL<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">24.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">}<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">25.<\/code><span class=\"content\"><span class=\"block\">\u00a0<\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">26.<\/code><span class=\"content\"><span class=\"block\"><code class=\"comments\">\/*** List Record ***\/<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">27.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$strSQL<\/code>\u00a0<code class=\"plain\">=\u00a0<\/code><code class=\"string\">\"SELECT * FROM mydata_utf8\"<\/code><code class=\"plain\">;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">28.<\/code><span class=\"content\"><span class=\"block\"><code class=\"variable\">$objQuery<\/code>\u00a0<code class=\"plain\">= mysql_query(<\/code><code class=\"variable\">$strSQL<\/code><code class=\"plain\">)\u00a0<\/code><code class=\"keyword\">or<\/code>\u00a0<code class=\"keyword\">die<\/code>\u00a0<code class=\"plain\">(<\/code><code class=\"string\">\"Error Query [\"<\/code><code class=\"plain\">.<\/code><code class=\"variable\">$strSQL<\/code><code class=\"plain\">.<\/code><code class=\"string\">\"]\"<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">29.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">?&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">30.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;table width=<\/code><code class=\"string\">\"498\"<\/code>\u00a0<code class=\"plain\">border=<\/code><code class=\"string\">\"1\"<\/code><code class=\"plain\">&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">31.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">32.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;th width=<\/code><code class=\"string\">\"87\"<\/code><code class=\"plain\">&gt; &lt;div align=<\/code><code class=\"string\">\"center\"<\/code><code class=\"plain\">&gt;UID &lt;\/div&gt;&lt;\/th&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">33.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;th width=<\/code><code class=\"string\">\"145\"<\/code><code class=\"plain\">&gt; &lt;div align=<\/code><code class=\"string\">\"center\"<\/code><code class=\"plain\">&gt;NAME &lt;\/div&gt;&lt;\/th&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">34.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;th width=<\/code><code class=\"string\">\"244\"<\/code><code class=\"plain\">&gt; &lt;div align=<\/code><code class=\"string\">\"center\"<\/code><code class=\"plain\">&gt;SURNAME &lt;\/div&gt;&lt;\/th&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">35.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">36.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;?php<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">37.<\/code><span class=\"content\"><span class=\"block\"><code class=\"keyword\">while<\/code><code class=\"plain\">(<\/code><code class=\"variable\">$objResult<\/code>\u00a0<code class=\"plain\">= mysql_fetch_array(<\/code><code class=\"variable\">$objQuery<\/code><code class=\"plain\">))<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">38.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">{<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">39.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">?&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">40.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">41.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;div align=<\/code><code class=\"string\">\"center\"<\/code><code class=\"plain\">&gt;&lt;?php\u00a0<\/code><code class=\"functions\">echo<\/code>\u00a0<code class=\"variable\">$objResult<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"UID\"<\/code><code class=\"plain\">];?&gt;&lt;\/div&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">42.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;?php\u00a0<\/code><code class=\"functions\">echo<\/code>\u00a0<code class=\"variable\">$objResult<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"NAME\"<\/code><code class=\"plain\">];?&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">43.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;?php\u00a0<\/code><code class=\"functions\">echo<\/code>\u00a0<code class=\"variable\">$objResult<\/code><code class=\"plain\">[<\/code><code class=\"string\">\"SURNAME\"<\/code><code class=\"plain\">];?&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">44.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">45.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;?php<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">46.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">}<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">47.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">?&gt;\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">48.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;form name=<\/code><code class=\"string\">\"frmMain\"<\/code>\u00a0<code class=\"plain\">method=<\/code><code class=\"string\">\"post\"<\/code>\u00a0<code class=\"plain\">action=<\/code><code class=\"string\">\"?Action=Save\"<\/code><code class=\"plain\">&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">49.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">50.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">51.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">52.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;input name=<\/code><code class=\"string\">\"txtName\"<\/code>\u00a0<code class=\"plain\">type=<\/code><code class=\"string\">\"text\"<\/code>\u00a0<code class=\"plain\">id=<\/code><code class=\"string\">\"txtName\"<\/code><code class=\"plain\">&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">53.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;td&gt;&lt;input name=<\/code><code class=\"string\">\"txtSurname\"<\/code>\u00a0<code class=\"plain\">type=<\/code><code class=\"string\">\"text\"<\/code>\u00a0<code class=\"plain\">id=<\/code><code class=\"string\">\"txtSurname\"<\/code><code class=\"plain\">&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">54.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;input name=<\/code><code class=\"string\">\"btnSubmit\"<\/code>\u00a0<code class=\"plain\">type=<\/code><code class=\"string\">\"submit\"<\/code>\u00a0<code class=\"plain\">id=<\/code><code class=\"string\">\"btnSubmit\"<\/code>\u00a0<code class=\"plain\">value=<\/code><code class=\"string\">\"Submit\"<\/code><code class=\"plain\">&gt;&lt;\/td&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">55.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/tr&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">56.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/form&gt;\u00a0\u00a0\u00a0\u00a0<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">57.<\/code><span class=\"content\"><span class=\"block\">\u00a0<\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">58.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/table&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">59.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;?php<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">60.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">mysql_close(<\/code><code class=\"variable\">$objConnect<\/code><code class=\"plain\">);<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">61.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">?&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt2\"><code class=\"number\">62.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/body&gt;<\/code><\/span><\/span><\/div>\n<div class=\"line alt1\"><code class=\"number\">63.<\/code><span class=\"content\"><span class=\"block\"><code class=\"plain\">&lt;\/html&gt;<\/code><\/span><\/span><\/div>\n<\/div>\n<\/div>\n<p><u><strong>Output<\/strong><\/u><\/p>\n<p><img decoding=\"async\" class=\"resize\" title=\"PHP MySQL (Thai)\" src=\"https:\/\/www.thaicreate.com\/upload\/community\/utf8-3.jpg?v=1001\" alt=\"PHP MySQL (Thai)\" border=\"0\" \/><\/p>\n<p>\u0e08\u0e30\u0e40\u0e2b\u0e47\u0e19\u0e27\u0e48\u0e32\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e43\u0e0a\u0e49\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22\u0e44\u0e14\u0e49\u0e17\u0e31\u0e49\u0e07 2 \u0e23\u0e39\u0e1b\u0e41\u0e1a\u0e1a \u0e41\u0e15\u0e48\u0e16\u0e36\u0e07\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e44\u0e23\u0e41\u0e25\u0e49\u0e27 \u0e1c\u0e21\u0e2d\u0e22\u0e32\u0e01\u0e43\u0e2b\u0e49\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e43\u0e2b\u0e49\u0e40\u0e1b\u0e47\u0e19\u00a0<strong>UTF-8<\/strong>\u00a0\u0e43\u0e2b\u0e49\u0e2b\u0e21\u0e14\u0e04\u0e23\u0e31\u0e1a \u0e40\u0e1e\u0e23\u0e32\u0e30\u0e21\u0e31\u0e19\u0e14\u0e35\u0e01\u0e27\u0e48\u0e32\u0e2b\u0e25\u0e32\u0e22 \u0e46 \u0e14\u0e49\u0e32\u0e19\u0e08\u0e23\u0e34\u0e07 \u0e46 \u0e04\u0e23\u0e31\u0e1a \u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e14\u0e32\u0e27\u0e19\u0e4c\u0e42\u0e2b\u0e25\u0e14 Code \u0e44\u0e14\u0e49\u0e08\u0e32\u0e01\u0e02\u0e49\u0e32\u0e07\u0e25\u0e48\u0e32\u0e07\u0e19\u0e48\u0e30\u0e04\u0e23\u0e31\u0e1a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21 PHP &amp; MySQL https:\/\/www.thaicreate.com\/php\/php-mysql.html \u0e40\u0e2b\u0e15\u0e38\u0e1c\u0e25\u0e17\u0e35\u0e48\u0e1c\u0e21\u0e17\u0e33\u0e1a\u0e17\u0e04\u0e27\u0e32\u0e21\u0e19\u0e35\u0e49\u0e02\u0e36\u0e49\u0e19\u0e01\u0e47\u0e01\u0e47\u0e40\u0e1e\u0e23\u0e32\u0e30\u0e21\u0e35\u0e01\u0e23\u0e30\u0e17\u0e39\u0e49\u0e16\u0e32\u0e21\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e01\u0e31\u0e1a\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22 ?????? \u0e17\u0e38\u0e01\u0e27\u0e31\u0e19\u0e04\u0e23\u0e31\u0e1a \u0e41\u0e25\u0e30\u0e40\u0e1b\u0e47\u0e19\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e17\u0e35\u0e48\u0e41\u0e01\u0e49\u0e44\u0e21\u0e48\u0e08\u0e1a\u0e0b\u0e30\u0e17\u0e35\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e1c\u0e39\u0e49\u0e17\u0e35\u0e48 \u0e01\u0e33\u0e25\u0e31\u0e07\u0e40\u0e23\u0e34\u0e48\u0e21\u0e40\u0e02\u0e35\u0e22\u0e19\u00a0MySQL\u00a04.1.x \u0e41\u0e25\u0e30 5.0.x \u0e02\u0e36\u0e49\u0e19\u0e44\u0e1b \u0e40\u0e1e\u0e23\u0e32\u0e30\u0e43\u0e19\u0e40\u0e27\u0e2d\u0e23\u0e4c\u0e0a\u0e31\u0e48\u0e19\u0e43\u0e2b\u0e21\u0e48\u0e19\u0e35\u0e49 \u0e17\u0e32\u0e07\u00a0MySQL\u00a0\u0e44\u0e14\u0e49\u0e43\u0e2b\u0e49\u0e04\u0e27\u0e32\u0e21\u0e2a\u0e33\u0e04\u0e31\u0e0d\u0e01\u0e31\u0e1a Charset \u0e21\u0e32\u0e01\u0e02\u0e36\u0e49\u0e19\u0e01\u0e27\u0e48\u0e32\u0e40\u0e27\u0e2d\u0e23\u0e4c\u0e0a\u0e31\u0e48\u0e19 \u0e40\u0e14\u0e34\u0e21 \u0e46 \u0e01\u0e48\u0e2d\u0e19\u0e2b\u0e19\u0e49\u0e32\u0e19\u0e35\u0e49\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32 \u0e46 \u0e43\u0e0a\u0e49 latin1 \u0e43\u0e19\u0e01\u0e32\u0e23\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22\u0e0b\u0e36\u0e48\u0e07\u0e08\u0e30\u0e21\u0e35\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e04\u0e48\u0e2d\u0e19\u0e02\u0e49\u0e32\u0e07\u0e1a\u0e48\u0e2d\u0e22\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e01\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e41\u0e2a\u0e14\u0e07\u0e1c\u0e25\u0e17\u0e35\u0e48\u0e1c\u0e34\u0e14\u0e40\u0e1e\u0e35\u0e49\u0e22\u0e19 \u0e01\u0e32\u0e23\u0e08\u0e31\u0e14\u0e40\u0e23\u0e35\u0e22\u0e07\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e16\u0e39\u0e01\u0e15\u0e49\u0e2d\u0e07 \u0e41\u0e25\u0e30\u0e04\u0e27\u0e32\u0e21\u0e08\u0e33\u0e01\u0e31\u0e14\u0e17\u0e32\u0e07\u0e14\u0e49\u0e32\u0e19\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e2b\u0e25\u0e32\u0e22 \u0e46 \u0e20\u0e32\u0e29\u0e32 \u0e17\u0e31\u0e49\u0e07\u0e19\u0e35\u0e49\u0e1c\u0e21\u0e04\u0e34\u0e14\u0e27\u0e48\u0e32\u0e01\u0e32\u0e23\u0e19\u0e33 Chatset \u0e21\u0e32\u0e43\u0e0a\u0e49 \u0e17\u0e32\u0e07 mySQL \u0e40\u0e2d\u0e07\u0e15\u0e49\u0e2d\u0e07\u0e01\u0e32\u0e23\u0e41\u0e01\u0e49\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e17\u0e35\u0e48\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e02\u0e49\u0e2d\u0e07\u0e01\u0e31\u0e1a\u0e20\u0e32\u0e29\u0e32\u0e01\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19 Application \u0e2d\u0e37\u0e48\u0e19 \u0e46 \u0e17\u0e35\u0e48\u0e23\u0e2d\u0e07\u0e23\u0e31\u0e1a\u0e23\u0e39\u0e1b\u0e41\u0e1a\u0e1a\u00a0UTF-8\u00a0\u0e44\u0e1b\u0e2b\u0e21\u0e14\u0e41\u0e25\u0e49\u0e27 \u0e04\u0e07\u0e08\u0e30\u0e40\u0e2b\u0e25\u0e37\u0e2d\u0e41\u0e15\u0e48\u0e04\u0e19\u0e44\u0e17\u0e22\u0e2a\u0e48\u0e27\u0e19\u0e21\u0e32\u0e01\u0e17\u0e35\u0e48\u0e22\u0e31\u0e07\u0e04\u0e07\u0e22\u0e36\u0e14\u0e15\u0e36\u0e14\u0e01\u0e31\u0e1a\u00a0TIS-620\u00a0\u0e16\u0e36\u0e07\u0e04\u0e23\u0e32\u0e27\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e08\u0e30\u0e15\u0e49\u0e2d\u0e07\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e21\u0e32\u0e43\u0e0a\u0e49 UTF-8 \u0e01\u0e31\u0e19\u0e44\u0e14\u0e49\u0e41\u0e25\u0e49\u0e27\u0e04\u0e23\u0e31\u0e1a \u0e41\u0e25\u0e30\u0e1c\u0e21\u0e01\u0e25\u0e49\u0e32\u0e23\u0e31\u0e1a\u0e1b\u0e23\u0e30\u0e01\u0e31\u0e19\u0e40\u0e25\u0e22\u0e04\u0e23\u0e31\u0e1a\u0e27\u0e48\u0e32 \u0e21\u0e31\u0e19\u0e14\u0e35\u0e01\u0e27\u0e48\u0e32\u0e40\u0e14\u0e34\u0e21 \u0e08\u0e30\u0e0a\u0e48\u0e27\u0e22\u0e25\u0e14\u0e1b\u0e31\u0e0d\u0e2b\u0e32\u0e15\u0e48\u0e32\u0e07 \u0e46 \u0e17\u0e35\u0e48\u0e40\u0e01\u0e35\u0e48\u0e22\u0e27\u0e01\u0e31\u0e1a\u0e20\u0e32\u0e29\u0e32\u0e44\u0e17\u0e22\u0e44\u0e14\u0e49\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e2b\u0e21\u0e14\u0e40\u0e01\u0e25\u0e35\u0e49\u0e22\u0e07 \u0e04\u0e23\u0e31\u0e1a<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[13],"tags":[],"class_list":["post-23362","post","type-post","status-publish","format-standard","hentry","category-13"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6cOVM-64O","_links":{"self":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/23362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23362"}],"version-history":[{"count":1,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/23362\/revisions"}],"predecessor-version":[{"id":23363,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/23362\/revisions\/23363"}],"wp:attachment":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}