Re: Multiline data Insert Into table from a generated form?

[Mike Smith <mikeosmith@xxxxxxxxx>]

> Code:
>  print '<table width="545" border="0" cellspacing="0" cellpadding="0"
> align="center"><tr>';
>  print '<form action="test1.php" method="POST">';
>  $i = 1;
>  while ($i <= $tour_days) {
>   print '<input type="hidden" name="tourdays" value="'.$tour_days.'">';
>   print '<input type="hidden" name="tourid'.$i.'" value="'.$tour_id.'">';
>   $days = ("Day&nbsp;0".$i);
>   print $days;
>   print '<input type="hidden" name="dayno'.$i.'" value="'.$days.'">';
>   print '</td>';
>   print '<input type="text" name="fromto'.$i.'" size="50"></td>';
>   print '<input type="text" name="bld'.$i.'" size="10"></td></tr>';
>   print '<tr><td colspan="3">';
>   print '<textarea name="descrip'.$i.'" rows="5" cols="80"
> wrap="virtual"></textarea></td></tr>';
>   $i++;
>   }
>  print '</table>';
>  print "<input type=\"submit\" value=\"submit!\">\n</form>\n";

Change the field names to arrays (i.e. "tourid".$i becomes tourid[]

When you POST loop through the array:

while($c=0;$c<count($_POST['tourid']):$c++){
    If($_POST['tourid'][$c]!=""...){
        $sql = "INSERT INTO reservations ('tourid'...) VALUES
('{$_POST['tourid'][$c]}'...)\n";
    }
}

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php