Cara multiple data dengan checkbox menggunakan PHP

Cara multiple data dengan checkbox menggunakan PHP

Cara multiple data dengan checkbox menggunakan PHP

Pada pelajaran coding kali ini saya akan membagikan Cara multiple data dengan checkbox menggunakan PHP Mysql dan jquery nah tanpa panjang lebar cek langsung skrip dibawah ini

database.php

<?php

$url='localhost';

$username='root';

$password='';

$conn=mysqli_connect($url,$username,$password,"crud");

if(!$conn){

die('Could not Connect My Sql:' .mysql_error());

}

?>

 

index.php

<?php

include_once 'database.php';

if(isset($_POST['save'])){

$checkbox = $_POST['check'];

for($i=0;$i<count($checkbox);$i++){

$del_id = $checkbox[$i];

mysqli_query($conn,"DELETE FROM employee WHERE userid='".$del_id."'");

$message = "Data deleted successfully !";

}

}

$result = mysqli_query($conn,"SELECT * FROM employee");

?>

<!DOCTYPE html>

<html>

<head>

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>

<title>Delete employee data</title>

</head>

<body>

<div><?php if(isset($message)) { echo $message; } ?>

</div>

<form method="post" action="">

<table class="table table-bordered">

<thead>

<tr>

<th><input type="checkbox" id="checkAl"> Select All</th>

<th>Employee Id</th>

<th>First Name</th>

<th>Last Name</th>

<th>City</th>

<th>Email id</th>

</tr>

</thead>

<?php

$i=0;

while($row = mysqli_fetch_array($result)) {

?>

<tr>

<td><input type="checkbox" id="checkItem" name="check[]" value="<?php echo $row["userid"]; ?>"></td>

<td><?php echo $row["userid"]; ?></td>

<td><?php echo $row["first_name"]; ?></td>

<td><?php echo $row["last_name"]; ?></td>

<td><?php echo $row["city_name"]; ?></td>

<td><?php echo $row["email"]; ?></td>

</tr>

<?php

$i++;

}

?>

</table>

<p align="center"><button type="submit" class="btn btn-success" name="save">DELETE</button></p>

</form>

<script>

$("#checkAl").click(function () {

$('input:checkbox').not(this).prop('checked', this.checked);

});

</script>

</body>

</html>

 

 

 

Baca Juga  Cara Membuat Upload File Lebih Dari Satu File Dengan Php

Tinggalkan Komentar

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

Need Help? Chat with us