{"id":2254,"date":"2015-04-01T07:51:55","date_gmt":"2015-04-01T07:51:55","guid":{"rendered":"http:\/\/www.webhozz.com\/blog\/?p=2254"},"modified":"2019-06-27T07:46:51","modified_gmt":"2019-06-27T07:46:51","slug":"crud-sederhana-dengan-php-mysql","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/","title":{"rendered":"CRUD Sederhana dengan PHP &amp; MySQL"},"content":{"rendered":"<p><a href=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\" size-large wp-image-2255 aligncenter\" src=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big-1024x685.jpg\" alt=\"php-elephant-big\" width=\"620\" height=\"415\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big-1024x685.jpg 1024w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big-300x201.jpg 300w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big.jpg 1280w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/a><\/p>\n<p>Halo jumpa lagi teman-teman WebHozz oke kali ini kita akan mencoba tutorial CRUD sederahana dengan PHP. Oke kalau begitu kita langsung coba ya teman-teman. \u00a0Operasi CRUD atau biasa di kenal dengan Create, Read Update dan Delete merupakan operasi yang sangat sering digunakan ketika seorang programer membuat suatu programdengan PHP. CRUD merupakan salah satu inti dari sebuah pemrograman karena didalam suatu program biasanya mencakup operasi Create atau menciptakan data, Read atau Menampilkan data, Update atau mengedit suatu data dan Delete atau menghapus data.<\/p>\n<p><!--more--><\/p>\n<p>Langsung saja, kalian jalankan \/\/localhost dengan web server seperti XAMPP atau AppServ, setelah itu kita akan membuat database. Kita akan membuat database dengan nama <span style=\"color: #ff0000\">karyawan <span style=\"color: #333333\"> seteal itu kita akan buat tabel dengan nama <span style=\"color: #ff0000\">profil<\/span> <\/span><\/span><\/p>\n<p><a href=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/struktur.jpg\"><img decoding=\"async\" class=\" size-large wp-image-2257 aligncenter\" src=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/struktur.jpg\" alt=\"struktur\" width=\"620\" height=\"179\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/struktur.jpg 842w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/struktur-300x87.jpg 300w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/a><\/p>\n<p>struktur tabel <span style=\"color: #ff0000\">profil<\/span> yang kita buat, bisa kalian lihat diatas. Nah kita sudah punya database dengan nama <span style=\"color: #ff0000\">karyawan<\/span> dengan tabel <span style=\"color: #ff0000\">profil <span style=\"color: #333333\">. Kita lanjutkan dengan membuat file untuk koneksi ke database. <\/span><\/span><\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n&lt;?php\r\n\r\n    $server = 'localhost'; \/\/nama lokalhost\r\n    $username = 'root'; \/\/ nama user\r\n    $password = ''; \/\/password\r\n    $dbase = 'karyawan2'; \/\/ nama databse\r\n\r\n    \/\/ query untuk koneksi ke database\r\n    mysql_connect($server, $username, $password) or die (mysql_error());\r\n\r\n    \/\/query untuk koneksi ke database\r\n    mysql_select_db($dbase) or die (mysql_error());\r\n\r\n\r\n\r\n\/**\r\n * Created by PhpStorm.\r\n * User: faroq\r\n * Date: 3\/2\/2015\r\n * Time: 10:11 PM\r\n *\/\r\n<\/pre>\n<p>Simpan file diatas dengan nama <span style=\"color: #ff0000\">koneksi.php<\/span><\/p>\n<p>Kita lanjutkan dengan membuat aksi untuk input data,<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n&lt;head lang=&quot;en&quot;&gt;\r\n    &lt;meta charset=&quot;UTF-8&quot;&gt;\r\n    &lt;title&gt;Input Profil&lt;\/title&gt;\r\n    &lt;link rel=&quot;stylesheet&quot; href=&quot;http:\/\/yui.yahooapis.com\/pure\/0.6.0\/pure-min.css&quot;&gt;\r\n    &lt;script type=&quot;text\/javascript&quot; src=&quot;ckeditor\/ckeditor.js&quot;&gt;&lt;\/script&gt;\r\n&lt;\/head&gt;\r\n&lt;body&gt;\r\n    &lt;form action=&quot;insert.php&quot; method=&quot;post&quot;&gt;\r\n        &lt;table align=&quot;center&quot;&gt;\r\n            &lt;tr&gt;\r\n                &lt;td colspan=&quot;3&quot;&gt;&lt;h3&gt;Form Input Profil&lt;\/h3&gt;&lt;\/td&gt;\r\n            &lt;\/tr&gt;\r\n            &lt;tr&gt;\r\n                &lt;td&gt;Nama&lt;\/td&gt;\r\n                &lt;td&gt;:&lt;\/td&gt;\r\n                &lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;nama&quot; placeholder=&quot;Masukan Nama&quot; required=&quot;required&quot;&gt;&lt;\/td&gt;\r\n            &lt;\/tr&gt;\r\n            &lt;tr&gt;\r\n                &lt;td&gt;Jenis Kelamin&lt;\/td&gt;\r\n                &lt;td&gt;:&lt;\/td&gt;\r\n                &lt;td&gt;&lt;input type=&quot;radio&quot; name=&quot;jenis_kelamin&quot; value=&quot;Laki-laki&quot;&gt;Laki-laki&lt;\/td&gt;\r\n                &lt;td&gt;&lt;input type=&quot;radio&quot; name=&quot;jenis_kelamin&quot; value=&quot;Perempuan&quot;&gt;Perempuan&lt;\/td&gt;\r\n            &lt;\/tr&gt;\r\n            &lt;tr&gt;\r\n                &lt;td&gt;Alamat&lt;\/td&gt;\r\n                &lt;td&gt;:&lt;\/td&gt;\r\n                &lt;td&gt;&lt;textarea cols=&quot;30&quot; rows=&quot;5&quot; name=&quot;alamat&quot; class=&quot;ckeditor&quot;&gt;&lt;\/textarea&gt;&lt;\/td&gt;\r\n            &lt;\/tr&gt;\r\n            &lt;tr&gt;\r\n                &lt;td&gt;Nomor Telepon&lt;\/td&gt;\r\n                &lt;td&gt;:&lt;\/td&gt;\r\n                &lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;tlp&quot;&gt;&lt;\/td&gt;\r\n            &lt;\/tr&gt;\r\n            &lt;tr&gt;\r\n                &lt;td colspan=&quot;3&quot;&gt;&lt;input type=&quot;submit&quot; name=&quot;submit&quot; value=&quot;Send&quot;&gt;\r\n                &lt;input type=&quot;reset&quot; name=&quot;reset&quot; value=&quot;Clear&quot;&gt;&lt;\/td&gt;\r\n            &lt;\/tr&gt;\r\n        &lt;\/table&gt;\r\n    &lt;\/form&gt;\r\n\r\n\r\n    &lt;h4&gt;&lt;a href=&quot;data_profil.php&quot;&gt;Lihat Data&lt;\/a&gt;&lt;\/h4&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;\r\n<\/pre>\n<p>simpan file diatas dengan nama <span style=\"color: #ff0000\">input_profil.php<\/span><\/p>\n<p>Kita lanjutkan dengan membuat proses, untuk insert ke databasenya.<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n&lt;?php\r\n\r\ninclude (&quot;koneksi.php&quot;);\r\n\r\n$nama = $_POST&#x5B;'nama'];\r\n$jk = $_POST&#x5B;'jenis_kelamin'];\r\n$almt = $_POST&#x5B;'alamat'];\r\n$telepon = $_POST&#x5B;'tlp'];\r\n\r\n\/\/Perintah Query untuk proses insert ke database\r\n\r\n$sql_profil = &quot;INSERT INTO profil (nama,jenis_kelamin,alamat,no_tlp)\r\n               VALUES ('$nama','$jk','$almt','$telepon')&quot;;\r\n\r\n$sql = mysql_query($sql_profil) or die (mysql_error());\r\n\r\nif($sql){\r\n    echo &quot;Berhasil Simpan!\r\n          &lt;meta http-equiv='refresh' content='3;url=input_profil.php'&gt;&quot;;\r\n} else {\r\n    echo &quot;Gagal simpan!\r\n         &lt;meta http-equiv='refresh' content='3;url=input_profil.php'&gt;&quot;;\r\n}\r\n\r\n\/**\r\n * Created by PhpStorm.\r\n * User: faroq\r\n * Date: 3\/4\/2015\r\n * Time: 7:25 PM\r\n *\/\r\n<\/pre>\n<p>simpan file diatas dengan nama <span style=\"color: #ff0000\">insert.php<\/span><\/p>\n<p>Sekarang kita lanjutkan untuk membuat tampilannya, sekarang buatlah file seperti berikut ini:<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n&lt;head lang=&quot;en&quot;&gt;\r\n    &lt;meta charset=&quot;UTF-8&quot;&gt;\r\n    &lt;title&gt;Data Profil&lt;\/title&gt;\r\n    &lt;link rel=&quot;stylesheet&quot; href=&quot;http:\/\/yui.yahooapis.com\/pure\/0.6.0\/pure-min.css&quot;&gt;\r\n&lt;\/head&gt;\r\n&lt;body&gt;\r\n\r\n    &lt;h1 align=&quot;center&quot;&gt;Data Profil&lt;\/h1&gt;\r\n    &lt;table border=&quot;1&quot; align=&quot;center&quot;&gt;\r\n        &lt;tr&gt;\r\n            &lt;td&gt;No&lt;\/td&gt;\r\n            &lt;td&gt;Id Profil&lt;\/td&gt;\r\n            &lt;td&gt;Nama&lt;\/td&gt;\r\n            &lt;td&gt;Jenis Kelamin&lt;\/td&gt;\r\n            &lt;td&gt;Alamat&lt;\/td&gt;\r\n            &lt;td&gt;No Telpon&lt;\/td&gt;\r\n            &lt;td colspan=&quot;2&quot;&gt;Aksi&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;?php\r\n            include(&quot;koneksi.php&quot;);\r\n            $sql_profil = &quot;SELECT * FROM profil&quot;;\r\n            $sql = mysql_query($sql_profil) or die (mysql_error());\r\n\r\n            \/\/proses menampilkan diambil dari database\r\n\r\n            $no = 1;\r\n            ?&gt;\r\n            &lt;?php while($data_profil = mysql_fetch_array($sql)){ ?&gt;\r\n\r\n                &lt;tr&gt;\r\n                            &lt;td&gt;&lt;?php echo $no ?&gt;&lt;\/td&gt;\r\n                            &lt;td&gt;&lt;?php echo $data_profil&#x5B;'id_profil']?&gt;&lt;\/td&gt;\r\n                            &lt;td&gt;&lt;?php echo $data_profil&#x5B;'nama']?&gt;&lt;\/td&gt;\r\n                            &lt;td&gt;&lt;?php echo $data_profil&#x5B;'jenis_kelamin']?&gt;&lt;\/td&gt;\r\n                            &lt;td&gt;&lt;?php echo $data_profil&#x5B;'alamat']?&gt;&lt;\/td&gt;\r\n                            &lt;td&gt;&lt;?php echo $data_profil&#x5B;'no_tlp']?&gt;&lt;\/td&gt;\r\n                            &lt;td&gt;&lt;a href='edit_profil.php?edit_id=&lt;?php echo $data_profil&#x5B;'id_profil']?&gt;'&gt;Edit&lt;\/td&gt;\r\n                            &lt;td&gt;&lt;a href=hapus.php?hapus_id=&lt;?php echo $data_profil&#x5B;'id_profil']?&gt;'&gt;Hapus&lt;\/a&gt;&lt;\/td&gt;\r\n                            \r\n                    &lt;\/tr&gt;\r\n\r\n               &lt;?php $no++;  } ?&gt;\r\n    &lt;\/table&gt;\r\n\r\n    &lt;h4&gt;&lt;a href=&quot;input_profil.php&quot;&gt;+Tambah Data&lt;\/a&gt;&lt;\/h4&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;\r\n<\/pre>\n<p>simpan file diatas dengan nama <span style=\"color: #ff0000\">data_profil.php<\/span><\/p>\n<p>oke kita lanjutkan supaya data tersebut bisa kita edit, kita buat file seperti berikut ini:<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n&lt;!DOCTYPE html&gt;\r\n&lt;html&gt;\r\n&lt;head lang=&quot;en&quot;&gt;\r\n    &lt;meta charset=&quot;UTF-8&quot;&gt;\r\n    &lt;title&gt;Input Profil&lt;\/title&gt;\r\n    &lt;link rel=&quot;stylesheet&quot; href=&quot;http:\/\/yui.yahooapis.com\/pure\/0.6.0\/pure-min.css&quot;&gt;\r\n&lt;\/head&gt;\r\n&lt;body&gt;\r\n\r\n    &lt;!--Form Edit Profil Karyawan --&gt;\r\n\r\n    &lt;?php\r\n        include(&quot;koneksi.php&quot;);\r\n        $id_edit = $_GET&#x5B;'edit_id'];\r\n        $query = &quot;SELECT * FROM profil WHERE id_profil = '$id_edit'&quot;;\r\n        $sql = mysql_query($query) or die(mysql_error());\r\n        while($data = mysql_fetch_array($sql)){\r\n            $id_profil = $data&#x5B;&quot;id_profil&quot;];\r\n            $nama = $data&#x5B;&quot;nama&quot;];\r\n            $jk = $data&#x5B;&quot;jenis_kelamin&quot;];\r\n            $almt = $data&#x5B;&quot;alamat&quot;];\r\n            $tlp = $data&#x5B;&quot;no_tlp&quot;];\r\n        }\r\n    ?&gt;\r\n\r\n\r\n&lt;form action=&quot;update.php&quot; method=&quot;post&quot; enctype=&quot;multipart\/form-data&quot;&gt;\r\n    &lt;table align=&quot;center&quot;&gt;\r\n        &lt;input type=&quot;hidden&quot; name=&quot;id_profil&quot; value=&quot;&lt;?php echo $id_profil?&gt;&quot;&gt;\r\n        &lt;tr&gt;\r\n            &lt;td colspan=&quot;3&quot;&gt;&lt;h3&gt;Form Input Profil&lt;\/h3&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;td&gt;Nama&lt;\/td&gt;\r\n            &lt;td&gt;:&lt;\/td&gt;\r\n            &lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;nama&quot; value=&quot;&lt;?php echo $nama?&gt;&quot;&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;td&gt;Jenis Kelamin&lt;\/td&gt;\r\n            &lt;td&gt;:&lt;\/td&gt;\r\n            &lt;td&gt;&lt;input type=&quot;radio&quot; name=&quot;jenis_kelamin&quot; value=&quot;Laki-laki&quot; &lt;?php if($jk == 'Laki-laki') echo &quot;checked&quot;?&gt;&gt;Laki-laki&lt;\/td&gt;\r\n            &lt;td&gt;&lt;input type=&quot;radio&quot; name=&quot;jenis_kelamin&quot; value=&quot;Perempuan&quot; &lt;?php if($jk == 'Perempuan') echo &quot;checked&quot;?&gt;&gt;Perempuan&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;td&gt;Alamat&lt;\/td&gt;\r\n            &lt;td&gt;:&lt;\/td&gt;\r\n            &lt;td&gt;&lt;textarea cols=&quot;30&quot; rows=&quot;5&quot; name=&quot;alamat&quot;&gt;&lt;?php echo $almt?&gt;&lt;\/textarea&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;td&gt;Nomor Telepon&lt;\/td&gt;\r\n            &lt;td&gt;:&lt;\/td&gt;\r\n            &lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;tlp&quot; value=&quot;&lt;?php echo $tlp?&gt;&quot;&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n        &lt;tr&gt;\r\n            &lt;td colspan=&quot;3&quot;&gt;&lt;input type=&quot;submit&quot; name=&quot;submit&quot; value=&quot;Send&quot;&gt;\r\n                &lt;input type=&quot;reset&quot; name=&quot;reset&quot; value=&quot;Clear&quot;&gt;&lt;\/td&gt;\r\n        &lt;\/tr&gt;\r\n    &lt;\/table&gt;\r\n&lt;\/form&gt;\r\n\r\n    &lt;h4&gt;&lt;a href=&quot;data_profil.php&quot;&gt;Lihat Data&lt;\/a&gt;&lt;\/h4&gt;\r\n&lt;\/body&gt;\r\n&lt;\/html&gt;\r\n<\/pre>\n<p>simpan nama file diatas dengan nama <span style=\"color: #ff0000\">edit_profil.php<\/span><br \/>\nKita lanjut dengan membuat file untuk proses updatenya<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n&lt;?php\r\ninclude&quot;koneksi.php&quot;;\r\n\r\n$id_profil = $_POST&#x5B;'id_profil'];\r\n$nama = $_POST&#x5B;'nama'];\r\n$jenis_kelamin = $_POST&#x5B;'jenis_kelamin'];\r\n$alamat = $_POST&#x5B;'alamat'];\r\n$telp = $_POST&#x5B;'tlp'];\r\n\r\n$query = &quot;UPDATE profil\r\n         SET nama='$nama', jenis_kelamin='$jenis_kelamin', alamat='$alamat', no_tlp='$telp', WHERE id_profil = '$id_profil'&quot;;\r\n$sql = mysql_query($query) or die (mysql_error());\r\n\r\n    if($sql){\r\n        echo&quot;Berhasil Update\r\n             &lt;meta http-equiv='refresh' content='1;url=data_profil.php'&gt;&quot;;\r\n    } else {\r\n        echo &quot;Gagal Update&quot;;\r\n    }\r\nmysql_close();\r\n\r\n\/**\r\n * Created by PhpStorm.\r\n * User: faroq\r\n * Date: 2\/14\/2015\r\n * Time: 11:34 AM\r\n *\/\r\n<\/pre>\n<p>simpan file tersebut dengan nama <span style=\"color: #ff0000\">update.php<\/span><br \/>\nUntuk berikutnya kita buat file <span style=\"color: #ff0000\">hapus.php<\/span><\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n&lt;?php\r\n\r\n    include(&quot;koneksi.php&quot;);\r\n\r\n    $id_hapus = $_GET&#x5B;'hapus_id'];\r\n\r\n    $sql_hapus = &quot;DELETE FROM profil WHERE id_profil = '$id_hapus'&quot;;\r\n    $sql = mysql_query($sql_hapus) or die (mysql_error());\r\n\r\n    if($sql){\r\n        echo&quot;&lt;script type='text\/javascript'&gt; alert('Data Berhasil di Hapus!')&lt;\/script&gt;\r\n             &lt;meta http-equiv='refresh' content='4;url=data_profil.php'&gt;&quot;;\r\n    } else {\r\n        echo&quot;Hapus Data Gagal!&quot;;\r\n    }\r\n\r\n\r\n\/**\r\n * Created by PhpStorm.\r\n * User: faroq\r\n * Date: 3\/4\/2015\r\n * Time: 8:29 PM\r\n *\/\r\n<\/pre>\n<p><a href=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-2258\" src=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed.png\" alt=\"ed\" width=\"615\" height=\"32\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed.png 615w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed-300x16.png 300w\" sizes=\"(max-width: 615px) 100vw, 615px\" \/><\/a><\/p>\n<p>edit_id dan hapus_id yang akan kita $_GET<\/p>\n<p><a href=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2259\" src=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed2.png\" alt=\"ed2\" width=\"534\" height=\"80\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed2.png 534w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/ed2-300x45.png 300w\" sizes=\"(max-width: 534px) 100vw, 534px\" \/><\/a><\/p>\n<p>begitu pun juga untuk hapus,<\/p>\n<p><a href=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/hap.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2260\" src=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/hap.png\" alt=\"hap\" width=\"715\" height=\"278\" srcset=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/hap.png 715w, https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/hap-300x117.png 300w\" sizes=\"(max-width: 715px) 100vw, 715px\" \/><\/a><\/p>\n<p>itu dia teman-teman WebHozz, CRUD sederhana dengan PHP, mudah bukan selamat mencoba.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Halo jumpa lagi teman-teman WebHozz oke kali ini kita akan mencoba tutorial CRUD sederahana dengan PHP. Oke kalau begitu kita langsung coba ya teman-teman. \u00a0Operasi<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[16,841,843,126,30,842],"class_list":["post-2254","post","type-post","status-publish","format-standard","hentry","category-belajar-web-programming","tag-belajar-php","tag-crud","tag-crud-sederhana","tag-php","tag-php-programming","tag-tutorial-crud"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>CRUD Sederhana dengan PHP &amp; 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\/crud-sederhana-dengan-php-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CRUD Sederhana dengan PHP &amp; MySQL - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Halo jumpa lagi teman-teman WebHozz oke kali ini kita akan mencoba tutorial CRUD sederahana dengan PHP. Oke kalau begitu kita langsung coba ya teman-teman. \u00a0Operasi\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-01T07:51:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-27T07:46:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"856\" \/>\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=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/ad1c5822a60b5b228c5ceda20e439fea\"},\"headline\":\"CRUD Sederhana dengan PHP &amp; MySQL\",\"datePublished\":\"2015-04-01T07:51:55+00:00\",\"dateModified\":\"2019-06-27T07:46:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/\"},\"wordCount\":1842,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/04\\\/php-elephant-big-1024x685.jpg\",\"keywords\":[\"Belajar PHP\",\"crud\",\"crud sederhana\",\"php\",\"php programming\",\"tutorial crud\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/\",\"name\":\"CRUD Sederhana dengan PHP &amp; MySQL - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/04\\\/php-elephant-big-1024x685.jpg\",\"datePublished\":\"2015-04-01T07:51:55+00:00\",\"dateModified\":\"2019-06-27T07:46:51+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/04\\\/php-elephant-big-1024x685.jpg\",\"contentUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2015\\\/04\\\/php-elephant-big-1024x685.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/crud-sederhana-dengan-php-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CRUD Sederhana dengan PHP &amp; 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\\\/ad1c5822a60b5b228c5ceda20e439fea\",\"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\\\/putralucio\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CRUD Sederhana dengan PHP &amp; 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\/crud-sederhana-dengan-php-mysql\/","og_locale":"en_US","og_type":"article","og_title":"CRUD Sederhana dengan PHP &amp; MySQL - WebHozz Blog","og_description":"Halo jumpa lagi teman-teman WebHozz oke kali ini kita akan mencoba tutorial CRUD sederahana dengan PHP. Oke kalau begitu kita langsung coba ya teman-teman. \u00a0Operasi","og_url":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/","og_site_name":"WebHozz Blog","article_published_time":"2015-04-01T07:51:55+00:00","article_modified_time":"2019-06-27T07:46:51+00:00","og_image":[{"width":1280,"height":856,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big.jpg","type":"image\/jpeg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/ad1c5822a60b5b228c5ceda20e439fea"},"headline":"CRUD Sederhana dengan PHP &amp; MySQL","datePublished":"2015-04-01T07:51:55+00:00","dateModified":"2019-06-27T07:46:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/"},"wordCount":1842,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big-1024x685.jpg","keywords":["Belajar PHP","crud","crud sederhana","php","php programming","tutorial crud"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/","url":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/","name":"CRUD Sederhana dengan PHP &amp; MySQL - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big-1024x685.jpg","datePublished":"2015-04-01T07:51:55+00:00","dateModified":"2019-06-27T07:46:51+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/#primaryimage","url":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big-1024x685.jpg","contentUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2015\/04\/php-elephant-big-1024x685.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/crud-sederhana-dengan-php-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"CRUD Sederhana dengan PHP &amp; 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\/ad1c5822a60b5b228c5ceda20e439fea","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\/putralucio\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/2254","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/comments?post=2254"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/2254\/revisions"}],"predecessor-version":[{"id":2262,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/2254\/revisions\/2262"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=2254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=2254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=2254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}