{"id":3319,"date":"2016-07-17T08:10:38","date_gmt":"2016-07-17T08:10:38","guid":{"rendered":"https:\/\/kiencang.net\/?p=3319"},"modified":"2016-07-17T08:10:38","modified_gmt":"2016-07-17T08:10:38","slug":"tao-co-du-lieu-mysql-trong-php","status":"publish","type":"post","link":"https:\/\/kiencang.net\/tao-co-du-lieu-mysql-trong-php\/","title":{"rendered":"T\u1ea1o c\u01a1 s\u01a1 d\u1eef li\u1ec7u MySQL trong PHP"},"content":{"rendered":"\n<p>M\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 th\u1ec3 bao g\u1ed3m m\u1ed9t ho\u1eb7c nhi\u1ec1u b\u1ea3ng.<\/p>\n\n\n\n<p>B\u1ea1n s\u1ebd c\u1ea7n \u0111\u1eb7c quy\u1ec1n CREATE \u0111\u1ec3 t\u1ea1o ho\u1eb7c xo\u00e1 c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">T\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL s\u1eed d\u1ee5ng MySQLi v\u00e0 PDO<\/h2>\n\n\n\n<p>L\u1ec7nh CREATE DATABASE s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u trong MySQL.<\/p>\n\n\n\n<p>C\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y t\u1ea1o m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 t\u00ean &#8220;myDB&#8221;:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5 (MySQLi h\u01b0\u1edbng \u0111\u1ed1i t\u01b0\u1ee3ng)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n $servername = \"localhost\";\n $username = \"username\";\n $password = \"password\";\n\n\/\/ Create connection\n $conn = new mysqli($servername, $username, $password);\n \/\/ Check connection\n if ($conn->connect_error) {\n die(\"Connection failed: \" . $conn->connect_error);\n }\n\n\/\/ Create database\n $sql = \"CREATE DATABASE myDB\";\n if ($conn->query($sql) === TRUE) {\n echo \"CSDL duoc tao thanh cong\";\n } else {\n echo \"Co loi khi tao CSDL: \" . $conn->error;\n }\n\n$conn->close();\n ?><\/code><\/pre>\n\n\n\n<p>Ch\u00fa \u00fd: Khi b\u1ea1n t\u1ea1o m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1edbi, b\u1ea1n s\u1ebd ch\u1ec9 \u0111\u1ecbnh ba \u0111\u1ed1i s\u1ed1 \u0111\u1ea7u ti\u00ean cho \u0111\u1ed1i t\u01b0\u1ee3ng mysqli (servername, username v\u00e0 password).<\/p>\n\n\n\n<p>M\u1eb9o: N\u1ebfu b\u1ea1n s\u1eed d\u1ee5ng c\u1ed5ng ch\u1ec9 \u0111\u1ecbnh, th\u00eam m\u1ed9t chu\u1ed7i r\u1ed7ng cho t\u00ean c\u01a1 s\u1edf d\u1eef li\u1ec7u, gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:\u00a0<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>new mysqli(\"localhost\", \"username\", \"password\", \"\", port)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5 (MySQLi Th\u1ee7 t\u1ee5c)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n $servername = \"localhost\";\n $username = \"username\";\n $password = \"password\";\n\n\/\/ T\u1ea1o k\u1ebft n\u1ed1i\n $conn = mysqli_connect($servername, $username, $password);\n\n\/\/ Ki\u1ec3m tra k\u1ebft n\u1ed1i\n if (!$conn) {\n die(\"Connection failed: \" . mysqli_connect_error());\n }\n\n\/\/ T\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u\n $sql = \"CREATE DATABASE myDB\";\n if (mysqli_query($conn, $sql)) {\n\necho \"C\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea1o th\u00e0nh c\u00f4ng\";\n } else {\n echo \"T\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u b\u1ecb l\u1ed7i: \" . mysqli_error($conn);\n }\n\nmysqli_close($conn);\n ?><\/code><\/pre>\n\n\n\n<p>Ch\u00fa \u00fd: V\u00ed d\u1ee5 PDO sau \u0111\u00e2y t\u1ea1o m\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u t\u00ean l\u00e0 &#8220;myDBPDO&#8221;:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">V\u00ed d\u1ee5 (PDO)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n $servername = \"localhost\";\n $username = \"username\";\n $password = \"password\";\n\ntry {\n $conn = new PDO(\"mysql:host=$servername;dbname=myDB\", $username, $password);\n\n\/\/ Thi\u1ebft l\u1eadp c\u00e1c ch\u1ebf \u0111\u1ed9 l\u1ed7i PDO \u0111\u1ec3 ngo\u1ea1i l\u1ec7\n $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n $sql = \"CREATE DATABASE myDBPDO\";\n\n\/\/ s\u1eed d\u1ee5ng exec() b\u1edfi v\u00ec kh\u00f4ng c\u00f3 k\u1ebft qu\u1ea3 n\u00e0o tr\u1ea3 v\u1ec1 \n $conn->exec($sql);\n echo \"C\u01a1 s\u1edf d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea1o th\u00e0nh c\u00f4ng&lt;br>\";\n }\n\ncatch(PDOException $e)\n {\n echo $sql . \"&lt;br>\" . $e->getMessage();\n }\n\n$conn = null;\n ?><\/code><\/pre>\n\n\n\n<p><strong>M\u1eb9o<\/strong>: M\u1ed9t l\u1ee3i \u00edch l\u1edbn c\u1ee7a PDO l\u00e0 n\u00f3 c\u00f3 l\u1edbp ngo\u1ea1i l\u1ec7 \u0111\u1ec3 x\u1eed l\u00fd b\u1ea5t k\u1ef3 v\u1ea5n \u0111\u1ec1 n\u00e0o 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 ra b\u00ean trong kh\u1ed1i try{}, k\u1ecbch b\u1ea3n ng\u1eebng th\u1ef1c thi v\u00e0 \u0111\u1ed5 tr\u1ef1c ti\u1ebfp \u0111\u1ec3 b\u1eaft \u0111\u1ea7u kh\u1ed1i catch(). Trong kh\u1ed1i catch tr\u00ean ch\u00fang ta xu\u1ea5t ra c\u00e2u l\u1ec7nh SQL v\u00e0 c\u00e1c th\u00f4ng b\u00e1o l\u1ed7i \u0111\u01b0\u1ee3c t\u1ea1o ra.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>M\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 th\u1ec3 bao g\u1ed3m m\u1ed9t ho\u1eb7c nhi\u1ec1u b\u1ea3ng. B\u1ea1n s\u1ebd c\u1ea7n \u0111\u1eb7c quy\u1ec1n CREATE \u0111\u1ec3 t\u1ea1o ho\u1eb7c xo\u00e1 c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL. T\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL s\u1eed d\u1ee5ng MySQLi v\u00e0 PDO L\u1ec7nh CREATE DATABASE s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u trong MySQL. C\u00e1c v\u00ed d\u1ee5 &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>T\u1ea1o c\u01a1 s\u01a1 d\u1eef li\u1ec7u MySQL trong 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\/tao-co-du-lieu-mysql-trong-php\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u1ea1o c\u01a1 s\u01a1 d\u1eef li\u1ec7u MySQL trong PHP &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"M\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 th\u1ec3 bao g\u1ed3m m\u1ed9t ho\u1eb7c nhi\u1ec1u b\u1ea3ng. B\u1ea1n s\u1ebd c\u1ea7n \u0111\u1eb7c quy\u1ec1n CREATE \u0111\u1ec3 t\u1ea1o ho\u1eb7c xo\u00e1 c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL. T\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL s\u1eed d\u1ee5ng MySQLi v\u00e0 PDO L\u1ec7nh CREATE DATABASE s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u trong MySQL. C\u00e1c v\u00ed d\u1ee5 &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/tao-co-du-lieu-mysql-trong-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=\"2016-07-17T08:10:38+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=\"2 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T\u1ea1o c\u01a1 s\u01a1 d\u1eef li\u1ec7u MySQL trong 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\/tao-co-du-lieu-mysql-trong-php\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u1ea1o c\u01a1 s\u01a1 d\u1eef li\u1ec7u MySQL trong PHP &#8226; Ki\u1ebfn c\u00e0ng","og_description":"M\u1ed9t c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u00f3 th\u1ec3 bao g\u1ed3m m\u1ed9t ho\u1eb7c nhi\u1ec1u b\u1ea3ng. B\u1ea1n s\u1ebd c\u1ea7n \u0111\u1eb7c quy\u1ec1n CREATE \u0111\u1ec3 t\u1ea1o ho\u1eb7c xo\u00e1 c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL. T\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL s\u1eed d\u1ee5ng MySQLi v\u00e0 PDO L\u1ec7nh CREATE DATABASE s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o c\u01a1 s\u1edf d\u1eef li\u1ec7u trong MySQL. C\u00e1c v\u00ed d\u1ee5 &hellip;","og_url":"https:\/\/kiencang.net\/tao-co-du-lieu-mysql-trong-php\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2016-07-17T08:10:38+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":"2 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/tao-co-du-lieu-mysql-trong-php\/","url":"https:\/\/kiencang.net\/tao-co-du-lieu-mysql-trong-php\/","name":"T\u1ea1o c\u01a1 s\u01a1 d\u1eef li\u1ec7u MySQL trong PHP &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2016-07-17T08:10:38+00:00","dateModified":"2016-07-17T08:10:38+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/tao-co-du-lieu-mysql-trong-php\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/tao-co-du-lieu-mysql-trong-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/tao-co-du-lieu-mysql-trong-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"T\u1ea1o c\u01a1 s\u01a1 d\u1eef li\u1ec7u MySQL trong 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\/3319"}],"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=3319"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3319\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=3319"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=3319"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=3319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}