Membuat Aplikasi CRUD Sederhana dengan PHP dan MySQL

<p><strong>Membuat Aplikasi CRUD Sederhana dengan PHP dan MySQL &&num;8211&semi;&nbsp&semi;<&sol;strong>Pada tutorial kali ini saya akan membahas tentang ilmu programming PHP&period; Seperti pada judul artikel ini&comma; saya akan membuat tutorial tentang bagaimana membuat aplikasi CRUD &lpar;Create&comma; Read&comma; Update&comma; Delete&rpar; pada bahas pemrograman PHP&period; Dimana keempat komponen ini sangat penting dalam sebuah program&period; Pada artikel Sebelumnya&comma; saya juga sudah membuat tutorial tentang membuat aplikasi <a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;membuat-crud-dengan-java-web-persiapan-awal&sol;">crud dengan java servlets dan jsp<&sol;a>&period;&nbsp&semi;<&sol;p>&NewLine;<p>Nah&comma; pada tutorial kali ini saya akan membuat versi untuk<a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;4-situs-terbaik-untuk-belajar-bahasa-pemrograman-secara-otodidak&sol;"> bahasa pemrograman<&sol;a> PHP&period;<&sol;p>&NewLine;<div class&equals;"bacajuga">&NewLine;<div class&equals;"titlebaca"><strong>Baca Juga&colon;<&sol;strong><&sol;div>&NewLine;<div class&equals;"contentbaca">&NewLine;<ul>&NewLine;<li><a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;cara-membuat-blog-lewat-hp&sol;" target&equals;"&lowbar;blank" rel&equals;"noopener noreferrer">Cara Mudah membuat blog lewat HP<&sol;a><&sol;li>&NewLine;<li><a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;membuat-shopping-cart&sol;">Membuat Shopping Cart dengan Java Servlet dan JSP<&sol;a><&sol;li>&NewLine;<li><a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;membuat-blog-toko-online&sol;">Membuat Blog Toko Online Sederhana dengan Java Web<&sol;a><&sol;li>&NewLine;<&sol;ul>&NewLine;<&sol;div>&NewLine;<&sol;div>&NewLine;<div class&equals;"partner-banner-aftc-baca-juga" style&equals;"text-align&colon; center&semi; margin-top&colon; 30px&semi;">&nbsp&semi;<&sol;div>&NewLine;<p>Tutorial ini saya buat sangat mudah agar Anda yang pemula bisa mempelajarinya dengan mudah&period; Karena ini hanya basicnya saja&comma; jadi tidak ada yang namanya kemanan dalam query ke database&comma; saya bua sangat sederhana agar mudah dipelajari dengan mudah&period;<&sol;p>&NewLine;<p>Ada beberapa hal yang harus disiapkan sebelum memasuki tutorial ini yaitu&colon;<&sol;p>&NewLine;<ol>&NewLine;<li>PHP<&sol;li>&NewLine;<li>MySQL<&sol;li>&NewLine;<&sol;ol>&NewLine;<p>Mudahnya&comma; anda bisa menggunakan XAMPP ataupun AppServ&comma; karena pada aplikasi tersebut sudah terinclude PHP maupun MySQL&period;<&sol;p>&NewLine;<h3><strong>Membuat Aplikasi CRUD Sederhana dengan PHP dan MySQL<&sol;strong><&sol;h3>&NewLine;<ol>&NewLine;<li>Buat beberapa file php yang dibutuhkan seperti pada gambar berikut&period;<a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;wp-content&sol;uploads&sol;Screenshot&lowbar;237-1&period;png"><img class&equals;"aligncenter size-full wp-image-3591" src&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;wp-content&sol;uploads&sol;Screenshot&lowbar;237-1&period;png" alt&equals;"membuat aplikasi crud" width&equals;"629" height&equals;"198"><&sol;a><&sol;li>&NewLine;<li>Langkah berikutnya kita akan membuat databasenya terlebih dahulu di phpmyadmin dengan nama&nbsp&semi;misal&nbsp&semi;<strong>tutorialpedia&comma;&nbsp&semi;<&sol;strong>lalu dumping sql berikut ini&period;&NewLine;<pre class&equals;"lang&colon;php decode&colon;true" title&equals;"siswa&period;sql">CREATE TABLE &grave;siswa&grave; &lpar; &NewLine; &grave;siswa&lowbar;id&grave; int&lpar;11&rpar; NOT NULL auto&lowbar;increment&comma; &NewLine; &grave;siswa&lowbar;nis&grave; int&lpar;20&rpar; NOT NULL&comma; &NewLine; &grave;siswa&lowbar;nama&grave; varchar&lpar;50&rpar; NOT NULL&comma; &NewLine; &grave;siswa&lowbar;kelas&grave; varchar&lpar;10&rpar; NOT NULL&comma; &NewLine; &grave;siswa&lowbar;jurusan&grave; varchar&lpar;30&rpar; NOT NULL&comma; &NewLine; PRIMARY KEY &lpar;&grave;siswa&lowbar;id&grave;&rpar; &NewLine;&rpar; ENGINE&equals;MyISAM DEFAULT CHARSET&equals;utf8 AUTO&lowbar;INCREMENT&equals;7 &semi;<&sol;pre>&NewLine;<p>&nbsp&semi;<&sol;li>&NewLine;<li>Sekarang kita akan membuat koneksi phpnya terlebih dahulu&period; Buka file&nbsp&semi;<strong>koneksi&period;php&nbsp&semi;<&sol;strong>lalu isi dengan kode berikut ini&period;&NewLine;<pre class&equals;"lang&colon;default decode&colon;true " title&equals;"koneksi&period;php">&lt&semi;&quest;php &NewLine;&dollar;host &equals; "localhost"&semi; &NewLine;&dollar;user &equals; "root"&semi; &NewLine;&dollar;pass &equals; "root"&semi; &NewLine;&dollar;name &equals; "tutorialpedia"&semi; &NewLine; &NewLine;&dollar;koneksi &equals; mysql&lowbar;connect&lpar;&dollar;host&comma; &dollar;user&comma; &dollar;pass&rpar; or die&lpar;"Koneksi ke database gagal&excl;"&rpar;&semi; &NewLine;mysql&lowbar;select&lowbar;db&lpar;&dollar;name&comma; &dollar;koneksi&rpar; or die&lpar;"Tidak ada database yang dipilih&excl;"&rpar;&semi; &NewLine;&quest;&gt&semi;<&sol;pre>&NewLine;<p>note &colon; untuk bagian &dollar;pass biarkan kosong jika tidak ada password di mysql anda&period;<&sol;li>&NewLine;<li>Kita coba tampilkan data yang ada didatabase dengan syntaks berikut ini&period; Buka file<strong> index&period;php<&sol;strong> lalu masukkan kode berikut&colon;&NewLine;<pre class&equals;"lang&colon;php decode&colon;true" title&equals;"index&period;php">&lt&semi;&excl;DOCTYPE html&gt&semi; &NewLine;&lt&semi;html&gt&semi; &NewLine;&lt&semi;head&gt&semi; &NewLine;&Tab;&lt&semi;title&gt&semi;Simple CRUD by TUTORIALPEDIA&period;NET&lt&semi;&sol;title&gt&semi; &NewLine;&lt&semi;&sol;head&gt&semi; &NewLine;&lt&semi;body&gt&semi; &NewLine;&Tab;&lt&semi;h2&gt&semi;Simple CRUD&lt&semi;&sol;h2&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;p&gt&semi;&lt&semi;a href&equals;"index&period;php"&gt&semi;Beranda&lt&semi;&sol;a&gt&semi; &sol; &lt&semi;a href&equals;"tambah&period;php"&gt&semi;Tambah Data&lt&semi;&sol;a&gt&semi;&lt&semi;&sol;p&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;h3&gt&semi;Data Siswa&lt&semi;&sol;h3&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;table cellpadding&equals;"5" cellspacing&equals;"0" border&equals;"1"&gt&semi; &NewLine;&Tab;&Tab;&lt&semi;tr bgcolor&equals;"&num;CCCCCC"&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;th&gt&semi;No&period;&lt&semi;&sol;th&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;th&gt&semi;NIS&lt&semi;&sol;th&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;th&gt&semi;Nama Lengkap&lt&semi;&sol;th&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;th&gt&semi;Kelas&lt&semi;&sol;th&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;th&gt&semi;Jurusan&lt&semi;&sol;th&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;th&gt&semi;Opsi&lt&semi;&sol;th&gt&semi; &NewLine;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;&lt&semi;&quest;php &NewLine;&Tab;&Tab;&sol;&sol;iclude file koneksi ke database &NewLine;&Tab;&Tab;include&lpar;'koneksi&period;php'&rpar;&semi; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;&sol;&sol;query ke database dg SELECT table siswa diurutkan berdasarkan NIS paling besar &NewLine;&Tab;&Tab;&dollar;query &equals; mysql&lowbar;query&lpar;"SELECT &ast; FROM siswa ORDER BY siswa&lowbar;nis DESC"&rpar; or die&lpar;mysql&lowbar;error&lpar;&rpar;&rpar;&semi; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;&sol;&sol;cek&comma; apakakah hasil query di atas mendapatkan hasil atau tidak &lpar;data kosong atau tidak&rpar; &NewLine;&Tab;&Tab;if&lpar;mysql&lowbar;num&lowbar;rows&lpar;&dollar;query&rpar; &equals;&equals; 0&rpar;&lbrace;&Tab;&sol;&sol;ini artinya jika data hasil query di atas kosong &NewLine;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&Tab;&sol;&sol;jika data kosong&comma; maka akan menampilkan row kosong &NewLine;&Tab;&Tab;&Tab;echo '&lt&semi;tr&gt&semi;&lt&semi;td colspan&equals;"6"&gt&semi;Tidak ada data&excl;&lt&semi;&sol;td&gt&semi;&lt&semi;&sol;tr&gt&semi;'&semi; &NewLine;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&rcub;else&lbrace;&Tab;&sol;&sol;else ini artinya jika data hasil query ada &lpar;data diu database tidak kosong&rpar; &NewLine;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&Tab;&sol;&sol;jika data tidak kosong&comma; maka akan melakukan perulangan while &NewLine;&Tab;&Tab;&Tab;&dollar;no &equals; 1&semi;&Tab;&sol;&sol;membuat variabel &dollar;no untuk membuat nomor urut &NewLine;&Tab;&Tab;&Tab;while&lpar;&dollar;data &equals; mysql&lowbar;fetch&lowbar;assoc&lpar;&dollar;query&rpar;&rpar;&lbrace;&Tab;&sol;&sol;perulangan while dg membuat variabel &dollar;data yang akan mengambil data di database &NewLine;&Tab;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&Tab;&Tab;&sol;&sol;menampilkan row dengan data di database &NewLine;&Tab;&Tab;&Tab;&Tab;echo '&lt&semi;tr&gt&semi;'&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;echo '&lt&semi;td&gt&semi;'&period;&dollar;no&period;'&lt&semi;&sol;td&gt&semi;'&semi;&Tab;&sol;&sol;menampilkan nomor urut &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;echo '&lt&semi;td&gt&semi;'&period;&dollar;data&lbrack;'siswa&lowbar;nis'&rsqb;&period;'&lt&semi;&sol;td&gt&semi;'&semi;&Tab;&sol;&sol;menampilkan data nis dari database &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;echo '&lt&semi;td&gt&semi;'&period;&dollar;data&lbrack;'siswa&lowbar;nama'&rsqb;&period;'&lt&semi;&sol;td&gt&semi;'&semi;&Tab;&sol;&sol;menampilkan data nama lengkap dari database &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;echo '&lt&semi;td&gt&semi;'&period;&dollar;data&lbrack;'siswa&lowbar;kelas'&rsqb;&period;'&lt&semi;&sol;td&gt&semi;'&semi;&Tab;&sol;&sol;menampilkan data kelas dari database &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;echo '&lt&semi;td&gt&semi;'&period;&dollar;data&lbrack;'siswa&lowbar;jurusan'&rsqb;&period;'&lt&semi;&sol;td&gt&semi;'&semi;&Tab;&sol;&sol;menampilkan data jurusan dari database &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;echo '&lt&semi;td&gt&semi;&lt&semi;a href&equals;"edit&period;php&quest;id&equals;'&period;&dollar;data&lbrack;'siswa&lowbar;id'&rsqb;&period;'"&gt&semi;Edit&lt&semi;&sol;a&gt&semi; &sol; &lt&semi;a href&equals;"hapus&period;php&quest;id&equals;'&period;&dollar;data&lbrack;'siswa&lowbar;id'&rsqb;&period;'" onclick&equals;"return confirm&lpar;&bsol;'Yakin&quest;&bsol;'&rpar;"&gt&semi;Hapus&lt&semi;&sol;a&gt&semi;&lt&semi;&sol;td&gt&semi;'&semi;&Tab;&sol;&sol;menampilkan link edit dan hapus dimana tiap link terdapat GET id -&gt&semi; &quest;id&equals;siswa&lowbar;id &NewLine;&Tab;&Tab;&Tab;&Tab;echo '&lt&semi;&sol;tr&gt&semi;'&semi; &NewLine;&Tab;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&Tab;&Tab;&dollar;no&plus;&plus;&semi;&Tab;&sol;&sol;menambah jumlah nomor urut setiap row &NewLine;&Tab;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&Tab;&rcub; &NewLine;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&rcub; &NewLine;&Tab;&Tab;&quest;&gt&semi; &NewLine;&Tab;&lt&semi;&sol;table&gt&semi; &NewLine;&lt&semi;&sol;body&gt&semi; &NewLine;&lt&semi;&sol;html&gt&semi;<&sol;pre>&NewLine;<p>Karena data yang ada di tabel&nbsp&semi;<strong>siswa&nbsp&semi;<&sol;strong>masih kosong&comma; maka tidak ada isinya&period;<a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;wp-content&sol;uploads&sol;Screenshot&lowbar;238-1&period;png"><img class&equals;"aligncenter size-full wp-image-3592" src&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;wp-content&sol;uploads&sol;Screenshot&lowbar;238-1&period;png" alt&equals;"membuat aplikasi crud" width&equals;"488" height&equals;"205"><&sol;a><&sol;li>&NewLine;<li>Untuk kita perlu menambahkan data&comma; buka file&nbsp&semi;<strong>tambah&period;php&nbsp&semi;<&sol;strong>lalu masukkan kode berikut ini&period;&NewLine;<pre class&equals;"lang&colon;php decode&colon;true " title&equals;"tambah&period;php">&lt&semi;&excl;DOCTYPE html&gt&semi; &NewLine;&lt&semi;html&gt&semi; &NewLine;&lt&semi;head&gt&semi; &NewLine;&Tab;&lt&semi;title&gt&semi;Simple CRUD by TUTORIALPEDIA&gt&semi;NET&lt&semi;&sol;title&gt&semi; &NewLine;&lt&semi;&sol;head&gt&semi; &NewLine;&lt&semi;body&gt&semi; &NewLine;&Tab;&lt&semi;h2&gt&semi;Simple CRUD&lt&semi;&sol;h2&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;p&gt&semi;&lt&semi;a href&equals;"index&period;php"&gt&semi;Beranda&lt&semi;&sol;a&gt&semi; &sol; &lt&semi;a href&equals;"tambah&period;php"&gt&semi;Tambah Data&lt&semi;&sol;a&gt&semi;&lt&semi;&sol;p&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;h3&gt&semi;Tambah Data Siswa&lt&semi;&sol;h3&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;form action&equals;"tambah-proses&period;php" method&equals;"post"&gt&semi; &NewLine;&Tab;&Tab;&lt&semi;table cellpadding&equals;"3" cellspacing&equals;"0"&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;NIS&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&colon;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&lt&semi;input type&equals;"text" name&equals;"nis" required&gt&semi;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;Nama Lengkap&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&colon;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&lt&semi;input type&equals;"text" name&equals;"nama" size&equals;"30" required&gt&semi;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;Kelas&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&colon;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;select name&equals;"kelas" required&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;""&gt&semi;Pilih Kelas&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"X"&gt&semi;X&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"XI"&gt&semi;XI&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"XII"&gt&semi;XII&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;&sol;select&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;Jurusan&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&colon;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;select name&equals;"jurusan" required&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;""&gt&semi;Pilih Jurusan&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Teknik Komputer dan Jaringan"&gt&semi;Teknik Komputer dan Jaringan&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Multimedia"&gt&semi;Multimedia&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Akuntansi"&gt&semi;Akuntansi&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Perbankan"&gt&semi;Perbankan&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Pemasaran"&gt&semi;Pemasaran&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;&sol;select&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&amp&semi;nbsp&semi;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&lt&semi;input type&equals;"submit" name&equals;"tambah" value&equals;"Tambah"&gt&semi;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&lt&semi;&sol;table&gt&semi; &NewLine;&Tab;&lt&semi;&sol;form&gt&semi; &NewLine;&lt&semi;&sol;body&gt&semi; &NewLine;&lt&semi;&sol;html&gt&semi;<&sol;pre>&NewLine;<p>Dari Form tidak ada yang spesial&comma; hanya form tersebut action nya&nbsp&semi;<strong>tambah-proses&period;php&period;&nbsp&semi;<&sol;strong>Tampilannya seperti gambar di bawah ini&colon;<a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;wp-content&sol;uploads&sol;Screenshot&lowbar;239-1&period;png"><img class&equals;"aligncenter size-full wp-image-3593" src&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;wp-content&sol;uploads&sol;Screenshot&lowbar;239-1&period;png" alt&equals;"membuat aplikasi crud" width&equals;"574" height&equals;"347"><&sol;a><&sol;li>&NewLine;<li>Nah ketika form tersebut di isi&comma; dan tombol Tambah di klik&comma; maka akan menjalankan file&nbsp&semi;<strong>tambah-proses&period;php&period;<&sol;strong>Jadi selanjutnya buat file baru dengan nama&nbsp&semi;<strong>tambah-proses&period;php<&sol;strong>&nbsp&semi;dan isinya adalah script di bawah ini&colon;&NewLine;<pre class&equals;"lang&colon;php decode&colon;true " title&equals;"tambah-proses&period;php">&lt&semi;&quest;php &NewLine;&sol;&sol;mulai proses tambah data &NewLine; &NewLine;&sol;&sol;cek dahulu&comma; jika tombol tambah di klik &NewLine;if&lpar;isset&lpar;&dollar;&lowbar;POST&lbrack;'tambah'&rsqb;&rpar;&rpar;&lbrace; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;inlcude atau memasukkan file koneksi ke database &NewLine;&Tab;include&lpar;'koneksi&period;php'&rpar;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;jika tombol tambah benar di klik maka lanjut prosesnya &NewLine;&Tab;&dollar;nis&Tab;&Tab;&equals; &dollar;&lowbar;POST&lbrack;'nis'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;nis dan datanya dari inputan NIS &NewLine;&Tab;&dollar;nama&Tab;&Tab;&equals; &dollar;&lowbar;POST&lbrack;'nama'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;nama dan datanya dari inputan Nama Lengkap &NewLine;&Tab;&dollar;kelas&Tab;&Tab;&equals; &dollar;&lowbar;POST&lbrack;'kelas'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;kelas dan datanya dari inputan dropdown Kelas &NewLine;&Tab;&dollar;jurusan&Tab;&equals; &dollar;&lowbar;POST&lbrack;'jurusan'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;jurusan dan datanya dari inputan dropdown Jurusan &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;melakukan query dengan perintah INSERT INTO untuk memasukkan data ke database &NewLine;&Tab;&dollar;input &equals; mysql&lowbar;query&lpar;"INSERT INTO siswa VALUES&lpar;NULL&comma; '&dollar;nis'&comma; '&dollar;nama'&comma; '&dollar;kelas'&comma; '&dollar;jurusan'&rpar;"&rpar; or die&lpar;mysql&lowbar;error&lpar;&rpar;&rpar;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;jika query input sukses &NewLine;&Tab;if&lpar;&dollar;input&rpar;&lbrace; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;echo 'Data berhasil di tambahkan&excl; '&semi;&Tab;&Tab;&sol;&sol;Pesan jika proses tambah sukses &NewLine;&Tab;&Tab;echo '&lt&semi;a href&equals;"tambah&period;php"&gt&semi;Kembali&lt&semi;&sol;a&gt&semi;'&semi;&Tab;&sol;&sol;membuat Link untuk kembali ke halaman tambah &NewLine;&Tab;&Tab; &NewLine;&Tab;&rcub;else&lbrace; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;echo 'Gagal menambahkan data&excl; '&semi;&Tab;&Tab;&sol;&sol;Pesan jika proses tambah gagal &NewLine;&Tab;&Tab;echo '&lt&semi;a href&equals;"tambah&period;php"&gt&semi;Kembali&lt&semi;&sol;a&gt&semi;'&semi;&Tab;&sol;&sol;membuat Link untuk kembali ke halaman tambah &NewLine;&Tab;&Tab; &NewLine;&Tab;&rcub; &NewLine; &NewLine;&rcub;else&lbrace;&Tab;&sol;&sol;jika tidak terdeteksi tombol tambah di klik &NewLine; &NewLine;&Tab;&sol;&sol;redirect atau dikembalikan ke halaman tambah &NewLine;&Tab;echo '&lt&semi;script&gt&semi;window&period;history&period;back&lpar;&rpar;&lt&semi;&sol;script&gt&semi;'&semi; &NewLine; &NewLine;&rcub; &NewLine;&quest;&gt&semi;<&sol;pre>&NewLine;<p>Untuk penjelasan setiap baris kode&comma;&nbsp&semi;Psudah saya masukkan pada file tersebut&comma; silahkan baca sendiri&period;<&sol;li>&NewLine;<li>Tahap ini adalah untuk melakukan edit data pada database&period; File yang akan kita buat adalah file&nbsp&semi;<strong>edit&period;php<&sol;strong>&period;Link untuk menuju halaman edit adalah pada file&nbsp&semi;<strong>index&period;php<&sol;strong>&nbsp&semi;dimana disana pada tabel kolom Opsi ada Link&nbsp&semi;<strong>edit<&sol;strong>&nbsp&semi;dan&nbsp&semi;<strong>hapus&period;<&sol;strong>&nbsp&semi;Dimana untuk Link&nbsp&semi;<strong>edit<&sol;strong>&nbsp&semi;yang di klik Anda akan mendapatkan Link seperti&nbsp&semi;<span class&equals;"lang&colon;default decode&colon;true crayon-inline">&lt&semi;a href&equals;”edit&period;php&quest;id&equals;12&quest;&gt&semi;Edit&lt&semi;&sol;a&gt&semi;<&sol;span>&nbsp&semi;dimana&nbsp&semi;<strong>id<&sol;strong>&nbsp&semi;ini adalah nilai dari&nbsp&semi;<strong>siswa&lowbar;id<&sol;strong>&period; Jika id tersebut adalah 12&comma; maka akan menampilkan data siswa dimana siswa&lowbar;id&equals;12&period;Oke&comma; silahkan buat file&nbsp&semi;<strong>edit&period;php<&sol;strong>&nbsp&semi;dan paste script di bawah ini&colon;&NewLine;<pre class&equals;"lang&colon;php decode&colon;true" title&equals;"edit&period;php">&lt&semi;&excl;DOCTYPE html&gt&semi; &NewLine;&lt&semi;html&gt&semi; &NewLine;&lt&semi;head&gt&semi; &NewLine;&Tab;&lt&semi;title&gt&semi;Simple CRUD by TUTORIALPEDIA&period;NET&lt&semi;&sol;title&gt&semi; &NewLine;&lt&semi;&sol;head&gt&semi; &NewLine;&lt&semi;body&gt&semi; &NewLine;&Tab;&lt&semi;h2&gt&semi;Simple CRUD&lt&semi;&sol;h2&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;p&gt&semi;&lt&semi;a href&equals;"index&period;php"&gt&semi;Beranda&lt&semi;&sol;a&gt&semi; &sol; &lt&semi;a href&equals;"tambah&period;php"&gt&semi;Tambah Data&lt&semi;&sol;a&gt&semi;&lt&semi;&sol;p&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;h3&gt&semi;Edit Data Siswa&lt&semi;&sol;h3&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;&quest;php &NewLine;&Tab;&sol;&sol;proses mengambil data ke database untuk ditampilkan di form edit berdasarkan siswa&lowbar;id yg didapatkan dari GET id -&gt&semi; edit&period;php&quest;id&equals;siswa&lowbar;id &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;include atau memasukkan file koneksi ke database &NewLine;&Tab;include&lpar;'koneksi&period;php'&rpar;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;membuat variabel &dollar;id yg nilainya adalah dari URL GET id -&gt&semi; edit&period;php&quest;id&equals;siswa&lowbar;id &NewLine;&Tab;&dollar;id &equals; &dollar;&lowbar;GET&lbrack;'id'&rsqb;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;melakukan query ke database dg SELECT table siswa dengan kondisi WHERE siswa&lowbar;id &equals; '&dollar;id' &NewLine;&Tab;&dollar;show &equals; mysql&lowbar;query&lpar;"SELECT &ast; FROM siswa WHERE siswa&lowbar;id&equals;'&dollar;id'"&rpar;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;cek apakah data dari hasil query ada atau tidak &NewLine;&Tab;if&lpar;mysql&lowbar;num&lowbar;rows&lpar;&dollar;show&rpar; &equals;&equals; 0&rpar;&lbrace; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;&sol;&sol;jika tidak ada data yg sesuai maka akan langsung di arahkan ke halaman depan atau beranda -&gt&semi; index&period;php &NewLine;&Tab;&Tab;echo '&lt&semi;script&gt&semi;window&period;history&period;back&lpar;&rpar;&lt&semi;&sol;script&gt&semi;'&semi; &NewLine;&Tab;&Tab; &NewLine;&Tab;&rcub;else&lbrace; &NewLine;&Tab; &NewLine;&Tab;&Tab;&sol;&sol;jika data ditemukan&comma; maka membuat variabel &dollar;data &NewLine;&Tab;&Tab;&dollar;data &equals; mysql&lowbar;fetch&lowbar;assoc&lpar;&dollar;show&rpar;&semi;&Tab;&sol;&sol;mengambil data ke database yang nantinya akan ditampilkan di form edit di bawah &NewLine;&Tab; &NewLine;&Tab;&rcub; &NewLine;&Tab;&quest;&gt&semi; &NewLine;&Tab; &NewLine;&Tab;&lt&semi;form action&equals;"edit-proses&period;php" method&equals;"post"&gt&semi; &NewLine;&Tab;&Tab;&lt&semi;input type&equals;"hidden" name&equals;"id" value&equals;"&lt&semi;&quest;php echo &dollar;id&semi; &quest;&gt&semi;"&gt&semi;&Tab;&lt&semi;&excl;-- membuat inputan hidden dan nilainya adalah siswa&lowbar;id --&gt&semi; &NewLine;&Tab;&Tab;&lt&semi;table cellpadding&equals;"3" cellspacing&equals;"0"&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;NIS&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&colon;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&lt&semi;input type&equals;"text" name&equals;"nis" value&equals;"&lt&semi;&quest;php echo &dollar;data&lbrack;'siswa&lowbar;nis'&rsqb;&semi; &quest;&gt&semi;" required&gt&semi;&lt&semi;&sol;td&gt&semi;&Tab;&lt&semi;&excl;-- value diambil dari hasil query --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;Nama Lengkap&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&colon;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&lt&semi;input type&equals;"text" name&equals;"nama" size&equals;"30" value&equals;"&lt&semi;&quest;php echo &dollar;data&lbrack;'siswa&lowbar;nama'&rsqb;&semi; &quest;&gt&semi;" required&gt&semi;&lt&semi;&sol;td&gt&semi; &lt&semi;&excl;-- value diambil dari hasil query --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;Kelas&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&colon;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;select name&equals;"kelas" required&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;""&gt&semi;Pilih Kelas&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"X" &lt&semi;&quest;php if&lpar;&dollar;data&lbrack;'siswa&lowbar;kelas'&rsqb; &equals;&equals; 'X'&rpar;&lbrace; echo 'selected'&semi; &rcub; &quest;&gt&semi;&gt&semi;X&lt&semi;&sol;option&gt&semi;&Tab;&lt&semi;&excl;-- jika data di database sama dengan value maka akan terselect&sol;terpilih --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"XI" &lt&semi;&quest;php if&lpar;&dollar;data&lbrack;'siswa&lowbar;kelas'&rsqb; &equals;&equals; 'XI'&rpar;&lbrace; echo 'selected'&semi; &rcub; &quest;&gt&semi;&gt&semi;XI&lt&semi;&sol;option&gt&semi;&Tab;&lt&semi;&excl;-- jika data di database sama dengan value maka akan terselect&sol;terpilih --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"XII" &lt&semi;&quest;php if&lpar;&dollar;data&lbrack;'siswa&lowbar;kelas'&rsqb; &equals;&equals; 'XII'&rpar;&lbrace; echo 'selected'&semi; &rcub; &quest;&gt&semi;&gt&semi;XII&lt&semi;&sol;option&gt&semi;&Tab;&lt&semi;&excl;-- jika data di database sama dengan value maka akan terselect&sol;terpilih --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;&sol;select&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;Jurusan&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&colon;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;select name&equals;"jurusan" required&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;""&gt&semi;Pilih Jurusan&lt&semi;&sol;option&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Teknik Komputer dan Jaringan" &lt&semi;&quest;php if&lpar;&dollar;data&lbrack;'siswa&lowbar;jurusan'&rsqb; &equals;&equals; 'Teknik Komputer dan Jaringan'&rpar;&lbrace; echo 'selected'&semi; &rcub; &quest;&gt&semi;&gt&semi;Teknik Komputer dan Jaringan&lt&semi;&sol;option&gt&semi;&Tab;&lt&semi;&excl;-- jika data di database sama dengan value maka akan terselect&sol;terpilih --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Multimedia" &lt&semi;&quest;php if&lpar;&dollar;data&lbrack;'siswa&lowbar;jurusan'&rsqb; &equals;&equals; 'Multimedia'&rpar;&lbrace; echo 'selected'&semi; &rcub; &quest;&gt&semi;&gt&semi;Multimedia&lt&semi;&sol;option&gt&semi;&Tab;&lt&semi;&excl;-- jika data di database sama dengan value maka akan terselect&sol;terpilih --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Akuntansi" &lt&semi;&quest;php if&lpar;&dollar;data&lbrack;'siswa&lowbar;jurusan'&rsqb; &equals;&equals; 'Akuntansi'&rpar;&lbrace; echo 'selected'&semi; &rcub; &quest;&gt&semi;&gt&semi;Akuntansi&lt&semi;&sol;option&gt&semi;&Tab;&lt&semi;&excl;-- jika data di database sama dengan value maka akan terselect&sol;terpilih --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Perbankan" &lt&semi;&quest;php if&lpar;&dollar;data&lbrack;'siswa&lowbar;jurusan'&rsqb; &equals;&equals; 'Perbankan'&rpar;&lbrace; echo 'selected'&semi; &rcub; &quest;&gt&semi;&gt&semi;Perbankan&lt&semi;&sol;option&gt&semi;&Tab;&lt&semi;&excl;-- jika data di database sama dengan value maka akan terselect&sol;terpilih --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;option value&equals;"Pemasaran" &lt&semi;&quest;php if&lpar;&dollar;data&lbrack;'siswa&lowbar;jurusan'&rsqb; &equals;&equals; 'Pemasaran'&rpar;&lbrace; echo 'selected'&semi; &rcub; &quest;&gt&semi;&gt&semi;Pemasaran&lt&semi;&sol;option&gt&semi;&Tab;&lt&semi;&excl;-- jika data di database sama dengan value maka akan terselect&sol;terpilih --&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&Tab;&lt&semi;&sol;select&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;tr&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&amp&semi;nbsp&semi;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&Tab;&lt&semi;td&gt&semi;&lt&semi;input type&equals;"submit" name&equals;"simpan" value&equals;"Simpan"&gt&semi;&lt&semi;&sol;td&gt&semi; &NewLine;&Tab;&Tab;&Tab;&lt&semi;&sol;tr&gt&semi; &NewLine;&Tab;&Tab;&lt&semi;&sol;table&gt&semi; &NewLine;&Tab;&lt&semi;&sol;form&gt&semi; &NewLine;&lt&semi;&sol;body&gt&semi; &NewLine;&lt&semi;&sol;html&gt&semi;<&sol;pre>&NewLine;<p>Jika sudah silahkan simpan&comma; dan hasil tampilan dari script di atas seperti gambar di bawah ini&colon;<a href&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;wp-content&sol;uploads&sol;Screenshot&lowbar;240-1&period;png"><img class&equals;"aligncenter size-full wp-image-3594" src&equals;"https&colon;&sol;&sol;www&period;tutorialpedia&period;net&sol;wp-content&sol;uploads&sol;Screenshot&lowbar;240-1&period;png" alt&equals;"membuat aplikasi crud" width&equals;"514" height&equals;"287"><&sol;a><&sol;li>&NewLine;<li>&nbsp&semi;form edit diatas jika di klik tombol Simpan&comma; maka akan menjalankan file&nbsp&semi;<strong>edit-proses&period;php<&sol;strong>&comma; dimana file ini adalah proses untuk melakukan update data ke database&period;Buat file&nbsp&semi;<strong>edit-proses&period;php<&sol;strong>&nbsp&semi;dan paste script di bawah ini&colon;&NewLine;<pre class&equals;"lang&colon;php decode&colon;true " title&equals;"edit-proses&period;php">&lt&semi;&quest;php &NewLine;&sol;&sol;mulai proses edit data &NewLine; &NewLine;&sol;&sol;cek dahulu&comma; jika tombol simpan di klik &NewLine;if&lpar;isset&lpar;&dollar;&lowbar;POST&lbrack;'simpan'&rsqb;&rpar;&rpar;&lbrace; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;inlcude atau memasukkan file koneksi ke database &NewLine;&Tab;include&lpar;'koneksi&period;php'&rpar;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;jika tombol tambah benar di klik maka lanjut prosesnya &NewLine;&Tab;&dollar;id&Tab;&Tab;&Tab;&equals; &dollar;&lowbar;POST&lbrack;'id'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;id dan datanya dari inputan hidden id &NewLine;&Tab;&dollar;nis&Tab;&Tab;&equals; &dollar;&lowbar;POST&lbrack;'nis'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;nis dan datanya dari inputan NIS &NewLine;&Tab;&dollar;nama&Tab;&Tab;&equals; &dollar;&lowbar;POST&lbrack;'nama'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;nama dan datanya dari inputan Nama Lengkap &NewLine;&Tab;&dollar;kelas&Tab;&Tab;&equals; &dollar;&lowbar;POST&lbrack;'kelas'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;kelas dan datanya dari inputan dropdown Kelas &NewLine;&Tab;&dollar;jurusan&Tab;&equals; &dollar;&lowbar;POST&lbrack;'jurusan'&rsqb;&semi;&Tab;&sol;&sol;membuat variabel &dollar;jurusan dan datanya dari inputan dropdown Jurusan &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;melakukan query dengan perintah UPDATE untuk update data ke database dengan kondisi WHERE siswa&lowbar;id&equals;'&dollar;id' &lt&semi;- diambil dari inputan hidden id &NewLine;&Tab;&dollar;update &equals; mysql&lowbar;query&lpar;"UPDATE siswa SET siswa&lowbar;nis&equals;'&dollar;nis'&comma; siswa&lowbar;nama&equals;'&dollar;nama'&comma; siswa&lowbar;kelas&equals;'&dollar;kelas'&comma; siswa&lowbar;jurusan&equals;'&dollar;jurusan' WHERE siswa&lowbar;id&equals;'&dollar;id'"&rpar; or die&lpar;mysql&lowbar;error&lpar;&rpar;&rpar;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;jika query update sukses &NewLine;&Tab;if&lpar;&dollar;update&rpar;&lbrace; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;echo 'Data berhasil di simpan&excl; '&semi;&Tab;&Tab;&sol;&sol;Pesan jika proses simpan sukses &NewLine;&Tab;&Tab;echo '&lt&semi;a href&equals;"edit&period;php&quest;id&equals;'&period;&dollar;id&period;'"&gt&semi;Kembali&lt&semi;&sol;a&gt&semi;'&semi;&Tab;&sol;&sol;membuat Link untuk kembali ke halaman edit &NewLine;&Tab;&Tab; &NewLine;&Tab;&rcub;else&lbrace; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;echo 'Gagal menyimpan data&excl; '&semi;&Tab;&Tab;&sol;&sol;Pesan jika proses simpan gagal &NewLine;&Tab;&Tab;echo '&lt&semi;a href&equals;"edit&period;php&quest;id&equals;'&period;&dollar;id&period;'"&gt&semi;Kembali&lt&semi;&sol;a&gt&semi;'&semi;&Tab;&sol;&sol;membuat Link untuk kembali ke halaman edit &NewLine;&Tab;&Tab; &NewLine;&Tab;&rcub; &NewLine; &NewLine;&rcub;else&lbrace;&Tab;&sol;&sol;jika tidak terdeteksi tombol simpan di klik &NewLine; &NewLine;&Tab;&sol;&sol;redirect atau dikembalikan ke halaman edit &NewLine;&Tab;echo '&lt&semi;script&gt&semi;window&period;history&period;back&lpar;&rpar;&lt&semi;&sol;script&gt&semi;'&semi; &NewLine; &NewLine;&rcub; &NewLine;&quest;&gt&semi;<&sol;pre>&NewLine;<p>Silahkan simpan&period; lalu jalankan&period; Untuk setiap penjelasan sudah saya sertakan di tiap baris kode&period;<&sol;li>&NewLine;<li>Terakhir&comma; sekarang kita akan mencoba menghapus data tersebut dari database&period;&nbsp&semi;file yang akan kita buat adalah&nbsp&semi;<strong>hapus&period;php<&sol;strong>&comma; dan isi scriptnya seperti di bawah ini&colon;&nbsp&semi;&NewLine;<pre class&equals;"lang&colon;php decode&colon;true" title&equals;"hapus&period;php">&lt&semi;&quest;php &NewLine;&sol;&sol;memulai proses hapus data &NewLine; &NewLine;&sol;&sol;cek dahulu&comma; apakah benar URL sudah ada GET id -&gt&semi; hapus&period;php&quest;id&equals;siswa&lowbar;id &NewLine;if&lpar;isset&lpar;&dollar;&lowbar;GET&lbrack;'id'&rsqb;&rpar;&rpar;&lbrace; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;inlcude atau memasukkan file koneksi ke database &NewLine;&Tab;include&lpar;'koneksi&period;php'&rpar;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;membuat variabel &dollar;id yg bernilai dari URL GET id -&gt&semi; hapus&period;php&quest;id&equals;siswa&lowbar;id &NewLine;&Tab;&dollar;id &equals; &dollar;&lowbar;GET&lbrack;'id'&rsqb;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;cek ke database apakah ada data siswa dengan siswa&lowbar;id&equals;'&dollar;id' &NewLine;&Tab;&dollar;cek &equals; mysql&lowbar;query&lpar;"SELECT siswa&lowbar;id FROM siswa WHERE siswa&lowbar;id&equals;'&dollar;id'"&rpar; or die&lpar;mysql&lowbar;error&lpar;&rpar;&rpar;&semi; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;jika data siswa tidak ada &NewLine;&Tab;if&lpar;mysql&lowbar;num&lowbar;rows&lpar;&dollar;cek&rpar; &equals;&equals; 0&rpar;&lbrace; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;&sol;&sol;jika data tidak ada&comma; maka redirect atau dikembalikan ke halaman beranda &NewLine;&Tab;&Tab;echo '&lt&semi;script&gt&semi;window&period;history&period;back&lpar;&rpar;&lt&semi;&sol;script&gt&semi;'&semi; &NewLine;&Tab; &NewLine;&Tab;&rcub;else&lbrace; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;&sol;&sol;jika data ada di database&comma; maka melakukan query DELETE table siswa dengan kondisi WHERE siswa&lowbar;id&equals;'&dollar;id' &NewLine;&Tab;&Tab;&dollar;del &equals; mysql&lowbar;query&lpar;"DELETE FROM siswa WHERE siswa&lowbar;id&equals;'&dollar;id'"&rpar;&semi; &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;&sol;&sol;jika query DELETE berhasil &NewLine;&Tab;&Tab;if&lpar;&dollar;del&rpar;&lbrace; &NewLine;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&Tab;echo 'Data siswa berhasil di hapus&excl; '&semi;&Tab;&Tab;&sol;&sol;Pesan jika proses hapus berhasil &NewLine;&Tab;&Tab;&Tab;echo '&lt&semi;a href&equals;"index&period;php"&gt&semi;Kembali&lt&semi;&sol;a&gt&semi;'&semi;&Tab;&sol;&sol;membuat Link untuk kembali ke halaman beranda &NewLine;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&rcub;else&lbrace; &NewLine;&Tab;&Tab;&Tab; &NewLine;&Tab;&Tab;&Tab;echo 'Gagal menghapus data&excl; '&semi;&Tab;&Tab;&sol;&sol;Pesan jika proses hapus gagal &NewLine;&Tab;&Tab;&Tab;echo '&lt&semi;a href&equals;"index&period;php"&gt&semi;Kembali&lt&semi;&sol;a&gt&semi;'&semi;&Tab;&sol;&sol;membuat Link untuk kembali ke halaman beranda &NewLine;&Tab;&Tab; &NewLine;&Tab;&Tab;&rcub; &NewLine;&Tab;&Tab; &NewLine;&Tab;&rcub; &NewLine;&Tab; &NewLine;&rcub;else&lbrace; &NewLine;&Tab; &NewLine;&Tab;&sol;&sol;redirect atau dikembalikan ke halaman beranda &NewLine;&Tab;echo '&lt&semi;script&gt&semi;window&period;history&period;back&lpar;&rpar;&lt&semi;&sol;script&gt&semi;'&semi; &NewLine;&Tab; &NewLine;&rcub; &NewLine;&quest;&gt&semi;<&sol;pre>&NewLine;<p>Jangan lupa disimpan&period;<&sol;p>&NewLine;<p>Sedikit penjelasan untuk script hapus di atas&period; Jika Anda mengklik tombol&sol;link hapus pada file index&period;php&comma; Anda akan mendapatkan Link seperti ini&nbsp&semi;<strong>www&period;hostingAnda&period;com&sol;hapus&period;php&quest;id&equals;12<&sol;strong>&comma; ini artinya Script akan mendeteksi dari URL tersebut berapa id nya&comma; misalkan disana id&equals;12&comma; maka script akan menghapus data siswa dimana siswa&lowbar;id&equals;12&period;<&sol;li>&NewLine;<&sol;ol>&NewLine;<p>Itulah tutorial sederhana tentang&nbsp&semi;<strong>cara membuat aplikas crud dengan php dan mysql&period;&nbsp&semi;<&sol;strong><&sol;p>&NewLine;<p>Untuk mendownload projek&nbsp&semi;<strong>Membuat CRUD dengan PHP dan MySQL&nbsp&semi;<&sol;strong>anda bisa klik link berikut ini&period;<&sol;p>&NewLine;<p><a class&equals;"fasc-button fasc-size-medium fasc-type-flat ico-fa fasc-ico-before fa-download" style&equals;"background-color&colon; &num;109d58&semi; color&colon; &num;ffffff&semi;" target&equals;"&lowbar;blank" rel&equals;"noopener" href&equals;"http&colon;&sol;&sol;adfoc&period;us&sol;18713565414454">Download<&sol;a><&sol;p>&NewLine;<p><strong>Demo<&sol;strong><&sol;p>&NewLine;<p><iframe width&equals;"560" height&equals;"314" src&equals;"&sol;&sol;www&period;youtube&period;com&sol;embed&sol;lF7qAKKD5zE" allowfullscreen&equals;"allowfullscreen"><&sol;iframe><&sol;p>&NewLine;<p>Demikian tutorial membuat crud dengan php dan mysql&period;<&sol;p>&NewLine;<p>Semoga bermanfaat&period;<&sol;p>&NewLine;

