Insert Deleted record to a new table

[mulaus]

as i said i did this in localhost

i manage to convert my radio button delete form to check boxes..how and where do i put insert query in delete.php ?

<?php
include "connect.php";
$result = mysql_query("SELECT * FROM person");

echo '<form action="delete.php" method="post">';

echo '<table border="1">
<tr>
<th>ID</th>
<th>Firstname</th>
<th>Lastname</th>
<th>Age</th>
</tr>';


$count = 1;

while($row = mysql_fetch_array($result))
{
$id=$row['id']; echo "<tr>";
echo "<td>";
echo $count++;

echo "<input type='checkbox' name='id[]' value='$id'></td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "</tr>";
}

echo '</table>
<br />
<input type="submit" value="Delete" />
</form>';

include "menu.php";


mysql_close($con);

?>

delete.php

<?php

include "connect.php";

$id=$_POST[id];

for($i=0;$i<count($_POST['id']);$i++)

mysql_query("DELETE FROM person WHERE id={$id[$i]}");

echo "$i records deleted";

include "menu.php";
mysql_close($con);
?>

[forum_amnesiac]

As I see it your problem is that you are not passing the value $id as a POST variable to delete.php.

Try changing this :

echo "<input type='checkbox' name='id[]' value='$id'></td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "</tr>"; 

to this :

echo "<input type='checkbox' name='id[]' value='$id'></td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "<td input type='hidden' name='id' value='".$row[id]."'></td>";
echo "</tr>"; 

Or change the checkbox line to this:

echo "<input type='checkbox' name='id[]' value='".$id."'></td>"; 

The input type="hidden" is a useful way of passing variables to PHP that you don't want to be visible on the input screen

[mulaus]

thanks..

i did it like this and it worked

delete.php

<?php

include "connect.php";

$id=$_POST[id];

for($i=0;$i<count($_POST['id']);$i++)
{
$result = mysql_query("SELECT * FROM person WHERE id={$id[$i]}") or die(mysql_error());

$row = mysql_fetch_array( $result ) or die(mysql_error());

mysql_query("INSERT INTO bin (id, firstname, lastname, age)
VALUES
(". $row['id'] . ",". $row['firstname'] . ",". $row['lastname'] . ",". $row['age'] . ")");


mysql_query("DELETE FROM person WHERE id={$id[$i]}");
}
echo "$i records deleted";

include "menu.php";
mysql_close($con);
?>

SOLVED..

[JShor]

Of course! I can't believe I didn't see that. I guess some problems are simpler than they look.

[mulaus]

can someone help me to check this...what did i do wrong

i add the ability to restore back the data in the 'recycle bin' (restore.php)

last time i didn't input/check it properly

the problem if i input first name,last name as text it is not inserted to the bin table...

but if i put first name,last name as numbers it is ok it is inserted to the bin table and i can restore it back to person table

and how do i put add new ability to delete in restore.php...

newbie here

please help...thanks



Person
http://img690.imageshack.us/i/person.jpg/

Bin
http://img215.imageshack.us/i/bint.jpg/

mylist.php

<?php
include "connect.php";
$result = mysql_query("SELECT * FROM person");

echo '<form action="mydelete.php" method="post">';

echo '<table border="1">
<tr>
<th>ID</th>
<th>Firstname</th>
<th>Lastname</th>
<th>Age</th>
</tr>';


$count = 1;

while($row = mysql_fetch_array($result))
{
$id=$row['id']; echo "<tr>";
echo "<td>";
echo $count++;

echo "<input type='checkbox' name='id[]' value='$id'></td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "</tr>";
}

echo '</table>
<br />
<input type="submit" value="Delete" />
</form>';

include "menu.php";


mysql_close($con);

?>

mydelete.php

<?php

include "connect.php";

$id=$_POST[id];

for($i=0;$i<count($_POST['id']);$i++)
{
$result = mysql_query("SELECT * FROM person WHERE id={$id[$i]}") or die(mysql_error());

$row = mysql_fetch_array( $result ) or die(mysql_error());

mysql_query("INSERT INTO bin (id, firstname, lastname, age)
VALUES
(". $row['id'] . ",". $row['firstname'] . ",". $row['lastname'] . ",". $row['age'] . ")");


mysql_query("DELETE FROM person WHERE id={$id[$i]}");
}
echo "$i records deleted";

include "menu.php";
mysql_close($con);
?>

restore.php

<?php
include "connect.php";
$result = mysql_query("SELECT * FROM bin");

echo '<form action="restore-success.php" method="post">';

echo "<H4>Deleted Items</H4>";

echo "Select To Restore";

echo '<table border="1">
<tr>
<th>No</th>
<th>Deleted ID</th>
<th>Firstname</th>
<th>Lastname</th>
<th>Age</th>
</tr>';

$count = 1;

while($row = mysql_fetch_array($result))
{
$bin_id=$row['bin_id']; 

echo "<tr>";
echo "<td>";
echo $count++;

echo "<input type='checkbox' name='bin_id[]' value='$bin_id'></td>";
echo "<td>" . $row['id'] . "</td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['age'] . "</td>";
echo "</tr>";
}

echo '</table>
<br />
<input type="submit" value="Restore" />
</form>';

include "menu.php";


mysql_close($con);

?>

restore-success.php

<?php

include "connect.php";

$bin_id=$_POST[bin_id];

for($i=0;$i<count($_POST['bin_id']);$i++)
{
$result = mysql_query("SELECT * FROM bin WHERE bin_id={$bin_id[$i]}") or die(mysql_error());

$row = mysql_fetch_array( $result ) or die(mysql_error());

mysql_query("INSERT INTO person (id, firstname, lastname, age)
VALUES
(". $row['id'] . ",". $row['firstname'] . ",". $row['lastname'] . ",". $row['age'] . ")");

mysql_query("DELETE FROM bin WHERE bin_id={$bin_id[$i]}");
}
echo "$i records restored";

include "menu.php";
mysql_close($con);
?>

[mulaus]

also tried below code but not working....this code is working perfectly if i input numbers for all fields i can delete and restore - but as text its failed to be inserted to bin table

<?php

include "connect.php";



$id_array=$_POST[id];
foreach($id_array as $id)
{
$result = mysql_query("SELECT * FROM person WHERE id=$id") or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$id=$row['id'];
$firstname=$row['firstname'];
$lastname=$row['lastname'];
$age=$row['age'];
}
echo $firstname;


mysql_query("INSERT INTO bin (id, firstname, lastname, age)
VALUES ($id,$firstname,$lastname,$age)");

mysql_query("DELETE FROM person WHERE id=$id");

echo "Record deleted and inserted to recycle bin";

}

mysql_close($con);
?>