Пример #1
0
require_once "../includes/config.php";
//**************************************
//     Page load dropdown results     //
//**************************************
function getTierOne()
{
    $result = mysql_query("SELECT DISTINCT tier_one FROM two_drops") or die(mysql_error());
    while ($tier = mysql_fetch_array($result)) {
        echo '<option value="' . $tier['tier_one'] . '">' . $tier['tier_one'] . '</option>';
    }
}
//**************************************
//     First selection results     //
//**************************************
if ($_GET['func'] == "drop_1" && isset($_GET['func'])) {
    drop_1($_GET['drop_var'], $_GET['drop_var2']);
}
function drop_1($drop_var, $drop_var2)
{
    require_once "../includes/config.php";
    $result = mysql_query("SELECT * FROM faqcategory WHERE faqCategoryParentId='{$drop_var}'") or die(mysql_error());
    echo '<select name="tier_two" id="tier_two">';
    if (isset($_GET['action']) && $_GET['action'] == 'add') {
        ?>
	     <option value=" " disabled="disabled" selected="selected">Choose one</option>';
 <?php 
    }
    while ($drop_2 = mysql_fetch_array($result)) {
        ?>
            <option <?php 
        if ($drop_2['faqCategoryId'] == $drop_var2) {
<?php

function getFaculties()
{
    $query = "select faculty_name from faculty";
    $result = mysql_query($query);
    while ($faculty = mysql_fetch_array($result)) {
        $value = $faculty[0];
        echo '<option value="' . $value . '">
                Faculty of ' . $value . '</option>';
    }
}
if (isset($_GET['func']) && $_GET['func'] == "drop_1") {
    drop_1($_GET['drop_var'], $_GET['course_var']);
}
if (isset($_GET['load_courses']) && $_GET['load_courses'] == "load_courses") {
    load_courses($_GET['drop_var'], $_GET['course_var']);
}
function load_courses($drop_var, $course_var)
{
    include_once 'connection.php';
    $query = "select faculty_id from faculty where faculty_name='{$drop_var}'";
    $result = mysql_query($query);
    if ($result) {
        $value = mysql_fetch_assoc($result);
        $faculty_id = $value['faculty_id'];
        $query = "SELECT `course`.* FROM `course` JOIN `course_faculty` ON `course`.`course_id` = `course_faculty`.`course_id`\n            WHERE `course_faculty`.`faculty_id` = {$faculty_id} and `course`.`course` like  '%{$course_var}%'";
        $result = mysql_query($query);
        $row_count = mysql_num_rows($result);
        $num = $row_count % 3 == 0 ? $row_count / 3 : (int) ($row_count / 3) + 1;
        $count = 0;
    if (!is_numeric($drop_var)) {
        exit;
    }
    include_once 'dbconnect.php';
    $result = mysql_query("SELECT * FROM elite_level_model WHERE make_id={$drop_var} ORDER BY title asc") or die(mysql_error());
    echo '<select name="model" id="drop_3">
          <option value=" " disabled="disabled" selected="selected">Select Model</option>';
    while ($drop_3 = mysql_fetch_array($result)) {
        echo '<option value="' . $drop_3['id'] . '">' . $drop_3['title'] . '</option>';
    }
    echo '</select>';
    echo "<script type=\"text/javascript\"> \r\n        \r\n       \r\n        jQuery('#drop_3').change(function() {\r\n            \r\n            jQuery('#cpkBtn').show('fast');\r\n            });\r\n            \r\n        </script>";
    //echo "<script type=\"text/javascript\">$('#wait_2').hide();</script>";
    //echo '<input type="button" class="vafSubmit" value="Search">';
    //echo '<img id="goBtn" src="goBtn.png"/>';
}
//**************************************
//     First selection results     //
//**************************************
if (isset($_GET['func'])) {
    if ($_GET['func'] == "drop_1") {
        drop_1($_GET['drop_var']);
    }
    //**************************************
    //     Second selection results     //
    //**************************************
    //$result = mysql_query("SELECT * FROM elite_level_model WHERE make_id=$drop_var ORDER BY title desc")
    if ($_GET['func'] == "drop_2") {
        drop_2($_GET['drop_var']);
    }
}