php mysql 下拉菜单_使用PHP和MySQL填充下拉列表

就像其他成员所说的那样,您应该使用PDO(带有准备好的语句)而不是mysql_.

一种可能的实现：

HTML(form.php)

1

2

3

$("#list1").change(function() {

$.ajax({

url : "get_list2.php?id=" + $(this).val(),

type: 'GET',

dataType:'json',

success : function(data) {

if (data.success) {

$('#list2').html(data.options);

}

else {

// Handle error

}

}

});

});

PHP(get_list2.php)

require_once("config.php");

$id = $_GET['id'];

if (!isset($id) || !is_numeric($id))

$reponse = array('success' => FALSE);

else {

// Where $db is a instance of PDO

$query = $db->prepare("SELECT * FROM mytable WHERE id = :id");

$query->execute(array(':id' => $id));

$rows = $query->fetchAll(PDO::FETCH_ASSOC);

$options = "";

foreach ($rows as $row) {

$options .= ''. $row .'';

}

$response = array(

'success' => TRUE,

'options' => $options

);

}

header('Content-Type: application/json');

echo json_encode($response);

PS：未经测试,但应该可以…我想.