<?php
foreach($_POST as $key => $value)
{
$$key = $value;
}
//获得新闻
$arrSubject = getSubject($subject);
//获得分类
$arrSort = getSort($sort);
?>
<script language='javascript'>
function selchange(form1)
{
form1.submit();
}
</script>
<form name = "form1" action='<?=$_SERVER['PHP_SELF']?>' method='post'>
<td colspan=2 bgcolor="#FFFFFF"> 省份:
<select name='subject' onchange='selchange(form1)'>
<?php
echo "<option value = '-1'>新闻表</option>";
while(list($key, $value) = each($arrSubject))
{
if($key == $subject)
echo "<option value='$key' selected>$value</option>";
else
echo "<option value='$key' >$value</option>";
}
?>
</select>
分类表:
<select name='sort'>
<?php
echo "<option value = '-1'>分类表</option>";
while(list($key, $value) = each($arrSort))
{
if($key == $sort)
echo "<option value='$key' selected>$value</option>";
else
echo "<option value='$key' >$value</option>";
}
?>
</select>
</form>
foreach($_POST as $key => $value)
{
$$key = $value;
}
//获得新闻
$arrSubject = getSubject($subject);
//获得分类
$arrSort = getSort($sort);
?>
<script language='javascript'>
function selchange(form1)
{
form1.submit();
}
</script>
<form name = "form1" action='<?=$_SERVER['PHP_SELF']?>' method='post'>
<td colspan=2 bgcolor="#FFFFFF"> 省份:
<select name='subject' onchange='selchange(form1)'>
<?php
echo "<option value = '-1'>新闻表</option>";
while(list($key, $value) = each($arrSubject))
{
if($key == $subject)
echo "<option value='$key' selected>$value</option>";
else
echo "<option value='$key' >$value</option>";
}
?>
</select>
分类表:
<select name='sort'>
<?php
echo "<option value = '-1'>分类表</option>";
while(list($key, $value) = each($arrSort))
{
if($key == $sort)
echo "<option value='$key' selected>$value</option>";
else
echo "<option value='$key' >$value</option>";
}
?>
</select>
</form>
兄弟,哪个函数定义了没?
怎么会出错!!
{
global $obj;
$arrSubject = array();
$sql = "select id,subject_name from subject";
$result = $obj->query($sql);
while($row = $result->fetchRow())
{
$arrSubject[$row[0]]= $row[1];
}
return $arrSubject;
}function getSort($sort = '')
{
global $obj;
$arrSort = array();
if($sort == '')
return $arrSort;
$sql = "select id,sort_name from sort where subject_id = $sort ";
$result = $obj->query($sql);
while($row = $result->fetchRow())
{
$arrSort[$row[0]]= $row[1];
}
return $arrSort;
}
另:
//需要引入pear的DB类
/* 数据库配置参数开始 */
define("DB_TYPE_REG","mysql");
define("DBADMIN_REG","root");
define("DBPASSWD_REG","111");/* 配置MYSQL的数据库参数 */
$DSN="mysql://".DBADMIN_REG.":".DBPASSWD_REG."@localhost/表名";
$db = new DB();
$obj = $db->connect($DSN);
谢谢jakey9826(无眠)
如果数据是动态的话,也要用动态脚本将数据全部取出传给JS.