Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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();


Ïà¹ØÎĵµ£º

MySQLÓÅ»¯Ó²¼þÌá¸ßÐÔÄÜ

ÓÅ»¯MySQL·þÎñÆ÷µÄÅäÖòÎÊý£¬¿ÉÒÔÌá¸ßMySQLÊý¾Ý¿âµÄÐÔÄÜ£¬µ«ÊǶÔÓÚÅäÖýϵ͵ķþÎñÆ÷À´Ëµ£¬ÄãÎÞÂÛÔõôÓÅ»¯ÅäÖ㬶¼²»»áµÃµ½ÀíÏëµÄЧ¹û£¬ÄǾÍÖ»ÄÜÌá¸ßÄãÓ²¼þÅäÖã¬À´³¹µ×ÓÐЧµØ¸ÄÉÆ·þÎñÆ÷µÄÐÔÄÜ¡£
¾ßÌåµÄ·½·¨ÈçÏ£º
Ò»¡¢ÔÚÉèÖÃMySQL ʱ£¬Ó¦¸ÃÅäÖÃÆäʹÓþ²Ì¬¿â¶ø²»Êǹ²Ïí¿â¡£Ê¹Óù²Ïí¿âµÄ¶¯Ì¬¶þ½øÖÆÏµÍ³¿É½ÚÊ¡´ÅÅ̿ռ䣬µ«¾² ......

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

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

LinuxÏÂMysql°²×°ºÍÅäÖÃ2

 LinuxÏÂmysqlµÄ°²×°²½Ö裨·Çrpm°²×°£©
1 ÏÂÔØmysql-standard-5.0.27-linux-i686-glibc23.tar.gz °ü
2 ½âѹµ½°²×°Ä¿Â¼£º tar -zxvf /edass/db/mysql-standard-5.0.27-linux-i686-glibc23.tar.gz
3 ½«  mysql-standard-5.0.27-linux-i686-glibc23Á´½Óµ½mysql : ln –s mysql-standard-5.0.27-linux-i686 ......

PHPÈçºÎÓëJS½øÐн»»¥£¿

½ñÌìÓÖͻȻ·¢ÏÖÁËÒ»¸ö¼¼ÇÉ£¬¾ÍÊÇPHP¿ÉÒÔ´«Öµ¸øjs£¬ÈçºÎ×öÄØ£¿
Ô­À´PHPµÄÔ­ÀíÊÇÕâÑùµÄ£º
PHPµÄËùÓÐÓ¦ÓóÌÐò¶¼ÊÇͨ¹ýWEB·þÎñÆ÷(ÈçIIS»òApache)ºÍPHPÒýÇæ³ÌÐò½âÊÍÖ´ÐÐÍê³ÉµÄ£¬¹¤×÷¹ý³Ì£º
(1)µ±Óû§ÔÚä¯ÀÀÆ÷µØÖ·ÖÐÊäÈëÒª·ÃÎʵÄPHPÒ³ÃæÎļþÃû£¬È»ºó»Ø³µ¾Í»á´¥·¢Õâ¸öPHPÇëÇ󣬲¢½«ÇëÇó´«ËÍ»¯Ö§³ÖPHPµÄWEB·þÎñÆ÷¡£
(2)WEB·þÎñÆ ......

phpÃæÏò¶ÔÏó


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