{"id":6052,"date":"2017-12-23T05:16:58","date_gmt":"2017-12-23T05:16:58","guid":{"rendered":"https:\/\/www.webhozz.com\/blog\/?p=6052"},"modified":"2019-07-07T06:26:13","modified_gmt":"2019-07-07T06:26:13","slug":"menghapus-data-di-database-beserta-file","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/","title":{"rendered":"Menghapus Data di Database Beserta File"},"content":{"rendered":"

Teknik yang Saya gunakan untuk menyimpan sebuah gambar kedalam database adalah dengan menyimpan nama gambar didalam database sedangkan gambarnya disimpan di dalam sebuah direktori tertentu pada website.<\/p>\n

Prosesnya adalah ketika user upload sebuah gambar\/foto menggunakan sebuah form upload, gambar akan direname\/diberi nama, kemudian nama gambar disimpan didatabse lalu sesudah itu disimpan ke direktori website, mungkin tekniknya akan berbeda \u2013 beda tapi umumnya file gambar tidak akan disimpan secara langsung di dalam database, yang berada didatabase hanyalah file berupa nama gambar\/foto.<\/p>\n

Oleh karena itu bila kita hanya menggunakan query untuk delete data saja seperti\u00a0“delete from nama_tabel where=’id'”;<\/b>\u00a0hanya akan menghapus nama gambar yang tersimpan didatabase sedangkan file aslinya tidak akan dihapus, dengan demikian kita juga memerlukan perintah tambahan untuk mendelete sebuah file didalam halaman website yaitu adalah dengan menggunakan perintah\u00a0unlink(namafile)<\/b>. Nanti prosesnya adalah data di pecah dengan\u00a0$variabel=mysql_fetch_array()<\/b>\u00a0lalu nanti diikuti dengan perintah$variabel[nama_kolom_gambar]<\/b>.Sehingga nanti perintahnya adalahunlink(\u201c$variabel[gambar]\u201d);\u00a0<\/b><\/p>\n

Biasanya saat kita melakukan hapus data , hanya data yang ada di table saja yang terhapus , sementara file yang di upload belum terhapus . Seperti contoh di bawah ini<\/p>\n

 <\/p>\n

Pertama , buat untuk tampilan data seperti di bawah ini<\/p>\n

\"\"<\/a><\/p>\n

Berikut tampilan pada folder foto nya<\/p>\n

\"\"<\/a><\/p>\n

Saat saya jalankan fungsi hapus maka data yang ada di database akan terhapus , namun file yang ada di folder foto belum terhapus .<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Maka agar file dapat terhapus saat data di hapus , tambhkan perintah unlink();<\/p>\n

Berikut contoh nya<\/p>\n

<?php<\/p>\n

include “koneksi.php”;<\/p>\n

 <\/p>\n

$p_id = $_GET[‘id’];<\/p>\n

 <\/p>\n

$pilih = mysql_query(“select*from coba_2 \u00a0where id=’$p_id'”);<\/p>\n

$data = mysql_fetch_array($pilih);<\/p>\n

$foto = $data[‘foto’];<\/p>\n

 <\/p>\n

unlink(“foto\/”.$foto);<\/p>\n

 <\/p>\n

$hapus = mysql_query(“delete from coba_2 where id=’$p_id'”);<\/p>\n

 <\/p>\n

if($hapus)<\/p>\n

{<\/p>\n

echo ”<\/p>\n

<script><\/p>\n

alert(‘Data Berhasil Di hapus’);<\/p>\n

location.href=’data.php’;<\/p>\n

<\/script><\/p>\n

“;<\/p>\n

}<\/p>\n

else<\/p>\n

{<\/p>\n

echo “Data Gagal Di hapus”;<\/p>\n

}<\/p>\n

?><\/p>\n

 <\/p>\n

Maka saat kita hapus data nya<\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

Createt by : Muhammad bashir<\/p>\n","protected":false},"excerpt":{"rendered":"

Teknik yang Saya gunakan untuk menyimpan sebuah gambar kedalam database adalah dengan menyimpan nama gambar didalam database sedangkan gambarnya disimpan di dalam sebuah direktori tertentu<\/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":[2502,2503,2505,2504,2500,2501],"class_list":["post-6052","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-belajar-web-programming","tag-direktori-tertentu-pada-website","tag-disimpan-ke-direktori-website","tag-hanya-data-yang-ada-di-table-saja-yang-terhapus","tag-menggunakan-query-untuk-delete-data","tag-menghapus-data-di-database-beserta-file","tag-menyimpan-nama-gambar-didalam-database"],"yoast_head":"\nMenghapus Data di Database Beserta File - 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\/menghapus-data-di-database-beserta-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Menghapus Data di Database Beserta File - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Teknik yang Saya gunakan untuk menyimpan sebuah gambar kedalam database adalah dengan menyimpan nama gambar didalam database sedangkan gambarnya disimpan di dalam sebuah direktori tertentu\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-12-23T05:16:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-07T06:26:13+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/d5f539ad171dc74baaf6a98dfef6fcef\"},\"headline\":\"Menghapus Data di Database Beserta File\",\"datePublished\":\"2017-12-23T05:16:58+00:00\",\"dateModified\":\"2019-07-07T06:26:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/\"},\"wordCount\":335,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"keywords\":[\"direktori tertentu pada website.\",\"disimpan ke direktori website\",\"hanya data yang ada di table saja yang terhapus\",\"menggunakan query untuk delete data\",\"Menghapus data di database beserta file\",\"menyimpan nama gambar didalam database\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/\",\"name\":\"Menghapus Data di Database Beserta File - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/12\\\/php_mysql.jpg\",\"datePublished\":\"2017-12-23T05:16:58+00:00\",\"dateModified\":\"2019-07-07T06:26:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/menghapus-data-di-database-beserta-file\\\/#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\\\/menghapus-data-di-database-beserta-file\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Menghapus Data di Database Beserta File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"name\":\"WebHozz Blog\",\"description\":\"Kursus Web & 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":"Menghapus Data di Database Beserta File - 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\/menghapus-data-di-database-beserta-file\/","og_locale":"en_US","og_type":"article","og_title":"Menghapus Data di Database Beserta File - WebHozz Blog","og_description":"Teknik yang Saya gunakan untuk menyimpan sebuah gambar kedalam database adalah dengan menyimpan nama gambar didalam database sedangkan gambarnya disimpan di dalam sebuah direktori tertentu","og_url":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/","og_site_name":"WebHozz Blog","article_published_time":"2017-12-23T05:16:58+00:00","article_modified_time":"2019-07-07T06:26:13+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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/d5f539ad171dc74baaf6a98dfef6fcef"},"headline":"Menghapus Data di Database Beserta File","datePublished":"2017-12-23T05:16:58+00:00","dateModified":"2019-07-07T06:26:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/"},"wordCount":335,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","keywords":["direktori tertentu pada website.","disimpan ke direktori website","hanya data yang ada di table saja yang terhapus","menggunakan query untuk delete data","Menghapus data di database beserta file","menyimpan nama gambar didalam database"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/","url":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/","name":"Menghapus Data di Database Beserta File - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2017\/12\/php_mysql.jpg","datePublished":"2017-12-23T05:16:58+00:00","dateModified":"2019-07-07T06:26:13+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/menghapus-data-di-database-beserta-file\/#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\/menghapus-data-di-database-beserta-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Menghapus Data di Database Beserta File"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/blog\/#website","url":"https:\/\/www.webhozz.com\/blog\/","name":"WebHozz Blog","description":"Kursus Web & 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\/6052","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=6052"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/6052\/revisions"}],"predecessor-version":[{"id":8650,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/6052\/revisions\/8650"}],"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=6052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=6052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=6052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}