PHP form needs a script to check for multiple selection

npereira

I have a form that gets member records off of mySQL db.
The php form prints out the list of members in the db and puts a
radio button in front of every member.

My problem is that;

When wanting to delete a member, I want the script to delete every single record (member) that is selected. Although, when modifying a record (member) I want the script to make sure taht there is only 1 record selected.

How could I do this?

Thanks in advance.

TreeUser

Search in the articles on ths site.
Maybe that'll help!!!

juschillinnow

did you get the new code that I sent you in your email?

All you have to do is use that. And you know how when you check several different ones and then click view and all of them show up?

Well it's that same thing with delete.

If you copy and paste the code from view inside the delete (if) and then replace the view with the delete query 😕 , then it will loop around for each one and delete it.

On the modify, you will have to use javascript so you can only select one box, This will be kinda tricky since it will not know when you are wanting to delete, or modify, unless you put the code on two different pages.

a good place to look would be

http://javascript.internet.com

npereira

I got your email but since the files where not ziped, Norton quarentied the files as suspect and now I cannot retreive them.... Please send it back ZIPPED!

Thanks

Nelson

juschillinnow

I resent them, hopefully you get them this time.

npereira

Got them... let me try it now...

P.S.: I try doing what you asked.. (the if delete statement)

Here is what the if () statement looks like;

//startifdelete

elseif($submit == 'DELETE')
{
	print("<table border=\"0\" width=\"900\">");
	$item = ${'checkbox'.$countnow};
	$query0 	= 	"delete from membres where id = '$item'";
	$mysql_result0	=	mysql_query($query0, $mysql_link);

}
//endifdelete

This has been put right after the

//endifsubmit

npereira

Works GREAT ! ! ! Thanks a bunch....

No an exercise for me..... first, make triple copies of this script and put in fireproof safe under the basment floor incased in 3 foot thik cement.

Next, add a back button in the VIEW screen.

P.S.: I liked the code that showed the total number of records, but in this new script, it's no longuer there!.

Nelson

juschillinnow

Yeah I took it out. If you want it, towards the bottom of the script, I think it's the last while loop like:

while()
{

}
echo $count.

or whichever string is added to everytime the while loop goes around.

npereira

This is what the script looks like in it final stage, and is working like a charm. Although, 2 questions remain, see next thread since not enough space on this one.

<?

include("./dbconnect.php");
print("<body background=\"fond.gif\">");
///////////////////////////////////////////////////////////////////////

