Print from Checkboxes

[lwaters]

I have created a form:

<form action="printable_version2_test.php" method="get"><fieldset id="el11">
                  <legend><strong>Search Results</strong></legend>
                  <table width="100%" border="0" cellspacing="1" cellpadding="6">
                    <tr>
                      <td valign="top"><?php do { ?>
                            <?php if ($totalRows_results > 0) { // Show if recordset not empty ?>
  <a href="profile.php?UID=<?php echo $row_results['UID']; ?>&amp;GCID=<?php echo $_GET['GCID']; ?>"> <?php echo $row_results['FNAME']; ?> <?php echo $row_results['LNAME']; ?></a> <input name="UID[]" type="checkbox" id="record" value="<?php echo $row_results['UID']; ?>" /><br />
  <?php } // Show if recordset not empty ?>
<?php } while ($row_results = mysql_fetch_assoc($results)); ?>
<?php if ($totalRows_results == 0) { // Show if recordset empty ?>
  <p>No applicants were found. <a href="search.php?GCID=<?php echo $_GET['GCID']; ?>">Search again</a>.
    <?php } // Show if recordset empty ?><input name="submit" type="submit" id="submit" value="Print" /></td>
                    </tr>
                  </table>
                  </fieldset></form>

and once the user hits submit, they will be taken to a page that will print out a profile for each of the students checked. I am using Dreamweaver and a newbie so, I am kind of lost. I think I have the form correct, it is the second page that I am having trouble creating. Any help would be appreciated. Thanks

[bradgrafelman]

lwaters;11020365 wrote:

it is the second page that I am having trouble creating.

What have you got so far?

It looks like what you'll want to do is something like:

1. Verify $_POST['UID'] is a non-empty array (see [man]empty/man and [man]is-array/man).

2. Sanitize the data; I'm guessing these UIDs are integers? If so, one simple approach might be to use [man]array_map/man to apply the [man]intval/man function to all of the values in the array. I don't use prepared statements, but there may be a clever way of doing so as well.

3. Insert the values in the array into the WHERE condition a SQL query to look something like:

   WHERE UID IN (1, 2, 3)

   (where 1, 2, and 3 are example values from the array). If not using prepared statements, a simple way to do this would be to use [man]implode/man.

EDIT: Also, welcome to PHPBuilder!

[lwaters]

This is what I have so far. Remember, I am using Dreamweaver so, it doesn't produce clean content. I know this isn't correct. It only returns one student profile since Dreamweaver's built in functions always thinks it is a single string. So, now, I have to convert this text into pulling in the array of the UID field. UID are integers. I hope you don't run once you read this code. 🙂

<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$colname_your_scholarships = "-1";
if (isset($_GET['UID'])) {
  $colname_your_scholarships = $_GET['UID'];
}
mysql_select_db($database_connect, $connect);
$query_your_scholarships = sprintf("SELECT * FROM gc_codes, users  INNER JOIN stu_app2008 ON users.UID = stu_app2008.UID  INNER JOIN activities ON users.UID = activities.UID INNER JOIN coll_exp ON users.UID = coll_exp.UID  INNER JOIN employ ON users.UID = employ.UID INNER JOIN fin_app ON users.UID = fin_app.UID  INNER JOIN finaid ON users.UID = finaid.UID  INNER JOIN stu_special ON users.UID = stu_special.UID WHERE users.UID = %s and gc_codes.GCID = users.GC", GetSQLValueString($colname_your_scholarships, "int"));
$your_scholarships = mysql_query($query_your_scholarships, $connect) or die(mysql_error());
$row_your_scholarships = mysql_fetch_assoc($your_scholarships);
$totalRows_your_scholarships = mysql_num_rows($your_scholarships);
?>
<?php  $lastTFM_nest = "";?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">