Record Delete Button

[Salchester]

Alloha,

I currently have 3 fields in a database, these are the following:

• Name
• Sex
• Age

How do I display all records in the database, and place a delete button next to each one. Upon the user clicking the button the associated record gets deleted and the page is refreshed to reflect the this action?

Many Thanks,

[sde]

people here are pretty open to newbie questions, but by now i'd think you have been developing with HTML/PHP/MySQL enough to get something started and show us where you're stuck. maybe just tell us ways you are considering going about it.

no offense, but i avoid your 'how do i' questions now because most of them don't show more effort on your part than it would take to answer your question. by the looks of your un-answered posts, it seems like others may feel the same way too.

don't take it as a flame, but i personally think you could answer most of the pieces that make up your question.

- How do I display all records in the database?
- How do I place a button next to each of these records?
- How do I do I make each button send POST or GET info?
- How do I handle the POST or GET info that the button sends?
- How do I delete the record in the database?
- How do I display all the records in the database now?

[DJMaze]

PHP Code:

$sql = mysql_query('SHOW * FROM samples WHERE user_name=\'Salchester\'');
while (mysql_fetch_row($sql))
{
    echo '<button name="delete" value="sample_id">delete</button>';
} 


But it wouldn't show any buttons cos there are no samples given yet.
Nor does the above code work, it's a quest.

[Salchester]

DJMaze,

I have come up with the following code, that displays each record with it's own check box. Though how do I assign the "Numeric Array Store" value of each record to each check box, so when the delete button is clicked, the code knows which record in the $records array to NOT copy into the $temp array?

Upon a record being selected and the delete button being clicked, how do I copy all but the selected records to a $temp array, from the $records array?

<?php
$con = mysql_connect("localhost","peter","abc123");

if (!$con)
{
  die('Could not connect: ' . mysql_error());
}

mysql_select_db("WB", $con);

$result = mysql_query("SELECT * FROM Birds");

if(mysql_error() != 0 || mysql_num_rows($result) == 0)
{
  die("No database, or no data");
}

$records = array();
$temp = array();
while($row = mysql_fetch_object($result))
{
  array_push($records, $row);
}

$i = 0;

foreach( $records as $k )
{
  echo "$k->Name";
  echo "$k->Species";
  echo "$k->Sex";
  echo "<input type='checkbox' name='remove[" .$i. "]' value=" .$i. " />\n"; 
  $i++;
}

echo "<input type='submit' value='Delete' />\n";
?>

Many Thanks,

[DJMaze]

You can't.
Learn those god damn primary id's as was told to you 100 times, you fool.

After that you know the answer of this topic.