{"id":343,"date":"2015-08-11T08:24:00","date_gmt":"2015-08-11T01:24:00","guid":{"rendered":"http:\/\/devbanban.com\/?p=343"},"modified":"2016-02-28T13:12:31","modified_gmt":"2016-02-28T06:12:31","slug":"json-%e0%b9%80%e0%b8%a3%e0%b8%b5%e0%b8%a2%e0%b8%81%e0%b8%82%e0%b9%89%e0%b8%ad%e0%b8%a1%e0%b8%b9%e0%b8%a5%e0%b8%88%e0%b8%b2%e0%b8%81-database-%e0%b8%a1%e0%b8%b2%e0%b9%81%e0%b8%aa%e0%b8%94%e0%b8%87","status":"publish","type":"post","link":"https:\/\/devbanban.com\/?p=343","title":{"rendered":"\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49 Json  PHP"},"content":{"rendered":"<p>\u0e43\u0e19 workshop \u0e19\u0e35\u0e49\u0e08\u0e30\u0e41\u0e19\u0e30\u0e19\u0e33\u0e01\u0e32\u0e23\u0e40\u0e02\u0e35\u0e22\u0e19 json \u0e01\u0e31\u0e1a php \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e40\u0e23\u0e35\u0e22\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a \u00a0 \u0e0b\u0e36\u0e48\u0e07\u0e19\u0e48\u0e32\u0e08\u0e30\u0e21\u0e35\u0e1b\u0e23\u0e30\u0e42\u0e22\u0e0a\u0e19\u0e4c\u0e01\u0e31\u0e1a\u0e2b\u0e25\u0e32\u0e22\u0e46\u0e04\u0e19 \u00a0\u0e21\u0e32\u0e40\u0e23\u0e34\u0e48\u0e21\u0e01\u0e31\u0e19\u0e40\u0e25\u0e22\u0e04\u0e23\u0e31\u0e1a <!--more--><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u0e17\u0e14\u0e25\u0e2d\u0e07\u0e2a\u0e23\u0e49\u0e32\u0e07 database \u0e14\u0e31\u0e07\u0e19\u0e35\u0e49 <strong>database name : myshop \u00a0<\/strong><\/p>\n<pre class=\"lang:mysql decode:true \">CREATE TABLE IF NOT EXISTS `products` (\r\n  `id` int(11) NOT NULL,\r\n  `name` varchar(32) NOT NULL,\r\n  `description` text NOT NULL,\r\n  `price` int(11) NOT NULL,\r\n  `category_id` int(11) NOT NULL,\r\n  `created` datetime NOT NULL,\r\n  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP\r\n) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;\r\n\r\n--\r\n-- Dumping data for table `products`\r\n--\r\n\r\nINSERT INTO `products` (`id`, `name`, `description`, `price`, `category_id`, `created`, `modified`) VALUES\r\n(1, 'LG P880 4X HD', 'My first awesome phone!', 336, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),\r\n(2, 'Google Nexus 4', 'The most awesome phone of 2013!', 299, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),\r\n(3, 'Samsung Galaxy S4', 'How about no?', 604, 3, '0000-00-00 00:00:00', '2015-05-03 04:20:18'),\r\n(6, 'Bench Shirt', 'The best shirt!', 295, 1, '2014-06-01 01:12:26', '2015-05-03 04:19:40'),\r\n(7, 'Lenovo Laptop', 'My business partner.', 399, 2, '2014-06-01 01:13:45', '2014-05-31 03:13:39'),\r\n(8, 'Samsung Galaxy Tab 10.1', 'Good tablet.', 259, 2, '2014-06-01 01:14:13', '2014-05-31 03:14:08'),\r\n(9, 'Spalding Watch', 'My sports watch.', 199, 1, '2014-06-01 01:18:36', '2014-05-31 03:18:31'),\r\n(10, 'Sony Smart Watch', 'The coolest smart watch!', 300, 2, '2014-06-06 17:10:01', '2014-06-05 19:09:51'),\r\n(11, 'Huawei Y300', 'For testing purposes.', 100, 2, '2014-06-06 17:11:04', '2014-06-05 19:10:54'),\r\n(12, 'Abercrombie Lake Arnold Shirt', 'Perfect as gift!', 60, 1, '2014-06-06 17:12:21', '2014-06-05 19:12:11'),\r\n(13, 'Abercrombie Allen Brook Shirt t', 'Cool red shirt!', 400, 1, '2014-06-06 17:12:59', '2015-05-15 10:04:17'),\r\n(19, '\u0e2a\u0e34\u0e19\u0e04\u0e49\u0e32', '\u0e2a\u0e34\u0e19\u0e04\u0e49\u0e32', 33, 1, '2015-05-14 20:09:25', '2015-05-14 13:09:25');<\/pre>\n<p>&nbsp;<\/p>\n<p>\u0e41\u0e25\u0e30 json \u0e44\u0e1f\u0e25\u0e4c\u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e40\u0e23\u0e35\u0e22\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01 database \u0e19\u0e35\u0e49\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a<\/p>\n<p>\u0e16\u0e49\u0e32\u0e40\u0e23\u0e32\u0e08\u0e30\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e0a\u0e37\u0e48\u0e2d datase \u0e01\u0e31\u0e1a table \u00a0\u0e43\u0e2b\u0e49\u0e2a\u0e31\u0e07\u0e40\u0e01\u0e15\u0e1a\u0e23\u0e23\u0e17\u0e31\u0e14\u0e17\u0e35\u0e48 3, 5, 8 \u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a\u0e15\u0e49\u0e2d\u0e07\u0e40\u0e1b\u0e25\u0e35\u0e48\u0e22\u0e19\u0e0a\u0e37\u0e48\u0e2d\u0e01\u0e32\u0e23\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e15\u0e48\u0e2d datase \u0e0a\u0e37\u0e48\u0e2d\u0e15\u0e32\u0e23\u0e32\u0e07\u0e43\u0e2b\u0e49\u0e16\u0e39\u0e01\u0e15\u0e49\u0e2d\u0e07<\/p>\n<pre class=\"lang:php decode:true \">&lt;?php\r\n\t\/\/connect db\r\n\t$objConnect = mysql_connect(\"localhost\",\"root\",\"\");  \r\n\t\/\/ database\r\n\t$objDB = mysql_select_db(\"myshop\");\r\n\tmysql_query(\"SET NAMES UTF8\");\r\n\t\/\/select table\r\n\t$SQLstring = \"SELECT * FROM products ORDER BY id ASC  \";\r\n\r\n\t$objQuery = mysql_query($SQLstring);\r\n\t$numRows = mysql_num_fields($objQuery);\r\n\t$resultArray = array();\r\n\twhile($obResult = mysql_fetch_array($objQuery))\r\n\t{\r\n\t\t$arrCol = array();\r\n\t\tfor($i=0;$i&lt;$numRows;$i++)\r\n\t\t{\r\n\t\t\t$arrCol[mysql_field_name($objQuery,$i)] = $obResult[$i];\r\n\t\t}\r\n\t\tarray_push($resultArray,$arrCol);\r\n\t}\r\n\tmysql_close($objConnect);\r\n\theader ('Content-type: text\/html; charset=utf-8');\r\n\techo json_encode($resultArray);\r\n?&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>\u0e40\u0e21\u0e37\u0e48\u0e2d\u0e17\u0e14\u0e25\u0e2d\u0e07 run \u0e44\u0e1f\u0e25\u0e4c\u0e19\u0e35\u0e49 \u0e1c\u0e25\u0e17\u0e35\u0e48\u0e44\u0e14\u0e49\u0e04\u0e37\u0e2d \u0e08\u0e30\u0e41\u0e2a\u0e14\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e31\u0e49\u0e07\u0e2b\u0e21\u0e14\u0e1a\u0e19 table \u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e40\u0e23\u0e35\u0e22\u0e01\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07<\/p>\n<p><a href=\"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/08\/Screen-Shot-2558-08-11-at-08.20.22.png\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"lazy alignleft size-large wp-image-345\" src=\"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/plugins\/wp-images-lazy-loading\/images\/grey.gif?resize=640%2C400&#038;ssl=1\" data-original=\"http:\/\/devbanban.com\/wp-content\/uploads\/2015\/08\/Screen-Shot-2558-08-11-at-08.20.22-1024x640.png\" alt=\"Screen Shot 2558-08-11 at 08.20.22\" width=\"640\" height=\"400\" \/><noscript><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignleft size-large wp-image-345\" src=\"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/08\/Screen-Shot-2558-08-11-at-08.20.22-1024x640.png?resize=640%2C400\" alt=\"Screen Shot 2558-08-11 at 08.20.22\" width=\"640\" height=\"400\" srcset=\"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/08\/Screen-Shot-2558-08-11-at-08.20.22.png?resize=1024%2C640&amp;ssl=1 1024w, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/08\/Screen-Shot-2558-08-11-at-08.20.22.png?resize=300%2C188&amp;ssl=1 300w, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/08\/Screen-Shot-2558-08-11-at-08.20.22.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/noscript><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>json \u0e44\u0e1f\u0e25\u0e4c\u0e2a\u0e32\u0e21\u0e32\u0e23\u0e16\u0e19\u0e33\u0e44\u0e1b\u0e1b\u0e23\u0e30\u0e22\u0e38\u0e01\u0e15\u0e4c\u0e43\u0e0a\u0e49\u0e44\u0e14\u0e49\u0e01\u0e31\u0e1a\u0e01\u0e32\u0e23\u0e1e\u0e31\u0e12\u0e19\u0e32\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e2b\u0e25\u0e32\u0e22\u0e23\u0e39\u0e1b\u0e41\u0e1a\u0e1a \u0e41\u0e21\u0e49\u0e01\u0e23\u0e30\u0e17\u0e31\u0e48\u0e07 Application \u0e1a\u0e19 Smart phone \u0e25\u0e2d\u0e07\u0e28\u0e36\u0e01\u0e29\u0e32\u0e41\u0e25\u0e30\u0e1d\u0e36\u0e01\u0e1b\u0e0f\u0e34\u0e1a\u0e31\u0e15\u0e34\u0e14\u0e39\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a ^_^<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0e43\u0e19 workshop \u0e19\u0e35\u0e49\u0e08\u0e30\u0e41\u0e19\u0e30\u0e19\u0e33\u0e01\u0e32\u0e23\u0e40\u0e02\u0e35\u0e22\u0e19 json \u0e01\u0e31\u0e1a php \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e40\u0e23\u0e35\u0e22\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e08\u0e32\u0e01\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a \u00a0 \u0e0b\u0e36\u0e48\u0e07\u0e19\u0e48\u0e32\u0e08\u0e30\u0e21\u0e35\u0e1b\u0e23\u0e30\u0e42\u0e22\u0e0a\u0e19\u0e4c\u0e01\u0e31\u0e1a\u0e2b\u0e25\u0e32\u0e22\u0e46\u0e04\u0e19 \u00a0\u0e21\u0e32\u0e40\u0e23\u0e34\u0e48\u0e21\u0e01\u0e31\u0e19\u0e40\u0e25\u0e22\u0e04\u0e23\u0e31\u0e1a<\/p>\n","protected":false},"author":1,"featured_media":152,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[15],"tags":[8,30,20,16,17,31,19],"class_list":["post-343","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-database","tag-json","tag-mysql","tag-php","tag-query","tag-select","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>json php example<\/title>\n<meta name=\"description\" content=\"json php example\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devbanban.com\/?p=343\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"json php example\" \/>\n<meta name=\"twitter:description\" content=\"json php example\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/php_devbanban.jpg?fit=200%2C100&ssl=1\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343\"},\"author\":{\"name\":\"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35\",\"@id\":\"https:\\\/\\\/devbanban.com\\\/#\\\/schema\\\/person\\\/aa637e5a6aefe44e0dbfcac2b429fcc3\"},\"headline\":\"\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49 Json PHP\",\"datePublished\":\"2015-08-11T01:24:00+00:00\",\"dateModified\":\"2016-02-28T06:12:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343\"},\"wordCount\":25,\"image\":{\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/devbanban.com\\\/wp-content\\\/uploads\\\/2015\\\/05\\\/php_devbanban.jpg?fit=200%2C100&ssl=1\",\"keywords\":[\"database\",\"json\",\"mysql\",\"PHP\",\"query\",\"select\",\"sql\"],\"articleSection\":[\"PHP\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343\",\"url\":\"https:\\\/\\\/devbanban.com\\\/?p=343\",\"name\":\"json php example\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/devbanban.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/devbanban.com\\\/wp-content\\\/uploads\\\/2015\\\/05\\\/php_devbanban.jpg?fit=200%2C100&ssl=1\",\"datePublished\":\"2015-08-11T01:24:00+00:00\",\"dateModified\":\"2016-02-28T06:12:31+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/devbanban.com\\\/#\\\/schema\\\/person\\\/aa637e5a6aefe44e0dbfcac2b429fcc3\"},\"description\":\"json php example\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/devbanban.com\\\/?p=343\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/devbanban.com\\\/wp-content\\\/uploads\\\/2015\\\/05\\\/php_devbanban.jpg?fit=200%2C100&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/devbanban.com\\\/wp-content\\\/uploads\\\/2015\\\/05\\\/php_devbanban.jpg?fit=200%2C100&ssl=1\",\"width\":200,\"height\":100},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/devbanban.com\\\/?p=343#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/devbanban.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49 Json PHP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/devbanban.com\\\/#website\",\"url\":\"https:\\\/\\\/devbanban.com\\\/\",\"name\":\"\u0e2a\u0e2d\u0e19\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e1f\u0e23\u0e35 [PHP, SQL, Codeigniter, Bootstrap, HTML]\",\"description\":\"\u0e2a\u0e2d\u0e19\u0e40\u0e02\u0e35\u0e22\u0e19\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e1f\u0e23\u0e35 \u0e2a\u0e2d\u0e19\u0e17\u0e33\u0e23\u0e30\u0e1a\u0e1a\u0e2d\u0e35\u0e04\u0e2d\u0e21\u0e40\u0e21\u0e34\u0e23\u0e4c\u0e0a \u0e23\u0e30\u0e1a\u0e1a\u0e2b\u0e19\u0e31\u0e07\u0e2a\u0e37\u0e2d\u0e40\u0e27\u0e35\u0e22\u0e19 \u0e23\u0e30\u0e1a\u0e22\u0e37\u0e21\u0e04\u0e37\u0e19\u0e04\u0e23\u0e38\u0e20\u0e31\u0e13\u0e11\u0e4c \u0e23\u0e30\u0e1a\u0e1a\u0e04\u0e25\u0e31\u0e07\u0e02\u0e49\u0e2d\u0e2a\u0e2d\u0e1a \u0e23\u0e30\u0e1a\u0e1a\u0e41\u0e08\u0e49\u0e07\u0e0b\u0e48\u0e2d\u0e21 \u0e23\u0e30\u0e1a\u0e1a\u0e27\u0e34\u0e08\u0e31\u0e22 \u0e41\u0e25\u0e30\u0e23\u0e30\u0e1a\u0e1a\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e1e\u0e23\u0e49\u0e2d\u0e21 Workshop PHP PDO MySQL \u0e2d\u0e35\u0e01\u0e21\u0e32\u0e01\u0e21\u0e32\u0e22\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/devbanban.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/devbanban.com\\\/#\\\/schema\\\/person\\\/aa637e5a6aefe44e0dbfcac2b429fcc3\",\"name\":\"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35\",\"description\":\"\u0e21\u0e35\u0e04\u0e27\u0e32\u0e21\u0e2a\u0e19\u0e43\u0e08\u0e40\u0e17\u0e04\u0e42\u0e19\u0e42\u0e25\u0e22\u0e35\u0e17\u0e35\u0e48\u0e43\u0e0a\u0e49\u0e1e\u0e31\u0e12\u0e19\u0e32\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c \u0e41\u0e25\u0e30\u0e2d\u0e22\u0e32\u0e01\u0e41\u0e1a\u0e48\u0e07\u0e1b\u0e31\u0e19\u0e04\u0e27\u0e32\u0e21\u0e23\u0e39\u0e49\u0e14\u0e49\u0e32\u0e19\u0e01\u0e32\u0e23\u0e1e\u0e31\u0e12\u0e19\u0e32\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e41\u0e25\u0e30\u0e2d\u0e37\u0e48\u0e19\u0e46\u0e2d\u0e35\u0e01\u0e21\u0e32\u0e01\u0e21\u0e32\u0e22...\",\"sameAs\":[\"http:\\\/\\\/devbanban.com\\\/\"],\"url\":\"https:\\\/\\\/devbanban.com\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"json php example","description":"json php example","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devbanban.com\/?p=343","twitter_card":"summary_large_image","twitter_title":"json php example","twitter_description":"json php example","twitter_image":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/php_devbanban.jpg?fit=200%2C100&ssl=1","twitter_misc":{"Written by":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/devbanban.com\/?p=343#article","isPartOf":{"@id":"https:\/\/devbanban.com\/?p=343"},"author":{"name":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","@id":"https:\/\/devbanban.com\/#\/schema\/person\/aa637e5a6aefe44e0dbfcac2b429fcc3"},"headline":"\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49 Json PHP","datePublished":"2015-08-11T01:24:00+00:00","dateModified":"2016-02-28T06:12:31+00:00","mainEntityOfPage":{"@id":"https:\/\/devbanban.com\/?p=343"},"wordCount":25,"image":{"@id":"https:\/\/devbanban.com\/?p=343#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/php_devbanban.jpg?fit=200%2C100&ssl=1","keywords":["database","json","mysql","PHP","query","select","sql"],"articleSection":["PHP"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/devbanban.com\/?p=343","url":"https:\/\/devbanban.com\/?p=343","name":"json php example","isPartOf":{"@id":"https:\/\/devbanban.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devbanban.com\/?p=343#primaryimage"},"image":{"@id":"https:\/\/devbanban.com\/?p=343#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/php_devbanban.jpg?fit=200%2C100&ssl=1","datePublished":"2015-08-11T01:24:00+00:00","dateModified":"2016-02-28T06:12:31+00:00","author":{"@id":"https:\/\/devbanban.com\/#\/schema\/person\/aa637e5a6aefe44e0dbfcac2b429fcc3"},"description":"json php example","breadcrumb":{"@id":"https:\/\/devbanban.com\/?p=343#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devbanban.com\/?p=343"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/devbanban.com\/?p=343#primaryimage","url":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/php_devbanban.jpg?fit=200%2C100&ssl=1","contentUrl":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/php_devbanban.jpg?fit=200%2C100&ssl=1","width":200,"height":100},{"@type":"BreadcrumbList","@id":"https:\/\/devbanban.com\/?p=343#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devbanban.com\/"},{"@type":"ListItem","position":2,"name":"\u0e01\u0e32\u0e23\u0e43\u0e0a\u0e49 Json PHP"}]},{"@type":"WebSite","@id":"https:\/\/devbanban.com\/#website","url":"https:\/\/devbanban.com\/","name":"\u0e2a\u0e2d\u0e19\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e1f\u0e23\u0e35 [PHP, SQL, Codeigniter, Bootstrap, HTML]","description":"\u0e2a\u0e2d\u0e19\u0e40\u0e02\u0e35\u0e22\u0e19\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e1f\u0e23\u0e35 \u0e2a\u0e2d\u0e19\u0e17\u0e33\u0e23\u0e30\u0e1a\u0e1a\u0e2d\u0e35\u0e04\u0e2d\u0e21\u0e40\u0e21\u0e34\u0e23\u0e4c\u0e0a \u0e23\u0e30\u0e1a\u0e1a\u0e2b\u0e19\u0e31\u0e07\u0e2a\u0e37\u0e2d\u0e40\u0e27\u0e35\u0e22\u0e19 \u0e23\u0e30\u0e1a\u0e22\u0e37\u0e21\u0e04\u0e37\u0e19\u0e04\u0e23\u0e38\u0e20\u0e31\u0e13\u0e11\u0e4c \u0e23\u0e30\u0e1a\u0e1a\u0e04\u0e25\u0e31\u0e07\u0e02\u0e49\u0e2d\u0e2a\u0e2d\u0e1a \u0e23\u0e30\u0e1a\u0e1a\u0e41\u0e08\u0e49\u0e07\u0e0b\u0e48\u0e2d\u0e21 \u0e23\u0e30\u0e1a\u0e1a\u0e27\u0e34\u0e08\u0e31\u0e22 \u0e41\u0e25\u0e30\u0e23\u0e30\u0e1a\u0e1a\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e1e\u0e23\u0e49\u0e2d\u0e21 Workshop PHP PDO MySQL \u0e2d\u0e35\u0e01\u0e21\u0e32\u0e01\u0e21\u0e32\u0e22","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devbanban.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/devbanban.com\/#\/schema\/person\/aa637e5a6aefe44e0dbfcac2b429fcc3","name":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","description":"\u0e21\u0e35\u0e04\u0e27\u0e32\u0e21\u0e2a\u0e19\u0e43\u0e08\u0e40\u0e17\u0e04\u0e42\u0e19\u0e42\u0e25\u0e22\u0e35\u0e17\u0e35\u0e48\u0e43\u0e0a\u0e49\u0e1e\u0e31\u0e12\u0e19\u0e32\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c \u0e41\u0e25\u0e30\u0e2d\u0e22\u0e32\u0e01\u0e41\u0e1a\u0e48\u0e07\u0e1b\u0e31\u0e19\u0e04\u0e27\u0e32\u0e21\u0e23\u0e39\u0e49\u0e14\u0e49\u0e32\u0e19\u0e01\u0e32\u0e23\u0e1e\u0e31\u0e12\u0e19\u0e32\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e41\u0e25\u0e30\u0e2d\u0e37\u0e48\u0e19\u0e46\u0e2d\u0e35\u0e01\u0e21\u0e32\u0e01\u0e21\u0e32\u0e22...","sameAs":["http:\/\/devbanban.com\/"],"url":"https:\/\/devbanban.com\/?author=1"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/php_devbanban.jpg?fit=200%2C100&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6bpqQ-5x","jetpack-related-posts":[{"id":429,"url":"https:\/\/devbanban.com\/?p=429","url_meta":{"origin":343,"position":0},"title":"workshop php OOP  \u0e40\u0e1a\u0e37\u0e49\u0e2d\u0e07\u0e15\u0e49\u0e19","author":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","date":"01\/10\/2015","format":false,"excerpt":"\u0e43\u0e19 workshop \u0e08\u0e30\u0e1b\u0e23\u0e30\u0e01\u0e2d\u0e1a\u0e44\u0e1b\u0e14\u0e49\u0e27\u0e22\u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e40\u0e1e\u0e34\u0e48\u0e21 \u0e25\u0e1a \u0e41\u0e01\u0e49\u0e44\u0e02 \u0e40\u0e23\u0e35\u0e22\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e44\u0e14\u0e49 \u0e0b\u0e36\u0e48\u0e07\u0e19\u0e48\u0e32\u0e08\u0e30\u0e40\u0e1b\u0e47\u0e19\u0e1b\u0e23\u0e30\u0e42\u0e22\u0e0a\u0e19\u0e4c\u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e1c\u0e39\u0e49\u0e17\u0e35\u0e48\u0e01\u0e33\u0e25\u0e31\u0e07\u0e28\u0e36\u0e01\u0e29\u0e32\u0e01\u0e32\u0e23\u0e40\u0e02\u0e35\u0e22\u0e19\u0e42\u0e1b\u0e23\u0e41\u0e01\u0e23\u0e21 php OOP \u00a0 \u00a0 \u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CREATE DATABASE IF NOT EXISTS `myshop` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `myshop`; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE IF NOT EXISTS `categories` ( `id` int(11) NOT NULL, `name` varchar(256) NOT\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"https:\/\/devbanban.com\/?cat=15"},"img":{"alt_text":"cats","src":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/10\/cats-1024x316.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/10\/cats-1024x316.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/10\/cats-1024x316.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/10\/cats-1024x316.jpg?resize=700%2C400 2x"},"classes":[]},{"id":218,"url":"https:\/\/devbanban.com\/?p=218","url_meta":{"origin":343,"position":1},"title":"\u0e40\u0e23\u0e34\u0e48\u0e21\u0e2a\u0e23\u0e49\u0e32\u0e07 Database \u0e01\u0e31\u0e19\u0e40\u0e16\u0e2d\u0e30","author":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","date":"20\/05\/2015","format":false,"excerpt":"\u0e01\u0e48\u0e2d\u0e19\u0e08\u0e30\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e20\u0e32\u0e29\u0e32 PHP \u0e41\u0e25\u0e30\u0e21\u0e35\u0e01\u0e32\u0e23\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e15\u0e48\u0e2d\u0e01\u0e31\u0e1a Database \u0e01\u0e48\u0e2d\u0e19\u0e2d\u0e37\u0e48\u0e19\u0e40\u0e23\u0e32\u0e15\u0e49\u0e2d\u0e07\u0e2d\u0e2d\u0e01\u0e41\u0e1a\u0e1a\u0e41\u0e25\u0e30\u0e2a\u0e23\u0e49\u0e32\u0e07 database \u0e01\u0e48\u0e2d\u0e19\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a \u0e1c\u0e21\u0e08\u0e30\u0e22\u0e01\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 \u0e43\u0e2b\u0e49\u0e2a\u0e23\u0e49\u0e32\u0e07 database \u0e0a\u0e37\u0e48\u0e2d myweb\u00a0\u0e41\u0e25\u0e30\u0e21\u0e35\u0e15\u0e32\u0e23\u0e32\u0e07\u0e0a\u0e37\u0e48\u0e2d tb_member \u00a0 \u0e2b\u0e23\u0e37\u0e2d\u0e15\u0e32\u0e23\u0e32\u0e07\u0e17\u0e35\u0e48\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e02\u0e2d\u0e07\u0e2a\u0e21\u0e32\u0e0a\u0e34\u0e01\u0e20\u0e32\u0e22\u0e43\u0e19\u0e40\u0e27\u0e47\u0e1a\u0e44\u0e0b\u0e15\u0e4c \u00a0(\u0e2a\u0e23\u0e49\u0e32\u0e07 copy code sql \u0e44\u0e1b\u0e27\u0e32\u0e07\u0e43\u0e19 phpmyadmin \u0e44\u0e14\u0e49\u0e40\u0e25\u0e22\u0e04\u0e23\u0e31\u0e1a) \u0e43\u0e19\u0e15\u0e32\u0e23\u0e32\u0e07\u0e08\u0e30\u0e21\u0e35\u0e01\u0e32\u0e23\u0e40\u0e01\u0e47\u0e1a\u0e1f\u0e34\u0e25\u0e14\u0e4c \u0e44\u0e2d\u0e14\u0e35\u0e2a\u0e21\u0e32\u0e0a\u0e34\u0e01, \u0e0a\u0e37\u0e48\u0e2d-\u0e2a\u0e01\u0e38\u0e25, username, password, email, \u0e41\u0e25\u0e30\u0e27\u0e31\u0e19\u0e17\u0e35\u0e48\u0e2a\u0e21\u0e31\u0e04\u0e23\u0e2a\u0e21\u0e32\u0e0a\u0e34\u0e01\u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a CREATE TABLE IF NOT EXISTS `tb_member` ( `member_id` int(10) NOT NULL, `member_name` varchar(100) CHARACTER SET utf8 NOT NULL, `member_lname` varchar(100) CHARACTER\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"https:\/\/devbanban.com\/?cat=15"},"img":{"alt_text":"Screen Shot 2558-05-20 at 08.25.06","src":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/Screen-Shot-2558-05-20-at-08.25.06-1024x325.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/Screen-Shot-2558-05-20-at-08.25.06-1024x325.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/Screen-Shot-2558-05-20-at-08.25.06-1024x325.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/05\/Screen-Shot-2558-05-20-at-08.25.06-1024x325.png?resize=700%2C400 2x"},"classes":[]},{"id":400,"url":"https:\/\/devbanban.com\/?p=400","url_meta":{"origin":343,"position":2},"title":"\u0e41\u0e2a\u0e14\u0e07\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e21\u0e35\u0e04\u0e48\u0e32\u0e27\u0e48\u0e32\u0e07 PHP","author":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","date":"16\/09\/2015","format":false,"excerpt":"\u0e2b\u0e25\u0e31\u0e07\u0e08\u0e32\u0e01\u0e40\u0e23\u0e32\u0e44\u0e14\u0e49\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e2a\u0e21\u0e31\u0e04\u0e23\u0e2a\u0e21\u0e32\u0e0a\u0e34\u0e01\u0e41\u0e25\u0e30\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e07\u0e43\u0e19 database \u0e41\u0e25\u0e49\u0e27 \u00a0\u0e41\u0e15\u0e48\u0e21\u0e35\u0e1a\u0e32\u0e07\u0e1f\u0e34\u0e25\u0e14\u0e4c\u0e17\u0e35\u0e48\u0e1c\u0e39\u0e49\u0e43\u0e0a\u0e49\u0e22\u0e31\u0e07\u0e44\u0e21\u0e48\u0e01\u0e23\u0e2d\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e41\u0e25\u0e30\u0e40\u0e23\u0e32\u0e01\u0e33\u0e2b\u0e19\u0e14\u0e1f\u0e34\u0e25\u0e14\u0e4c\u0e19\u0e31\u0e49\u0e19\u0e46\u0e43\u0e2b\u0e49\u0e40\u0e1b\u0e47\u0e19\u0e04\u0e48\u0e32\u0e27\u0e48\u0e32\u0e07 \u00a0(NULL) \u00a0\u0e40\u0e23\u0e32\u0e01\u0e47\u0e08\u0e30\u0e17\u0e33\u0e40\u0e23\u0e35\u0e22\u0e01\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e04\u0e48\u0e32\u0e27\u0e48\u0e32\u0e07\u0e19\u0e31\u0e49\u0e19\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07 \u0e21\u0e32\u0e40\u0e23\u0e34\u0e48\u0e21\u0e01\u0e31\u0e19\u0e40\u0e25\u0e22\u0e04\u0e23\u0e31\u0e1a... Database CREATE TABLE `tbl_member` ( `member_id` int(10) NOT NULL auto_increment, `member_name` varchar(100) NOT NULL, `member_lname` varchar(100) NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(50) NOT NULL, `email` varchar(15) NOT NULL, `phone` varchar(15) default NULL, `date_regis` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`member_id`)\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"https:\/\/devbanban.com\/?cat=15"},"img":{"alt_text":"1","src":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/09\/1.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/09\/1.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/09\/1.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/09\/1.jpg?resize=700%2C400 2x"},"classes":[]},{"id":4031,"url":"https:\/\/devbanban.com\/?p=4031","url_meta":{"origin":343,"position":3},"title":"PHP : \u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07\u0e01\u0e32\u0e23\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e15\u0e48\u0e2d 2 \u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e43\u0e19\u0e2b\u0e19\u0e49\u0e32\u0e40\u0e14\u0e35\u0e22\u0e27\u0e01\u0e31\u0e19, Connect 2 database on a single webpage","author":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","date":"03\/06\/2021","format":false,"excerpt":"\u0e43\u0e19\u0e1a\u0e32\u0e07\u0e01\u0e23\u0e13\u0e35\u0e08\u0e33\u0e40\u0e1b\u0e47\u0e19\u0e17\u0e35\u0e48\u0e08\u0e30\u0e15\u0e49\u0e2d\u0e07\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e15\u0e48\u0e2d\u0e41\u0e25\u0e30\u0e40\u0e23\u0e35\u0e22\u0e01\u0e43\u0e0a\u0e49\u0e07\u0e32\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e21\u0e32\u0e01\u0e01\u0e27\u0e48\u0e32 1 \u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e43\u0e19\u0e23\u0e30\u0e1a\u0e1a\u0e40\u0e14\u0e35\u0e22\u0e27\u0e01\u0e31\u0e19 \u0e14\u0e31\u0e07\u0e19\u0e31\u0e49\u0e19\u0e40\u0e23\u0e32\u0e21\u0e32\u0e1d\u0e36\u0e01\u0e17\u0e33 workshop \u0e01\u0e31\u0e19\u0e04\u0e23\u0e31\u0e1a \u0e40\u0e1c\u0e37\u0e48\u0e2d\u0e44\u0e14\u0e49\u0e43\u0e0a\u0e49\u0e43\u0e19\u0e2d\u0e19\u0e32\u0e04\u0e15 \u0e2b\u0e23\u0e37\u0e2d\u0e40\u0e23\u0e35\u0e22\u0e19\u0e23\u0e39\u0e49\u0e44\u0e27\u0e49\u0e01\u0e47\u0e44\u0e21\u0e48\u0e40\u0e2a\u0e35\u0e22\u0e2b\u0e32\u0e22\u0e04\u0e23\u0e31\u0e1a \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e43\u0e04\u0e23\u0e17\u0e35\u0e48\u0e1e\u0e36\u0e48\u0e07\u0e1d\u0e36\u0e01\u0e20\u0e32\u0e29\u0e32\u00a0PHP\u00a0\u0e44\u0e1b\u0e14\u0e39\u0e04\u0e25\u0e34\u0e1b\u0e0a\u0e38\u0e14\u0e19\u0e35\u0e49\u0e01\u0e48\u0e2d\u0e19\u0e04\u0e23\u0e31\u0e1a *Basic PHP 100 \u0e04\u0e25\u0e34\u0e1b ++ \u0e21\u0e32\u0e40\u0e23\u0e34\u0e48\u0e21\u0e15\u0e49\u0e19\u0e17\u0e33 Workshop \u0e01\u0e31\u0e19\u0e04\u0e23\u0e31\u0e1a 1.import \u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 CREATE DATABASE IF NOT EXISTS `workshop_db001` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `workshop_db001`; -- -------------------------------------------------------- -- -- Table structure for table `tbl_test1` -- CREATE TABLE `tbl_test1` ( `id` int(11) NOT\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"https:\/\/devbanban.com\/?cat=15"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2021\/06\/con2db.jpg?fit=800%2C524&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2021\/06\/con2db.jpg?fit=800%2C524&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2021\/06\/con2db.jpg?fit=800%2C524&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2021\/06\/con2db.jpg?fit=800%2C524&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":407,"url":"https:\/\/devbanban.com\/?p=407","url_meta":{"origin":343,"position":4},"title":"\u0e41\u0e2a\u0e14\u0e07\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e43\u0e0a\u0e48\u0e04\u0e48\u0e32\u0e27\u0e48\u0e32\u0e07 PHP","author":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","date":"16\/09\/2015","format":false,"excerpt":"\u0e2b\u0e25\u0e31\u0e07\u0e08\u0e32\u0e01\u0e40\u0e23\u0e32\u0e44\u0e14\u0e49\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e2a\u0e21\u0e31\u0e04\u0e23\u0e2a\u0e21\u0e32\u0e0a\u0e34\u0e01\u0e41\u0e25\u0e30\u0e40\u0e01\u0e47\u0e1a\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e25\u0e07\u0e43\u0e19 database \u0e41\u0e25\u0e49\u0e27 \u00a0\u0e41\u0e15\u0e48\u0e21\u0e35\u0e1a\u0e32\u0e07\u0e1f\u0e34\u0e25\u0e14\u0e4c\u0e17\u0e35\u0e48\u0e1c\u0e39\u0e49\u0e43\u0e0a\u0e49\u0e22\u0e31\u0e07\u0e44\u0e21\u0e48\u0e01\u0e23\u0e2d\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e41\u0e25\u0e30\u0e40\u0e23\u0e32\u0e01\u0e33\u0e2b\u0e19\u0e14\u0e1f\u0e34\u0e25\u0e14\u0e4c\u0e19\u0e31\u0e49\u0e19\u0e46\u0e43\u0e2b\u0e49\u0e40\u0e1b\u0e47\u0e19\u0e04\u0e48\u0e32\u0e27\u0e48\u0e32\u0e07 \u00a0(NULL) \u00a0\u0e40\u0e23\u0e32\u0e01\u0e47\u0e08\u0e30\u0e17\u0e33\u0e40\u0e23\u0e35\u0e22\u0e01\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e21\u0e32\u0e41\u0e2a\u0e14\u0e07\u0e40\u0e09\u0e1e\u0e32\u0e30\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e44\u0e21\u0e48\u0e40\u0e1b\u0e47\u0e19\u0e04\u0e48\u0e32\u0e27\u0e48\u0e32\u0e07\u00a0 \u00a0\u0e21\u0e32\u0e40\u0e23\u0e34\u0e48\u0e21\u0e01\u0e31\u0e19\u0e40\u0e25\u0e22\u0e04\u0e23\u0e31\u0e1a... Database CREATE TABLE `tbl_member` ( `member_id` int(10) NOT NULL auto_increment, `member_name` varchar(100) NOT NULL, `member_lname` varchar(100) NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(50) NOT NULL, `email` varchar(15) NOT NULL, `phone` varchar(15) default NULL, `date_regis` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`member_id`)\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"https:\/\/devbanban.com\/?cat=15"},"img":{"alt_text":"1","src":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/09\/1.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/09\/1.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/09\/1.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2015\/09\/1.jpg?resize=700%2C400 2x"},"classes":[]},{"id":771,"url":"https:\/\/devbanban.com\/?p=771","url_meta":{"origin":343,"position":5},"title":"PHP +Mysqli : \u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e15\u0e34\u0e14\u0e15\u0e48\u0e2d\u0e41\u0e1a\u0e1a\u0e40\u0e01\u0e47\u0e1a IP \u0e1c\u0e39\u0e49\u0e43\u0e0a\u0e49\u0e40\u0e02\u0e49\u0e32\u0e44\u0e1b\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25","author":"\u0e1e\u0e34\u0e28\u0e34\u0e29\u0e10\u0e4c \u0e1a\u0e27\u0e23\u0e40\u0e25\u0e34\u0e28\u0e2a\u0e38\u0e18\u0e35","date":"21\/04\/2016","format":false,"excerpt":"\u0e43\u0e19 workshop \u0e19\u0e35\u0e49\u0e08\u0e30\u0e41\u0e19\u0e30\u0e19\u0e33\u0e01\u0e32\u0e23\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e15\u0e34\u0e14\u0e15\u0e48\u0e2d\u0e42\u0e14\u0e22\u0e21\u0e35\u0e01\u0e32\u0e23\u0e40\u0e01\u0e47\u0e1a IP \u0e02\u0e2d\u0e07\u0e1c\u0e39\u0e49\u0e15\u0e34\u0e14\u0e15\u0e48\u0e2d\u0e2b\u0e23\u0e37\u0e2d\u0e1c\u0e39\u0e49\u0e43\u0e0a\u0e49\u0e40\u0e02\u0e49\u0e32\u0e44\u0e1b\u0e43\u0e19\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e14\u0e49\u0e27\u0e22 \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e43\u0e0a\u0e49\u0e40\u0e1b\u0e47\u0e19\u0e2b\u0e25\u0e31\u0e01\u0e10\u0e32\u0e19\u0e2d\u0e49\u0e32\u0e07\u0e2d\u0e34\u0e07\u0e15\u0e48\u0e32\u0e07\u0e46 \u00a0 \u0e01\u0e47\u0e43\u0e0a\u0e49\u0e40\u0e17\u0e04\u0e19\u0e34\u0e04\u0e01\u0e32\u0e23 Insert into \u0e40\u0e2b\u0e21\u0e37\u0e2d\u0e19\u0e40\u0e14\u0e34\u0e21 \u00a0\u0e0b\u0e36\u0e48\u0e07\u0e01\u0e47\u0e04\u0e25\u0e49\u0e32\u0e22\u0e46 \u0e01\u0e31\u0e1a\u0e1f\u0e2d\u0e23\u0e4c\u0e21\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e31\u0e48\u0e27\u0e46\u0e44\u0e1b\u0e19\u0e31\u0e49\u0e19\u0e41\u0e2b\u0e25\u0e30\u0e04\u0e23\u0e31\u0e1a \u00a0\u0e21\u0e32\u0e14\u0e39\u0e15\u0e31\u0e27\u0e2d\u0e22\u0e48\u0e32\u0e07 workshop \u0e01\u0e31\u0e19\u0e04\u0e23\u0e31\u0e1a SQL \u0e15\u0e32\u0e23\u0e32\u0e07\u0e17\u0e35\u0e48\u0e43\u0e0a\u0e49 CREATE TABLE `contact` ( `cid` int(10) NOT NULL auto_increment, `detail` text NOT NULL, `email` varchar(50) NOT NULL, `cip` varchar(20) NOT NULL, `datesave` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`cid`) ) ENGINE=MyISAM\u2026","rel":"","context":"In &quot;PHP&quot;","block_context":{"text":"PHP","link":"https:\/\/devbanban.com\/?cat=15"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/devbanban.com\/wp-content\/uploads\/2016\/04\/faa.jpg?fit=504%2C437&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/devbanban.com\/index.php?rest_route=\/wp\/v2\/posts\/343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devbanban.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devbanban.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devbanban.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devbanban.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=343"}],"version-history":[{"count":7,"href":"https:\/\/devbanban.com\/index.php?rest_route=\/wp\/v2\/posts\/343\/revisions"}],"predecessor-version":[{"id":676,"href":"https:\/\/devbanban.com\/index.php?rest_route=\/wp\/v2\/posts\/343\/revisions\/676"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devbanban.com\/index.php?rest_route=\/wp\/v2\/media\/152"}],"wp:attachment":[{"href":"https:\/\/devbanban.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devbanban.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devbanban.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}