1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106
| <?php session_start(); ?>
<html>
<head>
<?php
../..
$a = 0;
$cat_sql = "SELECT distinct(DOBRAND) FROM myfile order by DOBRAND ASC";
$cat_qry = mysql_query($cat_sql,$link);
while($cat_row = @mysql_fetch_array($cat_qry, MYSQL_ASSOC)){
$brandl[$a] = $cat_row['DOBRAND'];
$a++;
}
echo '<script language="JavaScript" type="text/JavaScript">
function selectModel(){
removeAllOptions(document.myform.domodel);';
for($a = 0; $a<sizeof($brandl); $a++){
echo 'if(document.myform.brand.value == "'.$brandl[$a].'"){';
$model_sql = "SELECT distinct(DOMODEL) FROM myfile WHERE DOMAINDO=0 AND DOBRAND='".$brandl[$a]."'";
$model_qry = mysql_query($model_sql,$link);
while($model_row = @mysql_fetch_array($model_qry, MYSQL_ASSOC)){
echo 'addOption(document.myform.domodel,"'.$model_row['DOMODEL'].'","'.$model_row['DOMODEL'].'");';
}//end of while loop
echo '}';
}//end of for loop
echo '
if(document.myform.brand.value == ""){
removeAllOptions(document.myform.domodel);
addOption(document.myform.domodel,"", "Select model");
}';
echo '}//end of function selectModel()';
echo '
function removeAllOptions(selectbox){
var i;
for(i=selectbox.options.length-1;i>=0;i--){
selectbox.remove(i);
}
}
function addOption(selectbox, value, text ){
var optn = document.createElement("OPTION");
optn.text = text;
optn.value = value;
selectbox.options.add(optn);
}
</script>';
?>
</head>
<body>
<form name="myform" method="post" action="record_public.php" enctype="multipart/form-data" >
<b>brand :</b>
<select name="brand" id="brand" onChange="selectModel()">
<option value="">- New brand -</option>
<?php
for($a = 0; $a<sizeof($brandl); $a++){
echo '<option value="'.$brandl[$a].'">'.$brandl[$a].'</option>';
}
?>
<br>
<b>model :</b>
<select name="domodel" id="domodel">
<?php
if(isset($_SESSION['model'])) {
echo '<option value="'.$_SESSION['model'].'">'.$_SESSION['model'].'</option>';
echo '<script>document.myform.domodel.selectedIndex = 1</script>';
}
Else
echo '<option value="">Select model</option>';
?>
</select>
<input type="submit" value="Record">
</form>
</BODY>
</HTML>
--------- record_public.php ----------------
<?php session_start(); ?>
<HTML>
<body>
<?php
$domodel = $_POST[domodel];
../..
If (trim($domodel) !='') $_SESSION['model'] = $domodel;
../..
?>
</BODY>
</HTML> |
Partager