Display values of db in form field

javiqq

I'm newbie to PHP and trying my best to learn on my own and take some courses online but currently I'm working on a website that stores information about students and their status. At the moment I have script that generates a list of students in a table and it works fine, but the list is way too long. So I thought maybe it would be efficient have the script generate the same list of students but in a TEXTAREA form field. Faculty will also need to have the ability to delete them individually or the whole list if necessary.

This is what I got so far:
<?php
$query = "SELECT re_first_name, re_last_name FROM students WHERE re_status_id_fk =3";
$result = mysql_query($query);

if($list=1)
{
while($row = mysql_fetch_assoc($result))
{
echo "<table cellspacing=3 cellpadding=0 border=0><tr><td width=70><b>Name: </b></td><td width=300>";
echo " ".$row[re_first_name]." ". $row[re_last_name]." ";
echo "</td>";

echo "</tr></table>";
}
echo "<br><br>";
}
else{
echo "The script isn't working properly, please try clicking the link again. If you continue to get this message contact your web site administrator.";
echo "<br>";
}
mysql_close();
include ('templates/footer.inc');
ob_end_flush();
exit();

😕Can anyone please help😕😕😕

devinemke

if you want the ability to delete single rows or many rows at a time i suggest a checkbox next to each row that flags multiple rows for deletion then delete all the checked rows upon form submission.

javiqq

That's what I did, now I need to figure out how to create the script that will detect which students' box is checked so it get deleted. :queasy:😕:queasy:

devinemke

a simple example:

<form action="" method="post">
<input type="checkbox" name="rows[]" value="1">row 1<br>
<input type="checkbox" name="rows[]" value="2">row 2<br>
<input type="checkbox" name="rows[]" value="3">row 3<br>
<input type="checkbox" name="rows[]" value="4">row 4<br>
<input type="checkbox" name="rows[]" value="5">row 5<br>
<input type="submit" name="submit" value="delete checked rows">
</form>

<?php
if (isset($_POST['submit']))
{
	if (isset($_POST['rows']))
	{
		$sql = 'DELETE FROM table WHERE id IN(' . implode(',', $_POST['rows']) . ')';
		echo $sql;
	}
	else
	{
		echo 'you did not check any rows';
	}
}
?>

djjjozsi

here is the form, with the student values:

<?
if($POST["Submit"]=="Submit_del")
{
if(isset($POST["aaa"]))

foreach($_POST["aaa"] AS $value)
{
print " You wanted to del:".$value;
$sql="DELETE FROM table WHERE ID=".(int)$value." ;";
}

if(isset($sql))
$result=mysql_query($sql);
if($result)
print "Deleted";
else
print "could not Deleted";

}

?>
In the value part, lets put the user's ID, and send that values as an Array [] after the name ...
<form name="form" method="post" action="?">
Student 1: <input name="aaa[]" type="checkbox" value="41"><br>
Student 2: <input name="aaa[]" type="checkbox" value="23"><br>
....
...

javiqq;10891613 wrote:
That's what I did, now I need to figure out how to create the script that will detect which students' box is checked so it get deleted. :queasy:😕:queasy: