neda_barnamenevis
دوشنبه 10 مهر 1391, 08:46 صبح
جهت اطلاع بقیه این کد من است بدون مشکل فقط نمیدانم چرا یکبار صفحه باید refresh شود تا کار کند
<html><head><title>MySQL Table Viewer</title></head><body>
<?php
$db_host = 'localhost';
$db_user = 'root';
$db_pwd = '';
$database = 'drupalfa';
$table = 'testinsert';
if (!mysql_connect($db_host, $db_user, $db_pwd))
die("Can't connect to database");
if (!mysql_select_db($database))
die("Can't select database");
// sending query
$result = mysql_query("SELECT * FROM {$table}");
if (!$result) {
die("Query to show fields from table failed");
}
$fields_num = mysql_num_fields($result);
if(isset($_POST['checkbox'])){
$select=array();
$select=$_POST['checkbox'];
foreach($select as $delete){
// $query="DELETE FROM testinsert WHERE id='".$delete."'";
//$query="UPDATE FROM testinsert SET checkbox='1' WHERE id='".$delete."'";
mysql_query("UPDATE testinsert SET checkbox='1' WHERE id = '$delete'")or die(mysql_error());
// mysql_query($query)or die(mysql_error());
}
}
echo "<form action=\"\" method=\"post\">";
echo "<table border='1'>
<tr>
<th>id</th>
<th>Firstname</th>
<th>Lastname</th>
<th>phone number</th>
<th>email</th>
<th>checkbox</th>
</tr>";
while($row = mysql_fetch_array($result))
{
if ($row[checkbox]==0){
?>
<tr>
<td> <?php echo $row['id'] ?> </td>
<td><?php echo $row['Fname'] ?> </td>
<td><?php echo $row['Lname'] ?> </td>
<td><?php echo $row['PHONE'] ?> </td>
<td><?php echo $row['Email'] ?> </td>
<td><input type="checkbox" name="checkbox[]" value="<?php echo $row['id'];?>"/></td>
</tr>
<?php
}
}
echo "</table>";
echo "<input type='submit' value='Delete Users' name='delete' />";
echo "</form>";
?>