Action
public function login(){ $name=$_POST['name'];
$psw = $_POST['pwd'];
$login1= D('Login');
$ab= $login1-> loginModel($name);
echo $ab;Model
public function loginModel($name){
$sql="SELECT * FROM userlogin where username ='$name'";
$info=mysql_query($sql);
$a=mysql_fetch_array($info);
return $a;
Html<form atcion="_URL_/login" method="post">
<ul>
<li>账号<input type="text" name="name"/></li>
<li>密码<input type="password" name="pwd"/></li>
<li><input type="submit" value="登陆"/></li></ul>
</form>
public function login(){ $name=$_POST['name'];
$psw = $_POST['pwd'];
$login1= D('Login');
$ab= $login1-> loginModel($name);
echo $ab;Model
public function loginModel($name){
$sql="SELECT * FROM userlogin where username ='$name'";
$info=mysql_query($sql);
$a=mysql_fetch_array($info);
return $a;
Html<form atcion="_URL_/login" method="post">
<ul>
<li>账号<input type="text" name="name"/></li>
<li>密码<input type="password" name="pwd"/></li>
<li><input type="submit" value="登陆"/></li></ul>
</form>
进了
$sql="SELECT * FROM userlogin where username ='$name'";
echo $sql;页面上能输出 sql语句
SELECT * FROM userlogin where username ='eeee'
var_dump($a); //贴出结果
mysql_query("set names utf8"); //如果你的表是gbk,就改为gbk
mysql_query("set names utf8");
$info=mysql_query($sql) or die(mysql_error());
$a=mysql_fetch_array($info);
var_dump($a);现在是什么结果,报什么错。
加上这个or die(mysql_error());报错了 SELECT * FROM userlogin where username =''Access denied for user 'ODBC'@'localhost' (using password: NO)