{"id":859,"date":"2018-01-08T14:12:18","date_gmt":"2018-01-08T07:12:18","guid":{"rendered":"http:\/\/www.yellowweb.id\/blog\/?p=859"},"modified":"2018-01-08T14:12:18","modified_gmt":"2018-01-08T07:12:18","slug":"crud-php-mysqli","status":"publish","type":"post","link":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/","title":{"rendered":"CRUD PHP MySQLi"},"content":{"rendered":"

Tutorial kali ini kita akan mencoba operasi CRUD PHP dengan menggunakan MySQLi, mulai dari melakukan koneksi ke database, menambah (CREATE<\/em>), menampilkan (READ<\/em>), melakukan rubah (UPDATE<\/em>) dan menghapus (DELETE<\/em>) data. Caranya tidak terlalu sulit, mungkin bagi teman-teman yang sudah terbiasa dengan perintah query sql pada umumnya. Karena teknik ini, merupakan teknik yang paling mendasasar\/ paling awal jika kita ingin menjadi seorang programmer. Langkah-langkahnya sebagai berikut:
\n
\n1. Buat file koneksi.php<\/strong>
\nLangkah ini menghubungkan koneksi ke server, disini kita menggunakan Apache sebagai servernya (sudah terdapat di XAMPP).<\/p>\n

<?php \r\n\r\n\t$server = \"localhost\";\/\/nama server\r\n\t$user = \"root\"; \/\/username server\r\n\t$pass = \"\";  \/\/password\r\n\t$dbase = \"db_crudku\"; \/\/ database yang dipakai\r\n\r\n\t\/\/Membuat koneksi\r\n\t$koneksi = mysqli_connect($server, $user, $pass, $dbase);\r\n\r\n\t\/\/Mengecek koneksi \r\n\tif(!$koneksi) {\r\n\t die(\"Koneksi Gagal : \".mysqli_connect_error());\r\n\t}\r\n\r\n\techo \"Koneksi Berhasil\";\r\n\r\n?><\/pre>\n
Hasilnya akan tampil seperti gambar berikut ini:<\/p>\n
\"koneksi.jpg\"<\/a>
koneksi berhasil<\/p><\/div>\n
Sebelumnya jangan lupa membuat databasenya terlebih dahulu disini nama database yang saya gunakan db_crudku<\/strong>, kemudian lanjutkan dengan membuat tabel, nama tabel disini mahasiswa<\/strong>.
\nHasilnya akan terlihat seperti pada gambar berikut:<\/p>\n
\"database.jpg\"<\/a>
Struktur Tabel<\/p><\/div>\n
2. Form Input Data (CREATE<\/em>)<\/strong>
\nBuat file dengan nama tambah-data.php<\/strong><\/p>\n
<!DOCTYPE html>\r\n<html>\r\n<head>\r\n\t<title>Tambah Data<\/title>\r\n<\/head>\r\n<body>\r\n\t<h3>Tambah Data<\/h3>\r\n\r\n\t<form action=\"insert.php\" method=\"POST\">\r\n\t\t<table>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>Nama Lengkap<\/td>\r\n\t\t\t\t<td>:<\/td>\r\n\t\t\t\t<td><input type=\"text\" name=\"nama\"><\/td>\r\n\t\t\t<\/tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>Email<\/td>\r\n\t\t\t\t<td>:<\/td>\r\n\t\t\t\t<td><input type=\"email\" name=\"mail\"><\/td>\r\n\t\t\t<\/tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td><\/td>\r\n\t\t\t\t<td><\/td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t<input type=\"submit\" name=\"kirim\" value=\"SIMPAN\">\r\n\t\t\t\t\t<input type=\"reset\" name=\"clear\" value=\"BATAL\">\r\n\t\t\t\t<\/td>\r\n\t\t\t<\/tr>\r\n\t\t<\/table>\r\n\t<\/form>\r\n\r\n<\/body>\r\n<\/html><\/pre>\n
Hasilnya akan tampil seperti pada gambar berikut:<\/p>\n
\"tambah-data.jpg\"<\/a>
form-tambah<\/p><\/div>\n
kemudian, lanjutkan dengan membuat file proses untuk insert ke database, insert.php<\/strong><\/p>\n
<?php\r\n\tinclude \"koneksi.php\";\r\n\r\n\t$nm = $_POST[\"nama\"];\r\n\t$em = $_POST[\"mail\"];\r\n\r\n\tdate_default_timezone_set(\"Asia\/Jakarta\");\r\n\r\n\t$tgl = date(\"Y:m:d\");\r\n\r\n\t\/\/ query sql\r\n\t$sql = \"INSERT INTO mahasiswa (nama_mahasiswa, email_mahasiswa, tanggal) VALUES('$nm','$em','$tgl')\";\r\n\t$query = mysqli_query($koneksi, $sql) or die (mysqli_error());\r\n\r\n\tif($query){\r\n\t\techo \"Data berhasil di insert!\";\r\n\t} else {\r\n\t\techo \"Error :\".$sql.\"<br>\".mysqli_error($koneksi);\r\n\t}\r\n\r\n\tmysqli_close($koneksi);\r\n\r\n?><\/pre>\n

\n3. Form Tampilan (READ<\/em>)<\/strong>
\nLangkah berikutnya dengan membuat form tampil-data.php<\/strong>, yang bertujuan untuk menampilkan data dari database.<\/p>\n
<!DOCTYPE html>\r\n<html>\r\n<head>\r\n\t<title>Tampil Data<\/title>\r\n<\/head>\r\n<body>\r\n\t<h3>Tampil Data<\/h3>\r\n\r\n\t<table border=\"1\">\r\n\t\t<thead>\r\n\t\t\t<th>No<\/th>\r\n\t\t\t<th>Nama Mahasiswa<\/th>\r\n\t\t\t<th>Email Mahasiswa<\/th>\r\n\t\t\t<th>Tanggal<\/th>\r\n\t\t\t<th colspan=\"2\">Aksi<\/th>\r\n\t\t<\/thead>\r\n\t\t<tbody>\r\n\t\t\t<?php\r\n\t\t\t\tinclude \"koneksi.php\";\r\n\r\n\t\t\t\t\/\/ query sql\r\n\t\t\t\t$sql = \"SELECT * FROM mahasiswa ORDER BY id_mhs DESC\";\r\n\t\t\t\t$query = mysqli_query($koneksi, $sql) or die (mysqli_error());\r\n\r\n\t\t\t\t$no = 1; \/\/ no. urut\r\n\r\n\t\t\t\twhile($data = mysqli_fetch_array($query)){\r\n\r\n\t\t\t\t\t$id = $data[\"id_mhs\"];\r\n\t\t\t\t\t$nm = $data[\"nama_mahasiswa\"];\r\n\t\t\t\t\t$em = $data[\"email_mahasiswa\"];\r\n\t\t\t\t\t$tg = $data[\"tanggal\"];\r\n\r\n\t\t\t\t\techo \"<tr>\r\n\t\t\t\t\t\t\t<td>$no<\/td>\r\n\t\t\t\t\t\t\t<td>$nm<\/td>\r\n\t\t\t\t\t\t\t<td>$em<\/td>\r\n\t\t\t\t\t\t\t<td>$tg<\/td>\r\n\t\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t\t<a href='rubah-data.php?rubah_id=$id'>Rubah<\/a>\r\n\t\t\t\t\t\t\t\t<a href='hapus-data.php?hapus_id=$id'>Hapus<\/a>\r\n\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t  <\/tr>\";\r\n\t\t\t\t\t$no++;\r\n\t\t\t\t}\r\n\t\t\t?>\r\n\r\n\t\t\t\r\n\t\t<\/tbody>\r\n\t<\/table>\r\n\r\n<\/body>\r\n<\/html><\/pre>\n
Hasilnya akan terlihat seperti gambar berikut:<\/p>\n
\"tampil-data.jpg\"<\/a>
Form tampil data<\/p><\/div>\n
4. Rubah Data (UPDATE<\/em>)<\/strong><\/p>\n
Jika kita ingin melakukan perubahan data\/ update<\/em> data, jangan lupa untuk membuat form rubah terlebih dahulu, yang bertujuan untuk menampilkan data yang ingin dirubah.
\nFormnya disini saya akan berikan dengan nama rubah-data.php<\/strong><\/p>\n
<!DOCTYPE html>\r\n<html>\r\n<head>\r\n\t<title>Rubah Data<\/title>\r\n<\/head>\r\n<body>\r\n\t<h3>Rubah Data<\/h3>\r\n\r\n\t<?php\r\n\t\tinclude \"koneksi.php\";\r\n\r\n\t\t$ide = $_GET[\"rubah_id\"];\r\n\r\n\t\t$sql = \"SELECT * FROM mahasiswa WHERE id_mhs='$ide'\";\r\n\t\t$query = mysqli_query($koneksi, $sql) or die (mysqli_error());\r\n\r\n\t\tif(mysqli_num_rows($query) > 0){\r\n\t\t\t$data = mysqli_fetch_array($query);\r\n\t\t}\r\n\t?>\r\n\r\n\t<form action=\"update.php\" method=\"POST\">\r\n\r\n\t\t<input type=\"hidden\" name=\"id\" value=\"<?php echo $data[\"id_mhs\"];?>\">\r\n\r\n\t\t<table>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>Nama Lengkap<\/td>\r\n\t\t\t\t<td>:<\/td>\r\n\t\t\t\t<td><input type=\"text\" name=\"nama\" value=\"<?php echo $data[\"nama_mahasiswa\"];?>\"><\/td>\r\n\t\t\t<\/tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>Email<\/td>\r\n\t\t\t\t<td>:<\/td>\r\n\t\t\t\t<td><input type=\"email\" name=\"mail\" value=\"<?php echo $data[\"email_mahasiswa\"];?>\"><\/td>\r\n\t\t\t<\/tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td><\/td>\r\n\t\t\t\t<td><\/td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t<input type=\"submit\" name=\"edit\" value=\"RUBAH\">\r\n\t\t\t\t<\/td>\r\n\t\t\t<\/tr>\r\n\t\t<\/table>\r\n\t<\/form>\r\n\r\n<\/body>\r\n<\/html><\/pre>\n
kemudian dengan lanjutkan dengan membuat file prosesnya, update.php<\/strong><\/p>\n
<?php\r\n\tinclude \"koneksi.php\";\r\n\r\n\t$nm = $_POST[\"nama\"];\r\n\t$em = $_POST[\"mail\"];\r\n\t$id = $_POST[\"id\"];\r\n\r\n\tdate_default_timezone_set(\"Asia\/Jakarta\");\r\n\r\n\t$tgl = date(\"Y:m:d\");\r\n\r\n\t\/\/ query sql\r\n\t$sql = \"UPDATE mahasiswa \r\n\t\t\tSET nama_mahasiswa='$nm',\r\n\t\t\t\temail_mahasiswa='$em',\r\n\t\t\t\ttanggal='$tgl'\r\n\t\t\tWHERE id_mhs='$id'\";\r\n\t$query = mysqli_query($koneksi, $sql) or die (mysqli_error());\r\n\r\n\tif($query){\r\n\t\techo \"Data berhasil dirubah!\";\r\n\t} else {\r\n\t\techo \"Error\".$sql.\"<br>\".mysqli_error($koneksi);\r\n\t}\r\n\r\n\tmysqli_close($koneksi);\r\n\r\n?><\/pre>\n
5. Hapus Data (DELETE<\/em>)<\/strong>
\nTeman-teman dapat melanjutkan dengan membuat file proses untuk melakukan hapus data yang ada di database, file yang akan saya buat disini hapus-data.php<\/strong><\/p>\n
<?php\r\n\tinclude \"koneksi.php\";\r\n\r\n\t$idh = $_GET[\"hapus_id\"];\r\n\r\n\t\/\/ query sql\r\n\t$sql = \"DELETE FROM mahasiswa WHERE id_mhs='$idh'\";\r\n\t$query = mysqli_query($koneksi, $sql) or die (mysqli_error());\r\n\r\n\tif($query){\r\n\t\techo \"Data berhasil di Hapus!\";\r\n\t} else {\r\n\t\techo \"Error :\".$sql.\"<br>\".mysqli_error($koneksi);\r\n\t}\r\n\r\n\tmysqli_close($koneksi);\r\n?><\/pre>\n
CRUD PHP dengan menggunakan MySQLi tidaklah sesulit apa yang kita kira, kalau diperhatikan pada penulisan query sql selalu menyertakan variabel yang mengacu ke bagian koneksi.
\nDemikian tutorial CRUD PHP dengan MySQLi, semoga bermanfaat bagi teman-teman semua \ud83d\ude42<\/p>\n
Source untuk databasenya, bisa diunduh disini:
\nURL: database_crud<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Tutorial kali ini kita akan mencoba operasi CRUD PHP dengan menggunakan MySQLi, mulai dari melakukan koneksi ke database, menambah (CREATE), menampilkan (READ), melakukan rubah (UPDATE) dan menghapus (DELETE) data. Caranya tidak terlalu sulit, mungkin bagi teman-teman yang sudah terbiasa dengan perintah query sql pada umumnya. Karena teknik ini, merupakan teknik yang paling mendasasar\/ paling awal […]<\/p>\n","protected":false},"author":1,"featured_media":878,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[190,397,110],"tags":[398,399,192,191,249,88],"class_list":["post-859","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-mysqli","category-php","tag-crud","tag-crud-php","tag-database","tag-mysql","tag-mysqli","tag-php"],"yoast_head":"\nCRUD PHP MySQLi - YELLOWWEB.ID<\/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.yellowweb.id\/blog\/crud-php-mysqli\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CRUD PHP MySQLi - YELLOWWEB.ID\" \/>\n<meta property=\"og:description\" content=\"Tutorial kali ini kita akan mencoba operasi CRUD PHP dengan menggunakan MySQLi, mulai dari melakukan koneksi ke database, menambah (CREATE), menampilkan (READ), melakukan rubah (UPDATE) dan menghapus (DELETE) data. Caranya tidak terlalu sulit, mungkin bagi teman-teman yang sudah terbiasa dengan perintah query sql pada umumnya. Karena teknik ini, merupakan teknik yang paling mendasasar\/ paling awal […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/\" \/>\n<meta property=\"og:site_name\" content=\"YELLOWWEB.ID\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-08T07:12:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/01\/crud-php-01.jpg?fit=600%2C290&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"290\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yellowweb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yellowweb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/\"},\"author\":{\"name\":\"yellowweb\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"headline\":\"CRUD PHP MySQLi\",\"datePublished\":\"2018-01-08T07:12:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/\"},\"wordCount\":329,\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/crud-php-01.jpg\",\"keywords\":[\"crud\",\"crud php\",\"database\",\"mysql\",\"mysqli\",\"php\"],\"articleSection\":[\"MySQL\",\"MySQLi\",\"PHP\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/\",\"name\":\"CRUD PHP MySQLi - YELLOWWEB.ID\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/crud-php-01.jpg\",\"datePublished\":\"2018-01-08T07:12:18+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/crud-php-01.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/crud-php-01.jpg\",\"width\":600,\"height\":290,\"caption\":\"crud php with mysqli\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/crud-php-mysqli\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CRUD PHP MySQLi\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\",\"name\":\"YELLOWWEB.ID\",\"description\":\"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\",\"name\":\"yellowweb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"caption\":\"yellowweb\"},\"sameAs\":[\"https:\\\/\\\/www.yellowweb.id\"],\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/author\\\/yellowweb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CRUD PHP MySQLi - YELLOWWEB.ID","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.yellowweb.id\/blog\/crud-php-mysqli\/","og_locale":"en_GB","og_type":"article","og_title":"CRUD PHP MySQLi - YELLOWWEB.ID","og_description":"Tutorial kali ini kita akan mencoba operasi CRUD PHP dengan menggunakan MySQLi, mulai dari melakukan koneksi ke database, menambah (CREATE), menampilkan (READ), melakukan rubah (UPDATE) dan menghapus (DELETE) data. Caranya tidak terlalu sulit, mungkin bagi teman-teman yang sudah terbiasa dengan perintah query sql pada umumnya. Karena teknik ini, merupakan teknik yang paling mendasasar\/ paling awal […]","og_url":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/","og_site_name":"YELLOWWEB.ID","article_published_time":"2018-01-08T07:12:18+00:00","og_image":[{"width":600,"height":290,"url":"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/01\/crud-php-01.jpg?fit=600%2C290&ssl=1","type":"image\/jpeg"}],"author":"yellowweb","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yellowweb","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/#article","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/"},"author":{"name":"yellowweb","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"headline":"CRUD PHP MySQLi","datePublished":"2018-01-08T07:12:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/"},"wordCount":329,"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/01\/crud-php-01.jpg","keywords":["crud","crud php","database","mysql","mysqli","php"],"articleSection":["MySQL","MySQLi","PHP"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/","url":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/","name":"CRUD PHP MySQLi - YELLOWWEB.ID","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/#primaryimage"},"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/01\/crud-php-01.jpg","datePublished":"2018-01-08T07:12:18+00:00","author":{"@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"breadcrumb":{"@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/#primaryimage","url":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/01\/crud-php-01.jpg","contentUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2018\/01\/crud-php-01.jpg","width":600,"height":290,"caption":"crud php with mysqli"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yellowweb.id\/blog\/crud-php-mysqli\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yellowweb.id\/blog\/"},{"@type":"ListItem","position":2,"name":"CRUD PHP MySQLi"}]},{"@type":"WebSite","@id":"https:\/\/www.yellowweb.id\/blog\/#website","url":"https:\/\/www.yellowweb.id\/blog\/","name":"YELLOWWEB.ID","description":"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yellowweb.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829","name":"yellowweb","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","caption":"yellowweb"},"sameAs":["https:\/\/www.yellowweb.id"],"url":"https:\/\/www.yellowweb.id\/blog\/author\/yellowweb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/comments?post=859"}],"version-history":[{"count":15,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/859\/revisions"}],"predecessor-version":[{"id":879,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/859\/revisions\/879"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media\/878"}],"wp:attachment":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media?parent=859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/categories?post=859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/tags?post=859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}