JComboを使用してチェーンコンボボックスを作成する

debugcn 投稿 Dev

xplody

私の現在のコードが機能しないので、コードの助けを求めたいです...このサイトからこのプラグインコードを見つけましたここをクリックしてください...今のところ、最初のコンボボックスフィルタリングでもすべてが機能していません...誰でも助けることができますこのコードを動作させてください。

ここに画像の説明を入力してください

index.php：

<!DOCTYPE html>
<html>
<head>
<title>test</title>
<script type="text/javascript" src="jquery/jquery-1.11.0.min.js"></script>
<script type="text/javascript" src="jquery.jCombo.min.js"></script>
<script type="text/javascript" src="jquery.jCombo.js"></script>
</head>
<body>
<form>
<select name="position" id="position"></select>
<select name="salary_grade" id="salary_grade"></select>
<select name="salary" id="salary"></select>
</form>
<script type="text/javascript">
$( document ).ready(function() { 
   $("#position").jCombo({ url: "getPosition.php", selected_value : '150' } );
    $("#salary_grade").jCombo({ url: "getSalary_Grade.php?sgid=",
                    parent: "#position",
                    selected_value: '178'
                });     
    $("#salary").jCombo({ url: "getSalary.php?salaryid=",
                    parent: "#salary_grade",
                    selected_value: '630'
                });
});
</script>
</body>
</html>

getPosition.php：

<?php

    // Connect Database
    mysql_connect("localhost","root","");     
    mysql_select_db("test");

    // Execute Query in the right order  
    //(value,text)
    $query = "SELECT tcode, position FROM positions";
    $result = mysql_query($query);
    $items = array();
    if($result && mysql_num_rows($result)>0) {
        while($row = mysql_fetch_array($result)) {
            $option = array("id" => $row[0], "value" => htmlentities($row[1]));
            $items[] = $option; 
        }        
    }
    mysql_close();
    $data = json_encode($items); 
    // convert into JSON format and print
    $response = isset($_GET['callback'])?$_GET['callback']."(".$data.")":$data; 
    echo $data;
?>

getSalary_Grade.php：

<?php

    // Connect Database 
    mysql_connect("localhost","root","");     
    mysql_select_db("test");

    // Get parameters from Array
    $sgid = !empty($_GET['tcode'])
              ?intval($_GET['tcode']):0;

    // if there is no city selected by GET, fetch all rows    
    $query = "SELECT id,salary FROM salary_grades WHERE salary_grades.id = '$sgid'"; 

    //  fetch the results
    $result = mysql_query($query);
    $items = array();
    if($result && mysql_num_rows($result)>0) {
        while($row = mysql_fetch_array($result)) {
            $option = array("id" => $row[0], "value" => htmlentities($row[1]));
            $items[] = $option; 
        }        
    } 
    mysql_close();
    $data = json_encode($items); 
    $response = isset($_GET['callback'])?$_GET['callback']."(".$data.")":$data; 
    $cache->finish($response);  
?>

getSalary.php：

<?php

    // Connect Database 
    mysql_connect("localhost","root","");     
    mysql_select_db("test");

    // Get parameters from Array
    $salaryid = !empty($_GET['id'])
              ?intval($_GET['id']):0;

    // if there is no city selected by GET, fetch all rows    
    $query = "SELECT id,salary FROM salarys WHERE salarys.id = '$salaryid'"; 

    //  fetch the results
    $result = mysql_query($query);
    $items = array();
    if($result && mysql_num_rows($result)>0) {
        while($row = mysql_fetch_array($result)) {
            $option = array("id" => $row[0], "value" => htmlentities($row[1]));
            $items[] = $option; 
        }        
    } 
    mysql_close();
    $data = json_encode($items); 
    $response = isset($_GET['callback'])?$_GET['callback']."(".$data.")":$data; 
    $cache->finish($response);  
?>

display-name-is-missing

これは機能するはずです：

getSalary.php

// Connect Database 
mysql_connect("localhost","root",""); 
mysql_select_db("klayton"); 

// Get parameters from Array 
$salaryid = !empty($_GET['salaryid']) 
?intval($_GET['salaryid']):0; 

// if there is no city selected by GET, fetch all rows 
$query = "SELECT id,salary FROM salarys WHERE id = $salaryid"; 

// fetch the results 
$result = mysql_query($query); 
$items = array(); 
if($result && mysql_num_rows($result)>0) { 
while($row = mysql_fetch_array($result)) { 
$option = array("id" => $row['id'], "value" => htmlentities($row['salary'])); 
$items[] = $option; 
} 
}

getSalary_Grades.php

<?php 

// Connect Database 
mysql_connect("localhost","root",""); 
mysql_select_db("klayton"); 

// Get parameters from Array 
$sgid = !empty($_GET['sgid']) 
?intval($_GET['sgid']):0;

// if there is no city selected by GET, fetch all rows 
$query = "SELECT id, salary FROM salary_grades WHERE id = $sgid"; 

// fetch the results 
$result = mysql_query($query); 
$items = array(); 
if($result && mysql_num_rows($result)>0) { 
while($row = mysql_fetch_array($result)) { 
$option = array("id" => $row['id'], "value" => htmlentities($row['salary'])); 
$items[] = $option; 
} 
}

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]