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); #´Ó½á
Ïà¹ØÎÊ´ð£º
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
Í ......
ÏÖÓÐÒ»PHP¿Õ¼ä£¬Ö§³ÖMYSQLÊý¾Ý¿â
Ϊ½ÚÊ¡·ÑÓã¬ÏÖÏëͨ¹ýÓòÃûתÏòĿ¼ÐÎʽ½øÐйÜÀí£¨¼´½«ÓòÃûA¼Ç¼£Û°üÀ¨¶¥¼¶ÓòÃû¼°¶þ¼¶ÓòÃû£Ý¶¼Ö¸Ïòͬһ¿Õ¼ä£©
È磺·ÃÎÊÓòÃû abcd.cn Ö±½Ó·ÃÎÊÍøÕ¾¸ùĿ¼
·ÃÎʶþ¼¶ÓòÃû ef.abcd.cn ......
ÓÖ³öÏÖÁË $bplot2->SetLegend("ÖÐÎÄÂÒÂë");//ÂÒ
$graph->title->Set("ÿÈÕ¶©µ¥Á¿ÔÂͳ¼ÆÍ¼");//²»ÂÒ
Í¬Ò»Ò³Ãæ
jpgraph jpgraph_bar.phpÖÐûÓÐSetFont(FF_SIMSUN,FS_BOLD);Õâ¸ö·½·¨Ñ½ ......