<?php
// definisikan koneksi ke database
$server = "localhost";
$username = "root";
$password = "";
$database = "Ganti Dengan Nama Database Anda";
// Koneksi dan memilih database di server
mysql_connect($server,$username,$password) or die("Koneksi gagal");
mysql_select_db($database) or die("Database tidak bisa dibuka");
?>
<?php
include "koneksi.php";
?>
<html>
<head><title>Delete</title>
<script>
var jumlahnya;
function ceksemua(){
jumlahnya = document.getElementById("jumlahcek").value;
if(document.getElementById("cekbox").checked==true){
for(i=0;i<jumlahnya;i++){
idcek = "bukuid"+i;
idtr = "tr"+i;
document.getElementById(idtr).style.backgroundColor = "#efefef";
document.getElementById(idcek).checked = true;
}
}else{
for(i=0;i<jumlahnya;i++){
idcek = "bukuid"+i;
idtr = "tr"+i;
document.getElementById(idtr).style.backgroundColor = "#00CC00";
document.getElementById(idcek).checked = false;
}
}
}
function konfirmasicek(indeks){
idcek = "bukuid"+indeks;
bukuidnya = document.getElementById(idcek).value;
tanya = confirm("Delete Buku dengan ID "+bukuidnya+"?");
if(tanya == 1){
window.location.href="delete.php?op=delsatu&id="+bukuidnya;
}
}
function konfirmasicek2(){
ada = 0; //untuk mengecek apakah ada checkbox yang dicek
semuanyakah = 1; //untuk mengecek apakah semua checkbox tercek
//untuk mengambil jumlah total checkbox yang ada
jumlahnya = document.getElementById("jumlahcek").value;
jumlahx = 0 //untuk mengetahui jumlah yang dicek
for(i=0;i<jumlahnya;i++){
idcek = "bukuid"+i;
if(document.getElementById(idcek).checked == true){
jumlahx++;
ada = 1;
}else{
semuanyakah = 0;
}
}
if(ada==1){
if(semuanyakah == 1){
tanya = confirm("Mau delete semuanyakah?");
if(tanya == 1){
document.getElementById("formulirku").submit();
}
}else{
tanya = confirm("Mau delete data "+jumlahx+" item ?");
if(tanya == 1){
document.getElementById("formulirku").submit();
}
}
}
}
function setwarna(indeks){
idcek = "bukuid"+indeks;
idtr = "tr"+indeks;
if(document.getElementById(idcek).checked == true){
document.getElementById(idtr).style.backgroundColor = "#efefef";
}else{
document.getElementById(idtr).style.backgroundColor = "#00CC00";
}
}
</script>
</head>
<body bgcolor="#009900">
<center><h2>MULTIPLE DELETE DATA DENGA CHECKBOX</h2></center><hr/>
<br>
<?php
if($_GET['op']=="berhasildelete"){
echo "<center><b><font color=red>Data berhasil didelete</font></b></center><br>";
}
?>
<form action=delete.php method=post id=formulirku>
<table align="center" border="1" cellpadding="3" cellspacing="0" bgcolor="#00CC00"
style="border-collapse: collapse" bordercolor="#000000">
<tr>
<td bgcolor="#006600"><input type="checkbox" onclick="ceksemua()" id="cekbox"></td>
<td bgcolor="#006600"><b>ID Buku</b></td>
<td bgcolor="#006600"><b>Judul Buku</b></td>
</tr>
<?php
$databuku = mysql_query("SELECT * FROM buku");
$indexcek = 0;
while($d = mysql_fetch_array($databuku)){
echo "<tr id='tr$indexcek'><td><input type='checkbox' name='bukuid[]'
value='".$d['id']."' id='bukuid$indexcek' onclick='setwarna($indexcek)'>
<img src='delete.gif' onclick=\"konfirmasicek('$indexcek')\"
style='cursor:pointer'>\n";
echo "<td>".$d['id']."</td><td>".$d['judul']."</td></tr>\n";
$indexcek++;
}
echo "<input type=hidden id='jumlahcek' value='$indexcek' name='jumlahcek'>";
?>
</table>
<center><input type="button" value="delete" onclick="konfirmasicek2()"></center>
</form>
</body>
</html>
<?php
include "koneksi.php";
$op = $_GET['op'];
if($op){
$id = $_GET['id'];
$del = mysql_query("DELETE FROM buku WHERE id='$id'");
}else{
foreach($_POST['bukuid'] as $value){
$del = mysql_query("DELETE FROM buku WHERE id='$value'");
}
}
if($del){
header("location:index.php?op=berhasildelete");
}else{
echo "error";
}
?>
<?phpPotongan Script Form
$host=”localhost”;
$user=”root”;
$pass=”";
$db=”test”;
//koneksi
$koneksi=mysql_connect($host,$user,$pass);
mysql_select_db($db,$koneksi);
?>
<td width=”241″>
<select multiple=”multiple” name=”id” id=”id” onChange=”pilih(this.value)”>
<?php
$query_limit=mysql_query(“select * from guestbook“);
while($row=mysql_fetch_array($query_limit))
{
?><option value=”<?php echo $row['id_gb']; ?>”><?php echo $row['nama']; ?></option><?php
}
?>
</select>
</td>
<td width=”195″ valign=”top”>
<select name=”id” id=”id” onChange=”pilih(this.value)“>
<option value=”0″ selected=”selected”>Pilih Nama</option>
<?php
$query_limit=mysql_query(“select * from guestbook”);
while($row=mysql_fetch_array($query_limit))
{
?><option value=”<?php echo $row['id_gb']; ?>”><?php echo $row['nama']; ?></option><?php
}
?>
</select>
</td>
<script languange=”Javascript1.2″>
function pilih(id){
location.replace(“list-ri32.php?id=”+id);
}
</script>
<?php
include “conn.php”;
if($_GET['']!==”"){
$id=$_GET['id'];
$query=mysql_query(“select * from guestbook where id_gb=’$id’”);
?>
<table border=”1″>
<tr><th>No</th><th>Nama</th><th>Email</th><th>Pesan</th></tr>
<?php
while($row=mysql_fetch_array($query)){
?>
<tr><td><?php echo $c=$c+1;?></td><td><?php echo $row['nama'];?></td><td><?php echo $row['email']; ?></td><td><?php echo $row['pesan']; ?></td></tr>
<?php
}
?></table><?php
}
?>
^_^
Template by:
