Multple Form Variables

yandoo · January 25, 2008

Hi there,

Is it possible to have mutliple form variables in a form on one page thats will POST the details of the record (Primary ID key) to another page but also post another attribute from page one also???

I have 2 pages "stage 1 & stage 2"

Stage 1 is simple form to input details of an animal - the record inserted and takes user to stage 2

Stage 2 is a complete replication of the stage 1 with a few additonal details that the user can add. In stage 2 a query displays the last updated record in the database (which is what the user has just inserted)

One of the additional details in stage 2 is the Breed of the animal. This is presented in a list menu of all the breeds avaliable.... This is where my problem is!!

Inorder for me display only the relevant animal breeds in the list menu, i must select ONLY the animal breed that is of the AnimalType that has been inserted in the previous page and displayed here.

So somehow i need a query that will compare the AnimalType From both breed table and (last updated)Animal table???

On stage 1 i added a php POST of the AnimalTypeID.......I then created a query on stage 2 that Selected only records from Breed table WHERE AnimalTypeID(of breed table) = AnimalTypeID (of animal table)

It doesnt work??? It doesnt display any breeds at all????????

Heres what my tables look like:

Table "Animal"

AnimalID - (primary)

AnimalTypeID -(index)

BreedID -(index)

AnimalName

Age

Sex

Table "AnimalType"

AnimalTypeID - (primary)

AnimalTypeName

Table "Breed"

BreedID - (primary)

AnimalTypeID -(index)

BreedName

Heres what my 2 pages (Stage 1 and Stage 2) look like:

Stage 1

<?php require_once('Connections/woodside.php'); ?>

<?php

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {

$insertSQL = sprintf("INSERT INTO animal (AnimalID, AnimalTypeID, Name, Age, Sex, `Date`, `Time`, HouseTrained, ExpCat, ExpDog, ExpCar, ExpChild, ExpAlone, ExpOnlead, ExpOffLead, Valid) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",

GetSQLValueString($_POST['AnimalID'], "text"),

GetSQLValueString($_POST['select'], "text"),

GetSQLValueString($_POST['Name'], "text"),

GetSQLValueString($_POST['select3'], "int"),

GetSQLValueString($_POST['select4'], "text"),

GetSQLValueString($_POST['Date'], "date"),

GetSQLValueString($_POST['hiddenField'], "date"),

GetSQLValueString(isset($_POST['checkbox']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['checkbox2']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['checkbox3']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['checkbox4']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['checkbox5']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['checkbox6']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['checkbox7']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['checkbox8']) ? "true" : "", "defined","1","0"),

GetSQLValueString($_POST['hiddenField'], "int"));

mysql_select_db($database_woodside, $woodside);

$Result1 = mysql_query($insertSQL, $woodside) or die(mysql_error());

$insertGoTo = "stage2.php";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

mysql_select_db($database_woodside, $woodside);

$query_Recordset1 = "SELECT AnimalTypeID FROM animaltype";

$Recordset1 = mysql_query($query_Recordset1, $woodside) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<td nowrap align="right">AnimalID:</td>

</tr>

<td nowrap align="right">AnimalTypeID:</td>

<?php

do {

?>

<?php

} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));

$rows = mysql_num_rows($Recordset1);

if($rows > 0) {

mysql_data_seek($Recordset1, 0);

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

}

?>

</select>

</label></td>

</tr>

</tr>

</select>

</label></td>

</tr>

</select>

</label></td>

</tr>

<td><p>

</p>

</td>

</tr>

<td><input type="hidden" name="hiddenField2" value="<?php

$now = getdate(time('G'));

echo $now['hours'] . ":" . $now['minutes'] . ":" . $now['seconds'];

?>

<?php

$now = getdate(time('G'));

$hours = $now['hours'];

$minutes = str_pad($now['minutes'], 2, "0", STR_PAD_LEFT);

$seconds = str_pad($now['seconds'], 2, "0", STR_PAD_LEFT);

echo $hours.":". $minutes.":".$seconds;

?>" /></td>

</tr>

<td nowrap align="right">HouseTrained:</td>

</label></td>

</tr>

<td nowrap align="right">ExpCat:</td>

</tr>

<td nowrap align="right">ExpDog:</td>

</tr>

<td nowrap align="right">ExpCar:</td>

</tr>

<td nowrap align="right">ExpChild:</td>

</tr>

<td nowrap align="right">ExpAlone:</td>

</tr>

<td nowrap align="right">ExpOnlead:</td>

</tr>

<td nowrap align="right">ExpOffLead:</td>

