| 12
 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