Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

phpµ÷ÓÃmysql´æ´¢¹ý³Ì·µ»Ø¶à¸ö½á¹û¼¯µÄ´¦Àí

 ·µ»ØÒ»¸ö½á¹ûÈ«ÊÀ½ç¶¼ÖªµÀÔõô´¦Àí£¬¹Ø¼üÊÇ·µ»Ø¶à¸ö½á¹û¼¯¾Í²»ºÃ°ìÁË£¬ÏÂÃæÓÐÒ»½â¾ö°ì·¨
´æ´¢¹ý³Ì´úÂë
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
    select * from `user`.`user` limit 0, 50;
    select count(0) as `count` from `user`.`user`;
END$$
DELIMITER ;$$
php ´úÂë
$rows = array ();
$db = new mysqli('127.0.0.1','root','123456','user');
if (mysqli_connect_errno()){
$this->message('Can not connect to MySQL server');
}
$db->query("SET NAMES UTF8");
if($db->real_query("call sp_test()")){
do{
if($result = $db->store_result()){
while ($row = $result->fetch_assoc()){
array_push($rows, $row);
}
$result->close();
}
}while($db->next_result());
}
$db->close();


Ïà¹ØÎĵµ£º

ubuntu°²×°MySQL£¬Apache

 °²裝MySQL-Server
$ sudo apt-get install mysql-server
°²裝Apache HTTP Server
$ sudo apt-get install apache2
°²裝PHP for Apache HTTP Server
$ sudo apt-get install php5
°²裝MySQL for Apache HTTP Server
$ sudo apt-get install libapache2-mod-auth-mysql
$ sudo apt-get ......

MySQL²éѯµÄÐÔÄÜÓÅ»¯

²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½Óɿͻ§¶Ë·¢À´µÄSQLÓï¾äºó£¬Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ø ......

linuxÏÂapache£¬php,mysqlÕûºÏtomcat

1.Ç°ÃæÒ»ÆªÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔ­Òò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......

phpÃæÏò¶ÔÏó


1.ÀàºÍ¶ÔÏó¡£
ÀàÊÇÒ»ÀàÊÂÎïµÄÃèÊö¡£³éÏ󣬸ÅÄîÉϵ͍Òå¡£
¶ÔÏóÊÇʵ¼Ê´æÔÚµÄÿ¸ö¸öÌå¡£Ò²½ÐʵÀý¡£¶ÔÏóÊÇnew³öÀ´µÄ¡£$p = new Person();
2.ÊôÐÔ
ÓÃÀ´ÃèÊöÀàÖеÄÊý¾ÝÔªËØ¡££¨Ò²½ÐÊý¾Ý/״̬£©
ÐÞÊηû£¨PHP5ÖбØÐëÐÞÊΣ©:public(¹«¿ª,ÀàµÄÄÚÍⲿ¶ÁÈ¡ÐÞ¸Ä),private(˽ÓÐÖ»ÔÚµ±Ç°ÀàÖжÁÈ¡ÐÞ¸Ä),protected(±£»¤,ÄÜÔÚÕâ¸öÀàºÍ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