switch ($MessageType)
{
/** BEGIN IF THE EDIT BUTTON IS PRESSED **/

case "Sauvegarder!":
$query = "update membres set prenom = '$editFirstName', nom = '$editLastName', adresse = '$editAddress', telephone = '$editTelephone', fréquence = '$editFrequency', email = '$editEmail' where id = '$ID'";
$mysql_result = mysql_query($query, $mysql_link);
echo "<h1>Un instant SVP!</h1>";
print("<meta http-equiv=\"refresh\" content=\"1\">");
break;

case "Ajouter!":
$query = "insert into membres (prenom, nom, adresse, telephone, fréquence, email)values('$addFirstName', '$addLastName', '$addAddress', '$addTelephone', '$addFrequency', '$addEmail')";
$mysql_result = mysql_query($query, $mysql_link);
echo "<h1>Un instant SVP!</h1>";
print("<meta http-equiv=\"refresh\" content=\"1\">");
break;

case "Effacer!":
$query = "delete from membres where id = '$ID'";
$mysql_result = mysql_query($query, $mysql_link);
echo "<h1>Un instant SVP!</h1>";
print("<meta http-equiv=\"refresh\" content=\"1\">");
break;

/////////////////////////////////////////////////////////////////////

case "Modifier":
    $countnow        = 0;
    $totalcols1        = 3;
    $colsprinted1         = 0;
    $totalcolsprinted     = 0;
    $sumcolsprinted     = 0;
    print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"40%\">");
    while($countnow <= $totalitems)
    {
        $countnow++;
        $item = ${'checkbox'.$countnow};
        if($item != '')
        {
            if($colsprinted1 == $totalcols1)
                {
                    print("</tr><tr>");
                    $colsprinted1 = 0;
                }
            $query0     =     "select * from membres where id = '$item'";
            $mysql_result0    =    mysql_query($query0, $mysql_link);
            while($row0 = mysql_fetch_row($mysql_result0))
                {
                    echo "<form action=\"$PHP_SELF\" method=\"post\">";
                    printf("<td valign=\"top\" align=\"center\" colspan=\"2\"><h2>Modifier les infos de:</h2></td></tr>
					<tr><td valign=\"top\" align=\"center\" colspan=\"2\"><h3>%s, %s</h3></td></tr>
					<tr><td valign=\"top\" align=\"left\"><b>Prénom:</b></td><td><input type=\"text\" name=\"editFirstName\" value=\"%s\" size=\"20\" MAXLENGTH=\"20\">
					<tr><td valign=\"top\" align=\"left\"><b>Nom:</b></td><td><input type=\"text\" name=\"editLastName\" value=\"%s\" size=\"20\" MAXLENGTH=\"20\">
					<tr><td valign=\"top\" align=\"left\"><b>Adresse:</b></td><td><input type=\"text\" name=\"editAddress\" value=\"%s\" size=\"50\" MAXLENGTH=\"50\">
					<tr><td valign=\"top\" align=\"left\"><b>Téléphone:</b></td><td><input type=\"text\" name=\"editTelephone\" value=\"%s\" size=\"12\" MAXLENGTH=\"12\">
					<tr><td valign=\"top\" align=\"left\"><b>Fréquence:</b></td><td><input type=\"text\" name=\"editFrequency\" value=\"%s\" size=\"20\" MAXLENGTH=\"20\">
					<tr><td valign=\"top\" align=\"left\"><b>Email:</b></td><td><input type=\"text\" name=\"editEmail\" value=\"%s\" size=\"40\" MAXLENGTH=\"40\"></td></tr>", $row0[2], $row0[1], $row0[1], $row0[2], $row0[3], $row0[4], $row0[5], $row0[6]);
                    echo "<input type=\"hidden\" name=\"ID\" value=\"$row0[0]\">";
                    echo "<input type=\"submit\" name=\"MessageType\" value=\"Sauvegarder!\">";
                    print("</td>");
                    echo "</form>";
                }
            $colsprinted1++;
            $totalcolsprinted++;
            $sumcolsprinted++;
        }
    }
break;
/** END OF EDIT BUTTON PRESSED **/

/** BEGIN IF THE ADD BUTTON IS PRESSED **/

case "Ajouter":
    print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"40%\">");
                    echo "<form action=\"$PHP_SELF\" method=\"post\">";
					printf("<td align=\"center\" valign=\"top\"colspan=\"2\"><h2>Ajouter:</h2></td></tr>
					<tr><td valign=\"top\" align=\"left\"><b>Prénom:</b></td><td><input type=\"text\" name=\"addFirstName\" size=\"20\" MAXLENGTH=\"20\">
					<tr><td valign=\"top\" align=\"left\"><b>Nom:</b></td><td><input type=\"text\" name=\"addLastName\" size=\"20\" MAXLENGTH=\"20\">
					<tr><td valign=\"top\" align=\"left\"><b>Adresse:</b></td><td><input type=\"text\" name=\"addAddress\" size=\"50\" MAXLENGTH=\"50\">
					<tr><td valign=\"top\" align=\"left\"><b>Téléphone:</b></td><td><input type=\"text\" name=\"addTelephone\" size=\"12\" MAXLENGTH=\"12\">
					<tr><td valign=\"top\" align=\"left\"><b>Fréquence:</b></td><td><input type=\"text\" name=\"addFrequency\" size=\"20\" MAXLENGTH=\"20\">
					<tr><td valign=\"top\" align=\"left\"><b>Email:</b></td><td><input type=\"text\" name=\"addEmail\" size=\"40\" MAXLENGTH=\"40\">");
                    print("</td>");
                    echo "<input type=\"submit\" name=\"MessageType\" value=\"Ajouter!\">";
                    echo "</form>";
    				echo "</table>";
