Array confusion....
Posted: Thu Aug 02, 2007 3:28 am
I got this array which different names such as title, surname and so on......
Basically i'm not sure how to process it in this page(I have setup a for each loop, but this is where i get confused) Help please...
Code: Select all
echo" <tr>
<td><strong>Title:</strong></td>
<td><select name=title[]>
<option value=></option>
<option value=Mr>Mr</option>
<option value=Mrs>Mrs</option>
<option value=Ms>Ms</option>
<option value=Master>Master</option>
</select></td>
</tr>
<tr>
<td><strong>First name:</strong></td>
<td><input type=text name=firstname[]></td>
</tr>
<tr>
<td height=32><strong>Surname:</strong></td>
<td><input type=text name=surname[]></td>
</tr>
<tr>
<td><strong>Child/Adult:</strong></td>
<td><select name=ChildAdult[]>
<option value=></option>
<option value=1>Child</option>
<option value=2>Adult</option>
</select></td>
</tr>
<tr>
<td><strong>Cost:</strong></td>
<td><input type=text name=cost[]></td>
</tr>
<tr>
<td width=17><strong>Notes:</strong></td>
<td width=83><textarea name=notes[]></textarea></td>
</tr>
<tr>
<td></td></tr>"
;
$numofpass = $numofpass-1;
}
?>Code: Select all
<?PHP include 'opendb.php'; ?>
<?PHP include 'header.php'; ?>
<?php
$title = $_GET['title'];
$firstname = $_GET['firstname'];
$surname = $_GET['surname'];
$ChildAdult = $_GET['ChildAdult'];
$cost = $_GET['cost'];
$notes = $_GET['notes'];
$FlightID = $_GET['FlightID'];
$ClientDetailID = $_GET['ClientDetailID'];
foreach()
{
//----Query 5------
$query = mssql_init ("sp_insertFlightSpaces");
mssql_bind($query, "@FlightID", $FlightID, SQLVARCHAR);
mssql_bind($query, "@ChildOrAdult", $UserNames, SQLVARCHAR);
mssql_bind($query, "@ClientDetailID", $ClientDetailID, SQLINT2);
mssql_bind($query, "@cost", $forename, SQLVARCHAR);
mssql_bind($query, "@notes", $forename, SQLVARCHAR);
mssql_bind($query, "@Title", $forename, SQLVARCHAR);
mssql_bind($query, "@FirstName", $forename, SQLVARCHAR);
mssql_bind($query, "@Surname", $forename, SQLVARCHAR);
if (($result = mssql_execute($query)) === false)
{
die('Could not execute the query query 2(Insert client)');
}
///--------------------------------------------
}
mssql_close()
?>
<?PHP include 'footer.php'; ?>