{"id":111,"date":"2025-09-19T06:03:42","date_gmt":"2025-09-19T06:03:42","guid":{"rendered":"https:\/\/www.warunginter.net\/2018\/06\/membuat-create-read-update-delete-image-pada-php.html"},"modified":"2025-09-19T06:03:42","modified_gmt":"2025-09-19T06:03:42","slug":"membuat-create-read-update-delete-image-pada-php-d","status":"publish","type":"post","link":"https:\/\/flycai.warunginter.net\/?p=111","title":{"rendered":"Membuat Create Read Update Delete Image Pada PHP dan MYSQL"},"content":{"rendered":"
\n
\nKali ini saya akan membahas bagaimana cara create, read, update dan delete image dengan menggunakan bahasa pemrograman PHP dan MYSQL. Masih hampir sama dengan beberapa waktu lalu tentang postingan yang saya buat mengenai Cara Membuat Edit Menggunakan Modal Bootstrap<\/a>. Jadi kita harus online untuk pemanggilan bootstrap tersebut agar tampilan yang dibuat tidak terlalu kaku.<\/p>\n
\n<\/a><\/div>\n

<\/p>\n

\n<\/div>\n

\nMembuat Create Read Update Delete Image Pada PHP dan MYSQL<\/h2>\n

1. Pertama-tama buat database dengan nama \u201cbelajar_image\u201d (tanpa petik).<\/p>\n

2. Kemudian buat satu table dengan nama \u201cuser\u201d dimana di table tersebut terdapat 3 field yakni id_user, username dan foto.<\/p>\n

3. Untuk id_user typenya pilih integer dan beri Primary Key serta Auto Increment, sedangkan untuk username dan foto beri type varchar saja dan untuk Length\/Values isi terserah atau sesuai dengan kebutuhan saja.<\/p>\n

4. Buat Folder dengan nama “crud_image” atau bisa disesuaikan dengan kebutuhan kamu, kemudian didalam folder tadi buat folder lagi dengan nama “foto”.<\/p>\n

5. Kemudian kita buat koneksi ke databasenya terlebih dahulu, buat file dan beri nama koneksi.php dan masukan script dibawah ini.<\/p>\n

<?php\n\n\u00a0\u00a0\u00a0 $server = \"localhost\";\n\n\u00a0\u00a0\u00a0 $username = \"root\";\n\n\u00a0\u00a0\u00a0 $password = \"\";\n\n\u00a0\u00a0\u00a0 $database = \"belajar_image\";\n\n\n\n\u00a0\u00a0\u00a0 mysql_connect($server,$username,$password) or die(\"Koneksi gagal\");\n\n\u00a0\u00a0\u00a0 mysql_select_db($database) or die(\"Database tidak bisa dibuka\");\n\n?>\n\n<\/pre>\n
\n6. Selanjutnya kita buat index.php untuk menampilkan data (Read) yang akan kita buat nanti, serta untuk menampilkan button tambah data (masukan script dibawah ini).<\/p>\n
<?php\n\n\u00a0\u00a0\u00a0 include 'koneksi.php';\n\n?>\n\n<!DOCTYPE html>\n\n<html lang=\"en\">\n\n\u00a0\u00a0\u00a0 <head>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta charset=\"utf-8\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"description\" content=\"\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"author\" content=\"\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <title>Index<\/title>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.min.css\" integrity=\"sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz\/K68vbdEjh4u\" crossorigin=\"anonymous\">\n\n\u00a0\u00a0\u00a0 <\/head>\n\n\u00a0\u00a0\u00a0 <body>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"container\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"row\"> \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"panel panel-default\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <div class=\"panel-heading\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <a href=\"formdata.php\" class=\"btn btn-primary btn-sm\"><span class=\"fa fa-plus\"><\/span> Tambah Data<\/a>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <!-- \/.panel-heading -->\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <div class=\"panel-body\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <table width=\"100%\" class=\"table table-striped table-bordered table-hover\" id=\"dataTables-example\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <thead>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <tr>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <th>No<\/th>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <th>Username<\/th>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <th>Foto<\/th>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <th>Aksi<\/th>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/tr>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/thead>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <tbody>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <?php \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $no=1;\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $sql = mysql_query(\"select * from user order by id_user desc\");\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 while($data=mysql_fetch_array($sql)){\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 ?>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <tr>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <td><?php echo $no ?><\/td>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <td><?php echo $data['username'] ?><\/td>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <td><img src=\"foto\/<?php echo $data['foto'] ?>\" width=\"150px\" height=\"120px\" \/><\/td>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <td>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <a href=\"formedit.php?id_user=<?php echo $data['id_user']; ?>\" class=\"btn btn-warning\" Title=\"Edit\"><span class=\"glyphicon glyphicon-edit\"><\/a>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <a onclick=\"if(confirm('Apakah anda yakin ingin menghapus data ini ??')){ location.href='deletedata.php?id_user=<?php echo $data['id_user']; ?>' }\" class=\"btn btn-danger\" Title=\"Delete\"><span class=\"glyphicon glyphicon-remove\"><\/a>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/td>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/tr>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <?php\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $no++;\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 }\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 ?>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/tbody>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/table>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 <script src=\"https:\/\/code.jquery.com\/jquery-3.1.1.min.js\"><\/script>\n\n\u00a0\u00a0\u00a0 <script src=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js\" integrity=\"sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa\" crossorigin=\"anonymous\"><\/script>\n\n\u00a0\u00a0\u00a0 <\/body>\n\n<\/html>\u00a0\u00a0\u00a0 \n\n<\/pre>\n
\n7. Sekarang buat file lagi dengan nama formdata.php, fungsinya yakni untuk menginput data yang akan kita tampilkan, langsung saja masukan script dibawah ini.<\/p>\n
<?php\n\n\u00a0\u00a0\u00a0 include 'koneksi.php';\n\n?>\n\n<!DOCTYPE html>\n\n<html lang=\"en\">\n\n\u00a0\u00a0\u00a0 <head>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta charset=\"utf-8\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"description\" content=\"\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"author\" content=\"\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <title>Form Data<\/title>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.min.css\" integrity=\"sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz\/K68vbdEjh4u\" crossorigin=\"anonymous\">\n\n\u00a0\u00a0\u00a0 <\/head>\n\n\u00a0\u00a0\u00a0 <body>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"container\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"row\"> \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"panel panel-primary\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <div class=\"panel-heading\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span class=\"fa fa-user\"> Tambah User<\/span>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <!-- \/.panel-heading -->\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <div class=\"panel-body\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <form action=\"tambahdata.php\" method=\"post\" enctype=\"multipart\/form-data\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"form-group\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <label>Username<\/label>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <input name=\"username\" type=\"text\" class=\"form-control\" placeholder=\"Username ..\" required>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"form-group\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <label>Foto<\/label>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <input name=\"gambar\" id=\"gambar\" type=\"file\" class=\"form-control\" required>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <input type=\"submit\" class=\"btn btn-primary\" value=\"Simpan\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <a href=\"index.php\" class=\"btn btn-warning\"> Kembali<\/a>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/form>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 <script src=\"https:\/\/code.jquery.com\/jquery-3.1.1.min.js\"><\/script>\n\n\u00a0\u00a0\u00a0 <script src=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js\" integrity=\"sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa\" crossorigin=\"anonymous\"><\/script>\n\n\u00a0\u00a0\u00a0 <\/body>\n\n<\/html>\u00a0\u00a0\u00a0 \n\n<\/pre>\n
\n8. Sekarang kita buat file proses penginputan tadi dengan nama tambahdata.php dan masukkan script dibawah ini.<\/p>\n
<?php \n\ninclude \"koneksi.php\";\n\n\n\n$username = $_POST['username'];\n\n$sumber = $_FILES['gambar']['tmp_name'];\n\n\u00a0\u00a0\u00a0 $target = 'foto\/';\n\n\u00a0\u00a0\u00a0 $nama_gambar = $_FILES['gambar']['name'];\n\n\n\n$pindah = move_uploaded_file($sumber, $target.$nama_gambar);\n\nif($pindah){\n\n$query = \"insert into user values('','$username','$nama_gambar')\";\n\n$hasil = mysql_query($query);\n\n}\n\nif($hasil)\n\n{\n\nheader(\"location:index.php\");\n\n}\n\nelse{\n\n\u00a0\u00a0\u00a0 echo \"Penyimpanan gagal\";\n\n} \n\n?>\n\n<\/pre>\n
\n9. Sampai disini kamu sudah membuat Create dan Read, selanjutnya kita akan membuat editnya. Buat file lagi dan beri nama formedit.php kemudian masukkan script dibawah ini.<\/p>\n
<?php\n\n\u00a0\u00a0\u00a0 include 'koneksi.php';\n\n?>\n\n<!DOCTYPE html>\n\n<html lang=\"en\">\n\n\u00a0\u00a0\u00a0 <head>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta charset=\"utf-8\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"description\" content=\"\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <meta name=\"author\" content=\"\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <title>Form Edit<\/title>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.min.css\" integrity=\"sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz\/K68vbdEjh4u\" crossorigin=\"anonymous\">\n\n\u00a0\u00a0\u00a0 <\/head>\n\n\u00a0\u00a0\u00a0 <body>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"container\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"row\"> \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <?php\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $id_user=mysql_real_escape_string($_GET['id_user']);\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $det=mysql_query(\"select * from user where id_user='$id_user'\")or die(mysql_error());\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 while($d=mysql_fetch_array($det)){\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 ?>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"panel panel-primary\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <div class=\"panel-heading\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span class=\"fa fa-user\"> Edit User<\/span>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <!-- \/.panel-heading -->\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <div class=\"panel-body\">\n\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <form action=\"updatedata.php\" method=\"post\" enctype=\"multipart\/form-data\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <input name=\"id_user\" type=\"hidden\" class=\"form-control\" value=\"<?php echo $d['id_user'] ?>\" required>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"form-group\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <label>Username<\/label>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <input name=\"username\" type=\"text\" class=\"form-control\" value=\"<?php echo $d['username'] ?>\" required>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <div class=\"form-group\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <label>Foto<\/label><br>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <img src=\"foto\/<?php echo $d['foto'] ?>\" width=\"150px\" height=\"120px\" \/><\/br>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <input type=\"checkbox\" name=\"ubah_foto\" value=\"true\"> Ceklis jika ingin mengubah foto<br>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <input name=\"gambar\" id=\"gambar\" type=\"file\" class=\"form-control\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <input type=\"submit\" class=\"btn btn-primary\" value=\"Simpan\">\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <a href=\"index.php\" class=\"btn btn-warning\"> Kembali<\/a>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/form>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <?php \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 }\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 ?>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/div>\n\n\u00a0\u00a0\u00a0 <script src=\"https:\/\/code.jquery.com\/jquery-3.1.1.min.js\"><\/script>\n\n\u00a0\u00a0\u00a0 <script src=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js\" integrity=\"sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa\" crossorigin=\"anonymous\"><\/script>\n\n\u00a0\u00a0\u00a0 <\/body>\n\n<\/html>\u00a0\u00a0\u00a0 \n\n<\/pre>\n
\n10. Sekarang kita buat proses update editnya, agak ribet sih sebenarnya untuk editnya tapi saya yakin kamu bisa memahaminya. Oke buat file dan beri nama updatedata.php lalu masukan script dibawah ini.<\/p>\n
<?php\n\ninclude \"koneksi.php\";\n\n\n\n$id_user=$_POST['id_user'];\n\n$username=$_POST['username'];\n\n\n\n\/\/ Cek apakah user ingin mengubah fotonya atau tidak\n\nif(isset($_POST['ubah_foto'])){ \/\/ Jika user menceklis checkbox yang ada di form ubah, lakukan :\n\n\u00a0\u00a0\u00a0 \/\/ Ambil data foto yang dipilih dari form\n\n\u00a0\u00a0\u00a0 $sumber = $_FILES['gambar']['name'];\n\n\u00a0\u00a0\u00a0 $nama_gambar = $_FILES['gambar']['tmp_name'];\n\n\u00a0\u00a0\u00a0 \n\n\u00a0\u00a0\u00a0 \/\/ Rename nama fotonya dengan menambahkan tanggal dan jam upload\n\n\u00a0\u00a0\u00a0 $fotobaru = date('dmYHis').$sumber;\n\n\u00a0\u00a0\u00a0 \n\n\u00a0\u00a0\u00a0 \/\/ Set path folder tempat menyimpan fotonya\n\n\u00a0\u00a0\u00a0 $path = \"foto\/\".$fotobaru;\n\n\n\n\u00a0\u00a0\u00a0 if(move_uploaded_file($nama_gambar, $path)){ \/\/ Cek apakah gambar berhasil diupload atau tidak\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/\/ Query untuk menampilkan data user berdasarkan id_user yang dikirim\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $query = \"SELECT * FROM user WHERE id_user='\".$id_user.\"'\";\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $sql = mysql_query($query); \/\/ Eksekusi\/Jalankan query dari variabel $query\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $data = mysql_fetch_array($sql); \/\/ Ambil data dari hasil eksekusi $sql\n\n\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/\/ Cek apakah file gambar sebelumnya ada di folder foto\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 if(is_file(\"foto\/\".$data['foto'])) \/\/ Jika gambar ada\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 unlink(\"foto\/\".$data['foto']); \/\/ Hapus file gambar sebelumnya yang ada di folder images\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/\/ Proses ubah data ke Database\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $query = \"update user set username='$username', foto='$fotobaru' where id_user='$id_user' \";\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 $sql = mysql_query($query); \/\/ Eksekusi\/ Jalankan query dari variabel $query\n\n\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 if($sql){ \/\/ Cek jika proses simpan ke database sukses atau tidak\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/\/ Jika Sukses, Lakukan :\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 header(\"location: index.php\"); \/\/ Redirect ke halaman index.php\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 }else{\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/\/ Jika Gagal, Lakukan :\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 echo \"Maaf, Terjadi kesalahan saat mencoba untuk menyimpan data ke database.\";\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 echo \"<br><a href='index.php'>Kembali Ke Form<\/a>\";\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 }\n\n\u00a0\u00a0\u00a0 }else{\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/\/ Jika gambar gagal diupload, Lakukan :\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 echo\u00a0\u00a0 \"<script> alert('Maaf, Gambar gagal untuk diupload'); \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 location = 'index.php'; \n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 <\/script>\";\n\n\u00a0\u00a0\u00a0 }\n\n}else{ \/\/ Jika user tidak menceklis checkbox yang ada di form ubah, lakukan :\n\n\u00a0\u00a0\u00a0 \/\/ Proses ubah data ke Database\n\n\u00a0\u00a0\u00a0 $query = \"update user set username='$username' where id_user='$id_user' \";\n\n\u00a0\u00a0\u00a0 $sql = mysql_query($query); \/\/ Eksekusi\/ Jalankan query dari variabel $query\n\n\n\n\u00a0\u00a0\u00a0 if($sql){ \/\/ Cek jika proses simpan ke database sukses atau tidak\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/\/ Jika Sukses, Lakukan :\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 header(\"location: index.php\"); \/\/ Redirect ke halaman index.php\n\n\u00a0\u00a0\u00a0 }else{\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \/\/ Jika Gagal, Lakukan :\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 echo \"Maaf, Terjadi kesalahan saat mencoba untuk menyimpan data ke database.\";\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 echo \"<br><a href='index.php'>Kembali Ke Form<\/a>\";\n\n\u00a0\u00a0\u00a0 }\n\n}\n\n\n\n?>\n\n<\/pre>\n
11. Terakhir adalah proses Delete data tersebut. Buat file dengan nama deletedata.php dan masukkan script dibawah ini.<\/p>\n
<?php\n\ninclude \"koneksi.php\";\n\n\n\n$id_user=$_GET['id_user'];\n\n$query = \"Delete From user Where id_user='$id_user'\";\n\n\n\n$hasil = mysql_query($query);\n\n\u00a0\u00a0\u00a0 \n\n\u00a0\u00a0\u00a0 if($hasil){\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 header(\"location:index.php\");\n\n\u00a0\u00a0\u00a0 }\n\n\u00a0\u00a0\u00a0 else{\n\n\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 echo \"Hapus Data Gagal\";\n\n\u00a0\u00a0\u00a0 }\n\n\n\n?>\n\n<\/pre>\n
12. Silahkan buka program diatas dengan url http:\/\/localhost\/crud_image<\/p>\n
Oke sampai disini kamu sudah berhasil membuat Create, Read, Update dan Delete Image menggunakan PHP dan MYSQL. Cara di atas saya menggunakan Xampp versi 5, jadi fungsi crud image diatas hanya berjalan pada xampp versi 5, jangan coba-coba menjalankannya di xampp versi 7 yah. <\/p>\n
Buat kamu yang gak ingin ribet dapat mendownloadnya dibawah ini, lengkap dengan file SQLnya.<\/p>\n
\n
\n<\/i><\/span>
\nDownload<\/span>
\nClick here<\/span>
\n<\/a>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Kali ini saya akan membahas bagaimana cara create, read, update dan delete image dengan menggunakan bahasa pemrograman PHP dan MYSQL. Masih hampir sama dengan beberapa waktu lalu tentang postingan yang… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":2092,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71,63],"tags":[],"class_list":["post-111","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php-native","category-source-code"],"_links":{"self":[{"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=\/wp\/v2\/posts\/111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=111"}],"version-history":[{"count":1,"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=\/wp\/v2\/posts\/111\/revisions"}],"predecessor-version":[{"id":1351,"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=\/wp\/v2\/posts\/111\/revisions\/1351"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=\/wp\/v2\/media\/2092"}],"wp:attachment":[{"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/flycai.warunginter.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}