php从数据库选择项,php-根据其他选择选项从数据库中提供选择...

当一个选择更改从服务器获取数据以馈送其他选择时,只需为此使用ajax.

$(function() {

$('.select_one').change(function() {

var select = $('.select_two').empty();

$.get('script.php', {region: $(this).val()}, function(result) {

$.each(result, function(i, item) {

$('' + item.name + '').

appendTo(select);

});

});

});

});

并且您script.php应该从数据库返回JSON：

if (isset($_GET['region'])) {

$sql = new mysqli('localhost','username','password','database');

$region = mysqli_real_escape_string($sql,$_GET['region']);

$query = "SELECT * FROM cities WHERE region = $region";

$ret = $sql->query($query);

$result = array();

while ($row = $ret->fetch_assoc()) {

$result[] = array(

'value' => $row['id'],

'name' => $row['city']

);

}

echo json_encode($result);

}