mysql中选择用户_当用户在选择字段中选择新选项时，如何运行mysql查询？

我想要一个列出产品类别的选择框。选择类别时，我想同时从数据库中选择该类别的产品。我需要在这个应用程序中使用AJAX吗？任何关于这样做的例子？以下是我正在使用的代码：

这些功能构建每个选择字段的选项。

function buildCategoryOptions($catId = 0)

{

$sql = "SELECT cat_id, cat_parent_id, cat_name

FROM tbl_category

ORDER BY cat_id";

$result = dbQuery($sql) or die('Cannot get Product. ' . mysql_error());

$categories = array();

while($row = dbFetchArray($result)) {

list($id, $parentId, $name) = $row;

if ($parentId == 0) {

// we create a new array for each top level categories

$categories[$id] = array('name' => $name, 'children' => array());

} else {

// the child categories are put int the parent category's array

$categories[$parentId]['children'][] = array('id' => $id, 'name' =>

$name);

}

}

// build combo box options

$list = '';

foreach ($categories as $key => $value) {

$name = $value['name'];

$children = $value['children'];

$list .= "

if ($key == $catId) {

$list.= " selected";

}

$list .= ">$name

\r\n";

foreach ($children as $child) {

$list .= "

if ($child['id'] == $catId) {

$list.= " selected";

}

$list .= ">  {$child['name']}

\r\n";

}

}

return $list;

}/ *

构建收音机选项的产品选项列表

* /

function buildProductOptions($catId = 0)

{

$sql = "SELECT pd_id, pd_name, cat_id

FROM tbl_product

WHERE cat_id = $catId

ORDER BY pd_name";

$result = dbQuery($sql) or die('Cannot get Product. ' . mysql_error());

$numProduct = dbNumRows($result);

$products = array();

while($row = dbFetchArray($result)) {

list($id, $name) = $row;

// we create a new array for each top level categories

$products[$id] = array('name' => $name);

}

// build combo box options

$list = '';

foreach ($products as $key => $value) {

$name = $value['name'];

$list .= "

$list .= ">$name

\r\n";

}

return $list;}

这是选择字段的页面：

$catId = (isset($_GET['catId']) && $_GET['catId'] > 0) ? $_GET['catId'] : 0;

$categoryList = buildCategoryOptions($catId);

$productList = buildProductOptions($catId);

-- Choose Category --

echo $categoryList;

?>

--Pick the other options--

echo $productList;

?>