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

["Alp" <alp.bekisoglu@xxxxxxxxxxxxxx>]

Thank you Mike for your quick reply. I will try to incorporate it into the
function I'm using and let you know the result. The function code is also
given below.

Alp

function add_to_database( $tourid, $dayno, $fromto, $bld, $descrip,
&$dberror)
 {
 //user connection section--begin
 $username="root";
 $password="";
 $database="nazardane";
 $link = mysql_pconnect("localhost", $username, $password);
 if ( ! $link )
  {
  $dberror = "Couldn't connect to MySQL server";
  return false;
  }
 if ( ! mysql_select_db( $database, $link))
  {
  $dberror = mysql_error();
  return false;
  }
  $sql = "INSERT INTO tour_details ( tour_id, dayno, fromto, bld, descrip )
VALUES ( '$tourid', '$dayno', '$fromto', '$bld', '$descrip' ) )";
  if (! mysql_query($sql, $link))
   {
   $dberror = mysql_error();
   return false;
   }

 return true;
 }



"Mike Smith" <mikeosmith@xxxxxxxxx> wrote in message
news:d46325db050202033225f24987@xxxxxxxxxxxxxxxxx
> > 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