代码写的有问题. 先这样写了,看看错误提示是啥. $db = new mysqli("localhost", "ak", "111111", "welworld"); $db->query("set names 'gbk'") or die(mysqli_error()); $result = $db->query("select uid from ww_users where username='test'") or die(mysqli_error()); while (list($uid) = $result->fetch_row()) echo $uid;
$db = new mysqli("localhost", "ak", "111111", "welworld");/* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }
所以你应当查看存储过程又没有返回正确的数据
---------------------------------------
存储过程这么写:
==================================
CREATE PROCEDURE p(out p int)
select uid into p from ww_users where username='test';php这么拿:
=====================================
$db = new mysqli("localhost", "ak", "111111", "welworld");
$db->query("set names 'gbk'");
$db->query("call p(@a)");
$result = $db->query("select @a");
while (list($uid) = $result->fetch_row())
echo $uid;
http://www.itcncom.com/php/20070411_457.html
先这样写了,看看错误提示是啥.
$db = new mysqli("localhost", "ak", "111111", "welworld"); $db->query("set names 'gbk'") or die(mysqli_error());
$result = $db->query("select uid from ww_users where username='test'") or die(mysqli_error());
while (list($uid) = $result->fetch_row())
echo $uid;
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
可是我不用存储过程直接用sql语句是可以的啊,那说明能够链接数据库的啊,奇怪的是如果我的存储过程是插入数据的,那是可以执行的哦,就是查询(select语句)的就没有结果返回。请高手们帮帮我吧。
结构->EXECUTE 就可以了,谢谢各位大哥,我待会儿结帐,现在吃饭,都额坏了。
具体加的什么呢 ?