How to store a group of SN to mysql

[andrewchan83]

Dear all,

I need help, my final project, i need to capture a group of serial number to store into mysql using php form.

But i have no idea on how to do on it.

Can any of you help on this part?

Let say i need to store a group of sn to the database using form. The there is 2 test box. The first one is the starting sn and the second one is the final value.

Help.

Thank you
Andrew

[NogDog]

Just get start/end values from the form, and use them in a for() loop to create the query (or queries) needed to insert them into the database.

$start = (int) $_POST['start'];
$end = (int) $_POST['end'];
if($start <= $end)
{
   for($sn = $start; $sn <= $end; $sn++)
   {
      $sql = "INSERT INTO table_name (serial_number) VALUES ($sn)";
      $result = mysql_query($sql);
   }
}

The above is, of course, minimal code that should be enhanced with more thorough validation and error-checking. It could also be enhanced to combine ranges of serial numbers in a set of insert values so as to reduce the number of queries required.