php drop down menu help | Member | | Join Date: Jan 2009 Location: USA
Posts: 118
| | |
hello -
i've created a drop down menu in dreamweaver, it selects my states from a list table that i have for users table.
I went from enum to list table and created a fk to the parent table.
i'm use to doing in access a lookup filed to a list this is what i'm trying to pretty much accomplish.
i'm able to pull the data no problem. just when it goes to insert into the child table to states it errors. cannot add or update a child row. because it's trying to insert the wrong data type.
how can i query both items from the parent and insert only the selected states primary_id not name into the child table?
thanks in advance for your help
|  | Moderator | | Join Date: Jun 2007 Location: York, England, with wolves.
Posts: 4,948
| | | re: php drop down menu help
Can you provide the code you have used to try this. Also, any error messages and any info that could be useful. Also, maybe an example (in concise english) of what the outcome should be.
| | Member | | Join Date: Jan 2009 Location: USA
Posts: 118
| | | re: php drop down menu help
sorry i've been up late programming and kind!
1. create a drop down list.
2. when the item is selected, insert it's id, not name into the table
I'm able to query the database for the drop down menu items, but i can't think of a way to insert the id and not the item name. -
<?php require_once('Connections/userstatesTest.php'); ?>
-
<?php require_once('Connections/enumTest.php'); ?>
-
<?php
-
if (!function_exists("GetSQLValueString")) {
-
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
-
{
-
if (PHP_VERSION < 6) {
-
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
-
}
-
-
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 users (users_id, users_name, states_id) VALUES (%s, %s, %s)",
-
GetSQLValueString($_POST['users_id'], "int"),
-
GetSQLValueString($_POST['users_name'], "text"),
-
GetSQLValueString($_POST['states_id'], "int"));
-
-
mysql_select_db($database_enumTest, $enumTest);
-
$Result1 = mysql_query($insertSQL, $enumTest) or die(mysql_error());
-
}
-
-
mysql_select_db($database_userstatesTest, $userstatesTest);
-
$query_Recordset1 = "SELECT * FROM states";
-
$Recordset1 = mysql_query($query_Recordset1, $userstatesTest) 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">
-
<html xmlns="http://www.w3.org/1999/xhtml">
-
<head>
-
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
-
<title>Untitled Document</title>
-
</head>
-
-
<body>
-
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
-
<table align="center">
-
<tr valign="baseline">
-
<td nowrap="nowrap" align="right">Users_id:</td>
-
<td><input type="text" name="users_id" value="" size="32" /></td>
-
</tr>
-
<tr valign="baseline">
-
<td nowrap="nowrap" align="right">Users_name:</td>
-
<td><input type="text" name="users_name" value="" size="32" /></td>
-
</tr>
-
<tr valign="baseline">
-
<td nowrap="nowrap" align="right">States_id:</td>
-
<td><select name="states_id">
-
<?php
-
do {
-
?>
-
<option value="<?php echo $row_Recordset1['states_name']?>" ><?php echo $row_Recordset1['states_name']?></option>
-
<?php
-
} while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
-
?>
-
</select></td>
-
</tr>
-
<tr> </tr>
-
<tr valign="baseline">
-
<td nowrap="nowrap" align="right"> </td>
-
<td><input type="submit" value="Insert record" /></td>
-
</tr>
-
</table>
-
<input type="hidden" name="MM_insert" value="form1" />
-
</form>
-
<p> </p>
-
</body>
-
</html>
-
<?php
-
mysql_free_result($Recordset1);
-
?>
-
-
-
error message was child constraint, that because it's trying to insert the name, not id into the child table.
i have a states table -
| states | CREATE TABLE `states` (
-
`states_id` bigint(20) NOT NULL DEFAULT '0',
-
`states_name` varchar(255) DEFAULT NULL,
-
PRIMARY KEY (`states_id`)
-
) ENGINE=InnoDB
-
here is the users table -
| users | CREATE TABLE `users` (
-
`users_id` bigint(20) NOT NULL DEFAULT '0',
-
`users_name` varchar(20) DEFAULT NULL,
-
`states_id` bigint(20) NOT NULL DEFAULT '0',
-
PRIMARY KEY (`users_id`,`states_id`),
-
KEY `states_id` (`states_id`),
-
CONSTRAINT `users_ibfk_1` FOREIGN KEY (`states_id`) REFERENCES `states` (`states_id`) ON DELETE CASCADE ON UPDATE CASCADE
-
) ENGINE=InnoDB
-
thanks again for your help!
| | Member | | Join Date: Jan 2009 Location: USA
Posts: 118
| | | re: php drop down menu help
also, states is a list table with a 1 => 8 to users.
| | Moderator | | Join Date: Jun 2007 Location: York, England, with wolves.
Posts: 4,948
| | | re: php drop down menu help
My eyes hurt. Anyway, why not pass the states ID instead of it's name to the value attribute of the drop down. Or am I misunderstanding your problem?
| | Member | | Join Date: Jan 2009 Location: USA
Posts: 118
| | | re: php drop down menu help
the drop down wont display the name of the state if i pass it the state id, unless you know how?
| | Member | | Join Date: Jan 2009 Location: USA
Posts: 118
| | | re: php drop down menu help
ok i've got it accomplished thanks for your help.
it was a setting on the app side that i need to call entity states_name, but get the states_id value for insert
| | Moderator | | Join Date: Jun 2007 Location: York, England, with wolves.
Posts: 4,948
| | | re: php drop down menu help
Quote:
Originally Posted by wizardry  ok i've got it accomplished thanks for your help.
it was a setting on the app side that i need to call entity states_name, but get the states_id value for insert Glad you got it working.
- Markus.
|  |
| | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,471 network members.
|
