Posted by Alp on 10/03/32 11:07

Hi Mike,

PHP returns a parse error indicating the line number for the while (.....) !
Code now is:
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;
}
while ($c=0;$c<count($_POST['tourid']):$c++) {
if ($_POST['tourid'][$c]!="" && $_POST['dayno'][$c]!="" &&
$_POST['fromto'][$c]!="" && $_POST['bld'][$c]!="" &&
$_POST['descrip'][$c]!=""){
$sql = "INSERT INTO tour_details ('tour_id'. 'dayno', 'fromto', 'bld',
'descrip') VALUES ('{$_POST['tourid'][$c]}'. '{$_POST['dayno'][$c]}',
'{$_POST['fromto'][$c]}', '{$_POST['bld'][$c]}',
'{$_POST['descrip'][$c]}')\n";
}
if (! mysql_query($sql, $link))
{
$dberror = mysql_error();
return false;
}
}
$lastinsertid = mysql_insert_id();

return true;
}

Actually the form is posted to itself. What could be the problem now?

Thanks in advance.

Alp

"Mike Smith" <mikeosmith@gmail.com> wrote in message
news:d46325db050202033225f24987@mail.gmail.com...
> > 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";
> }
> }

• Next in thread: Re: [PHP] Multiline data Insert Into table from a generated form?
• Prev in thread: Re: [PHP] Multiline data Insert Into table from a generated form?
• Next in forum: Re: [PHP] Multiline data Insert - Resolved
• Prev in forum: Re: What's wrong with this rewrite rule?
• Thread view: Multiline data Insert Into table from a generated form?

[Reply to this message]