<?php
$name = isset($_POST['name'])?$_POST['name']:'';
$posd = isset($_POST['password'])?$_POST['password']:'';
if ($name==''||$posd=='') {
header('location:denglu.html');
}
$con = mysql_connect('localhost','root','');
mysql_select_db('ena');
$sql= "select * from student where name='$name' and password=$posd";
$fan= mysql_query($sql);
$hang = mysql_num_rows($fan);
var_dump($hang);
?>
输出int(0)
应该输出int(1);
这是怎么回事啊。
$name = isset($_POST['name'])?$_POST['name']:'';
$posd = isset($_POST['password'])?$_POST['password']:'';
if ($name==''||$posd=='') {
header('location:denglu.html');
}
$con = mysql_connect('localhost','root','');
mysql_select_db('ena');
$sql= "select * from student where name='$name' and password=$posd";
$fan= mysql_query($sql);
$hang = mysql_num_rows($fan);
var_dump($hang);
?>
输出int(0)
应该输出int(1);
这是怎么回事啊。
如果不是请加上单引号。
$sql= "select * from student where name='$name' and password='$posd'";
你sql语句用拼接的字符串试试,是不是单引号不解析变量啊