break;
/** END OF ADD BUTTON PRESSED **/

/** BEGIN IF THE DELETE BUTTON IS PRESSED **/

case "Effacer":
    $countnow        = 0;
    $totalcols1        = 3;
    $colsprinted1         = 0;
    $totalcolsprinted     = 0;
    $sumcolsprinted     = 0;
    print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"40%\">");
    while($countnow <= $totalitems)
    {
        $countnow++;
        $item = ${'checkbox'.$countnow};
        if($item != '')
        {
            if($colsprinted1 == $totalcols1)
                {
                    print("</tr><tr>");
                    $colsprinted1 = 0;
                }
            $query0     =     "select * from membres where id = '$item'";
            $mysql_result0    =    mysql_query($query0, $mysql_link);
            while($row0 = mysql_fetch_row($mysql_result0))
                {
                    echo "<form action=\"$PHP_SELF\" method=\"post\">";
                    printf("<td align=\"center\" valign=\"top\"><h2>Voulez-vous vraiement éffacer ce membre?</h2></td></tr><tr><td valign=\"top\" align=\"center\"><h2><font color=\"#FF0000\">%s, %s</font></h2>", $row0[2], $row0[1]);
                    print("</td>");
                    echo "<input type=\"hidden\" name=\"ID\" value=\"$row0[0]\">";
                    echo "<input type=\"submit\" name=\"MessageType\" value=\"Effacer!\">";
                    echo "</form>";
                }
            $colsprinted1++;
            $totalcolsprinted++;
            $sumcolsprinted++;
        }
    }
break;
/** END OF DELETE BUTTON PRESSED **/



///////////////////////////////////////////////////////////////////////


///////////////////////////////////////////////////////////////////////
default:
print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"75%\"><tr>");
print("<form action = \"$PHP_SELF\" method=\"post\">");
print("<td align=\"center\" colspan=\"4\"><h1>INSTRUCTION</h1><font color=\"#FF0000\">Selectionner 1 membre puis cliquer sur \"Modifier\" ou \"Effacer\".<br>Ou cliquer sur \"Ajouter\" pour ajouter un membre.</font></td></tr>");
print("<tr><td align=\"center\" colspan=\"4\">");
print("<input type=\"submit\" name=\"MessageType\" value=\"Modifier\">&nbsp;&nbsp;&nbsp;");
print("<input type=\"submit\" name=\"MessageType\" value=\"Ajouter\">&nbsp;&nbsp;&nbsp;");
print("<input type=\"submit\" name=\"MessageType\" value=\"Effacer\">&nbsp;&nbsp;&nbsp;");
print("</td></tr>");
$count        =    1;
$colsprinted    =    0;
$totalcols    =    3;
$totalitems    =    0;
$query         =    "select * from membres order by nom";
$mysql_result    =    mysql_query($query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
if($colsprinted == $totalcols)
{
print("</tr><tr>");
$colsprinted    =    0;
}
printf("<td align=\"top\" valign=\"top\" style=\"border-bottom: solid 1 #000000\">
<input type=\"checkbox\" name=\"checkbox$count\" value=\"%s\" unchecked>
<b>%s, %s</b><br>
<b>Adr.:</b> %s<br>
<b>Tel.:</b> %s<br>
<b>Fréq.:</b> %s<br>
<b>Email:</b> %s</td>", $row[0], $row[2], $row[1], $row[3], $row[4], $row[5], $row[6]);
$count++;
$colsprinted++;
$totalitems++;
}
printf("<input type=\"hidden\" name=\"totalitems\" value=\"%s\">", $totalitems);
print("</td></tr>");
print("</form>");
print("</table>");
break;
////////////////////////////////////////////////////////////////////////
}


?>

See next thread.......

npereira

Here are the 2 questions I still have.

Questions:

1) Can you explain to me line by line what this part means? Except the lines I have marked as "DON'T NEED TO EXPLAIN THIS".

