{"id":17,"date":"2015-02-07T07:46:00","date_gmt":"2015-02-07T07:46:00","guid":{"rendered":"https:\/\/kiencang.net\/2015\/02\/07\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/"},"modified":"2015-02-07T07:46:00","modified_gmt":"2015-02-07T07:46:00","slug":"cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php","status":"publish","type":"post","link":"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/","title":{"rendered":"C\u00e1c ki\u1ec3u k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL b\u1eb1ng PHP"},"content":{"rendered":"\n<p>PHP 5 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n v\u1ec1 sau l\u00e0m vi\u1ec7c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL th\u00f4ng qua hai ph\u01b0\u01a1ng ph\u00e1p:<\/p>\n\n\n\n<ul><li><b>MySQLi extension<\/b> (ch\u1eef i vi\u1ebft t\u1eaft cho t\u1eeb c\u1ea3i ti\u1ebfn \/ improved);<\/li><li><b>PDO (PHP Data Objects)<\/b>;<\/li><\/ul>\n\n\n\n<p>C\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00e2y c\u1ee7a PHP s\u1eed d\u1ee5ng MySQL extension (<b>kh\u00f4ng c\u00f3 i<\/b>). Tuy nhi\u00ean, ph\u1ea7n m\u1edf r\u1ed9ng n\u00e0y kh\u00f4ng \u0111\u01b0\u1ee3c t\u00e1n th\u00e0nh t\u1eeb n\u0103m 2012.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_60 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6577d6963fbe6\" ><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6577d6963fbe6\"  type=\"checkbox\" id=\"item-6577d6963fbe6\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/#Vay_toi_nen_su_dung_MySQLi_hay_PDO\" title=\"V\u1eady t\u00f4i n\u00ean s\u1eed d\u1ee5ng MySQLi hay PDO\">V\u1eady t\u00f4i n\u00ean s\u1eed d\u1ee5ng MySQLi hay PDO<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/#Cac_vi_du_ve_MySQL_bao_gom_ca_cu_phap_cua_MySQLi_va_PDO\" title=\"C\u00e1c v\u00ed d\u1ee5 v\u1ec1 MySQL, bao g\u1ed3m c\u1ea3 c\u00fa ph\u00e1p c\u1ee7a MySQLi v\u00e0 PDO\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 MySQL, bao g\u1ed3m c\u1ea3 c\u00fa ph\u00e1p c\u1ee7a MySQLi v\u00e0 PDO<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/#Mo_va_ket_noi_voi_MySQL\" title=\"M\u1edf v\u00e0 k\u1ebft n\u1ed1i v\u1edbi MySQL\">M\u1edf v\u00e0 k\u1ebft n\u1ed1i v\u1edbi MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/#Dong_ket_noi\" title=\"\u0110\u00f3ng k\u1ebft n\u1ed1i\">\u0110\u00f3ng k\u1ebft n\u1ed1i<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Vay_toi_nen_su_dung_MySQLi_hay_PDO\"><\/span>V\u1eady t\u00f4i n\u00ean s\u1eed d\u1ee5ng MySQLi hay PDO<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>N\u1ebfu b\u1ea1n c\u1ea7n c\u00e2u tr\u1ea3 l\u1eddi nhanh g\u1ecdn th\u00ec \u0111\u00f3 l\u00e0: &#8220;T\u00f9y v\u00e0o b\u1ea1n th\u00edch c\u00e1i n\u00e0o h\u01a1n!&#8221;<\/p>\n\n\n\n<p>C\u1ea3 MySQLi v\u00e0 PDO \u0111\u1ec1u c\u00f3 nh\u1eefng l\u1ee3i th\u1ebf ri\u00eang.<\/p>\n\n\n\n<p>PDO l\u00e0m vi\u1ec7c v\u1edbi 12 h\u1ec7 th\u1ed1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u kh\u00e1c nhau, trong khi MySQLi ch\u1ec9 l\u00e0m vi\u1ec7c v\u1edbi duy nh\u1ea5t h\u1ec7 c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL m\u00e0 th\u00f4i.<\/p>\n\n\n\n<p>V\u00ec v\u1eady n\u1ebfu b\u1ea1n c\u1ea7n chuy\u1ec3n \u0111\u1ed5i d\u1ef1 \u00e1n \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi c\u00e1c h\u1ec7 c\u01a1 s\u1ee1 d\u1eef li\u1ec7u kh\u00e1c nhau th\u00ec PDO s\u1ebd t\u1ed1t cho b\u1ea1n h\u01a1n. B\u1ea1n ch\u1ec9 ph\u1ea3i thay \u0111\u1ed5i m\u00e3 k\u1ebft n\u1ed1i v\u00e0 v\u00e0i c\u00e2u truy v\u1ea5n. V\u1edbi MySQLi b\u1ea1n ph\u1ea3i vi\u1ebft l\u1ea1i code ho\u00e0n to\u00e0n, bao g\u1ed3m c\u1ea3 truy v\u1ea5n.<\/p>\n\n\n\n<p>C\u1ea3 hai \u0111\u1ec1u h\u01b0\u1edbng \u0111\u1ed1i t\u01b0\u1ee3ng nh\u01b0ng MySQLi cung c\u1ea5p API cho b\u1ea1n.<\/p>\n\n\n\n<p>C\u1ea3 hai \u0111\u1ec1u h\u1ed7 tr\u1ee3 Prepared Statements. Prepared Statements gi\u00fap b\u1ea1n \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 kh\u1ecfi c\u00e1c cu\u1ed9c t\u1ea5n c\u00f4ng s\u1eed d\u1ee5ng SQL injection v\u00e0 \u0111i\u1ec1u n\u00e0y r\u1ea5t quan tr\u1ecdng cho c\u00e1c \u1ee9ng d\u1ee5ng web c\u1ea7n t\u00ednh b\u1ea3o m\u1eadt.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cac_vi_du_ve_MySQL_bao_gom_ca_cu_phap_cua_MySQLi_va_PDO\"><\/span>C\u00e1c v\u00ed d\u1ee5 v\u1ec1 MySQL, bao g\u1ed3m c\u1ea3 c\u00fa ph\u00e1p c\u1ee7a MySQLi v\u00e0 PDO<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Trong ph\u1ea7n n\u00e0y v\u00e0 c\u00e1c ph\u1ea7n sau, ch\u00fang t\u00f4i \u0111\u01b0a ra ba c\u00e1ch \u0111\u1ec3 l\u00e0m vi\u1ec7c v\u1edbi PHP v\u00e0 MySQL:<\/p>\n\n\n\n<ul><li>MySQLi (h\u01b0\u1edbng \u0111\u1ed1i t\u01b0\u1ee3ng);<\/li><li>MySQLi (th\u1ee7 t\u1ee5c);<\/li><li>PDO;<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">C\u00e0i \u0111\u1eb7t MySQLi<\/h3>\n\n\n\n<p>D\u00f9ng cho Linux v\u00e0 Windows: C\u00e1c extension c\u1ee7a MySQLi \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t m\u1eb7c \u0111\u1ecbnh trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p khi g\u00f3i PHP5 mysql \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t.<\/p>\n\n\n\n<p>H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t chi ti\u1ebft, xem t\u1ea1i \u0111\u00e2y: <a href=\"http:\/\/php.net\/manual\/en\/mysqli.installation.php\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/php.net\/manual\/en\/mysqli.installation.php<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">C\u00e0i \u0111\u1eb7t PDO<\/h3>\n\n\n\n<p>H\u01b0\u1edbng d\u1eabn chi ti\u1ebft xem t\u1ea1i \u0111\u00e2y:<a href=\"http:\/\/php.net\/manual\/en\/pdo.installation.php\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/php.net\/manual\/en\/pdo.installation.php<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Mo_va_ket_noi_voi_MySQL\"><\/span>M\u1edf v\u00e0 k\u1ebft n\u1ed1i v\u1edbi MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Tr\u01b0\u1edbc khi ch\u00fang ta c\u00f3 quy\u1ec1n truy c\u1eadp v\u00e0o c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL, ch\u00fang ta c\u1ea7n k\u1ebft n\u1ed1i v\u1edbi server:<\/p>\n\n\n\n<p>V\u00ed d\u1ee5 (MySQLi h\u01b0\u1edbng \u0111\u1ed1i t\u01b0\u1ee3ng):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n\n$servername = \"localhost\";\n\n$username = \"username\";\n\n$password = \"password\";\n\n\/\/ T\u1ea1o k\u1ebft n\u1ed1i\n\n$conn = new mysqli($servername, $username, $password);\n\n\/\/ Ki\u1ec3m tra k\u1ebft n\u1ed1i\n\nif ($conn->connect_error) {\n\ndie(\"Connection failed: \" . $conn->connect_error);\n\n}\n\necho \"Connected successfully\";\n\n?><\/code><\/pre>\n\n\n\n<p>Ch\u00fa \u00fd: trong v\u00ed d\u1ee5 theo ki\u1ec3u h\u01b0\u1edbng \u0111\u1ed1i t\u01b0\u1ee3ng \u1edf tr\u00ean: $connect_error s\u1ebd c\u00f3 v\u1ea5n \u0111\u1ec1 v\u1edbi c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc PHP 5.2.9 v\u00e0 5.3.0. N\u1ebfu b\u1ea1n c\u1ea7n \u0111\u1ea3m b\u1ea3o kh\u1ea3 n\u0103ng t\u01b0\u01a1ng th\u00edch v\u1edbi c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3, s\u1eed d\u1ee5ng \u0111o\u1ea1n code thay th\u1ebf d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ Ki\u1ec3m tra k\u1ebft n\u1ed1i\n\nif (mysqli_connect_error()) {\n\ndie(\"Database connection failed: \" . mysqli_connect_error());\n\n}<\/code><\/pre>\n\n\n\n<p>V\u00ed d\u1ee5 (MySQLi th\u1ee7 t\u1ee5c):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n\n$servername = \"localhost\";\n\n$username = \"username\";\n\n$password = \"password\";\n\n\/\/ T\u1ea1o k\u1ebft n\u1ed1i\n\n$conn = mysqli_connect($servername, $username, $password);\n\n\/\/ Ki\u1ec3m tra k\u1ebft n\u1ed1i\n\nif (!$conn) {\n\ndie(\"Connection failed: \" . mysqli_connect_error());\n\n}\n\necho \"Connected successfully\";\n\n?><\/code><\/pre>\n\n\n\n<p>V\u00ed d\u1ee5 (PDO):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n\n$servername = \"localhost\";\n\n$username = \"username\";\n\n$password = \"password\";\n\ntry {\n\n$conn = new PDO(\"mysql:host=$servername;dbname=myDB\", $username, $password);\n\n\/\/ set the PDO error mode to exception\n\n$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n\necho \"Connected successfully\";\n\n}\n\ncatch(PDOException $e)\n\n{\n\necho \"Connection failed: \" . $e->getMessage();\n\n}\n\n?><\/code><\/pre>\n\n\n\n<p>Ch\u00fa \u00fd r\u1eb1ng trong v\u00ed d\u1ee5 v\u1ec1 PDO \u1edf tr\u00ean, ch\u00fang ta c\u0169ng \u0111\u00e3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u (myDB ) . PDO \u0111\u00f2i h\u1ecfi m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u h\u1ee3p l\u1ec7 \u0111\u1ec3 k\u1ebft n\u1ed1i. N\u1ebfu kh\u00f4ng c\u00f3 c\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ch\u1ec9 \u0111\u1ecbnh, m\u1ed9t ngo\u1ea1i l\u1ec7 (exception) \u0111\u01b0\u1ee3c n\u00e9m ra.<\/p>\n\n\n\n<p>M\u1eb9o: L\u1ee3i \u00edch l\u1edbn c\u1ee7a PDO l\u00e0 n\u00f3 c\u00f3 m\u1ed9t l\u1edbp ngo\u1ea1i l\u1ec7 \u0111\u1ec3 x\u1eed l\u00fd b\u1ea5t k\u1ef3 v\u1ea5n \u0111\u1ec1 c\u00f3 th\u1ec3 x\u1ea3y ra trong c\u00e1c truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta. N\u1ebfu m\u1ed9t ngo\u1ea1i l\u1ec7 \u0111\u01b0\u1ee3c n\u00e9m trong khu v\u1ef1c try { }, k\u1ecbch b\u1ea3n ng\u1eebng th\u1ef1c thi v\u00e0 \u0111\u1ed5 tr\u1ef1c ti\u1ebfp v\u00e0o khu v\u1ef1c catch( ) { }.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Dong_ket_noi\"><\/span>\u0110\u00f3ng k\u1ebft n\u1ed1i<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>K\u1ebft n\u1ed1i s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00f3ng t\u1ef1 \u0111\u1ed9ng khi m\u00e3 k\u1ebft th\u00fac, \u0111\u1ec3 \u0111\u00f3ng k\u1ebft n\u00f3i tr\u01b0\u1edbc \u0111\u00f3, s\u1eed d\u1ee5ng \u0111o\u1ea1n code sau:<\/p>\n\n\n\n<p>V\u00ed d\u1ee5 (MySQLi h\u01b0\u1edbng \u0111\u1ed1i t\u01b0\u1ee3ng):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$conn->close();<\/code><\/pre>\n\n\n\n<p>V\u00ed d\u1ee5 (MySQLi Th\u1ee7 t\u1ee5c):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysqli_close($conn);<\/code><\/pre>\n\n\n\n<p>V\u00ed d\u1ee5 (PDO):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$conn = null;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>PHP 5 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n v\u1ec1 sau l\u00e0m vi\u1ec7c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL th\u00f4ng qua hai ph\u01b0\u01a1ng ph\u00e1p: MySQLi extension (ch\u1eef i vi\u1ebft t\u1eaft cho t\u1eeb c\u1ea3i ti\u1ebfn \/ improved); PDO (PHP Data Objects); C\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00e2y c\u1ee7a PHP s\u1eed d\u1ee5ng MySQL extension (kh\u00f4ng c\u00f3 i). Tuy nhi\u00ean, ph\u1ea7n m\u1edf &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[238],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1c ki\u1ec3u k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL b\u1eb1ng PHP &#8226; Ki\u1ebfn c\u00e0ng<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c ki\u1ec3u k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL b\u1eb1ng PHP &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"PHP 5 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n v\u1ec1 sau l\u00e0m vi\u1ec7c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL th\u00f4ng qua hai ph\u01b0\u01a1ng ph\u00e1p: MySQLi extension (ch\u1eef i vi\u1ebft t\u1eaft cho t\u1eeb c\u1ea3i ti\u1ebfn \/ improved); PDO (PHP Data Objects); C\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00e2y c\u1ee7a PHP s\u1eed d\u1ee5ng MySQL extension (kh\u00f4ng c\u00f3 i). Tuy nhi\u00ean, ph\u1ea7n m\u1edf &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-02-07T07:46:00+00:00\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1c ki\u1ec3u k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL b\u1eb1ng PHP &#8226; Ki\u1ebfn c\u00e0ng","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:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1c ki\u1ec3u k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL b\u1eb1ng PHP &#8226; Ki\u1ebfn c\u00e0ng","og_description":"PHP 5 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n v\u1ec1 sau l\u00e0m vi\u1ec7c v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL th\u00f4ng qua hai ph\u01b0\u01a1ng ph\u00e1p: MySQLi extension (ch\u1eef i vi\u1ebft t\u1eaft cho t\u1eeb c\u1ea3i ti\u1ebfn \/ improved); PDO (PHP Data Objects); C\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00e2y c\u1ee7a PHP s\u1eed d\u1ee5ng MySQL extension (kh\u00f4ng c\u00f3 i). Tuy nhi\u00ean, ph\u1ea7n m\u1edf &hellip;","og_url":"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2015-02-07T07:46:00+00:00","author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"4 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/","url":"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/","name":"C\u00e1c ki\u1ec3u k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL b\u1eb1ng PHP &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2015-02-07T07:46:00+00:00","dateModified":"2015-02-07T07:46:00+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/cac-kieu-ket-noi-co-so-du-lieu-mysql-bang-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"C\u00e1c ki\u1ec3u k\u1ebft n\u1ed1i c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL b\u1eb1ng PHP"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/17"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/17\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}