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

¼òµ¥µÄPHP²Ù×÷MysqlÀà

<?php
/*
 * Ãû³Æ : MySQLÊý¾Ý¿â»ù±¾²Ù×÷
 * ×÷Õß : pjx
 * °æ±¾ : v 2010/02/25 v 1.0
 * ˵Ã÷ : ¸ÃÀàÓÃÓÚ¶ÔMySQL×öһЩ¼òµ¥µÄ²Ù×÷
 * ʾÀý £º
 * ʵÀý => $db = new DB_MYSQL($database),´ò¸ö$databaseÊý¾Ý¿â
 * ²éѯÊý¾Ý¿â => $db->query($sql_str),²éѯ$sql_strÓï¾ä
 * »ñµÃÐнá¹û => $db->get_rows_result();
 * »ñµÃÐÐÊý => $db->get_rows();
 * »ñµÃÁнá¹û => $db->get_files_result();
 * »ñµÃÁÐÊý => $db->get_files();
 * ÊͷŽá¹û¼¯ => $db->free();
 * ²éѯ²¢»ñµÃÐнá¹û(ÐèʵÀý OP_MYSQL($database)) => query_and_get_rows($sql_str);
 * ²éѯ²¢»ñµÃÐнá¹û(ÐèʵÀý OP_MYSQL($database)) => query_and_get_files($sql_str);
 **/
