Parsing question

[FreeBaGeL]

Hi, I have a script that allows me to delete multiple rows in one of my database tables with checkboxes.

The problem is that the table has a primary key made of two columns: student ID and detail ID.

Student ID's may hence show up more than once with different detail ID's.

I have the checkbox set up to send the student ID with the box, but because of this, when I delete it deletes the entire student ID from the table, and hence every occurrence of it rather than just the single row I want.

I've only figured out one way to send both the Student ID and the Detail ID with the checkbox, and here it is:

while(OCIFetchInto($q, $arrGrades, OCI_ASSOC+OCI_RETURN_NULLS)){

   $sid=$arrGrades['STUDENT_ID'];
   $did=$arrGrades['DTL_ID'];
   $name="" . s . "" . $sid . "" . d . "" . $did ."";

   echo '<tr height="28"><td><p align="center"><input type="checkbox" value="';
   echo $name;
   echo'" name="DeleteGrades[]"></td></tr>';

This way it makes the value of the checkbox a string with the letter s, then the value of the student ID, then the letter d, and then the value of the detail ID.

For instance, the checkbox for the row with student ID 7 and Detail ID 11 would have the value "s7d11"

My question is how do I parse this in the processing file? Basically I want to extract just the '7' as the student ID, and the 11 as the detail ID.

I'm doing this in oracle, but any general help is more than welcome as well, thanks.

[drew010]

preg_match("/s(\d+)d(\d+)/", $name, $matches);

echo "Student ID = {$matches[1]}, Detail ID = {$matches[2]}.";

that will capture the student id and detail id.

[FreeBaGeL]

When I plug that in I get an error.

Warning: preg_match() expects parameter 2 to be string, array given in /amd/netapp2/vol/vol0/homes02/aantonio/public_html/Admin/Grades/SubmitDeleteGrades.php on line 35

Here's the code:

  //get Grades to be deleted
  $Grades = $_POST['DeleteGrades'];

  preg_match("/s(\d+)d(\d+)/", $Grades, $matches);

  echo "Student ID = {$matches[1]}, Detail ID = {$matches[2]}.";

[luke9_20]

Try changing your beginning script to this:

<?
$sid = $arrGrades['STUDENT_ID'];
$did = $arrGrades['DTL_ID'];
$name = "$sid;$did";

echo '<tr height="28"><td><p align="center"><input type="checkbox" value="';
echo '$name';
echo '" name="DeleteGrades"></td></tr>';
?>

then when you are changing that back to the two variables, simply explode the two:

<?
$name = explode(";", $_POST['DeleteGrades']);
echo "Student ID = $name[0], Detail ID = $name[1].";
?>

Hope that helps.