PHP下拉列表实现+增加“全部”到查询的数据中

下拉列表实现

样式

1、在php语言中使用html语言的下拉列表

//引入前端HTML语言echo ' ';
	echo ' 
		<select name="anzhuanggong" id="anzhuanggong" onchange="checkall()">
	';  
//PHP使用sql语言，查询当order_number等于变量$_SESSION['Contract' . $identifier]->order_number时，在so_anzhuanggong表中的anzhuanggong字段值
      $sql = "select anzhuanggong from so_anzhuanggong where order_number='" . $_SESSION['Contract' . $identifier]->order_number . "' ";
      $result = DB_query($sql, $db);
      while ($v = DB_fetch_array($result)) { //当变量v值为sql查询的值时（不为空赋值执行while语句）
		if ($v['anzhuanggong'] == $_SESSION['Contract' . $identifier]->anzhuanggong) { //如果存在初始值$_SESSION['Contract' . $identifier]->anzhuanggong，给其定义为$v['anzhuanggong']
			echo '<option value="'. $v['anzhuanggong'].'" selected="selected">'. $v['anzhuanggong'].'</option>';//将选项默认值设置为存在的初始值$_SESSION['Contract' . $identifier]->anzhuanggong
        } 
		else {//如果没有初始值，就不设置默认值
			echo '<option value="'. $v['anzhuanggong'] .'">'. $v['anzhuanggong'].'</option>';
		}
	}
	echo '</select>
 

 2、在html引入php语言的下拉列表

<!--前端html的下拉列表语句-->
<select name="chanpinleixing<?=$j?>" id="add_chanpinleixing<?=$j?>" onblur="checkaddall()" onchange="checkaddall()">
	<?php//执行php语句使用sql进行数据查询
		$sql = "select name from so_parameter where type='安装产品类型'";
		$result = DB_query($sql,$db);
		while ($v = DB_fetch_array($result)) {
			if ($v['name']==$_POST['chanpinleixing<?=$j?>']) {//如果有初始值，设置默认值
	?>
				<option value="<?=$v['name']?>" selected="selected"><?=$v['name']?></option>
	<?php 
			}
			else{//如果没有初始值，就不设置默认值
	?>
				<option value="<?=$v['name']?>"><?=$v['name']?></option>
	<?php 
			}
	}
?> 
</select>

 向查询的数据中增加属性

 

 union连接两段sql、distinct查询字段中所有不重复的值组成的集合

echo '<div class="text-nav3">';
echo '<div class="text-nav-1"><div>' . _('表名') . '</div> 
		<select name="table_name" id="table_name">';
$sql2v = "  select '全部' table_name from dual 
            union 
            select distinct table_name 
            from attribute		 
	";
$result2v = DB_query($sql2v, $db);
while ($v2 = DB_fetch_array($result2v)) {
	if ($v2['table_name'] == $_POST['table_name']) {
		echo '<option value="' . $v2['table_name'] . '" selected="selected">' . $v2['table_name'] . '</option>';
	} else {
		echo '	<option value="' . $v2['table_name'] . '">' . $v2['table_name'] . '</option>';
	}
}
echo ' </select></div>';