*******var sValue
＄db->query("select * from news_bclass order by id desc");
while(＄db->next_record()){
＄parentid=＄db->Record["id"];
＄db1->query("select * from news_sclass where parentid='＄parentid' order by parentid desc");
while(＄db1->next_record()){
＄nums=＄db1->num_rows();
＄j++;
＄sValue.="\"".＄db1->Record["id"]."\",";
if(＄j==＄nums){
＄sValue="[".＄sValue."],[";
＄j=0;
}
}
}
＄sValue.="]";
＄sValue=str_replace("\",]","\"]",＄sValue);
＄sValue=str_replace(",[]","]",＄sValue);
if((substr(＄sValue,0,2))=="[\""){
＄sValue="[".＄sValue;
}else{
＄sValue=preg_replace("/\[{3,}/is","[[\\1",＄sValue);//匹配
}

?>
<div id="tar"></div>
<SCRIPT LANGUAGE="JavaScript" DEFER>
var fMenu = <?php echo ＄fMenu; ?>;
var fValue = <?php echo ＄fValue; ?>;
var sMenu = <?php echo ＄sMenu; ?>;
var sValue = <?php echo ＄sValue; ?>;

var oWhere = document.all.tar;
var ofMenu = document.createElement("<SELECT name='bigclass'>");
var osMenu = document.createElement("<SELECT name='smallclass'>");
with(oWhere)appendChild(ofMenu),appendChild(osMenu);

createMainOptions();
createSubOptions(0);

ofMenu.onchange = function() {createSubOptions(this.selectedIndex);};

function createMainOptions() {
for(var i=0;i<fMenu.length;i++)ofMenu.options[i] = new Option(fMenu[i],fValue[i]);
}
function createSubOptions(j) {
with(osMenu) {
length=0;
for(var i=0;i<sMenu[j].length;i++)osMenu.options[i] = new Option(sMenu[j][i]

上一页  [1] [2] [3] 下一页

在google里搜索更多一个用数据库的php二级联动

	Web www.51ec.org

上一篇信息学院： 关于PHP中的Class的几点个人看法

下一篇信息学院： PHP操作MySQL的函数