<select name="type[]" id="type">
<option value="01" selected="selected">审批登录</option>
<option value="02">查询登录</option>
<option value="03">管理员</option>
</select>
<input type="submit" value="登录" name="submit" />数据库里有3章用户表: 1、spuser 2、testuser 3、admin
要求:判断用户选择的是那个权限的用户,查找相对应的表! 比如,选择 查询登录
php的代码应该怎么写
if($_POST["type"][0]=="查询登录")
{
//TODO
}
$type=$_POST['type'];
switch($type)
{
case "01":
//审批登录要做的事情
break;
case "02":
//查询登录要做的事情
break;
case "03":
//管理员要做的事情
}
?>
帮我看下:
<form action="index.php" method="post">
<label for="username">用户名:</label>
<input type="text" name="username" id="username" />
<label for="password">密码:</label>
<input type="password" name="password" id="password" />
<select name="type[]" id="type">
<option value="01" selected="selected">审批登录</option>
<option value="02">查询登录</option>
<option value="03">管理员</option>
</select>
<input type="submit" value="登录" name="submit" />
<input type="hidden" name="submitted" value="TURE" />
</form>
<?php #登录页面
if(isset($_POST['submitted'])){ // if click
require_once('conn.php'); //连接数据库
//check username
if(!empty($_POST['username'])){
$n=$_POST['username'];
}else{
$n=FALSE;
echo '<p>请输入用户名</p>';
}
//check password
if(!empty($_POST['password'])){
$p=$_POST['password'];
}else{
$p=FALSE;
echo '<p>请输入密码</p>';
}
if($p&&$n){ // 用户名和密码都输入
// 数据库中查询
//判断选择的是哪个权限的用户
$type=$_POST['type'];
switch($type)
{
case "01":
//审批登录要做的事情
$query = "SELECT name, pswd FROM spuser WHERE name='$n' AND pswd='$p' ";
$result = mssql_query ($query);
break;
case "02":
//查询登录要做的事情
$query = "SELECT username, password FROM usertable WHERE username='$n' AND password='$p' ";
$result = mssql_query ($query);
break;
case "03":
//管理员要做的事情
$query = "SELECT name, pswd FROM spuser WHERE name='$n' AND pswd='$p' ";
$result = mssql_query ($query);
}
if (@mssql_num_rows($result) == 1) { // 返回一条记录
$row = mssql_fetch_array ($result);
mssql_free_result($result);
mssql_close(); // Close the database connection.
$_SESSION['name'] = $row[0]; //
$_SESSION['psdw'] = $row[1];
//网页跳转
echo '<script type="text/javascript"> location.href="system.php";</script>';
exit(); // Quit the script.
} else { // 无记录
echo '<p>输入的用户名或者密码至少有一项不正确</p>';
}
} else { // If everything wasn't OK.
echo '<p>请再试一次</p>';
}
mssql_close(); // Close the database connection.
}
?>