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

±È½Ï²»´íµÄmysql²Ù×÷Àà

<?php
/*
 * by:lenush
 * qicq:707207845
 * email:lenus-h@163.com
 * site:www.hackthiswebsite.cn
 * that's all
 *
 */ 
class mysql{
 
 private $db_host;  //Êý¾Ý¿âÖ÷»ú
 private $db_user;  //Êý¾Ý¿âÓû§Ãû
 private $db_pwd;   //Êý¾Ý¿âÓû§ÃûÃÜÂë
 private $db_database;    //Êý¾Ý¿âÃû
 private $conn;           //Êý¾Ý¿âÁ¬½Ó±êʶ;
 private $result;         //Ö´ÐÐqueryÃüÁîµÄ½á¹û×ÊÔ´±êʶ
 private $sql;   //sqlÖ´ÐÐÓï¾ä
 private $row;     //·µ»ØµÄÌõÄ¿Êý
 private $coding;  //Êý¾Ý¿â±àÂ룬GBK,UTF8,gb2312
 private $bulletin = true;    //ÊÇ·ñ¿ªÆô´íÎó¼Ç¼
 private $show_error = true;  //²âÊԽ׶Σ¬ÏÔʾËùÓдíÎó,¾ßÓа²È«Òþ»¼,ĬÈϹرÕ
 private $is_error = false;   //·¢ÏÖ´íÎóÊÇ·ñÁ¢¼´ÖÕÖ¹,ĬÈÏtrue,½¨Òé²»ÆôÓã¬ÒòΪµ±ÓÐÎÊÌâʱÓû§Ê²Ã´Ò²¿´²»µ½ÊǺܿàÄÕµÄ
  
 /*¹¹Ô캯Êý*/
 public function __construct($db_host,$db_user,$db_pwd,$db_database,$conn,$coding){
      $this->db_host=$db_host;
      $this->db_user=$db_user;
      $this->db_pwd = $db_pwd;
      $this->db_database=$db_database;
      $this->conn=$conn;
      $this->coding=$coding;
      $this->connect();
    }
 /*Êý¾Ý¿âÁ¬½Ó*/                
 public function connect()
 {
  if($this->conn=="pconn"){
   //ÓÀ¾ÃÁ´½Ó
      $this->conn=mysql_pconnect($this->db_host,$this->db_user,$this->db_pwd);
  }else{
  &


Ïà¹ØÎĵµ£º

MySQL+PHP²úÉúÂÒÂëµÄÔ­Òò¼°½â¾ö·½·¨

MySQL+PHP²úÉúÂÒÂëÔ­Òò£º
¡¡¡¡¡ô MySQLÊý¾Ý¿âĬÈϵıàÂëÊÇutf8,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄPHPÍøÒ³²»Ò»ÖÂ,¿ÉÄܾͻáÔì³ÉMySQLÂÒÂë;
¡¡¡¡¡ô MySQLÖд´½¨±íʱ»áÈÃÄãÑ¡ÔñÒ»ÖÖ±àÂë,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³ÉMySQLÂÒÂë;
¡¡¡¡¡ô MySQL´´½¨±íʱÌí¼Ó×Ö¶ÎÊÇ¿ÉÒÔÑ¡Ôñ±àÂëµÄ,Èç¹ûÕâÖÖ±àÂëÓëÄãµÄÍøÒ³±àÂë²»Ò»ÖÂ,Ò²¿ÉÄÜÔì³É ......

Windowsƽ̨¶àMYSQLÅäÖÃ(¶àMy.ini)

    ×î½üÔÚѧϰSSH£¬ÓÉÓÚΪÁ˽ÚÔ¼Äڴ棬ËùÒÔ¾Í×¼±¸Ê¹ÓÃMYSQL´úÌæOracle£¬ÎªÁ˸üÉîÒ»²½µØÁ˽âMySQL£¬ÓÚÊǾͼƻ®°²×°noinstall°æ±¾£¬Õâ°æ±¾±È°²×°°æ¿ÉÂ鷳һЩ£¬ÌرðÊÇÅäÖ÷½Ã棬Èç¹ûÅäÖúõϰ¾Í¿ÉÒÔÔÚһ̨»úÆ÷ÉÏÔËÐжà¸ö°æ±¾µÄMYSQL£¬ÔÚÍøÉÏÕÒÁËǰ±²ÃǵıʼǺóѧϰÍê±ÏºóÔټǼһ±Ê£¬¾ÍÎÒÕâ¼ÇÐÔ£¬¹À¼ÆÃ ......

MySQL 5.1ÐÂÌØÐÔ֮ʼþµ÷¶ÈÆ÷(Event Scheduler)

À´×Ô£ºhttp://www.sofee.cn/blog/2007/07/18/91/
MySQL 5.1ÐÂÌØÐÔ֮ʼþµ÷¶ÈÆ÷(Event Scheduler)
CREATE-EVENT, cron, Event-Scheduler, ´¥·¢Æ÷, ¼Æ»®ÈÎÎñ, MySQL,Triggers, Ê¼þµ÷¶ÈÆ÷, ×÷Òµµ÷¶È
July 18, 2007 at 20:34:50 · Filed under MySQL
Ò»¡¢Ç°ÑÔ
×ÔMySQL5.1 ......

MySQL³£ÓÃÃüÁîÒ»ÀÀ


ÓкܶàÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâÆªÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
Ê×ÏÈÔÚ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼ mysqlbin£¬ÔÙ¼üÈëÃüÁîmysql -uroot -p£¬»Ø³µ ......

Myeclipse7.5Á¬½ÓMySQLÊý¾Ý¿â

Èý²½×ߣº
1.ÔÚwindows-->perspective-->DB browser
 
2.Create a database connection profile
 
  Çý¶¯ÏÂÔØ£º http://dev.mysql.com/downloads/
  ÎļþÃû£ºmysql-connector-java-5.0.4-bin
3.Open a database connection
 
Á´½Óʱ¿ÉÄܳöÏÖ´íÎó£¬ÄÇôÇë³¢ÊÔÈçÏ·½·¨£º
Err ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