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

phpÁ¬½Ómysql²âÊÔºÍÅäÖÃ


phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall   to   undefined   function   'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã»ÅäÖúÃ, php5 µÄĬÈÏ mysql ÊǹرյÄ
½«php_mysql.dllºÍlibmysql.dllÎļþ¿½±´ÖÁc:\winnt\system32ÖУ¨ÎÒ©ÁËlibmysql.dll£©
ÕÒµ½php.iniÖеÄ;extension=php_mysql,È¥µôÇ°ÃæµÄ";"   ÖØÆô·þÎñÆ÷.


Ïà¹ØÎĵµ£º

php¿ª·¢web³ÌÐòµÄ¼¸µã¾­Ñé¼Ç¼

ÒÔǰ°Ñphpµ±×÷Ò»¸ö´¿´âµÄϵͳ±à³Ì½Å±¾£¬´Ó3Ô·ݿªÊ¼µÚÒ»´ÎʹÓÃphpдwebÍøÕ¾£¬Ò»µã¾­ÑéÔÚÕâÀï×ܽáһϡ£
Ò»£º´ò¿ª´íÎóÏÔʾºÍ´íÎóÈÕÖ¾¡£ÔÚphp.iniÖаÑdispaly_errorsÉèÖÃΪOn£¬»òÕßÔڽű¾¿ªÍ·ÓÃini_set('display_errors', 'On')¡£
¶þ£º
µ÷ÊÔ¹¤¾ß±Ø±¸¡£ÐèÒªÁ½ÖÖµ÷ÊÔ¹¤¾ß£ºµÚÒ»ÖÖÊǵ÷ÊÔphp½Å±¾µÄ£¬¾ÍÏñCµ÷ÊÔÆ÷ÄÇÑù¿ÉÒÔÔڽű¾ ......

mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯

mysqlÊý¾Ý¿âlimit²éѯÓÅ»¯
 
MYSQLµÄÓÅ»¯ÊǷdz£ÖØÒªµÄ¡£ÆäËû×î³£ÓÃÒ²×îÐèÒªÓÅ»¯µÄ¾ÍÊÇlimit¡£mysqlµÄlimit¸ø·ÖÒ³´øÀ´Á˼«´óµÄ·½±ã£¬µ«Êý¾ÝÁ¿Ò»´óµÄʱºò£¬limitµÄÐÔÄܾͼ±¾çϽµ¡£
ͬÑùÊÇÈ¡10ÌõÊý¾Ý
select * from yanxue8_visit limit 10000,10 ºÍ
select * from yanxue8_visit limit 0,10
¾Í²»ÊÇÒ»¸öÊýÁ¿¼¶±ðµ ......

lighttpd + mysql + php(fast cgi)°²×°ÓëÅäÖÃ

×¼±¸:
lighttpd-1.4.15.tar.gz
php-4.4.2.tar.gz
mysql-5.0.20a.tar.gz
¿ªÊ¼:
1 ±àÒë°²×°lighttpd
 # tar zxvf lighttpd-1.4.15.tar.gz
 # cd lighttpd-1.4.15
 #  ls
 # ./configure --prefix=/usr/local/lighttpd    //´Ë²¿ÎÞ·¨±àÒëʱÌáʾ°²×°prce-devel
 #&nbs ......

MySql ±íµÄÖ÷¼üË÷ÒýÎÊÌâ

²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽âÆäº¬Òå¼°×÷Óã ......

mysqlÔÚcmdϵÄһЩÓï¾ä

ÉèÖÃ×ֶεÄĬÈÏÖµ£º
    ´´½¨±íµÄʱºò£ºcreate table
tablename(columnname columntype default
defaultvalue);
    Ð޸ıíµÄʱºò£ºalter table
tablename alter column
columnname set 
default
deflaultvalue; ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