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

<?
session_start();
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
header("content-type: application/x-javascript; charset=UTF-8");

    $data=$_GET['data'];
     $val=$_GET['val'];
     $val2=$_GET['val2'];
    
    $handle=mysql_connect($_SESSION['hostname'],$_SESSION['user'],$_SESSION['passwd']) or die("connect to database fail");
    $result1=mysql_select_db($_SESSION['dbname'],$handle) or die ("͡");

        $charset = "SET character_set_results=utf8";
        $charset="SET NAMES 'utf8'";
        mysql_query($charset) or die('Invalid query: ' . mysql_error());
        echo"<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
        

    if ($data=='lv1') // first dropdown  
        {  
             $sql_lv1 = "SELECT name,id_product FROM cms_product WHERE id_parent = '0'  AND `condition` =  '1' ORDER BY name ASC";
            $result_lv1 = mysql_query($sql_lv1) or die (mysql_error()); 
            echo "<select name='lv1' id='lv1' onChange=\"dochange('lv2', this.value, '$val2')\">\n";
            echo "<option value=''>===หมวดสินค้า่หลัก===</option>\n";
         
              while($data_result_lv1=mysql_fetch_array($result_lv1))
                {  
                        if($val==$data_result_lv1['id_product'])
                        echo "<option value=".$data_result_lv1['id_product']." selected='selected'>".$data_result_lv1['name']."</option>\n" ; 
                        else
                        echo "<option value=".$data_result_lv1['id_product']." >".$data_result_lv1['name']."</option>\n" ; 
                }
        
    } 
    
    
    
    else if ($_GET[data]=="lv2") 
    { // second dropdown
            
             $sql_lv2 = "SELECT `id_product`, `name` FROM cms_product WHERE `id_parent` = '$val'  and `condition` =  '1' ORDER BY `name` ASC ";            
            $result_lv2 = mysql_query($sql_lv2); 
            
        echo "<select name='lv2'>\n";   
        echo "<option value=''>====หมวดสินค้ารอง====</option>\n";  
         
        while($data_result_lv2=mysql_fetch_array($result_lv2))
             {  
                         if($val2==$data_result_lv2['id_product'])
                        echo "<option value=".$data_result_lv2['id_product']." selected='selected'>".$data_result_lv2['name']."</option>\n" ; 
                        else
                        echo "<option value=".$data_result_lv2['id_product'].">".$data_result_lv2['name']."</option>\n" ;             
             }
        echo "</select>\n";
    }

?>