Recent Articles

Kumpulan DNS Gratis Tercepat!

0
DNS merupakan sebuah sistem yang bertugas menyimpan semua informasi data domain dalam jaringan. Dengan adanya DNS, domain atau hostname yang ada akan ditranslate dan...

Apa itu DNS ? Dan Fungsinya

0
Apa itu DNS? - DNS (Domain Name System) adalah sebuah sistem yang bertugas menyimpan semua informasi data domain dalam jaringan. Dengan adanya DNS, domain...

Apa itu OLT ? Serta Fungsinya Dalam Jaringan

0
Apa itu olt ? OLT (Optical Line Termination) adalah perangkat keras yang berfungsi sebagai titik akhir (end-point) dari layanan jaringan optik pasif (Passive Optical...

Template Voucher Untuk Mixradius

2
Template Voucher Untuk Mixradius - Pasti kalian bosen kan dengan template voucher default mixradius? tenang. kali ini saya akan memberikan template untuk voucher mixradius kamu agar...

Daftar Port Game Online Mikrotik Terbaru

2
Daftar port game online dibawah ini bisa digunakan untuk membuat rule agar koneksi ke game online tersebut bisa lancar, bisa juga untuk memisahkan antara...

Related Articles

2 Comments

Leave A Reply

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Dapatkan konten terbaik dari kami!