<html><head><title>aFe Catalog Test v3</title>
</style>
<script type="text/javascript" src="ajax/ajax.js"></script>
<script type="text/javascript">
var ajax = new sack();
var selYear;
var selMake;
var selModel;
function getMake(sel) {
selYear = sel.options[sel.selectedIndex].value;
if(selYear.length>0){
ajax.requestFile = 'getsearch.php?getmake=1&year='+selYear; // Specifying what to get
ajax.onCompletion = createDropdownMake; // Specify function that will be executed after file has been found
ajax.runAJAX(); // Execute AJAX function
}
}
function createDropdownMake() {
document.getElementById("divmsg").innerHTML = ajax.response;
}
function getModel(sel) {
selMake = sel.options[sel.selectedIndex].value;
if(selMake.length>0){
ajax.requestFile = 'getsearch.php?getmodel=1&make='+selMake+'&year='+selYear; // Specifying what to get
ajax.onCompletion = createDropdownModel; // Specify function that will be executed after file has been found
ajax.runAJAX(); // Execute AJAX function
}
}
function createDropdownModel() {
document.getElementById("divmsg").innerHTML = ajax.response;
}
function getDesc(sel) {
selModel = sel.options[sel.selectedIndex].value;
if(selModel.length>0){
ajax.requestFile = 'getsearch.php?getdesc=1&model='+selModel'&=make'+selMake+'&year='+selYear; // Specifying what to get
ajax.onCompletion = createDesc; // Specify function that will be executed after file has been found
ajax.runAJAX(); // Execute AJAX function
}
}
function createDesc() {
document.getElementById("divmsg").innerHTML = ajax.response;
}
</script>
</head>
<body>
<?php
// ================================================== ===
// Populate the YEARS selection list from the database
// ================================================== ===
echo '<u><b>aFe Vehicle Search Browser v3</b></u>
<form action="" method="post">
Select year:
<select id="years" name="years" style="width: 170" onchange="getMake(this)">
<option value="">Select</option>';
// Connection to the Database
include ('db functions/db_connect.php');
$res = mysql_query("SELECT year FROM Catalog GROUP BY year ORDER BY year DESC")
or die("Invalid query: " . mysql_query());
while ($row = mysql_fetch_assoc($res)) {
$yr = $row['year'];
echo "<option value=$yr>$yr</option>";
}
echo '</select>';
?>
<div id="divmsg" />
</form>
</body></html>
<?php
// Connection to the Database
include ('db functions/db_connect.php');
// Get the make after user searched year.
if(isset($_GET['getmake']) AND isset($_GET['year'])){
$yr = $_GET['year'];
$res = mysql_query("SELECT make FROM Catalog WHERE year=$yr GROUP BY make ORDER BY make")
or die("Invalid query: " . mysql_query());
echo 'Select make: ';
echo '<select id="make" name="make" style="width: 170" onchange="getDesc(this)">';
echo '<option value="">Select</option>';
while ($row = mysql_fetch_assoc($res)) {
$mk = $row['make'];
echo "<option value=$mk>$mk</option>";
}
echo '</select>';
}
// Get the model after user searched make.
if(isset($_GET['getmodel']) AND isset($_GET['year']) AND isset($_GET['make'])){
$yr = $_GET['year'];
$mk = $_GET['make'];
$mo = $_GET['model];
$res = mysql_query("SELECT model FROM Catalog WHERE year=$yr GROUP BY model ORDER BY model")
or die("Invalid query: " . mysql_query());
echo 'Select Model: ';
echo '<select id="model" name="model" style="width: 170" onchange="getModel(this)">';
echo '<option value="">Select</option>';
while ($row = mysql_fetch_assoc($res)) {
$mo = $row['model'];
echo "<option value=$mo>$mo</option>";
}
echo '</select>';
}
// Get the description
if(isset($_GET['getdesc']) AND isset($_GET['make']) AND isset($_GET['year']) AND isset($_GET['model'])){
$mk = $_GET['make'];
$yr = $_GET['year'];
$mo = $_GET['model];
$res = mysql_query("SELECT exppartno FROM Catalog WHERE year=$yr AND make=$mk AND model=$mo")
or die("Invalid query: " . mysql_query());
echo "Make: $mk<br />";
$res = mysql_query("SELECT exppartno FROM Catalog WHERE year=$yr GROUP BY exppartno ORDER BY exppartno")
or die("Invalid query: " . mysql_query());
while ($row = mysql_fetch_assoc($res)) {
$ds = $row['exppartno'];
echo "<p><b>Part Number:</b> $ds <br></p>";
}
}
?>
Comment