refining a mysql search

gisele

I have a form that users can choose what categories of products they want to search for. This is fine and works no problem.

The results go to another page with a complete list of product id's, names and descriptions.

What I have to do now, is with those results on the screen, I have to put checkboxes next to each record and if someone clicks in the check box, only those records will appear on the next page.

The purpose is to have people select what they want and it to appear on a page which they can print.

Any ideas?

Anon

Yea! Here is an idea. Check this code out. I havent tested any of it. So just try and if not hope it gives some ideas! Oh and its better (For security reasons) to have all your products on one .php page instead of jumping pages. It will ensure that nobody can exploit you. I hate when that stuff happens! Ya know what I mean? Ok so here is some sample script. If you cannot get it then buzz me on AIM at chads2k2. I will try to help you.

<form method="POST" action="addandprint.php">
<table border="1" width="100%">
<tr>
<td width="28%" align="center"><b>Product Id:</b></td>
<td width="28%" align="center"><b>Product Name:</b></td>
<td width="29%" align="center"><b>Product Description:</b></td>
<td width="15%" align="center"><b>Check To List:</b></td>
</tr>
<?php
$db = mysql_connect("localhost","username","password");
mysql_select_db("dbname", $db);
$sql = "select * from tablename";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
print("<tr>");
printf("<td width='28%%'>%s</td>\n",$row["product_id"]);
printf("<td width='28%%'>%s</td>\n",$row["product_name"]);
printf("<td width='29%%'>%s</td>\n",$row["product_description"]);
printf("<td width='15%%'><input type='checkbox' name='%s' value="%s">Add</td>\n",$row["product_name"],$row["product_id"]);
print("</tr>");
}
?>
</table>
<p><input type="submit" value="Add These Please" name="getgoing">
</form>

If you use it please let me know! I really like to know if my scripting is decent. Thanks!
Chad R. Smith
President of Designcmc

gisele

Hi Chad,

Thanks for your help, unfortunately, the script didn't work. It needed a
little modification. If I selected two items and clicked submit, it would
still return everything in the table.

here is my code:

<?
print '<form action='.$PHP_SELF.'>';
?>
<table border="1" width="100%">
<tr>
<td width="28%" align="center"><b>Product Id:</b></td>
<td width="28%" align="center"><b>Product Name:</b></td>
<td width="29%" align="center"><b>Product Description:</b></td>
<td width="15%" align="center"><b>Check To List:</b></td>
</tr>
<?php

$user = "username";
$pass = "password";
$db = "databasename";
$table = "tablename";

$link = mysql_connect ( "localhost", $user, $pass );
mysql_select_db ( $db, $link ) or die ( "couldn't open $db:
".mysql_error() );

$sql = "select * from $table";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
print"<tr>";
printf("<td width='28%%'>%s</td>\n",$row["PRODUCTID"]);
printf("<td width='28%%'>%s</td>\n",$row["PRODUCTNAME"]);
printf("<td width='29%%'>%s</td>\n",$row["DESCRIPTION"]);
printf("<td width='15%%'><input type='checkbox' name='%s'
value=\"%s\">Add</td>\n",$row["PRODUCTNAME"],$row["PRODUCTID"]);
print"</tr>";
}
?>
</table>
<p><input type="submit" value="Add These Please" name="getgoing">
</form>