PHP basic code for delete data
<?php
$localhost="localhost";
$user="root";
$pass="";
$db="test";
$connect = mysqli_connect('localhost', 'root', '' ,'test');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Books</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" href="css/layout.css" type="text/css" />
</head>
<body id="top">
<div class="wrapper col0">
<div id="topline">
<p>Name: Books Website</p>
<br class="clear" />
</div>
</div>
<!-- ####################################################################################################### -->
<div class="wrapper">
<div id="header">
<div class="fl_left">
<h1><a href="index.html"><strong>T</strong>e<strong> s</strong>T</a></h1>
<p>Welcome to our website</p>
</div>
<br class="clear" />
</div>
</div>
<!-- ####################################################################################################### -->
<div class="wrapper col2">
<div id="topbar">
<div id="topnav">
<ul>
<li class="active"><a href="add.php">Add</a></li>
<li><a href="show.php">Show</a></li>
<li><a href="delete.php">Delete</a></li>
<li><a href="register.php">Register</a></li>
<li><a href="login.php">Login</a></li>
</ul>
</div>
<br class="clear" />
</div>
</div>
<!-- ####################################################################################################### -->
<div class="wrapper">
<br class="clear" />
</div>
<div id="hpage_cats">
<form method="post" action="">
<b>Books</b>
<table>
<thead>
<tr>
<th><input type="checkbox" id="checkAl"></th>
<th>Name</th>
<th>Description</th>
</tr>
</thead>
<?php
$i=0;
$sql="SELECT * FROM books";
$result=$connect->query($sql);
while($row=$result->fetch_assoc()) {
?>
<tr>
<td><input type="checkbox" id="checkItem" name="check[]" value="<?php echo $row["bookid"]; ?>"></td>
<td><?php echo $row["title"]; ?></td>
<td><?php echo $row["description"]; ?></td>
</tr>
<?php
$i++;
}
?>
</table>
<p align="center"><button type="submit" class="btn btn-success" name="delete" id="delete">DELETE ALL</button></p>
</form>
<script>
$("#checkAl").click(function () {
$('input:checkbox').not(this).prop('checked', this.checked);
});
</script></div><hr>
<!-- ####################################################################################################### -->
<?php
if(isset($_POST["delete"]))
{
// foreach ($_POST["checkbox"] as $title) {
$sqlDel="DELETE FROM `books`";
/*WHERE bookid='$title'*/
$resultDel=mysqli_query($connect,$sqlDel);
if($resultDel)
echo "Your data has deleted";
else
echo "Try again";
}
$connect->close();
?>
<!-- ####################################################################################################### -->
<div class="wrapper col8">
<div id="copyright">
<p class="fl_left">Copyright © 2021</p>
<br class="clear" />
</div>
</div>
</body>
</html>
No comments:
Post a Comment