{"id":295,"date":"2023-02-12T06:37:54","date_gmt":"2023-02-11T23:37:54","guid":{"rendered":"https:\/\/www.jogjahost.co.id\/blog\/?p=295"},"modified":"2023-03-31T08:56:25","modified_gmt":"2023-03-31T01:56:25","slug":"perbedaan-mysql-dan-mysqli","status":"publish","type":"post","link":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/","title":{"rendered":"Apa saja Perbedaan MySQL &#038; MySQLi? Mari Selidiki!"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;295&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;4&quot;,&quot;greet&quot;:&quot;&quot;,&quot;legend&quot;:&quot;4.5\\\/5 - (2 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Apa saja Perbedaan MySQL \\u0026amp; MySQLi? Mari Selidiki!&quot;,&quot;width&quot;:&quot;124&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 124px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            4.5\/5 - (2 votes)    <\/div>\n    <\/div>\n\n<h2 class=\"wp-block-heading\"><strong>Memahami RDBMS &amp; Koneksi ke Server Database<\/strong><\/h2>\n\n\n\n<p>Apa perbedaan <a href=\"https:\/\/www.jogjahost.co.id\/blog\/mysql-adalah\/\" class=\"rank-math-link\">MySql<\/a> dan MySQLi?<\/p>\n\n\n\n<p>Sebelum menjawab pertanyaan tersebut, Anda perlu memahami lebih dahulu tentang apa itu RDBMS dan koneksi antara aplikasi ke database server.<\/p>\n\n\n\n<p>RDBMS adalah suatu program yang berfungsi untuk mengelola sistem basis data dengan mengusung konsep relational.&nbsp;<\/p>\n\n\n\n<p>Salah satu aplikasi RDBMS yang paling populer adalah MySQL. Aplikasi MySQL berbasis bahasa pemrograman SQL.<\/p>\n\n\n\n<p>Pada suatu project pembuatan aplikasi web, dibutuhkan suatu server database. Server database merupakan komputer yang menjalankan pengelolaan data. Di server database inilah aplikasi MySQL bekerja.<\/p>\n\n\n\n<p>Aplikasi web harus dikoneksikan dengan server database supaya bisa beroperasi dengan semestinya. Koneksi tersebut dibuat dengan sintaks bahasa pemrograman PHP dan SQL.<\/p>\n\n\n\n<p>Koneksi PHP ke database MySQL bisa terjadi dengan adanya fitur \u201cExtension\u201d pada bahasa pemrograman PHP..<\/p>\n\n\n\n<p>Nah, Extension MySQL terdiri dari 2 jenis yaitu MySQL extension dan MySQLi extension.<\/p>\n\n\n\n<p>Nah, saat membicarakan tentang perbedaan antara MySQL dan MySQLi, pembahasan tentu akan mengarah pada extension.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Membedah MySQL &amp; MySQLi Extension<\/strong><\/h2>\n\n\n\n<p>Jadi MySQL yang dimaksud di sini adalah extensionnya, bukan aplikasi RDBMS nya.<\/p>\n\n\n\n<p>Sudah sepakat ya? Oke kita lanjutkan pembahasan.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Mengenal Extension PHP &#8211; Database MySQL<\/strong><\/h3>\n\n\n\n<p>Sebelum menggali lebih jauh tentang perbedaan MySQL vs MySQLi extension, ada baiknya kita pahami dulu, apa yang dimaksud dengan extension.<\/p>\n\n\n\n<p>Extension pada bahasa pemrograman PHP mengarah pada susunan fungsi untuk mengakses program tambahan. Fungsi tersebut memungkinkan PHP untuk bisa didukung dengan fitur baru.<\/p>\n\n\n\n<p>Pada aplikasi intinya (PHP core), tidak ada fungsi PHP untuk menjalankan program database MySQL. Maka dari itu disediakan extension atau fungsi tambahan supaya PHP bisa terkoneksi dengan MySQL dan menjalankan program database tersebut.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Latar Belakang MySQL &amp; MySQLi Extension<\/strong><\/h3>\n\n\n\n<p>PHP dan MySQL ibarat pasangan mesra pada pemrograman web. Saat belajar PHP untuk pertama kali, Anda pasti diarahkan untuk menggunakan MySQL sebagai aplikasi pengelolaan databasenya.<\/p>\n\n\n\n<p>PHP sudah bisa di support dengan MySQL sejak generasi kedua. Koneksinya bisa menggunakan MySQL extension.<\/p>\n\n\n\n<p>Pada saat itu, Anda pasti akan bertemu dengan fungsi-fungsi berikut ini untuk mengakses MySQL dari PHP:&nbsp;<\/p>\n\n\n\n<p><em>mysql_connect(),<\/em><em><br><\/em><em>mysql_query(),<\/em><em><br><\/em><em>mysql_fetch_array()&nbsp;<\/em><\/p>\n\n\n\n<p>Sayangnya, extension ini tidak lagi mendapat update fitur baru&nbsp; sejak tahun 2006. Meski fungsi ini cukup stabil, perkembangan zaman akan menuntut penyesuaian lebih. Kode dari extension ini sudah out of date dan harus diganti.<\/p>\n\n\n\n<p>Akhirnya, MySQL extension dinyatakan deprecated saat <a href=\"https:\/\/www.php.net\/downloads.php\" class=\"rank-math-link\">PHP v5.5<\/a> resmi dirilis. Hal ini berarti MySQL extension tidak akan lagi ada di versi PHP selanjutnya.<\/p>\n\n\n\n<p>Sebagai gantinya, dikeluarkanlah \u201cMySQLi extension\u201d. Kepanjangan dari MySQLi adalah MySQL Improved. Secara eksplisit sudah menjelaskan bahwa fungsi tersebut merupakan pengembangan dari extensi sebelumnya yang sudah kadaluarsa.<\/p>\n\n\n\n<p>Extensi ini sengaja dikembangkan untuk bisa mendukung berbagai fitur baru yang ada di aplikasi MySQL v4.1 ke atas.<\/p>\n\n\n\n<p>Upgrade ini memiliki kelebihan yang bisa menunjang Anda dalam mengakses fitur-fitur lebih lengkap.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Kelebihan MySQLi<\/strong><\/h3>\n\n\n\n<p>Sebelumnya sudah dijelaskan bahwa MySQLi merupakan pengembangan atau upgrade dari MySQL extension yang pada akhirnya tidak akan bisa lagi digunakan.<\/p>\n\n\n\n<p>Sebagai program upgrade, tentu saja ada sejumlah kelebihan yang dimiliku oleh extension ini. Berikut beberapa kelebihannya:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sudah didukung dengan tampilan berbasis objek atau object-oriented<\/li>\n\n\n\n<li>Sudah didukung fitur prepared statement. Jadi Anda bisa mengeksekusi perintah SQL yang hanya berbeda parameter dengan lebih efisien.<\/li>\n\n\n\n<li>Sudah support dengan fitur multiple statement atau multiple query.<\/li>\n\n\n\n<li>Sudah mendukung proses transaksi untuk bisa memperkecil error saat pemrosesan data berlangsung.&nbsp;<\/li>\n\n\n\n<li>Fitur debugging yang di upgrade kemampuannya.<\/li>\n\n\n\n<li>Sudah didukung dengan fitur embedded server.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Penggunaan Fungsi MySQLi<\/strong><\/h3>\n\n\n\n<p>Pada dasarnya, fungsi di MySQL extension hampir semuanya ada di MySQLi extension.<\/p>\n\n\n\n<p>Anda yang sudah lebih dulu mempelajari mendalami MySQL extension rasanya tidak akan kesulitan melakukan peralihan. Pasalnya, Syntax atau aturan penulisannya cukup mirip.<\/p>\n\n\n\n<p>Misalnya, untuk melakukan koneksi ke server MySQL.&nbsp;<\/p>\n\n\n\n<p>MySQL extension menggunakan fungsi<strong> mysql_connect (). <\/strong>Sedangkan MySQLi menggunakan fungsi <strong>mysqli_connect ()<\/strong>.<\/p>\n\n\n\n<p>Selain itu, peletakan argumen juga mengalami perubahan.<\/p>\n\n\n\n<p>Pada MySQL extension, argumen diletakan di paling belakang. Sedangkan pada MySQLi extension, Anda perlu menuliskan argumen pada bagian depan.&nbsp;<\/p>\n\n\n\n<p>Perlu jadi catatan, sintaks untuk sistem prosedural dan object-oriented sedikit berbeda.<\/p>\n\n\n\n<p>Secara paradigma pemrograman, MySQLi mendukung sistem prosedural dan object-oriented. Anda bisa memilih salah satu di antara keduanya. Tentukan sesuai kebutuhan pada pengerjaan project milik Anda.<\/p>\n\n\n\n<p>Sebagai catatan, sintaksnya sedikit berbeda.<\/p>\n\n\n\n<p>Misalnya untuk menghubungkan database.<\/p>\n\n\n\n<p>Sistem prosedural menggunakan fungsi <strong>mysql_connect () <\/strong>sedangkan object-oriented menggunakan fungsi <strong>$mysqli-&gt;query.<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Head to Head Perbedaan MySQL dan MySQLi dalam Tabel<\/strong><\/h3>\n\n\n\n<p>Supaya bisa lebih jelas membedakan MySQL dan MySQLi extension, Anda bisa melihat tabel berikut ini:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td><strong>MySQL<\/strong><\/td><td><strong>MySQLi<\/strong><\/td><\/tr><tr><td>Dihapus dari PHP v.5.5.0.<\/td><td>Ditambahkan pada PHP v.5.5.0, bekerja di MySQL v.4.1.3 ke atas.<\/td><\/tr><tr><td>Tidak mendukung fitur Prepared Statement.<\/td><td>Sudah mendukung fitur Prepared Statement.<\/td><\/tr><tr><td>Hanya menggunakan paradigma pemrograman Prosedural.<\/td><td>Bisa menggunakan paradigma pemrograman prosedural dan object-oriented.<\/td><\/tr><tr><td>Tidak mendukung fitur multiple query.<\/td><td>Mendukung fitur multiple query<\/td><\/tr><tr><td>Setiap transaksi hanya ditangani oleh query SQL.<\/td><td>Sudah didukung transaksi API.<\/td><\/tr><tr><td>Sistem keamanan masih rentan. Rawan SQL injection.<\/td><td>Sistem debugging di upgrade. Keamanan lebih terjamin.<\/td><\/tr><tr><td>Tidak mendukung fitur store procedure.<\/td><td>Sudah bisa menggunakan fitur store procedure.<\/td><\/tr><tr><td>Direktori extensinya ada di: ext\/mysql.<\/td><td>Direktori extensinya ada di: ext\/mysqli.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Dengan bantuan tabel seperti di atas, diharapkan bisa memudahkan Anda untuk memahami perbedaan di antara keduanya.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>MySQL vs MySQLi Extension: Pembaruan Fungsi Ekstensi<\/strong><\/h2>\n\n\n\n<p>Sekarang MySQL ekstension sudah kadaluarsa. Jika ingin membuat koneksi antara PHP ke MySQL Anda bisa menggunakan MySQLi extension.&nbsp;<\/p>\n\n\n\n<p>MySQLi Extension akan berjalan di PHP v.5.5. Ekstensi ini akan mendukung MySQL v4.1.3 dan versi-versi terbarunya.&nbsp;<\/p>\n\n\n\n<p>Dengan ekstensi ini, Anda akan bisa mengakses fitur yang lebih lengkap lagi. Kebutuhan yang kompleks bisa diakomodasi dengan ekstensi ini.<\/p>\n\n\n\n<p>Saatnya beralih ke MySQLi dan jangan lupa pelajari dengan seksama cara penggunaannya.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Apa perbedaan MySql dan MySQLi? Keduanya adalah PHP Extension untuk membuat koneksi antara PHP ke MySQL dan mengakses sejumlah fitur. Selengkapnya dibahas di artikel ini<\/p>\n","protected":false},"author":2,"featured_media":297,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[93,39,91,92,44],"class_list":["post-295","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-website","tag-database","tag-mysql","tag-mysqli","tag-php-extension","tag-rdbms"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Apa saja Perbedaan MySQL dan MySQLi? Ayo Selidiki!<\/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.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apa saja Perbedaan MySQL dan MySQLi? Ayo Selidiki!\" \/>\n<meta property=\"og:description\" content=\"Apa perbedaan MySql dan MySQLi? Keduanya adalah PHP Extension untuk membuat koneksi antara PHP ke MySQL dan mengakses sejumlah fitur. Selengkapnya dibahas di artikel ini\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/\" \/>\n<meta property=\"og:site_name\" content=\"Jogjahost Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hostingindonesia\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-11T23:37:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-31T01:56:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jogjahost.co.id\/blog\/wp-content\/uploads\/2020\/11\/a.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"527\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jho\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jho\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/\"},\"author\":{\"name\":\"Jho\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#\\\/schema\\\/person\\\/f7c992b57236db3af7c9b4981c748892\"},\"headline\":\"Apa saja Perbedaan MySQL &#038; MySQLi? Mari Selidiki!\",\"datePublished\":\"2023-02-11T23:37:54+00:00\",\"dateModified\":\"2023-03-31T01:56:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/\"},\"wordCount\":902,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/a.jpg\",\"keywords\":[\"database\",\"mysql\",\"mysqli\",\"php extension\",\"rdbms\"],\"articleSection\":[\"Website\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/\",\"url\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/\",\"name\":\"Apa saja Perbedaan MySQL dan MySQLi? Ayo Selidiki!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/a.jpg\",\"datePublished\":\"2023-02-11T23:37:54+00:00\",\"dateModified\":\"2023-03-31T01:56:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/a.jpg\",\"contentUrl\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/a.jpg\",\"width\":900,\"height\":527,\"caption\":\"Sumber: freepik.com\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/perbedaan-mysql-dan-mysqli\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Beranda\",\"item\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Website\",\"item\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/category\\\/website\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Apa saja Perbedaan MySQL &#038; MySQLi? Mari Selidiki!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/\",\"name\":\"Jogjahost Blog\",\"description\":\"Official\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#organization\",\"name\":\"Jogjahost\",\"url\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/Jogjahost-Logo.png\",\"contentUrl\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/11\\\/Jogjahost-Logo.png\",\"width\":200,\"height\":63,\"caption\":\"Jogjahost\"},\"image\":{\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hostingindonesia\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/ptjogjahost\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCNjzg7FZMoDlHQRvztXTZQA\\\/featured\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/#\\\/schema\\\/person\\\/f7c992b57236db3af7c9b4981c748892\",\"name\":\"Jho\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a940f9df7d6eb39176ff487c642337071de767315e1b2ceed9d358ddd0d5207?s=96&d=blank&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a940f9df7d6eb39176ff487c642337071de767315e1b2ceed9d358ddd0d5207?s=96&d=blank&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/1a940f9df7d6eb39176ff487c642337071de767315e1b2ceed9d358ddd0d5207?s=96&d=blank&r=g\",\"caption\":\"Jho\"},\"description\":\"Saya akan berbagi tulisan tentang definisi apapun yang berkaitan dengan dunia hosting, domain dan website.\",\"url\":\"https:\\\/\\\/www.jogjahost.co.id\\\/blog\\\/author\\\/jho\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apa saja Perbedaan MySQL dan MySQLi? Ayo Selidiki!","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.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/","og_locale":"en_US","og_type":"article","og_title":"Apa saja Perbedaan MySQL dan MySQLi? Ayo Selidiki!","og_description":"Apa perbedaan MySql dan MySQLi? Keduanya adalah PHP Extension untuk membuat koneksi antara PHP ke MySQL dan mengakses sejumlah fitur. Selengkapnya dibahas di artikel ini","og_url":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/","og_site_name":"Jogjahost Blog","article_publisher":"https:\/\/www.facebook.com\/hostingindonesia","article_published_time":"2023-02-11T23:37:54+00:00","article_modified_time":"2023-03-31T01:56:25+00:00","og_image":[{"width":900,"height":527,"url":"https:\/\/www.jogjahost.co.id\/blog\/wp-content\/uploads\/2020\/11\/a.jpg","type":"image\/jpeg"}],"author":"Jho","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jho","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/#article","isPartOf":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/"},"author":{"name":"Jho","@id":"https:\/\/www.jogjahost.co.id\/blog\/#\/schema\/person\/f7c992b57236db3af7c9b4981c748892"},"headline":"Apa saja Perbedaan MySQL &#038; MySQLi? Mari Selidiki!","datePublished":"2023-02-11T23:37:54+00:00","dateModified":"2023-03-31T01:56:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/"},"wordCount":902,"commentCount":0,"publisher":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/#organization"},"image":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jogjahost.co.id\/blog\/wp-content\/uploads\/2020\/11\/a.jpg","keywords":["database","mysql","mysqli","php extension","rdbms"],"articleSection":["Website"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/","url":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/","name":"Apa saja Perbedaan MySQL dan MySQLi? Ayo Selidiki!","isPartOf":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/#primaryimage"},"image":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jogjahost.co.id\/blog\/wp-content\/uploads\/2020\/11\/a.jpg","datePublished":"2023-02-11T23:37:54+00:00","dateModified":"2023-03-31T01:56:25+00:00","breadcrumb":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/#primaryimage","url":"https:\/\/www.jogjahost.co.id\/blog\/wp-content\/uploads\/2020\/11\/a.jpg","contentUrl":"https:\/\/www.jogjahost.co.id\/blog\/wp-content\/uploads\/2020\/11\/a.jpg","width":900,"height":527,"caption":"Sumber: freepik.com"},{"@type":"BreadcrumbList","@id":"https:\/\/www.jogjahost.co.id\/blog\/perbedaan-mysql-dan-mysqli\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Beranda","item":"https:\/\/www.jogjahost.co.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Website","item":"https:\/\/www.jogjahost.co.id\/blog\/category\/website\/"},{"@type":"ListItem","position":3,"name":"Apa saja Perbedaan MySQL &#038; MySQLi? Mari Selidiki!"}]},{"@type":"WebSite","@id":"https:\/\/www.jogjahost.co.id\/blog\/#website","url":"https:\/\/www.jogjahost.co.id\/blog\/","name":"Jogjahost Blog","description":"Official","publisher":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jogjahost.co.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.jogjahost.co.id\/blog\/#organization","name":"Jogjahost","url":"https:\/\/www.jogjahost.co.id\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.jogjahost.co.id\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.jogjahost.co.id\/blog\/wp-content\/uploads\/2020\/11\/Jogjahost-Logo.png","contentUrl":"https:\/\/www.jogjahost.co.id\/blog\/wp-content\/uploads\/2020\/11\/Jogjahost-Logo.png","width":200,"height":63,"caption":"Jogjahost"},"image":{"@id":"https:\/\/www.jogjahost.co.id\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hostingindonesia","https:\/\/www.linkedin.com\/in\/ptjogjahost\/","https:\/\/www.youtube.com\/channel\/UCNjzg7FZMoDlHQRvztXTZQA\/featured"]},{"@type":"Person","@id":"https:\/\/www.jogjahost.co.id\/blog\/#\/schema\/person\/f7c992b57236db3af7c9b4981c748892","name":"Jho","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1a940f9df7d6eb39176ff487c642337071de767315e1b2ceed9d358ddd0d5207?s=96&d=blank&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1a940f9df7d6eb39176ff487c642337071de767315e1b2ceed9d358ddd0d5207?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1a940f9df7d6eb39176ff487c642337071de767315e1b2ceed9d358ddd0d5207?s=96&d=blank&r=g","caption":"Jho"},"description":"Saya akan berbagi tulisan tentang definisi apapun yang berkaitan dengan dunia hosting, domain dan website.","url":"https:\/\/www.jogjahost.co.id\/blog\/author\/jho\/"}]}},"_links":{"self":[{"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/posts\/295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/comments?post=295"}],"version-history":[{"count":4,"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/posts\/295\/revisions"}],"predecessor-version":[{"id":3143,"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/posts\/295\/revisions\/3143"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/media\/297"}],"wp:attachment":[{"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/media?parent=295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/categories?post=295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jogjahost.co.id\/blog\/wp-json\/wp\/v2\/tags?post=295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}