[RESOLVED] Dynamic dropdown list

roscor

Hi, I have been looking at this subject for weeks and cannot get my head around it.

I have created a dynamic 3 tier list using this http://www.dynamicdrive.com/dynamicindex16/chainedselects/index.htm as a template

I have since created the fields to represent, country, county and town all using javascript and addoption(). This code is quite large as I have included most large towns to counties in England. I will need to expand shortly and need to sort this first.

These three dropdowns workalong with a large form including 20 other text boxes.

When I submit to my database I get a null value.

Is this a Javascript or PHP issue. I have looked at using certain Javascript functions such as document.getElementById but I am not up on Javascript. Do I need to look at Ajax or rethink my PHP by populating the dropdown from my database. I have tried google plus many forums but have come back to phpbuilder hoping that someone can advise or point me in the right direction. Here Is a simple version of my code so far so that I can test the working structure.

<? session_start();
if (empty($_SESSION['valid_user'])){
header("location:../userlogin.php");
exit();
}
?>

<!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=iso-8859-1" />
<title>Add Tenants Data</title>

<script language="javascript" src="chainedmenu.js"></script>
<script language="javascript" src="config.js"></script>

<body onload="initListGroup('chainedmenu', document.listmenu0.country, document.listmenu0.county, document.listmenu0.town, 'saveit')">

</head>

<body>

<?php

if($_POST['submit']=="send") {

     include("dbinfo.inc.php");
  $town=$_POST['town'];
  $county=$_POST['county'];
  $country=$_POST['country'];


mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO tenant_data SET
id = '',
town = '$town',
county = '$county',
country = '$country'";
mysql_query($query);

mysql_close();
    }

?>





<form name="listmenu0" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" >
<table width="800" align="center">

<tr>
<td><select name="country" id="country" style="width:180px;" value="<? echo $country; ?>"></select></td>

<td><select name="county" id="county" style="width:160px;" value="<? echo $county; ?>"></select></td>

<td><select name="town" id="town" style="width:160px;" value="<? echo $town; ?>"></select></td>

<td><input type="button" value="Reset" onclick="resetListGroup('chainedmenu')"><input name="submit" type="submit" value="send"></td>

</tr>
</table>
</form>


</body>


</html>

regards

roscor

etully

Just before thise line: mysql_query($query);
print the value of $query and examine it for any obvious errors. Seeing the values will help you determine why the record isn't getting inserted.

If you can't see the problem in the query, try pasting it to the MySQL command line and see if MySQL returns any errors.

roscor

Hi thanks for replying etully,
I tried print_r($query) and print_r($_POST) and got

INSERT INTO tenant_data SET id = '', town = '', county = '', country = ''

Array ( [country] => [county] => [town] => [submit] => send )

still strugleing with this one, Is there a javascript function that i am missing?

alxweb

Change the post attribute equal to the name of the file rather than use $_SERVER['PHP_SELF']

Use

rather than

<input name="submit" type="submit" value="send">

roscor

Resolved this issue,

for others-

addListGroup("chainedmenu", "First-Select");

addOption("First-Select", "Select a Country", "", 1); //HEADER OPTION
addList("First-Select", "England", "England", "England");

The third "" on addlist("First-Select", "Select a Country", "England","England", 1); //HEADER OPTION
must be populated or the list expects to go to the next level. When a value is there it then reads and will execute command $_POST.

so further

addListGroup("chainedmenu", "First-Select");

addOption("First-Select", "Select a Country", "", 1); //HEADER OPTION
addList("First-Select", "England", "England", "England");

addOption("England", "Select a County", "", 1); //HEADER OPTION
addList("England", "Bedfordshire", "Bedfordshire", "Bedfordshire-Towns");

addOption("Bedfordshire-Towns", "Select a Town/Area", "", 1); //HEADER OPTION
addOption("Bedfordshire-Towns", "Ampthill","Ampthill");

and so on.
Hope this helps others, I just had to read the write up properly on dynamic Drive.

roscor