phpµ÷ÓÃMYSQLµÄ´æ´¢¹ý³ÌÎÊÌâ,¼±¼±! - PHP / ¿ªÔ´×ÊÔ´

´æ´¢¹ý³Ì:
DELIMITER $$
CREATE PROCEDURE login4 ()
BEGIN
SELECT * from glcity_user LIMIT 1;
END;
$$

PHPµ÷Óò¢Êä³öÒ»¸ö×Ö¶Î:
$ok_cg= $DB->hxGetOne("call login4()");
echo "aaa" . $ok_cg["user_name"] . "aaa";

ÕâÑùÊÇûÓÐÖµÊä³ö!!!
µ«ÈçÏÂÓï¾ä¾ÍÓÐÊä³ö:
$ok_cg= $DB->hxGetOne("SELECT * from glcity_user LIMIT 1");
echo "aaa" . $ok_cg["user_name"] . "aaa";

ÕâÊÇΪʲôѽ?
ÊDz»ÊÇÎÒµÄPHPÎÊÌâ???

---

Â¥Ö÷ÏÈÔÚÄãµÄsql¹¤¾ßÀïÖ´Ðп´¿´Õâ¸ö´æ´¢¹ý³Ì

---

沒ÓÃ過這種µÄ, ·過

---

ÔÚÊý¾Ý¿âÀïÖ´ÐÐCALL login4(),ÊÇÓÐÒ»Ìõ¼Ç¼µÄ!!!

---

ÔÚmysql query browserÖÐÖ´ÐÐCALL login4(),ÊÇÓÐÒ»Ìõ¼Ç¼³öÀ´µÄ!!!

---

var_dump($DB->hxGetOne("call login4()"));//¿´¿´ÄãÓнá¹ûû ûÓеĻ° ˵Ã÷hxGetOne¶ÔsqlÖ´Ðнá¹û×öÁË´¦Àí ¸ú¹ýÈ¥¿´¿´

---

var_dump($DB->hxGetOne("call login4()"));
ÈçϽá¹û:
bbbccc
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\wwwroot\php\huaxusoft\class\mysql.db.class.php on line 133
bool(false)

×¢ÒâhxGetOneÖÐÓÐÁ½´¦Êä³ö:
function hxGetOne($sql = "")
{
if($sql)
{
echo "bbb";
$this->hxQuery($sql);
}
echo "ccc";
$rows = mysql_fetch_array($this->result,$this->rsType); #´Ó½á