</tr>

<td nowrap align="right">Valid:</td>

</tr>

</tr>

</table>

<?php $_GET['AnimalTypeID']; ?></form>

</body>

</html>

<?php

mysql_free_result($Recordset1);

?>

and stage 2...

<?php require_once('Connections/woodside.php'); ?>

<?php

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {

$updateSQL = sprintf("UPDATE animal SET AnimalTypeID=%s, BreedID=%s, Name=%s, Age=%s, Sex=%s, `Date`=%s, HouseTrained=%s, ExpCat=%s, ExpDog=%s, ExpCar=%s, ExpChild=%s, ExpAlone=%s, ExpOnlead=%s, ExpOffLead=%s, Valid=%s WHERE AnimalID=%s",

GetSQLValueString($_POST['AnimalTypeID'], "text"),

GetSQLValueString($_POST['BreedID'], "text"),

GetSQLValueString($_POST['Name'], "text"),

GetSQLValueString($_POST['Age'], "int"),

GetSQLValueString($_POST['Sex'], "text"),

GetSQLValueString($_POST['Date'], "date"),

GetSQLValueString(isset($_POST['HouseTrained']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['ExpCat']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['ExpDog']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['ExpCar']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['ExpChild']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['ExpAlone']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['ExpOnlead']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['checkbox']) ? "true" : "", "defined","1","0"),

GetSQLValueString(isset($_POST['Valid']) ? "true" : "", "defined","1","0"),

GetSQLValueString($_POST['AnimalID'], "text"));

mysql_select_db($database_woodside, $woodside);

$Result1 = mysql_query($updateSQL, $woodside) or die(mysql_error());

$updateGoTo = "stage2.php";

if (isset($_SERVER['QUERY_STRING'])) {

$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";

$updateGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $updateGoTo));

}

mysql_select_db($database_woodside, $woodside);

$query_animal = "SELECT * FROM animal ORDER BY AnimalID DESC";

$animal = mysql_query($query_animal, $woodside) or die(mysql_error());

$row_animal = mysql_fetch_assoc($animal);

$totalRows_animal = mysql_num_rows($animal);

$colname_Recordset1 = "-1";

if (isset($_POST['AnimalTypeID'])) {

$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['AnimalTypeID'] : addslashes($_POST['AnimalTypeID']);

}

mysql_select_db($database_woodside, $woodside);

$query_Recordset1 = sprintf("SELECT BreedID FROM breed WHERE AnimalTypeID = '%s'", $colname_Recordset1);

$Recordset1 = mysql_query($query_Recordset1, $woodside) or die(mysql_error());

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$breedtype = "SELECT BreedID, Breed.AnimalTypeID FROM Breed

INNER JOIN AnimalType ON AnimalType.AnimalTypeID = Breed.AnimalTypeID";

$result = mysql_query($breedtype) or die(mysql_error());

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<td nowrap align="right">AnimalID:</td>

</tr>

<td nowrap align="right">AnimalTypeID:</td>

</tr>

<td nowrap align="right">BreedID:</td>

<?php

do {

?>

<?php

} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));

$rows = mysql_num_rows($Recordset1);

if($rows > 0) {

mysql_data_seek($Recordset1, 0);

$row_Recordset1 = mysql_fetch_assoc($Recordset1);

}

?>

</select>

</label>

</tr>

</tr>

</tr>

</tr>

</tr>

<td nowrap align="right">HouseTrained:</td>

</tr>

<td nowrap align="right">ExpCat:</td>

</tr>

<td nowrap align="right">ExpDog:</td>

</tr>

<td nowrap align="right">ExpCar:</td>

</tr>

<td nowrap align="right">ExpChild:</td>

</tr>

<td nowrap align="right">ExpAlone:</td>

</tr>

<td nowrap align="right">ExpOnlead:</td>

</tr>

<td nowrap align="right">ExpOffLead:</td>

<label>

<input <?php if (!(strcmp($row_animal['ExpOffLead'],1))) {echo "checked=\"checked\"";} ?> type="checkbox" name="checkbox" value="checkbox" />

</label></td>

</tr>

<td nowrap align="right">Valid:</td>

</tr>

</tr>

</table>

<?php echo $breedtype;?>

</form>

<?php echo $row_animal['AnimalTypeID']?>

</body>

</html>

<?php

mysql_free_result($animal);

mysql_free_result($Recordset1);

?>

If anybody can help me please do id be most greatful as im really stuck now..

Thanks for listneing

Tom

Sign In

Multple Form Variables

Recommended Posts

yandoo

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information