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

PHP·ÃÎÊMySQLÊý¾Ý¿âº¯Êý¼ò½é


      PHP·ÃÎÊMySQLÊý¾Ý¿âº¯Êý¼ò½é
1. ½øÐÐÊý¾Ý¿âÁ¬½Ó
    Á¬½ÓÊý¾Ý¿â·þÎñÆ÷£¬¾ÍÊǿͻ§¶ËÏò¼ºÔËÐеÄÊý¾Ý¿â·þÎñÆ÷·¢³öÁ¬½ÓÇëÇó£¬
    ³É¹¦ÒÔºó¾Í¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐÐÏàÓ¦²Ù×÷£¬ÓÉÓÚÓû§µÄȨÏÞ²»Í¬£¬ËùÄܽø
    ÐеIJÙ×÷Ò²²»Ò»Ñù¡£PHPÌṩÁËһϵÁÐMySQL²Ù×÷µÄº¯Êý£¬ÓÃÀ´Á¬½ÓÊý¾Ý
    ¿âµÄº¯ÊýÓÐÁ½¸ö£¬·Ö±ðÊÇ£ºmysql_connect()ºÍmysql_pconnect()¡£
    ÏÂÃæÔÚ¶Ô³£Óõöº¯Êý×÷¼òµ¥½éÉܺó£¬ÓÃÒ»¸öÀý×ÓÀ´ËµÃ÷ÔÚPHP½Å±¾ÖÐ
    ×Ô¶¯Á¬½ÓÊý¾Ý¿âµÄ·½·¨¡£
  1.1 mysql_connectº¯Êý
     º¯Êýµ÷ÓøñʽÈçÏ£º
     int mysql_connect([string hostname] [:port][, string usename]
                       [, string password]);
     
     ²ÎÊýÁбíÖеÄport²ÎÊý±íʾÊý¾Ý¿â·þÎñÆ÷µÄ¶Ë¿ÚºÅ£¬Ò»°ãÓÃËüµÄĬÈ϶Ë
     ¿Ú3306¾Í¿ÉÒÔÁË¡£Èç¹û²»ÌîÈκβÎÊý£¬ÔòĬÈϵÄhostnameΪ"localhost",
     usnameΪ"root", passwordΪ¿Õ¡£µ±È»£¬Óû§¿ÉÒÔÖ¸¶¨×Ô¼ºËùÒªÁ¬½ÓµÄ
     Ö÷»úÃû¡¢Óû§Ãû¡¢Óû§ÃÜÂ룬À´Á¬½ÓÖ¸¶¨µÄÊý¾Ý¿â¡£
     º¯ÊýÖ´Ðгɹ¦£¬·µ»ØÒ»¸öintÀàÐ͵ÄÁ¬½ÓºÅ£¬Ö´ÐÐʧ°Ü£¬·µ»ØfalseÖµ¡£
     
     Àý1.1£º
       <?PHP
  //Á¬½ÓÊý¾Ý¿â·þÎñÆ÷
  $connect = mysql_connect("localhost","user","password");
  if($connect)
  {
       echo "Á¬½Ó³É¹¦";    //Á¬½Ó³É¹¦£¬ÏÔʾ“Á¬½Ó³É¹¦";
  }
  else
  {
       echo "Á¬½Óʧ°Ü";    //Á¬½Óʧ°Ü£¬ÏÔʾ"Á¬½Óʧ°Ü";
  }
 ?>
      ÔÚÉÏÀýÖУ¬Èômysql_connectº¯ÊýÖ´ÐÐʧ°Ü£¬½«ÏÔʾÏàÓ¦µÄ´íÎóÌáʾ£¬
      ¶øºó¼ÌÐøÍùÏÂÖ´ÐС£Èç¹ûÏëÆÁ±ÎϵͳµÄ´íÎóÌáʾ²¢ÔÚʧ°Üºó½áÊø³ÌÐò


Ïà¹ØÎĵµ£º

windows°²×°apache+php+mysqlµÄһЩ¼Ç¼

apache°²×°£¬mysql°²×°£¬php5Ö±½Ó½âѹ£¬¾ù·ÅÔÚD:\wwwÏ¡£
Ŀ¼½á¹¹Îª£º
D:\www\apache2
D:\www\mysql
D:\www\php5
½«php5\php.ini-dist¸´ÖÆÎªphp.ini£¬°ÑÐèÒªÓõ½µÄ×é¼þ½«Ç°ÃæµÄ;È¥µô¡£
Èç
extension=php_mysql.dll
extension=php_gd2.dll
ÔÚapache2µÄconf/httpd.confÎļþÖмÓ
LoadFile D:/www/php5/php5ts.dll
......

MySQL²é¿´ºÍµ¼Èëµ¼³öÃüÁî

MySQLµ¼Èëµ¼³öÃüÁî
1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
3.µ¼³öÒ ......

php ÕýÔò±í´ïʽ×ܽá

Àý£º
ÒªÇóÆ¥Åä±êÌâ
 <div class="detail-hd">
 <h3>
     Îå»Ê¹Ú 2010´º×°ÐÂÆ·Ê±ÉÐTÐô ³¤Ðä Å®×°³¤¿îTÐô ÈÈÂôº«°æ³¤T ÌØ¼Û
   </h3>
$reg="|<div class=\"detail-hd\">[\n\r\t]*<h3>[\n\r\t]*(.*)[\n\r\t]*</h3>|";
pre ......

PHP 5.3ÖеÄÐÂÌØÐÔ

sink°´£º½ñÌìÊÇÖÜÄ©ËùÒÔ¿´ÁËÏÂÊé¡£ÒòΪÎÒÒ»Ö±ÈÏΪÎÞÂÛ¶àæ£¬ÎÞÂÛæʲô£¬Ã¿¸öÖÜÓ¦¸Ã¸ø×Ô¼ºÒ»¸öÓÐÑô¹âµÄÏÂÎ磬´øÉÏÒ»±­ÒûÆ·£¬¿´×ÅÔÓÖ¾»òÕßÖø×÷¡£¿´µÄÊÇ¡¶³ÌÐòÔ±2009¾«»ª±¾¡·£¬¾ªÆæµÄ·¢ÏÖPHP5.3ÒѾ­³öÏÖ£¬¶øÄÇÆªÎÄÕÂдµÃºÜºÃ£¬¹ÊÍøÉÏËÑË÷ÁËϲ¢×ªÔعýÀ´¡£
ºÁÎÞÒÉÎÊ£¬Èç½ñPHPÒѾ­³ÉΪWEB¿ª·½µ±ÖÐ×îÈÈÃŵļ¼ÊõÖ®Ò»¡£¸ù¾Ýnexen. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