NEED HELP: creating a list with checkboxs like webmail account

ahoo

I am a newbie in PHP.
I want to create a list, which will retrieve the expired members' name from database and display it as a list. Then with every retrived name, it's a checkbox beside it to allow me check or uncheck it. Then I can click on the DELETE button to remove those checked members from MySQL database. Can somebody show me the trick? 😕

cahva

Heres a script which gives you a push in the right direction:

<?php
$server = "localhost";
$user = "****";
$db = "****";
$pass = "****";
mysql_connect($server, $user, $pass);
mysql_select_db($db) or die(mysql_error());

// Check if form is submitted and delete the expired members
if ($_POST['submit']) {

// Get the checkboxes names and values. $key=members name, $val=members id
reset ($_POST);
while (list ($key, $val) = each ($_POST)) {
	if (!strstr('submit',$key)) { // exclude submit from selection
		$del.="id='$val' AND ";
		$names[]=$key;
	}
}

if ($del) {
	$del=substr($del,0,-4);
	$names=implode(',',$names);
	mysql_query("DELETE FROM table WHERE $del"); // This does the actual deletion
	mysql_close();
	die($names.' deleted from database!');
}
} 
?>
<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
<?php
$query="SELECT id,name FROM table WHERE expired='1' ORDER by name";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)) {
	echo '<input type="checkbox" name="'.$row['name'].'" value="'.$row['id'].'">'.$row['name'].'<br>';
}
mysql_close();
?>
<input type='submit' name="submit" value="DELETE">
</form>

ahoo

Thanks for your help.

I need some time to digest this.

I will tell you if I success to get it. See you.

ahoo

Hi cahva, I tried to make your code simple and test it out to improve my PHP skill. But I got this error:

Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in /var/www/html/diy4org/listmember.php on line 22

Can you tell me where is my mistake? Thanks!

<html>
<head><title></title></head>
<body>

<?php

include( "connect.php" );

$query = "SELECT name, recordID FROM member";

$result = mysql_query( $query );

?>

<form action="" method="post">

<?php


while( $row = mysql_fetch_array( $result ) )
{
echo '<input type="checkbox" name="'.$row['name']'" value="'.$row['recordID'].'">'.$row['name'].'<br>';
}

mysql_close();
?>

</form>
</body>
</html>

cahva

You have a missing dot after the first $row['name'].. Change the line to this:

echo '<input type="checkbox" name="'.$row['name'].'" value="'.$row['recordID'].'">'.$row['name'].'<br>';