{"id":7430,"date":"2018-11-28T11:30:53","date_gmt":"2018-11-28T11:30:53","guid":{"rendered":"https:\/\/www.webhozz.com\/blog\/?p=7430"},"modified":"2019-08-01T20:18:19","modified_gmt":"2019-08-01T20:18:19","slug":"membuat-crud-php-mysql","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/","title":{"rendered":"Membuat CRUD PHP MySQL"},"content":{"rendered":"<p>Assalamualaikum Wr. Wb<\/p>\n<p>Sahabat Webhozz dimanapun berada, apa kabarnya??? Mudah-mudahan sehat selalu dan selalu bahagia ya, amin.<\/p>\n<p>Alhamdulillah, kali ini kita ada kesempatan untuk berbagi ilmu.<\/p>\n<p>Kali ini kita akan belajar CRUD PHP MySQL. Lo kok bikin CRUD lagi???<\/p>\n<p>Bukannya sebelumnya udah posting???<\/p>\n<p>Memang sih, sebelumnya Webhozz pernah posting disini (https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/).<\/p>\n<p>Nah, itu adalah PHP versi lama. Dan untuk koneksi serta transaksi databasenya masih menggunakan mysql pada perintah PHPnya.<\/p>\n<p>Dan sekarang kita sudah memasuki PHP versi 7. Dan versi yang sebelumnya sudah tidak dipakai lagi untuk ke depannya. Dan versi PHP 7 ini adalanya di aplikasi XAMPP Control Panel 3.2.2. Bahkan untuk server online juga sudah menggunakan kode PHP 7 ini.<\/p>\n<p>Oke, langsung aja kita coba ya&#8230;<!--more--><\/p>\n<p>Kasusnya, kita akan membuat input data mahasiswa baru sederhana. Dan mari ikuti langkah berikut ini.<\/p>\n<p>1. Buat dulu databasenya, yaitu buat nama databasenya universitasku.<\/p>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah1.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-7399\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah1.png\" alt=\"\" width=\"542\" height=\"129\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah1.png 542w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah1-300x71.png 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/a><\/p>\n<p>2. Buat tabel untuk databasenya, dan buat nama tabelnya &#8220;mahasiswa&#8221; dengan ketentuan seperti gambar di bawah ini.<\/p>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah2.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7400\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah2.png\" alt=\"\" width=\"542\" height=\"275\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah2.png 542w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah2-300x152.png 300w\" sizes=\"(max-width: 542px) 100vw, 542px\" \/><\/a><\/p>\n<p>3. Buat, file koneksi databasenya supaya terhubung dengan file phpnya. Disini kita buat filenya dengan nama &#8220;koneksi.php&#8221;, berikut scriptnya.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\/\/===========================================================\r\n&lt;?php \r\n\t\r\n\t$server   = &quot;localhost&quot;;\r\n\t$username = &quot;root&quot;;\r\n\t$password = &quot;&quot;;\r\n\t$database = &quot;universitasku&quot;;\r\n\r\n\t\/\/sambungkan ke database\r\n\t$sambungan = mysqli_connect($server, $username, $password, $database);\r\n\r\n\tif (!$sambungan) \/\/jika tidak berhasil disambungkan\r\n\t{\r\n\t\techo &quot;&lt;h1&gt;Sambungan Gagal&lt;\/h1&gt;&quot;;\r\n\t}\r\n\r\n?&gt;\r\n\/\/===========================================================<\/pre>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah3.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7401\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah3.png\" alt=\"\" width=\"548\" height=\"301\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah3.png 548w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah3-300x165.png 300w\" sizes=\"(max-width: 548px) 100vw, 548px\" \/><\/a><\/p>\n<p>4. Buat file untuk menambahkan data lewat php, simpan dengan nama &#8220;mahasiswa-tambah.php&#8221; dan script seperti berikut.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\/\/===========================================================\r\n&lt;h2&gt;Tambah Data Mahasiswa&lt;\/h2&gt;\r\n\t\t\t\t\t\t&lt;!--enctype=&quot;multipart\/form-data&quot;, wajib ada kalo ada upload file--&gt;\r\n&lt;form action=&quot;mahasiswa-simpan.php&quot; method=&quot;post&quot; enctype=&quot;multipart\/form-data&quot;&gt;\r\n\t&lt;p&gt;\r\n\t\tNama Mahasiswa : &lt;br&gt;\r\n\t\t&lt;input type=&quot;text&quot; name=&quot;nama&quot; required=&quot;&quot;&gt;\r\n\t&lt;\/p&gt;\r\n\r\n\t&lt;p&gt;\r\n\t\tAlamat : &lt;br&gt;\r\n\t\t&lt;textarea name=&quot;alamat&quot; required=&quot;&quot;&gt;&lt;\/textarea&gt;\r\n\t&lt;\/p&gt;\r\n\r\n\t&lt;p&gt;\r\n\t\tNo. Telp : &lt;br&gt;\r\n\t\t&lt;input type=&quot;text&quot; name=&quot;notelp&quot; required=&quot;&quot;&gt;\r\n\t&lt;\/p&gt;\r\n\r\n\t&lt;p&gt;\r\n\t\tJenis Kelamin : &lt;br&gt;\r\n\t\t&lt;input type=&quot;radio&quot; name=&quot;jekel&quot; value=&quot;Laki-laki&quot;&gt;Laki-laki\r\n\t\t&lt;input type=&quot;radio&quot; name=&quot;jekel&quot; value=&quot;Perempuan&quot;&gt;Perempuan\r\n\t&lt;\/p&gt;\r\n\r\n\t&lt;p&gt;\r\n\t\t&lt;input type=&quot;submit&quot; value=&quot;SIMPAN&quot;&gt;\r\n\t&lt;\/p&gt;\r\n&lt;\/form&gt;\r\n\/\/===========================================================<\/pre>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah4-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7422\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah4-1.png\" alt=\"\" width=\"507\" height=\"383\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah4-1.png 507w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah4-1-300x227.png 300w\" sizes=\"(max-width: 507px) 100vw, 507px\" \/><\/a><\/p>\n<p>5. Buat file baru untuk menyimpan data hasil input di &#8220;mahasiswa-tambah.php&#8221; tadi. Simpan dengan nama &#8220;mahasiswa-simpan.php&#8221;, berikut scriptnya.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\/\/===========================================================\r\n&lt;?php \r\n\r\n\tinclude 'koneksi.php';\r\n\t$nama   = $_POST&#x5B;'nama'];\r\n\t$alamat = $_POST&#x5B;'alamat'];\r\n\t$notelp = $_POST&#x5B;'notelp'];\r\n\t$jekel  = $_POST&#x5B;'jekel'];\r\n\r\n\t\r\n\t$sql = &quot;INSERT INTO mahasiswa VALUES('', '$nama', '$alamat', '$notelp', '$jekel')&quot;;\r\n\t$que = mysqli_query($sambungan, $sql);\t\r\n\t\/\/peyimpanan\r\n\tif ($que) \/\/jika berhasil\r\n\t{\r\n\t\techo \r\n\t\t&quot;\r\n\t\t\t&lt;script type='text\/javascript'&gt;\r\n\t\t\t\talert('Data telah disimpan');\r\n\t\t\t\twindow.location='mahasiswa-data.php';\r\n\t\t\t&lt;\/script&gt;\r\n\t\t&quot;;\r\n\t}\r\n\telse \/\/jika gagal\r\n\t{\r\n\t\techo \r\n\t\t&quot;\r\n\t\t\t&lt;script type='text\/javascript'&gt;\r\n\t\t\t\talert('Gagal disimpan');\r\n\t\t\t\twindow.location='mahasiswa-tambah.php';\r\n\t\t\t&lt;\/script&gt;\r\n\t\t&quot;;\r\n\t}\r\n\t\/\/penyimpanan\r\n\r\n?&gt;\r\n\/\/===========================================================<\/pre>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah5-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7423\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah5-1.png\" alt=\"\" width=\"447\" height=\"128\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah5-1.png 447w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah5-1-300x86.png 300w\" sizes=\"(max-width: 447px) 100vw, 447px\" \/><\/a><\/p>\n<p>6. Buat file untuk menampilkan data-data yang sudah disimpan melalui file yang diinputkan dari file &#8220;mahasiswa-tambah.php&#8221; dan &#8220;mahasiswa-simpan.php&#8221;. Simpan dengan nama &#8220;mahasiswa-data.php&#8221;, berikut scriptnya.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\/\/===========================================================\r\n&lt;h2&gt;Data Mahasiswa&lt;\/h2&gt;\r\n\r\n&lt;a href=&quot;mahasiswa-tambah.php&quot;&gt;Tambah Baru&lt;\/a&gt;\r\n\r\n&lt;table border=&quot;1&quot; width=&quot;600&quot;&gt;\r\n\t&lt;tr&gt;\r\n\t\t&lt;th&gt;No.&lt;\/th&gt;\r\n\t\t&lt;th&gt;Nama Mahasiswa&lt;\/th&gt;\r\n\t\t&lt;th&gt;Alamat&lt;\/th&gt;\r\n\t\t&lt;th&gt;No. Telp&lt;\/th&gt;\r\n\t\t&lt;th&gt;Jenis Kelamin&lt;\/th&gt;\r\n\t\t&lt;th&gt;Aksi&lt;\/th&gt;\r\n\t&lt;\/tr&gt;\r\n\r\n\t&lt;?php \r\n\r\n\t\tinclude 'koneksi.php';\r\n\t\t$sql = &quot;SELECT *FROM mahasiswa&quot;;\r\n\t\t$que = mysqli_query($sambungan, $sql);\/\/eksekusi perintah $sql\r\n\t\t$no=1;\r\n\t\twhile ($data=mysqli_fetch_array($que)) \r\n\t\t{\r\n\t\t\t\/\/deklarasi database\r\n\t\t\t\/\/var      \/\/wajib sama dengan yg di database\r\n\t\t\t$idm    = $data&#x5B;'id_mahasiswa'];\r\n\t\t\t$nama   = $data&#x5B;'nama_mahasiswa'];\r\n\t\t\t$alamat = $data&#x5B;'alamat'];\r\n\t\t\t$notelp = $data&#x5B;'no_telp'];\r\n\t\t\t$jkel   = $data&#x5B;'jkel'];\r\n\r\n\t\t\techo \r\n\t\t\t&quot;\r\n\t\t\t\t&lt;tr&gt;\r\n\t\t\t\t\t&lt;td align='center'&gt;$no&lt;\/td&gt;\r\n\t\t\t\t\t&lt;td&gt;$nama&lt;\/td&gt;\r\n\t\t\t\t\t&lt;td&gt;$alamat&lt;\/td&gt;\r\n\t\t\t\t\t&lt;td&gt;$notelp&lt;\/td&gt;\r\n\t\t\t\t\t&lt;td&gt;$jkel&lt;\/td&gt;\r\n\t\t\t\t\t&lt;td&gt;\r\n\t\t\t\t\t\t&lt;a href='mahasiswa-edit.php?id=$idm'&gt;Edit&lt;\/a&gt;\r\n\t\t\t\t\t\t&lt;a href='mahasiswa-hapus.php?id=$idm'&gt;Hapus&lt;\/a&gt;\r\n\t\t\t\t\t&lt;\/td&gt;\r\n\t\t\t\t&lt;\/tr&gt;\r\n\t\t\t&quot;;\r\n\t\t\t$no++;\r\n\t\t}\r\n\r\n\t?&gt;\r\n&lt;\/table&gt;\r\n\/\/===========================================================<\/pre>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah6-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7424\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah6-1.png\" alt=\"\" width=\"625\" height=\"236\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah6-1.png 625w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah6-1-300x113.png 300w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><\/p>\n<p>7. Buat file untuk mengubah data yang sudah disimpan. Simpan dengan nama &#8220;mahasiswa-edit.php&#8221; dan berikut scriptnya.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\/\/===========================================================\r\n&lt;h2&gt;Edit Data Mahasiswa&lt;\/h2&gt;\r\n\r\n&lt;?php \r\n\tinclude 'koneksi.php';\r\n\t$id  = $_GET&#x5B;'id'];\r\n\t$sql = &quot;SELECT *FROM mahasiswa WHERE id_mahasiswa='$id'&quot;;\r\n\t$que = mysqli_query($sambungan, $sql);\r\n\r\n\twhile ($data=mysqli_fetch_array($que)) \r\n\t{\r\n\t\t$nama   = $data&#x5B;'nama_mahasiswa'];\r\n\t\t$alamat = $data&#x5B;'alamat'];\r\n\t\t$notelp = $data&#x5B;'no_telp'];\r\n\t\t$jekel  = $data&#x5B;'jkel'];\r\n\t}\r\n?&gt;\r\n\r\n&lt;form action=&quot;mahasiswa-ubah.php&quot; method=&quot;post&quot; enctype=&quot;multipart\/form-data&quot;&gt;\r\n\t&lt;input type=&quot;hidden&quot; name=&quot;idm&quot; value=&quot;&lt;?php echo&quot;$id&quot;; ?&gt;&quot;&gt;\r\n\t&lt;p&gt;\r\n\t\tNama Mahasiswa : &lt;br&gt;\r\n\t\t&lt;input type=&quot;text&quot; name=&quot;nama&quot; required=&quot;&quot; value=&quot;&lt;?php echo &quot;$nama&quot;; ?&gt;&quot;&gt;\r\n\t&lt;\/p&gt;\r\n\r\n\t&lt;p&gt;\r\n\t\tAlamat : &lt;br&gt;\r\n\t\t&lt;textarea name=&quot;alamat&quot; required=&quot;&quot;&gt;&lt;?php echo &quot;$alamat&quot;; ?&gt;&lt;\/textarea&gt;\r\n\t&lt;\/p&gt;\r\n\r\n\t&lt;p&gt;\r\n\t\tNo. Telp : &lt;br&gt;\r\n\t\t&lt;input type=&quot;text&quot; name=&quot;notelp&quot; required=&quot;&quot; value=&quot;&lt;?php echo &quot;$notelp&quot;; ?&gt;&quot;&gt;\r\n\t&lt;\/p&gt;\r\n\r\n\t&lt;p&gt;\r\n\t\tJenis Kelamin : &lt;br&gt;\r\n\t\t&lt;?php \r\n\r\n\t\t\tif ($jekel==&quot;Laki-laki&quot;) \r\n\t\t\t{\r\n\t\t\t\techo \r\n\t\t\t\t&quot;\r\n\t\t\t\t\t&lt;input type='radio' name='jekel' value='Laki-laki' checked=''&gt;Laki-laki\r\n\t\t\t\t\t&lt;input type='radio' name='jekel' value='Perempuan'&gt;Perempuan\r\n\t\t\t\t&quot;;\r\n\t\t\t}\r\n\t\t\telse\r\n\t\t\t{\r\n\t\t\t\techo \r\n\t\t\t\t&quot;\r\n\t\t\t\t\t&lt;input type='radio' name='jekel' value='Laki-laki'&gt;Laki-laki\r\n\t\t\t\t\t&lt;input type='radio' name='jekel' value='Perempuan' checked=''&gt;Perempuan\r\n\t\t\t\t&quot;;\r\n\t\t\t}\r\n\r\n\t\t?&gt;\r\n\r\n\t&lt;\/p&gt;\r\n\r\n\t&lt;p&gt;\r\n\t\t&lt;input type=&quot;submit&quot; value=&quot;SIMPAN&quot;&gt;\r\n\t&lt;\/p&gt;\r\n&lt;\/form&gt;\r\n\/\/===========================================================<\/pre>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah7-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7425\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah7-1.png\" alt=\"\" width=\"533\" height=\"319\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah7-1.png 533w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah7-1-300x180.png 300w\" sizes=\"(max-width: 533px) 100vw, 533px\" \/><\/a><\/p>\n<p>8. Buat file untuk menyimpan hasil edit dari &#8220;mahasiswa-edit.php&#8221;. Langkah no. 7 dan 8 ini hampir sama dengan langkah 4 dan 5 sebelumnya. Simpan file tersebut dengan nama &#8220;mahasiswa-ubah.php&#8221; dan berikut scriptnya.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\/\/===========================================================\r\n&lt;?php \r\n\r\n\tinclude 'koneksi.php';\r\n\t$id     = $_POST&#x5B;'idm'];\r\n\t$nama   = $_POST&#x5B;'nama'];\r\n\t$alamat = $_POST&#x5B;'alamat'];\r\n\t$notelp = $_POST&#x5B;'notelp'];\r\n\t$jekel  = $_POST&#x5B;'jekel'];\r\n\r\n\t\/\/perintah sql untuk menyimpan ke database\r\n\t$sql = &quot;UPDATE mahasiswa SET nama_mahasiswa='$nama', alamat='$alamat', no_telp='$notelp', jkel ='$jekel' WHERE id_mahasiswa='$id'&quot;;\r\n\t\r\n\t$que = mysqli_query($sambungan, $sql);\t\r\n\t\/\/peyimpanan\r\n\tif ($que) \/\/jika berhasil\r\n\t{\r\n\t\techo \r\n\t\t&quot;\r\n\t\t\t&lt;script type='text\/javascript'&gt;\r\n\t\t\t\talert('Data telah diubah');\r\n\t\t\t\twindow.location='mahasiswa-data.php';\r\n\t\t\t&lt;\/script&gt;\r\n\t\t&quot;;\r\n\t}\r\n\telse \/\/jika gagal\r\n\t{\r\n\t\techo \r\n\t\t&quot;\r\n\t\t\t&lt;script type='text\/javascript'&gt;\r\n\t\t\t\talert('Gagal diubah');\r\n\t\t\t\twindow.location='mahasiswa-edit.php?id=$id';\r\n\t\t\t&lt;\/script&gt;\r\n\t\t&quot;;\r\n\t}\r\n\t\/\/penyimpanan\r\n?&gt;\r\n\/\/===========================================================<\/pre>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah8-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7426\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah8-1.png\" alt=\"\" width=\"449\" height=\"129\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah8-1.png 449w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah8-1-300x86.png 300w\" sizes=\"(max-width: 449px) 100vw, 449px\" \/><\/a><\/p>\n<p>9. Buat file untuk menghapus data-data yang sudah tersimpan, kemudian simpan dengan nama &#8220;mahasiswa-hapus.php&#8221;. File ini akan berfungsi saat kita pilih salah satu data yang tersimpan alias sudah tampil di &#8220;mahasiswa-data.php&#8221;. Berikut ini adalah scriptnya.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\/\/===========================================================\r\n&lt;?php \r\n\tinclude 'koneksi.php';\r\n\t$id  = $_GET&#x5B;'id'];\r\n\t$sql = &quot;DELETE FROM mahasiswa WHERE id_mahasiswa='$id'&quot;;\r\n\t$que = mysqli_query($sambungan, $sql);\t\r\n\t\/\/peyimpanan\r\n\tif ($que) \/\/jika berhasil\r\n\t{\r\n\t\techo \r\n\t\t&quot;\r\n\t\t\t&lt;script type='text\/javascript'&gt;\r\n\t\t\t\talert('Data telah dihapus');\r\n\t\t\t\twindow.location='mahasiswa-data.php';\r\n\t\t\t&lt;\/script&gt;\r\n\t\t&quot;;\r\n\t}\r\n\telse \/\/jika gagal\r\n\t{\r\n\t\techo \r\n\t\t&quot;\r\n\t\t\t&lt;script type='text\/javascript'&gt;\r\n\t\t\t\talert('Gagal dihapus');\r\n\t\t\t\twindow.location='mahasiswa-data.php';\r\n\t\t\t&lt;\/script&gt;\r\n\t\t&quot;;\r\n\t}\r\n\r\n?&gt;\r\n\/\/===========================================================<\/pre>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah9-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7427\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah9-1.png\" alt=\"\" width=\"451\" height=\"130\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah9-1.png 451w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah9-1-300x86.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>10. Dan inilah kondisi file &#8220;mahasiswa-data.php&#8221;, setelah salah satu data dihapus.<\/p>\n<p><a href=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah10-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7428\" src=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah10-1.png\" alt=\"\" width=\"630\" height=\"254\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah10-1.png 630w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/langkah10-1-300x121.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p>Alhamdulillah postingan artikel yang dapat kita bagikan pada kesempatan kali ini. Selamat mencoba ya&#8230; Akhir kata, semoga artikel ini bermanfaat.Amin.<br \/>\nWassalamualaikum Wr. Wb.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Assalamualaikum Wr. Wb Sahabat Webhozz dimanapun berada, apa kabarnya??? Mudah-mudahan sehat selalu dan selalu bahagia ya, amin. Alhamdulillah, kali ini kita ada kesempatan untuk berbagi<\/p>\n","protected":false},"author":15,"featured_media":9070,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[2654,16,35,2653,2655,2652,2656],"class_list":["post-7430","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-belajar-web-programming","tag-bagaimana-membuat-crud-php-mysql","tag-belajar-php","tag-belajar-web-programming-2","tag-cara-membuat-crud-php-mysql","tag-coding-membuat-crud-php-mysql","tag-membuat-crud-php-mysql","tag-script-membuat-php-mysql-crud"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Membuat CRUD PHP MySQL - 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\/membuat-crud-php-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Membuat CRUD PHP MySQL - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Assalamualaikum Wr. Wb Sahabat Webhozz dimanapun berada, apa kabarnya??? Mudah-mudahan sehat selalu dan selalu bahagia ya, amin. Alhamdulillah, kali ini kita ada kesempatan untuk berbagi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-28T11:30:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-01T20:18:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/crud-php-mysql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"700\" \/>\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=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/c14789b713aefdff4189815a3655a941\"},\"headline\":\"Membuat CRUD PHP MySQL\",\"datePublished\":\"2018-11-28T11:30:53+00:00\",\"dateModified\":\"2019-08-01T20:18:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/\"},\"wordCount\":1340,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/crud-php-mysql.jpg\",\"keywords\":[\"bagaimana membuat crud php mysql\",\"Belajar PHP\",\"belajar web programming\",\"cara membuat crud php mysql\",\"coding membuat crud php mysql\",\"membuat crud php mysql\",\"script membuat php mysql crud\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/\",\"name\":\"Membuat CRUD PHP MySQL - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/crud-php-mysql.jpg\",\"datePublished\":\"2018-11-28T11:30:53+00:00\",\"dateModified\":\"2019-08-01T20:18:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/crud-php-mysql.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/crud-php-mysql.jpg\",\"width\":700,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/membuat-crud-php-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Membuat CRUD PHP MySQL\"}]},{\"@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\\\/c14789b713aefdff4189815a3655a941\",\"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\\\/farry\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Membuat CRUD PHP MySQL - 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\/membuat-crud-php-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Membuat CRUD PHP MySQL - WebHozz Blog","og_description":"Assalamualaikum Wr. Wb Sahabat Webhozz dimanapun berada, apa kabarnya??? Mudah-mudahan sehat selalu dan selalu bahagia ya, amin. Alhamdulillah, kali ini kita ada kesempatan untuk berbagi","og_url":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/","og_site_name":"WebHozz Blog","article_published_time":"2018-11-28T11:30:53+00:00","article_modified_time":"2019-08-01T20:18:19+00:00","og_image":[{"width":700,"height":400,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/crud-php-mysql.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/c14789b713aefdff4189815a3655a941"},"headline":"Membuat CRUD PHP MySQL","datePublished":"2018-11-28T11:30:53+00:00","dateModified":"2019-08-01T20:18:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/"},"wordCount":1340,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/crud-php-mysql.jpg","keywords":["bagaimana membuat crud php mysql","Belajar PHP","belajar web programming","cara membuat crud php mysql","coding membuat crud php mysql","membuat crud php mysql","script membuat php mysql crud"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/","url":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/","name":"Membuat CRUD PHP MySQL - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/crud-php-mysql.jpg","datePublished":"2018-11-28T11:30:53+00:00","dateModified":"2019-08-01T20:18:19+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/#primaryimage","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/crud-php-mysql.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/11\/crud-php-mysql.jpg","width":700,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/membuat-crud-php-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Membuat CRUD PHP MySQL"}]},{"@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\/c14789b713aefdff4189815a3655a941","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\/farry\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/7430","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\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/comments?post=7430"}],"version-history":[{"count":5,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/7430\/revisions"}],"predecessor-version":[{"id":8410,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/7430\/revisions\/8410"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media\/9070"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=7430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=7430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=7430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}