**DON'T NEED TO EXPLAIN THIS**print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"75%\"><tr>");
**DON'T NEED TO EXPLAIN THIS**print("<form action = \"$PHP_SELF\" method=\"post\">");
**DON'T NEED TO EXPLAIN THIS**print("<td align=\"center\" colspan=\"4\"><h1>INSTRUCTION</h1><font color=\"#FF0000\">Selectionner 1 membre puis cliquer sur \"Modifier\" ou \"Effacer\".<br>Ou cliquer sur \"Ajouter\" pour ajouter un membre.</font></td></tr>");
**DON'T NEED TO EXPLAIN THIS**print("<tr><td align=\"center\" colspan=\"4\">");
**DON'T NEED TO EXPLAIN THIS**print("<input type=\"submit\" name=\"MessageType\" value=\"Modifier\">&nbsp;&nbsp;&nbsp;");
**DON'T NEED TO EXPLAIN THIS**print("<input type=\"submit\" name=\"MessageType\" value=\"Ajouter\">&nbsp;&nbsp;&nbsp;");
**DON'T NEED TO EXPLAIN THIS**print("<input type=\"submit\" name=\"MessageType\" value=\"Effacer\">&nbsp;&nbsp;&nbsp;");
**DON'T NEED TO EXPLAIN THIS**print("</td></tr>");
$count        =    1;
$colsprinted    =    0;
$totalcols    =    3;
$totalitems    =    0;
$query         =    "select * from membres order by nom";
$mysql_result    =    mysql_query($query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
if($colsprinted == $totalcols)
{
**DON'T NEED TO EXPLAIN THIS**print("</tr><tr>");
$colsprinted    =    0;
}
**DON'T NEED TO EXPLAIN THIS**printf("<td align=\"top\" valign=\"top\" style=\"border-bottom: solid 1 #000000\">
<input type=\"checkbox\" name=\"checkbox$count\" value=\"%s\" unchecked>
<b>%s, %s</b><br>
<b>Adr.:</b> %s<br>
<b>Tel.:</b> %s<br>
<b>Fréq.:</b> %s<br>
<b>Email:</b> %s</td>", $row[0], $row[2], $row[1], $row[3], $row[4], $row[5], $row[6]);
$count++;
$colsprinted++;
$totalitems++;
}
printf("<input type=\"hidden\" name=\"totalitems\" value=\"%s\">", $totalitems);
**DON'T NEED TO EXPLAIN THIS**print("</td></tr>");
**DON'T NEED TO EXPLAIN THIS**print("</form>");
**DON'T NEED TO EXPLAIN THIS**print("</table>");

2) I don't know where you mean for the "number of records"!?!

Thanks for your response

npereira

juschillinnow,

Can you explain to me the script and specificaly where I mention?

Thanks

**DON'T NEED TO EXPLAIN THIS**print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"75%\"><tr>");
**DON'T NEED TO EXPLAIN THIS**print("<form action = \"$PHP_SELF\" method=\"post\">");
**DON'T NEED TO EXPLAIN THIS**print("<td align=\"center\" colspan=\"4\"><h1>INSTRUCTION</h1><font color=\"#FF0000\">Selectionner 1 membre puis cliquer sur \"Modifier\" ou \"Effacer\".<br>Ou cliquer sur \"Ajouter\" pour ajouter un membre.</font></td></tr>");
**DON'T NEED TO EXPLAIN THIS**print("<tr><td align=\"center\" colspan=\"4\">");
**DON'T NEED TO EXPLAIN THIS**print("<input type=\"submit\" name=\"MessageType\" value=\"Modifier\">&nbsp;&nbsp;&nbsp;");
**DON'T NEED TO EXPLAIN THIS**print("<input type=\"submit\" name=\"MessageType\" value=\"Ajouter\">&nbsp;&nbsp;&nbsp;");
**DON'T NEED TO EXPLAIN THIS**print("<input type=\"submit\" name=\"MessageType\" value=\"Effacer\">&nbsp;&nbsp;&nbsp;");
**DON'T NEED TO EXPLAIN THIS**print("</td></tr>");
$count        =    1;
$colsprinted    =    0;
$totalcols    =    3;
$totalitems    =    0;
$query         =    "select * from membres order by nom";
$mysql_result    =    mysql_query($query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
if($colsprinted == $totalcols)
{
**DON'T NEED TO EXPLAIN THIS**print("</tr><tr>");
$colsprinted    =    0;
}
**DON'T NEED TO EXPLAIN THIS**printf("<td align=\"top\" valign=\"top\" style=\"border-bottom: solid 1 #000000\">
<input type=\"checkbox\" name=\"checkbox$count\" value=\"%s\" unchecked>
<b>%s, %s</b><br>
<b>Adr.:</b> %s<br>
<b>Tel.:</b> %s<br>
<b>Fréq.:</b> %s<br>
<b>Email:</b> %s</td>", $row[0], $row[2], $row[1], $row[3], $row[4], $row[5], $row[6]);
$count++;
$colsprinted++;
$totalitems++;
}
printf("<input type=\"hidden\" name=\"totalitems\" value=\"%s\">", $totalitems);
**DON'T NEED TO EXPLAIN THIS**print("</td></tr>");
**DON'T NEED TO EXPLAIN THIS**print("</form>");
**DON'T NEED TO EXPLAIN THIS**print("</table>");

