Re: [How]Delete button
Posted: Mon Jul 20, 2009 9:13 pm
Implode works too though I've never thought about using it except when other members show examples of it in use. Good stuff! 
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/

Code: Select all
<?
error_reporting(E_ALL);
echo ("<form action=\"do.php\" method=\"post\" name=\"delete\">");
echo ("
<table width=\"50%\">
<tr>
<td width=\"5%\"></td>
<td width=\"20%\">Name</td>
<td width=\"10%\">Number</td>
<td width=\"20%\">Date</td>
</tr>
</table>
<br>
");
echo "<table width=\"50%\">";
require ("conn.php");
$query="select * from invoice order by date DESC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
echo ("
<tr>
<td width=\"5%\"><input type=\"checkbox\"></td>
<td width=\"20%\">$row[name]</td>
<td width=\"10%\">$row[number]</td>
<td width=\"20%\">$row[date]</td>
</tr>
");
}
echo "</table>";
echo "<input type=\"submit\" name=\"delete\" value=\"Delete\">";
echo ("</form>");
?>Code: Select all
<?php
include "conn.php";
$i = 0;
foreach($_POST['delete'] as $key => $value)
{
if ($i !=0) { $del .= ' or id=''.mysql_real_escape_string($_POST['delete']).''';
else {$del = 'id=''mysql_real_escape_string($_POST['delete']).'' ';}
$i++;
}
$query = "DELETE FROM chat WHERE ".$del;
echo '<div>'.$query.'</div>';
?>
Code: Select all
if ($i !=0) { $del .= ' or id=''.mysql_real_escape_string($_POST['delete']).''';Code: Select all
if ($i !=0) { $del .= ' or id=''.mysql_real_escape_string($_POST['delete']).''';"Code: Select all
<?php
$i = 0;
foreach($_POST['delete'] as $key => $value)
{
if ($i !=0)
{
$del .= " or id='".mysql_real_escape_string($_POST['delete'])."'";
}else{
$del .= "id='"mysql_real_escape_string($_POST['delete'])."'";
}
$i++;
}
$query = "DELETE FROM invoice WHERE ".$del;
echo '<div>'.$query.'</div>';
?>Code: Select all
$del .= "id='"mysql_real_escape_string($_POST['delete'])."'";Code: Select all
1. <?php
2. $i = 0;
3. foreach($_POST['delete'] as $key => $value)
4. {
5. if ($i !=0)
6. {
7. $del .= " or id='".mysql_real_escape_string($_POST['delete'])."'";
8. }else{
9. $del .= "id='".mysql_real_escape_string($_POST['delete'])."'";
10. }
11. $i++;
12. }
13.
14. $query = "DELETE FROM invoice WHERE ".$del;
15.
16. echo '<div>'.$query.'</div>';
17. ?>Code: Select all
foreach($_POST['delete'] as $key => $value)