hello i have problem with this code..I want to keep the
values of the textboxes when the pageload and didnt write again the
values. I have two drop down list. the First one is the country when the country selected then the page load and appear the city to select but afte the pageload the
values on textbox is empty. I want to keep the
values of textbox when the page load.
This is the code
<head>
<script type="text/javascript">
function Load_id() {
var Count = document.getElementById("Count").value;
var Count_txt = "?Count="
location = Count_txt + Count
}
</script>
<meta charset="UTF-8">
</head>
<body>
<div class="main">
<div class="headers">
<table>
<tr><td rowspan="2"><img alt="unipi" src="/Images/logo.jpeg" height="75" width="52"></td>
<td>University</td></tr>
<tr><td>Data</td></tr>
</table>
</div>
<div class="form">
<h3>Personal</h3><br/><br/><br/>
<form id="Page1" name="Page1" action="Form1Sub.php" method="Post">
<table style="width:520px;text-align:left;">
<tr><td><label>Number:</label></td>
<td><input type="text" required="required" id="AM" name="AM" value=""/></td>
</tr>
<tr><td><label>Name:</label></td>
<td><input type="text" required="required" name="Name"/></td>
</tr>
<?php
$host="localhost";
$username="";
$password="";
$dbName="Database";
$connection = mysql_connect($host, $username, $password) or die("Couldn't Connect to the Server");
$db = mysql_select_db($dbName, $connection) or die("cannot select DataBase");
$Count = $_GET['Count'];
echo "<tr><td><label>Country</label></td>\n";
$country = mysql_query("select DISTINCT Country FROM lut_country_city ");
echo " <td><select id=\"Count\" name=\"cat\" onChange=\"Load_id(this)\">\n";
echo " `<option>Select Country</option>\n";
while($nt=mysql_fetch_array($country)){
$selected = ($nt["Country"] == $Count)? "SELECTED":"";
echo"<option value=\"".$nt['Country']."\"". $selected." >".$nt['Country']."</option>";
}
echo " </select></td></tr>\n";
echo"<tr><td><label>City:</label></td>\n";
$q2 = mysql_query("Select id,City,Country FROM lut_country_city WHERE Country = '$Count'");
echo"<td><select name=\"SelectCity\">\n";
while($row = mysql_fetch_array($q2)) {
echo"<option value=\"".$row['id']."\">".$row['City']."</option>";
}
echo " </select></td></tr>\n";
?>
</table>
<p>
<button type="submit" id="Next">Next</button>
</form>
<form id="form1" action="index.php">
<button id="Back" type="submit">Back</button>
</form>
</p>
</div>
</div>
</body>
</html>
