{"id":499,"date":"2019-09-16T11:48:55","date_gmt":"2019-09-16T11:48:55","guid":{"rendered":"https:\/\/www.webhozz.com\/code\/?p=499"},"modified":"2019-09-16T12:27:30","modified_gmt":"2019-09-16T12:27:30","slug":"php-menghubungkan-php-dengan-mysql-server","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/","title":{"rendered":"PHP MySQL : Connect"},"content":{"rendered":"\n<h5 class=\"wp-block-heading\">Menghubungkan PHP dengan MySQL Server<\/h5>\n\n\n\n<p>Untuk menyimpan atau mengakses data di dalam database MySQL,\nkalian harus terlebih dahulu terhubung ke server database MySQL. PHP menawarkan\ndua cara berbeda untuk terhubung ke server MySQL: ekstensi <strong><em>MySQLi<\/em><\/strong> (Improved MySQL)\ndan <strong><em>PDO<\/em><\/strong>\n(PHP Data Objects).<\/p>\n\n\n\n<p>Sementara ekstensi PDO lebih portabel dan mendukung lebih dari dua belas database yang berbeda, ekstensi MySQLi seperti namanya hanya mendukung database MySQL. Namun ekstensi MySQLi menyediakan cara yang lebih mudah untuk terhubung, dan menjalankan query pada, server database MySQL. Baik PDO dan MySQLi menawarkan API berorientasi objek, tetapi MySQLi juga menawarkan API prosedural yang relatif mudah bagi pemula untuk memahaminya.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Menghubungkan MySQL dengan Database Server<\/h5>\n\n\n\n<p>Dalam PHP kalian dapat dengan mudah melakukan hal ini menggunakan fungsi <strong><em>mysqli_connect().<\/em><\/strong> Semua komunikasi antara PHP dan server database MySQL dilakukan melalui koneksi ini. Inilah sintaks dasar untuk menghubungkan ke MySQL menggunakan ekstensi MySQLi dan PDO:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img fetchpriority=\"high\" decoding=\"async\" width=\"794\" height=\"339\" src=\"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26.jpg\" alt=\"\" class=\"wp-image-501\" srcset=\"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26.jpg 794w, https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26-300x128.jpg 300w, https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26-768x328.jpg 768w\" sizes=\"(max-width: 794px) 100vw, 794px\" \/><\/figure>\n\n\n\n<p>Parameter <em>hostname<\/em>\ndalam sintaks di atas menentukan nama host (mis. <strong><em>Localhost<\/em><\/strong>), atau alamat\nIP dari server MySQL, sedangkan parameter <em>username\n<\/em>dan <em>password <\/em>menentukan\nkredensial untuk mengakses server MySQL, dan parameter database, jika\ndisediakan akan menentukan default MySQL database yang akan digunakan saat\nmelakukan Query.<\/p>\n\n\n\n<p>Contoh berikut menunjukkan bagaimana menghubungkannya ke server database MySQL menggunakan MySQLi (baik cara <em>procedural<\/em> dan <em>object oriented<\/em>) dan ekstensi PDO.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: php; title: ; notranslate\" title=\"\">\n&lt;?php\n\/* Attempt MySQL server connection. Assuming you are running MySQL\nserver with default setting (user 'root' with no password) *\/\n$link = mysqli_connect(&quot;localhost&quot;, &quot;root&quot;, &quot;&quot;);\n \n\/\/ Check connection\nif($link === false){\n    die(&quot;ERROR: Could not connect. &quot; . mysqli_connect_error());\n}\n \n\/\/ Print host information\necho &quot;Connect Successfully. Host info: &quot; . mysqli_get_host_info($link);\n?&gt;\n<\/pre><\/div>\n\n\n<p><strong><em>Tips<\/em><\/strong>: Mengatur atribut <strong><em>PDO: :ATTR_ERRMODE<\/em><\/strong> ke <strong><em>PDO: :ERRMODE_EXCEPTION<\/em><\/strong> memberi tahu PDO untuk memberi pengecualian setiap kali terjadi kesalahan basis data.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Menutup Koneksi Server Database MySQL<\/h5>\n\n\n\n<p>Koneksi ke server database MySQL akan ditutup secara otomatis segera setelah eksekusi skrip berakhir. Namun, jika kalian ingin menutupnya lebih awal, kalian dapat melakukan ini hanya dengan memanggil fungsi PHP <strong><em>mysqli_close().<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: php; title: ; notranslate\" title=\"\">\n&lt;?php\n\/* Attempt MySQL server connection. Assuming you are running MySQL\nserver with default setting (user 'root' with no password) *\/\n$link = mysqli_connect(&quot;localhost&quot;, &quot;root&quot;, &quot;&quot;);\n \n\/\/ Check connection\nif($link === false){\n    die(&quot;ERROR: Could not connect. &quot; . mysqli_connect_error());\n}\n \n\/\/ Print host information\necho &quot;Connect Successfully. Host info: &quot; . mysqli_get_host_info($link);\n \n\/\/ Close connection\nmysqli_close($link);\n?&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Menghubungkan PHP dengan MySQL Server Untuk menyimpan atau mengakses data di dalam database MySQL, kalian harus terlebih dahulu terhubung ke server database MySQL. PHP menawarkan<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-499","post","type-post","status-publish","format-standard","hentry","category-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Belajar PHP MySQL : Connect - WebHozz Code<\/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:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Belajar PHP MySQL : Connect - WebHozz Code\" \/>\n<meta property=\"og:description\" content=\"Menghubungkan PHP dengan MySQL Server Untuk menyimpan atau mengakses data di dalam database MySQL, kalian harus terlebih dahulu terhubung ke server database MySQL. PHP menawarkan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Code\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-16T11:48:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-16T12:27:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"794\" \/>\n\t<meta property=\"og:image:height\" content=\"339\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\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:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\"},\"headline\":\"PHP MySQL : Connect\",\"datePublished\":\"2019-09-16T11:48:55+00:00\",\"dateModified\":\"2019-09-16T12:27:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/\"},\"wordCount\":270,\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Untitled-1-26.jpg\",\"articleSection\":[\"PHP\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/\",\"name\":\"Belajar PHP MySQL : Connect - WebHozz Code\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Untitled-1-26.jpg\",\"datePublished\":\"2019-09-16T11:48:55+00:00\",\"dateModified\":\"2019-09-16T12:27:30+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Untitled-1-26.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/Untitled-1-26.jpg\",\"width\":794,\"height\":339},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-menghubungkan-php-dengan-mysql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP MySQL : Connect\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/\",\"name\":\"WebHozz Code\",\"description\":\"Tutorial Web &amp; Pemrograman Indonesia\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/author\\\/dody\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Belajar PHP MySQL : Connect - WebHozz Code","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:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/","og_locale":"en_US","og_type":"article","og_title":"Belajar PHP MySQL : Connect - WebHozz Code","og_description":"Menghubungkan PHP dengan MySQL Server Untuk menyimpan atau mengakses data di dalam database MySQL, kalian harus terlebih dahulu terhubung ke server database MySQL. PHP menawarkan","og_url":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/","og_site_name":"WebHozz Code","article_published_time":"2019-09-16T11:48:55+00:00","article_modified_time":"2019-09-16T12:27:30+00:00","og_image":[{"width":794,"height":339,"url":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1"},"headline":"PHP MySQL : Connect","datePublished":"2019-09-16T11:48:55+00:00","dateModified":"2019-09-16T12:27:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/"},"wordCount":270,"image":{"@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26.jpg","articleSection":["PHP"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/","url":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/","name":"Belajar PHP MySQL : Connect - WebHozz Code","isPartOf":{"@id":"https:\/\/www.webhozz.com\/code\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26.jpg","datePublished":"2019-09-16T11:48:55+00:00","dateModified":"2019-09-16T12:27:30+00:00","author":{"@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1"},"breadcrumb":{"@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/#primaryimage","url":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26.jpg","contentUrl":"https:\/\/www.webhozz.com\/code\/wp-content\/uploads\/2019\/09\/Untitled-1-26.jpg","width":794,"height":339},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/code\/php-menghubungkan-php-dengan-mysql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/code\/"},{"@type":"ListItem","position":2,"name":"PHP MySQL : Connect"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/code\/#website","url":"https:\/\/www.webhozz.com\/code\/","name":"WebHozz Code","description":"Tutorial Web &amp; Pemrograman Indonesia","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/code\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/code\/author\/dody\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/comments?post=499"}],"version-history":[{"count":3,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/499\/revisions"}],"predecessor-version":[{"id":514,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/499\/revisions\/514"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/media?parent=499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/categories?post=499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/tags?post=499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}