class DB_MYSQL{
    /*
     * host : Ö÷»úÃû»òµØÖ·
     * db : Êý¾Ý¿â
     * user : Êý¾Ý¿âÓû§Ãû
     * pw : Êý¾Ý¿âÓû§ÃÜÂë
     * */
    var $host = "localhost";
    var $db = "";
    var $user = "root";
    var $pw = "";
    /*
     * link_id : Êý¾Ý¿âÁ¬½ÓµÄid
     * query_id : Êý¾Ý¿â²éѯµÄid
     * error : Õë¶ÔÓû§µÄ´íÎóÏûÏ¢
     * error_mysql : Êý¾Ý¿â·µ»ØµÄ´íÎóÏûÏ¢,Õë¶Ô³ÌÐòÔ±
     * rows : ½á¹ûÐÐÊý
     * files : ½á¹ûÁÐÊý
     * result_rows : Ðнá¹û¼¯
     * result_files : Áнá¹û¼¯
     */
    var $link_id = 0;
    var $query_id = 0;
    var $error = "";
    var $error_mysql = "";
    var $rows = 0;
    var $files = 0;
    var $result_rows = array();
    var $result_files = array();
    var $mysql_char = "utf8";
    function __construct($d="",$h="",$u="",$p=""){
 &


Ïà¹ØÎĵµ£º

MYSQLѧϰ

MYSQLÓжàÖÖ´æ´¢ÒýÇæºÍ±íÀàÐÍ£¬InnoDBºÍBDBÖ§³ÖÊÂÎñ£¬Èç¹ûҪʹÓÃÊÂÎñ£¬±íµÄÀàÐ;ÍÓ¦¸ÃÊÇInnoDB.
Ìá¸ß±íµÄÐÔÄÜ£º
1¡¢ÓÃ×îСµÄÊý¾ÝÀàÐÍ¡£Õ¼ÓÿռäС£¬½ÚÊ¡´ÅÅ̿ռäºÍÄÚ´æ¡£
2¡¢±í¸ñµÄÖ÷Ë÷ÒýÒª¾¡¿ÉÄܵĶ̣¬ÒÔÃ÷ÏÔÌá¸ßЧÂÊ¡£
3¡¢Ë÷Òý×îºÃ½¨ÔÚΨһµÄÁÐÉÏ£¬Ë÷ÒýÔ½¶Ì£¬ËÙ¶ÈÔ½¿ì¡£
4¡¢¶àÁÐË÷Òý±ØÐë°üº¬×î×ó±ßµÄǰ׺²ÅÓÐЧ¡£ ......

[ÔÓ¼Ç] ÐÂÄêÎïÓï&¹ØÓÚMysqlÒýÇæÐÔÄܲâÊÔ

æµµÄ2009ÖÕÓÚ¹ýÈ¥£¬Ò²ÖÕÓÚ°ÑÈËÉú´óÊÂæÍêÁË£¬»Øµ½Õý³£µÄ¹¤×÷Éú»îÖÐÀ´¡£2010¶ÔÎÒÀ´ËµÓ¦¸ÃÊdzäÂúÐÂÆÚÍûµÄÒ»Ä꣬ÐÂµÄÆõ»ú¾ÍÔÚÑÛǰ£¬¼ÓÓÍŬÁ¦°É~
ÁíÍâ×¼±¸12¸öÔÂÖ®ºóÔÙÀ´×ܽáһϽñÄêµÄÖØ´óʼǣ¬ºÇºÇ~
˳±ã¿´µ½Ò»¸öMysqlµÄ²âÊÔÎÄÕ£¬¸Ð¾õ»¹ÂúÓвο¼¼ÛÖµµÄ£¬ÓÚÊǼǼÏÂÀ´ÒÔ±ã²Î¿¼¡£
ÒÔÏÂÊÇÒ»¸öMySQLÖÐMyISAMÒýÇæÓëInnoDBÒ ......

ÐÖµÜÁ¬ÉçÍÅ——È«¹ú×î´óµÄPHP¼¼ÊõÉçÍÅ

1¡¢ÉçÍżò½é£º
LAMPÐÖµÜÁ¬ÉçÍÅ£¨¼ò³ÆÐÖµÜÁ¬£©ÊÇÒ×µÚÓŽÌÓýѧԺÁ쵼ϵÄÉçÍÅ×éÖ¯£¬ÊÇѧԺÁªÏµ¹ã´óLAMP°®ºÃÕßµÄÇÅÁººÍŦ´ø£¬ÊÇѧԺÉçÍŹÜÀíЭµ÷µÄ»ú¹¹¡£
2¡¢ÉçÍÅÐÔÖÊ£º
ÓÉLAMPÐÖµÜÁ¬·¢Æð£¨www.lampbrother.net£©µÄÈ«¹úרҵÐÔ¡¢¹«ÒæÐÔÉç»áɳÁú×éÖ¯¡£
3¡¢ÉçÍÅÄ¿µÄ£º
a¡¢Îª°®ºÃLAMPµÄÅóÓÑÃǴһ¸öѧϰ½»Á÷µÄƽ̨
b¡¢Îª ......

Óà ignore_user_abortº¯ÊýʵÏÖphp¼Æ»®ÈÎÎñ

˵µ½¼Æ»®ÈÎÎñ´ó¼Ò¿ÉÄܶ¼Ïëµ½ÓÃcrontabÀ´ÊµÏÖ¡£¿ÉÊDz¢²»ÊÇËùÓÐÈ˶¼ÊÇʹÓÃlinuxϵͳ£¬Ò²²»ÊÇËùÓÐÈ˶¼ÓжÀÁ¢·þÎñÆ÷¡£ÕâʱºòÈçºÎÓÃphpÀ´
ʵÏּƻ®ÈÎÎñÄØ¡£
º¯Êý- ignore_user_abort()
£¬
Õâ¸öº¯Êý¿ÉÒÔ°ïÖúÎÒÃÇʵÏÖÏñlinuxÖеÄcronÒ»ÑùʵÏּƻ®ÈÎÎñ£¬ÏÂÃæÒ»ÆðÀ´¿´Ï¸ÃÈçºÎÀ´ÊµÏÖ¡£
¸Ãº¯Êý°´ÕÕ×ÖÃæÒâ˼¾ÍÊÇ“ºöÂÔÓû§Ö ......

phpÔÚIIsÉϵÄÅäÖð²×°

ÒÔǰֻŪ¹ýasp£¬×î½üÓеãÐËȤÀ´Ñ§ÏÂphp£¬·¢ÏÖphp±Èasp²»ÊÇÒ»°ãµÄ¹¦ÄÜÇ¿´ó¡£
¸Õ¿ªÊ¼ÍµÁËÏÂÀÁ£¬Ã»ÓÐÈ¥php¹ÙÍø¿´°ïÖú£¬Ó¢ÎĵÄËäÈ»¿´ÆðÀ´²»ÄÑ£¬µ«ÊÇ»¹ÊÇϰ¹ß¿´ÖÐÎÄ£¬ÓÚÊÇËÑË÷Á˼¸ÆªÓйØphpÔÚiisÉϰ²×°µÄÎÄÕ£¬°´ÕÕÕâЩÎÄÕÂÉϵÄ˵Ã÷¿ªÊ¼ÅäÖÃphp¡£ÎҾͶ¥Ëü¸ö·Î£¬ÅäÖÃÆðÀ´ÎÊÌâÇ§Ææ°Ù¹Ö£¬ÕÛÌÚÁËÁ½Ì죬ҲÓôÃÆÁËÁ½Ìì¡£
µÃ£¬Ë÷ÐÔ¿´¹Ù ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