$connection= mysql_connect("localhost","root","85222387");
mysql_select_db("sd",$connection);
mysql_query("SET NAMES GBK");
$name="小明";
$pwd="334455";
[正确]//$query="select * from `user` where name='$name' and password='$pwd'";
[出错]//$query="call `cheak_login`('$name','$pwd')";
$result=mysql_query($query);
$num=mysql_num_rows($result);
echo $num;
---------------------------------------
CREATE PROCEDURE `cheak_login`(
IN name varchar(40),
IN pwd varchar(40)
)
select * from `user` where name=name and password=pwd;
------------------------------------------------------
并且单独在cmd里call `sd`.`cheak_login`("小明","334455");也不出错
是怎么回事吖?
mysql_select_db("sd",$connection);
mysql_query("SET NAMES GBK");
$name="小明";
$pwd="334455";
[正确]//$query="select * from `user` where name='$name' and password='$pwd'";
[出错]//$query="call `cheak_login`('$name','$pwd')";
$result=mysql_query($query);
$num=mysql_num_rows($result);
echo $num;
---------------------------------------
CREATE PROCEDURE `cheak_login`(
IN name varchar(40),
IN pwd varchar(40)
)
select * from `user` where name=name and password=pwd;
------------------------------------------------------
并且单独在cmd里call `sd`.`cheak_login`("小明","334455");也不出错
是怎么回事吖?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货