juschillinnow

Both questions are answered here:

**DON'T NEED TO EXPLAIN THIS**print("<table border=\"1\" cellpadding=\"1\" cellspacing=\"1\" align=\"center\" width=\"75%\"><tr>");
**This is used when you pull items off the database and name the checkbox.  Instead of checkbox it would be named checkbox1, checkbox2, etc...**$count        =    1;

**This number will increase in the while loop until the number 'totalcols' are printed, when reached it turns off the <tr> turns on a new <tr> and is set to 0 again to start over** $colsprinted    =    0;

**This is the number of columns you want** $totalcols    =    3;

**This is used on the receiving end to let the while loop know how many times to loop. It is increased in the while loop below** $totalitems    =    0;

**Queries the database** $query         =    "select * from membres order by nom";

**Query Result** $mysql_result    =    mysql_query($query, $mysql_link);

** This is the while loop in which your columns are printed and numbers are increased** while($row = mysql_fetch_row($mysql_result))

{

**This checks to see if it needs to start a new row or continue making columns** if($colsprinted == $totalcols)

{


**colsprinted is set back to zero so it can start printed columns in a new row** $colsprinted    =    0;

}

**Names the checkbox with $count so the name is never the same so you can identify it on the receving end** <input type=\"checkbox\" name=\"checkbox$count\" value=\"%s\" unchecked>

**You should know all this but, %s is a holding place for a string and then you just identify them at the end** <b>%s, %s</b><br>

<b>Adr.:</b> %s<br>

<b>Tel.:</b> %s<br>

<b>Fréq.:</b> %s<br>

<b>Email:</b> %s</td>", $row[0], $row[2], $row[1], $row[3], $row[4], $row[5], $row[6]);

**Next three lines, all variables are increased by 1 so they are different** $count++;

$colsprinted++;

$totalitems++;

}

//Put the next line in and it will give you the total items in database
echo $totalitems;
**This is passed to the receiving end and will let the while loop for the checkboxes know what the name is of the one you selected** printf("<input type=\"hidden\" name=\"totalitems\" value=\"%s\">", $totalitems);

npereira

//Put the next line in and it will give you the total items in database
echo $totalitems;

I've put the line right after the

default:

And it will not show the number of records in the database.

juschillinnow

put it where I had it in the script. leave it where it was when I replied and told you where to put it.
If you want to do it on the receiving end you will have to pass the value in the form like:

echo "<input type=\"hidden\" name=\"totalitems\" value=\"$totalitems\">";

npereira

Originally posted by juschillinnow
put it where I had it in the script. leave it where it was when I replied and told you where to put it.

I don't recall seeing it anywhere!

juschillinnow

//Put the next line in and it will give you the total items in database
echo $totalitems;

That line right there. leave it where I originally had it. Or where it was when I sent the code to you.

Basically what happens is that as the database is being queried, a while loop adds 1 to totalitems for each loop.

At the end you have a total. so anywhere outside of the loop, add echo $totalitems;

If you want it on the receiving side of the script you have to pass the value in your form.