【php开源代码栏目提醒】:网学会员为广大网友收集整理了,show_list.php,希望对大家有所帮助!
<?php
/*
* Created on 2006-11-14
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse -
PHP - Code Templates
* 下拉
列表字典显示*/
function init()
{
require_once('db.php');
$db = new DataAccess();
$db->connect();
}
function listjob($job_id)
{
init();
if($job_id == "")
$sql = "select jobclass from joblist";
else
$sql = "select jobclass from joblist where joblist_id = '$job_id'";
mysql_query("set names 'gbk'");
$result = mysql_query($sql) or die("Could not query:" . mysql_error());
//echo "<SELECT SIZE='1' NAME='jobvalue' onChange='document.getElementById('jobtmp').value=this.options[selectedIndex].text' STYLE='border: 1px solid #333333; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; background-color: #FFFFFF'><OPTION VALUE='0'>请选择职位类别</OPTION>";
while($row = mysql_fetch_array($result))
echo "<option value=".$row['joblist_id'].">".$row['jobclass']."</option>";
//echo "</SELECT>";
}
function listarea($area_id)
{
init();
if($area_id == "")
$sql = "select areaclass from arealist";
else
$sql = "select areaclass from arealist where arealist_id = '$area_id'";
mysql_query("set names 'gbk'");
$result = my
sql_query($sql) or die("Could not query:" .
mysql_error());
//echo "<SELECT SIZE='1' NAME='areavalue' onChange='document.getElementById('areatmp').value=this.options[selectedIndex].text' STYLE='border: 1px solid #333333; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; background-color: #FFFFFF'><OPTION VALUE='0'>请选择工作省份</OPTION>";
while($row = mysql_fetch_array($result))
echo "<option value=".$row['arealist_id'].">".$row['areaclass']."</option>";
//echo "</SELECT>";
}
function listspecial($speciallist_id)
{
init();
if($speciallist_id == "")
$sql = "select specialname from speciallist";
else
$sql = "select specialname from speciallist where arealist_id = '$speciallist_id'";
mysql_query("set names 'gbk'");
$result = mysql_query($sql) or die("Could not query:" . mysql_error());
//echo "<SELECT SIZE='1' NAME='areavalue' onChange='document.getElementById('areatmp').value=this.options[selectedIndex].text' STYLE='border: 1px solid #333333; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1; background-color: #FFFFFF'><OPTION VALUE='0'>请选择
工作省份</OPTION>";
while($row = mysql_fetch_array($result))
echo "<option value=".$row['speciallist_id'].">".$row['specialname']."</option>";
//echo "</SELECT>";
}
?>