[mulaus]

Hi..

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

i have this code add, edit, delete

i have two table , person (input data) and bin (deleted data)

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

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
Imageshack - person.jpg

Bin
Imageshack - bint.jpg

mylist.php

PHP Code:

<?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 Code:

<?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 Code:

<?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 Code:

<?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);
?>

[wirehopper]

Take out the periods, use {}

","{$row['firstname']}",".

Spend some time up at php.net, studying strings.

[mulaus]

i tried but not working

PHP Code:

"{$row['id']}","{$row['firstname']}","{$row['firstname']}","{$row['age']}" 

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 Code:

<?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);
?>

[wirehopper]

i tried but not working

PHP Code:
"{$row['id']}","{$row['firstname']}","{$row['firstname']}","{$row['age']}"

This isn't enough information for people to help you, and it isn't in the larger segment either. Please post the whole command, from start to semicolon, and all lines in between.

[Jcbones]

Originally Posted by wirehopper

Take out the periods, use {}

","{$row['firstname']}",".

Spend some time up at php.net, studying strings.

Try: String starts with double-quote(").

PHP Code:

','{$row['firstname']}','