#!/usr/bin/php -q
<?php
echo "\n mysql connect test";$con=mysql_connect("localhost","root1","");if(!$con)
{
echo "connect error";
}
else
echo "connetc success";mysql_select_db("ivr-test",$con);
$money=mysql_query("select money from money where callno='2135'");
echo $money;echo "over";?>输出:
#!/usr/bin/php -q mysql connect testconnect errorover
为什么$money是errorselect money from money where callno='2135'这条SQL查询语句运行了没问题本人初学,请高手指教,谢谢!
<?php
echo "\n mysql connect test";$con=mysql_connect("localhost","root1","");if(!$con)
{
echo "connect error";
}
else
echo "connetc success";mysql_select_db("ivr-test",$con);
$money=mysql_query("select money from money where callno='2135'");
echo $money;echo "over";?>输出:
#!/usr/bin/php -q mysql connect testconnect errorover
为什么$money是errorselect money from money where callno='2135'这条SQL查询语句运行了没问题本人初学,请高手指教,谢谢!
echo $rs;
echo $rs[0];在$money=mysql_query("select money from money where callno='2135'");之后添加
{
echo "connect error";
}
else
echo "connetc success";
这里输出的 connect error 数据库连接错误!
#!/usr/bin/php -q mysql connect testconnect errorover数据库连接错
显示的结果是这个,失误了,sorry
echo $rs;+++
connect error:
下面没东西了
你的连接是正确的,只是在得到mysql返回的结果集后,你不能直接打印,需要:$rs = mysql_fetch_array ($money)
print_r($rs);得到全部的:
$arr=array();
while($rs = mysql_fetch_array ($money)){
$arr[]=$rs;
}
print_r($arr);
Array ( [0] => 40 [money] => 40 )这个是正确了,为什么返回值是一个数值呢,我就一个值啊
$arr[]=$rs;
}