PHP Forum

**lardy** · 12-09-2005, 04:18 AM

How do I keep this form looping and send to mysql database.

<html>
<head>
<title>Guest list pages!</title>
</head>
<body>
<?
if (!isset($_GET['Number_of_family_members'])) {
// this checks if the form has been posted. if it hasnt it dsiplays the html below.
?>
<p>
First enter number of family members staying at address<br>
and press enter.On the next page enter family details<br>
press enter next family. Repeat process untill your guest
list is complete.
</p>
<form name="emailform" method="GET">
<SELECT NAME="Number_of_family_members" SIZE="1">
<OPTION SELECTED>1
<OPTION>2
<OPTION>3
<OPTION>4
<OPTION>5
<OPTION>6
<OPTION>7
<OPTION>8
<OPTION>9
<OPTION>10
<OPTION>11
<OPTION>12
</SELECT>
<INPUT TYPE="submit" value="Enter family details">
</form>
<?
}else { // if the form has been posted display this...
?>
<form action="number of members.php" method="GET">
<?
for ($i = 1; $i <= $_GET['Number_of_family_members']; $i++) {

//this loops thru Number_of_family_members
?>

<dl>

<dt>Family Member:</dt>
<dd><input type="text" name="family member<?echo $i;?>"></dd>

</dl>
<?};?>
<dt>Förnamn:</dt>
<dd><input type="text" name="förnamn"></dd>
<dt>Efternamn:</dt>
<dd><input type="text" name="efternamn"></dd>

<dt>Address:</dt>
<dd><input type="text" name="address"></dd>

<dt>Postnummer:</dt>
<dd><input type="text" name="postnummer"></dd>
<INPUT TYPE="submit" value="Enter next family">
<INPUT TYPE="reset" value="Reset Form">
</form>
<? }; ?>
</body>
</html>
Thanks for any help

**cerebro89** · 12-09-2005, 08:19 AM

what you need to do is connect to the database and make an insert statement.

**lardy** · 12-09-2005, 09:00 AM

Ive done that before using a insert.php, but I dont see how that will work haere as I need it to loop back.

**uktvindex** · 12-13-2005, 07:59 AM

Ok, once you select the number of family members, you need to allow the script to post the final results. The loop back remains is still in place but the final results can be sent to a database.

You need to change this:

Quote:

to:

Quote:

Then create an page entitled addmembers.php and add a connect to database command and then an insert command.

If you need further help let me know.

Nick

**0beron** · 12-13-2005, 02:24 PM

How is the form supposed to behave? Do you want people to be able to fill out an unlimited number of forms, and have the server remember and store the results for all of them? I would advise using sessions for this - you need to call session_start() at the top of all the pages that need to manipulate form data. Then you can assign things to elements of the special $_SESSION array, and these are carried over to the next page. You can even store multi dimensional arrays, so you might end up setting
$_SESSION['page'][1] = $_POST
on page one, which copies the entire form submission into the active session. Then on page two you can say
$_SESSION['page'][2] = $_POST
etc until all the forms are filled. Then when finished, your database insert code can look at the $_SESSION array which has all the data from as many pages as you want all in one place.

Sound like it might solve your problem? Let us know if you want more help on it.