You are here: Re: [PHP] Multiline data Insert Into table from a generated form? « PHP « IT news, forums, messages
Re: [PHP] Multiline data Insert Into table from a generated form?

Posted by Mike Smith on 02/02/05 13:32

> 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";
}
}

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация