multiple row deleting into mysql table using mysql and php script or multiple check box select script
multiple row deleting into mysql table using mysql and php script or multiple check box select script
<html>
<head>
<title>php and mysql by sam saifi</title>
</head>
<body>
multiple row deleting into mysql and php
step by step
step1:- create connection to data like $con.
step2:-select database like $db.
step3:- write query like $sql.
step4:-fetching data in loop like while loop
step5:- create object in loop like $row.
step6:-execute object with table colum name like $row['name'];
step7:-create if condition and validate delete button
step8:-if condition is true then write your logic for multiple check box value
<form action="" method="post" >
<?
$con = mysql_connect("localhost","sam","") or die(mysql_error());// here sam is user name
$db = mysql_select_db("sam");//here sam is data base name
$sql = "SELECT * FROM cust";
$query = mysql_query($sql) or die ("error Query [".$sql."]");
?>
<table >
<tr>
<th > <div >id </div></th>
<th > <div >name </div></th>
<th > <div >e-mail </div></th>
<th > <div >School </div></th>
<th > <div >class </div></th>
<th > <div >gender </div></th>
<th > <div >Delete </div></th>
</tr><?
while($row = mysql_fetch_array($query))
{
?>
<tr>
<td><div ><?php $row["id"];?></div></td>
<td><?php $row["name"];?></td>
<td><?php $row["e-mail"];?></td>
<td><div ><?php $row["School"];?></div></td>
<td><?php $row["class"];?></td>
<td><?php $row["gender"];?></td>
<td ><input type="checkbox" name="del[]" value="<?php $row["id"];?>"></td>
</tr>
<?
}
?>
</table>
<?
mysql_close($con);
?>
<input type="submit" name="delete" value="Delete">
</form>
</body>
</html>
<!--- php tutorials with sam saifi -->
Deleting code in php and mysql data row
<?php if($_REQUEST['delete']){
$del=$_REQUEST['del[]'];
$delmem=0;
$i=1;
foreach($del as $delid)
{
$sql = "SELECT * FROM cust where id=".$delid."";
$query = mysql_query($sql) or die ("error Query [".$sql."]");
$delmem +=$i;
$i++;
}
echo $delmem."sucessfully deleted";
?>
}>
<html>
<head>
<title>php and mysql by sam saifi</title>
</head>
<body>
multiple row deleting into mysql and php
step by step
step1:- create connection to data like $con.
step2:-select database like $db.
step3:- write query like $sql.
step4:-fetching data in loop like while loop
step5:- create object in loop like $row.
step6:-execute object with table colum name like $row['name'];
step7:-create if condition and validate delete button
step8:-if condition is true then write your logic for multiple check box value
<form action="" method="post" >
<?
$con = mysql_connect("localhost","sam","") or die(mysql_error());// here sam is user name
$db = mysql_select_db("sam");//here sam is data base name
$sql = "SELECT * FROM cust";
$query = mysql_query($sql) or die ("error Query [".$sql."]");
?>
<table >
<tr>
<th > <div >id </div></th>
<th > <div >name </div></th>
<th > <div >e-mail </div></th>
<th > <div >School </div></th>
<th > <div >class </div></th>
<th > <div >gender </div></th>
<th > <div >Delete </div></th>
</tr><?
while($row = mysql_fetch_array($query))
{
?>
<tr>
<td><div ><?php $row["id"];?></div></td>
<td><?php $row["name"];?></td>
<td><?php $row["e-mail"];?></td>
<td><div ><?php $row["School"];?></div></td>
<td><?php $row["class"];?></td>
<td><?php $row["gender"];?></td>
<td ><input type="checkbox" name="del[]" value="<?php $row["id"];?>"></td>
</tr>
<?
}
?>
</table>
<?
mysql_close($con);
?>
<input type="submit" name="delete" value="Delete">
</form>
</body>
</html>
<!--- php tutorials with sam saifi -->
Deleting code in php and mysql data row
<?php if($_REQUEST['delete']){
$del=$_REQUEST['del[]'];
$delmem=0;
$i=1;
foreach($del as $delid)
{
$sql = "SELECT * FROM cust where id=".$delid."";
$query = mysql_query($sql) or die ("error Query [".$sql."]");
$delmem +=$i;
$i++;
}
echo $delmem."sucessfully deleted";
?>
}>
Comments
Post a Comment