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º¯ÊýÖ´ÐÐʧ°Ü£¬½«ÏÔʾÏàÓ¦µÄ´íÎóÌáʾ£¬
¶øºó¼ÌÐøÍùÏÂÖ´ÐС£Èç¹ûÏëÆÁ±ÎϵͳµÄ´íÎóÌáʾ²¢ÔÚʧ°Üºó½áÊø³ÌÐò
Ïà¹ØÎĵµ£º
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µ¼Èëµ¼³öÃüÁî
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.µ¼³öÒ ......
Àý£º
ÒªÇóÆ¥Åä±êÌâ
<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 ......
sink°´£º½ñÌìÊÇÖÜÄ©ËùÒÔ¿´ÁËÏÂÊé¡£ÒòΪÎÒÒ»Ö±ÈÏΪÎÞÂÛ¶àæ£¬ÎÞÂÛæʲô£¬Ã¿¸öÖÜÓ¦¸Ã¸ø×Ô¼ºÒ»¸öÓÐÑô¹âµÄÏÂÎ磬´øÉÏÒ»±ÒûÆ·£¬¿´×ÅÔÓÖ¾»òÕßÖø×÷¡£¿´µÄÊÇ¡¶³ÌÐòÔ±2009¾«»ª±¾¡·£¬¾ªÆæµÄ·¢ÏÖPHP5.3ÒѾ³öÏÖ£¬¶øÄÇÆªÎÄÕÂдµÃºÜºÃ£¬¹ÊÍøÉÏËÑË÷ÁËϲ¢×ªÔعýÀ´¡£
ºÁÎÞÒÉÎÊ£¬Èç½ñPHPÒѾ³ÉΪWEB¿ª·½µ±ÖÐ×îÈÈÃŵļ¼ÊõÖ®Ò»¡£¸ù¾Ýnexen. ......