{"id":12260,"date":"2023-01-27T08:23:09","date_gmt":"2023-01-27T08:23:09","guid":{"rendered":"https:\/\/www.webhozz.com\/blog\/?p=12260"},"modified":"2023-05-09T07:42:35","modified_gmt":"2023-05-09T07:42:35","slug":"php-mysql-ajax-search","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/","title":{"rendered":"PHP MySQL : Ajax Search"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Kalian dapat membuat fungsionalitas pencarian basis data live sederhana menggunakan Ajax dan PHP, di mana hasil pencarian akan ditampilkan saat kalian mulai mengetik beberapa karakter di kotak input pencarian (contohnya seperti saat menginput kata pencarian di google).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dalam tutorial ini kita akan membuat kotak pencarian live yang akan mencari tabel&nbsp;<em>countries<\/em>&nbsp;dan menunjukkan hasilnya secara tidak sinkron. Tapi, pertama-tama kita perlu membuat tabel ini terlebih dahulu.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Langkah 1 : Membuat Tabel Database<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Jalankan query SQL berikut untuk membuat tabel&nbsp;<em>countries<\/em>&nbsp;di database MySQL kalian.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: php; title: ; notranslate\" title=\"\">\nCREATE TABLE countries (\n    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,\n    name VARCHAR(50) NOT NULL\n);\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Setelah membuat tabel, kalian perlu mengisinya dengan beberapa data menggunakan pernyataan SQL<strong>&nbsp;<em>INSERT<\/em><\/strong>. Atau, kalian dapat mengunduh tabel pra-populasi&nbsp;<em>countries<\/em>&nbsp;dengan mengklik tombol unduh dan mengimpornya ke dalam basis data MySQL kalian.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Silakan periksa tutorial tentang pernyataan&nbsp;<strong><em>SQL CREATE TABLE<\/em><\/strong>&nbsp;untuk informasi terperinci tentang sintaks untuk membuat tabel dalam sistem database MySQL.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Langkah 2 : Membuat Form Search<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Sekarang, mari kita buat antarmuka (interface) web sederhana yang memungkinkan pengguna untuk tinggal mencari nama-nama negara yang tersedia di tabel&nbsp;<em>countries<\/em>&nbsp;kita, seperti autocomplete atau typeahead.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Buat file PHP bernama \u201c<strong><em>search-form.php<\/em><\/strong>\u201d dan letakkan kode berikut di dalamnya.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: php; title: ; notranslate\" title=\"\">\n&lt;!DOCTYPE html&gt;\n&lt;html lang=&quot;en&quot;&gt;\n&lt;head&gt;\n&lt;meta charset=&quot;UTF-8&quot;&gt;\n&lt;title&gt;PHP Live MySQL Database Search&lt;\/title&gt;\n&lt;style type=&quot;text\/css&quot;&gt;\n    body{\n        font-family: Arail, sans-serif;\n    }\n    \/* Formatting search box *\/\n    .search-box{\n        width: 300px;\n        position: relative;\n        display: inline-block;\n        font-size: 14px;\n    }\n    .search-box input&#x5B;type=&quot;text&quot;]{\n        height: 32px;\n        padding: 5px 10px;\n        border: 1px solid #CCCCCC;\n        font-size: 14px;\n    }\n    .result{\n        position: absolute;        \n        z-index: 999;\n        top: 100%;\n        left: 0;\n    }\n    .search-box input&#x5B;type=&quot;text&quot;], .result{\n        width: 100%;\n        box-sizing: border-box;\n    }\n    \/* Formatting result items *\/\n    .result p{\n        margin: 0;\n        padding: 7px 10px;\n        border: 1px solid #CCCCCC;\n        border-top: none;\n        cursor: pointer;\n    }\n    .result p:hover{\n        background: #f2f2f2;\n    }\n&lt;\/style&gt;\n&lt;script src=&quot;https:\/\/code.jquery.com\/jquery-1.12.4.min.js&quot;&gt;&lt;\/script&gt;\n&lt;script type=&quot;text\/javascript&quot;&gt;\n$(document).ready(function(){\n    $(&#039;.search-box input&#x5B;type=&quot;text&quot;]&#039;).on(&quot;keyup input&quot;, function(){\n        \/* Get input value on change *\/\n        var inputVal = $(this).val();\n        var resultDropdown = $(this).siblings(&quot;.result&quot;);\n        if(inputVal.length){\n            $.get(&quot;backend-search.php&quot;, {term: inputVal}).done(function(data){\n                \/\/ Display the returned data in browser\n                resultDropdown.html(data);\n            });\n        } else{\n            resultDropdown.empty();\n        }\n    });\n     \n    \/\/ Set search input value on click of result item\n    $(document).on(&quot;click&quot;, &quot;.result p&quot;, function(){\n        $(this).parents(&quot;.search-box&quot;).find(&#039;input&#x5B;type=&quot;text&quot;]&#039;).val($(this).text());\n        $(this).parent(&quot;.result&quot;).empty();\n    });\n});\n&lt;\/script&gt;\n&lt;\/head&gt;\n&lt;body&gt;\n    &lt;div class=&quot;search-box&quot;&gt;\n        &lt;input type=&quot;text&quot; autocomplete=&quot;off&quot; placeholder=&quot;Search country...&quot; \/&gt;\n        &lt;div class=&quot;result&quot;&gt;&lt;\/div&gt;\n    &lt;\/div&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Setiap kali konten input search diubah atau keyup event terjadi pada input pencarian, kode jQuery (baris no-47 hingga 67) mengirim permintaan Ajax ke file \u201c<strong><em>backend-search.php<\/em><\/strong>\u201d yang mengambil catatan dari tabel negara terkait dengan istilah yang dicari. Catatan-catatan itu nantinya akan dimasukkan ke dalam&nbsp;<strong><em>&lt;div&gt;<\/em><\/strong>&nbsp;oleh jQuery dan ditampilkan di browser.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">Langkah 3 : Memproses Search Query di Backend<\/h5>\n\n\n\n<p class=\"wp-block-paragraph\">Dan inilah kode sumber dari file \u201c<strong><em>backend-search.php<\/em><\/strong>\u201d kita yang mencari basis data berdasarkan string query yang dikirim oleh permintaan Ajax dan mengirimkan hasilnya kembali ke browser.<\/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 &#039;root&#039; with no password) *\/\n$link = mysqli_connect(&quot;localhost&quot;, &quot;root&quot;, &quot;&quot;, &quot;demo&quot;);\n  \n\/\/ Check connection\nif($link === false){\n    die(&quot;ERROR: Could not connect. &quot; . mysqli_connect_error());\n}\n  \nif(isset($_REQUEST&#x5B;&quot;term&quot;])){\n    \/\/ Prepare a select statement\n    $sql = &quot;SELECT * FROM countries WHERE name LIKE ?&quot;;\n     \n    if($stmt = mysqli_prepare($link, $sql)){\n        \/\/ Bind variables to the prepared statement as parameters\n        mysqli_stmt_bind_param($stmt, &quot;s&quot;, $param_term);\n         \n        \/\/ Set parameters\n        $param_term = $_REQUEST&#x5B;&quot;term&quot;] . &#039;%&#039;;\n         \n        \/\/ Attempt to execute the prepared statement\n        if(mysqli_stmt_execute($stmt)){\n            $result = mysqli_stmt_get_result($stmt);\n             \n            \/\/ Check number of rows in the result set\n            if(mysqli_num_rows($result) &gt; 0){\n                \/\/ Fetch result rows as an associative array\n                while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){\n                    echo &quot;&lt;p&gt;&quot; . $row&#x5B;&quot;name&quot;] . &quot;&lt;\/p&gt;&quot;;\n                }\n            } else{\n                echo &quot;&lt;p&gt;No matches found&lt;\/p&gt;&quot;;\n            }\n        } else{\n            echo &quot;ERROR: Could not able to execute $sql. &quot; . mysqli_error($link);\n        }\n    }\n      \n    \/\/ Close statement\n    mysqli_stmt_close($stmt);\n}\n  \n\/\/ close connection\nmysqli_close($link);\n?&gt;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Pernyataan SQL&nbsp;<strong><em>SELECT&nbsp;<\/em><\/strong>digunakan dalam kombinasi dengan operator&nbsp;<strong><em>LIKE<\/em><\/strong>&nbsp;(baris no-16) untuk menemukan catatan yang cocok di tabel basis data&nbsp;<em>countries<\/em>. Kita telah menerapkan pernyataan yang sudah disiapkan agar kinerja pencarian lebih baik serta untuk mencegah serangan injeksi SQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Catatan:<\/em><\/strong>&nbsp;Selalu filter dan validasi input pengguna sebelum menggunakannya dalam pernyataan SQL. Kalian juga dapat menggunakan fungsi PHP&nbsp;<strong><em>mysqli_real_escape_string()<\/em><\/strong>&nbsp;untuk menghindari karakter khusus pada input pengguna dan membuat string SQL legal untuk memproteksi terhadap injeksi SQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kalian dapat membuat fungsionalitas pencarian basis data live sederhana menggunakan Ajax dan PHP, di mana hasil pencarian akan ditampilkan saat kalian mulai mengetik beberapa karakter<\/p>\n","protected":false},"author":1,"featured_media":9023,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[3896,3894,3895,3898,3897,3893],"class_list":["post-12260","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-belajar-web-programming","tag-belajar-php-mysql-ajax-search","tag-belajar-php-mysql-ajax-search-pemula","tag-kursus-php-mysql-ajax-search-bandung","tag-kursus-php-mysql-ajax-search-jakarta","tag-tutorial-php-mysql-ajax-search","tag-tutorial-php-mysql-ajax-search-pemula"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>PHP MySQL : Ajax Search - WebHozz Blog<\/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\/blog\/php-mysql-ajax-search\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP MySQL : Ajax Search - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Kalian dapat membuat fungsionalitas pencarian basis data live sederhana menggunakan Ajax dan PHP, di mana hasil pencarian akan ditampilkan saat kalian mulai mengetik beberapa karakter\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-27T08:23:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-09T07:42:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\"},\"headline\":\"PHP MySQL : Ajax Search\",\"datePublished\":\"2023-01-27T08:23:09+00:00\",\"dateModified\":\"2023-05-09T07:42:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/\"},\"wordCount\":364,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"keywords\":[\"Belajar PHP MySQL Ajax Search\",\"Belajar PHP MySQL Ajax Search Pemula\",\"Kursus PHP MySQL Ajax Search Bandung\",\"Kursus PHP MySQL Ajax Search Jakarta\",\"Tutorial PHP MySQL Ajax Search\",\"Tutorial PHP MySQL Ajax Search Pemula\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/\",\"name\":\"PHP MySQL : Ajax Search - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"datePublished\":\"2023-01-27T08:23:09+00:00\",\"dateModified\":\"2023-05-09T07:42:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"width\":750,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/php-mysql-ajax-search\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP MySQL : Ajax Search\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"name\":\"WebHozz Blog\",\"description\":\"Kursus Web &amp; Android di Jakarta Bandung\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\",\"name\":\"WebHozz\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"width\":442,\"height\":442,\"caption\":\"WebHozz\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHP MySQL : Ajax Search - WebHozz Blog","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\/blog\/php-mysql-ajax-search\/","og_locale":"en_US","og_type":"article","og_title":"PHP MySQL : Ajax Search - WebHozz Blog","og_description":"Kalian dapat membuat fungsionalitas pencarian basis data live sederhana menggunakan Ajax dan PHP, di mana hasil pencarian akan ditampilkan saat kalian mulai mengetik beberapa karakter","og_url":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/","og_site_name":"WebHozz Blog","article_published_time":"2023-01-27T08:23:09+00:00","article_modified_time":"2023-05-09T07:42:35+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef"},"headline":"PHP MySQL : Ajax Search","datePublished":"2023-01-27T08:23:09+00:00","dateModified":"2023-05-09T07:42:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/"},"wordCount":364,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","keywords":["Belajar PHP MySQL Ajax Search","Belajar PHP MySQL Ajax Search Pemula","Kursus PHP MySQL Ajax Search Bandung","Kursus PHP MySQL Ajax Search Jakarta","Tutorial PHP MySQL Ajax Search","Tutorial PHP MySQL Ajax Search Pemula"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/","url":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/","name":"PHP MySQL : Ajax Search - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","datePublished":"2023-01-27T08:23:09+00:00","dateModified":"2023-05-09T07:42:35+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/#primaryimage","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","width":750,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/php-mysql-ajax-search\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PHP MySQL : Ajax Search"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/blog\/#website","url":"https:\/\/www.webhozz.com\/blog\/","name":"WebHozz Blog","description":"Kursus Web &amp; Android di Jakarta Bandung","publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhozz.com\/blog\/#organization","name":"WebHozz","url":"https:\/\/www.webhozz.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","width":442,"height":442,"caption":"WebHozz"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/comments?post=12260"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12260\/revisions"}],"predecessor-version":[{"id":12579,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/12260\/revisions\/12579"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media\/9023"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=12260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=12260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=12260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}