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

¼¸ÖÖ³£ÓÃPHPÁ¬½ÓÊý¾Ý¿âµÄ´úÂë

PHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓMYSQLÊý¾Ý¿â´úÂë < ?php   
$mysql_server_name='localhost'; 
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿â·þÎñÆ÷  
$mysql_username='root'; 
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÓû§Ãû  
$mysql_password='12345678'; 
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÃÜÂë  
$mysql_database='mycounter';
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÃû  
$conn=mysql_connect($mysql_server_name,
$mysql_username,$mysql_password,
$mysql_database);   
$sql='CREATE DATABASE mycounter 
DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;   
';   
mysql_query($sql);   
$sql='CREATE TABLE `counter` 
(`id` INT(255) UNSIGNED NOT NULL
AUTO_INCREMENT ,`count` INT(255)
UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY
( `id` ) ) TYPE = innodb;';   
mysql_select_db($mysql_database,$conn);   
$result=mysql_query($sql);   
//echo $sql;   
mysql_close($conn);   
echo "Hello!Êý¾Ý¿âmycounterÒѾ­³É¹¦½¨Á¢£¡";   
?> 
¸´ÖÆ´úÂëPHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓACCESSÊý¾Ý¿â´úÂë·½·¨ < ?  
$conn = new com("ADODB.Connection");   
$connstr = "DRIVER={Microsoft
Access Driver (*.mdb)};
DBQ=". realpath("data/db.mdb");  
$conn->Open($connstr);   
$rs = new com("ADODB.RecordSet");   
$rs->Open("select *
from szd_t",$conn,1,1);  
while(! $rs->eof) {   
$f = $rs->Fields(1);   
echo $f->value;   
$rs->MoveNext();   
}   
?>
¸´ÖÆ´úÂëPHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓMS SQLÊý¾Ý¿â´úÂë·½·¨
1.°²×°SQL·þÎñÆ÷²¢Ìí¼ÓPHPµÄMSSQLÀ©Õ¹
2.ʹÓÃÒÔÏ´úÂëÁ¬½Ó²¢²âÊÔ < ?php   
$myServer = localhost; //Ö÷»ú  
$myUser = sa; //Óû§Ãû  
$myPass = password; //ÃÜÂë  
$myDB = Northwind; //MSS


Ïà¹ØÎĵµ£º

PHP֪ʶ»ýÀÛ

1 ÔÚSQLÓï¾äÖпÉͨ¹ýÌí¼ÓÏÞÖÆÌõ¼þ:left(text,20)ֻȡtextÎı¾µÄǰ20¸ö×Ö;
¡¡¡¡2 ¿ÉÒÔÓÃlimit fromRecord, RecordNum À´×÷Ϊ·ÖҳʹÓÃ,±ÈÈçlimit 0,30±íʾ´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼±éÀú30¸ö¼Í¼;
¡¡¡¡3 Á½¸ö±íµÄÁ¬½Ó¿ÉÒÔÊÇ£ºtable1 join table2 using x(xΪÁ½¸ö±íµÄ¹«¹²×Ö¶Î),»òÕßÊÇtable1 join table2 on table1.x = table2.x
¡¡¡ ......

php ²»Ö§³ÖÖÐÎÄÎļþÃûµÄ´¦Àí

×î½üдһ¸ö¹ØÓÚ¶ÁÈ¡ÖÐÎÄÎļþÃûµÄСCASEÖÐÓöµ½Á˲»PHP²»Ö§³ÖÖÐÎÄÎļþÃûµÄÎÊÌâ
ÎҵĻ·¾³£º
WINDOWS+Appach +mysql
phpÒ³ MYSQL¾ùΪ±àÂëUTF-8
½â¾ö·½·¨ÈçÏ£º
ÔÚMYSQLÖÐÈ¡³öµÄÖÐÎÄÎļþÃûת»»Æä±àÂë
$fileName=iconv("UTF-8","GBK",$fileName); ......

ÍêÕûlinuxÏÂphpµ¥·þÎñÆ÷ÅäÖÃ

²Ù×÷ϵͳCentOS 5.3
ϵͳ°²×°Íê³Éºó£¬°²×°±ØÒªµÄ°ü
yum install autoconf gcc gcc-c++ libjpeg libjpeg-level
libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs ......

linux·þÎñÆ÷ÓÃPHPµÄPDOÁ´½Ómyql·½·¨(php pdo)

PDOΪºÎÎï
POD£¨PHP Data Object£©À©Õ¹ÔÚPHP5ÖмÓÈ룬PHP6Öн«Ä¬ÈÏʶÓÃPDOÁ¬½ÓÊý¾Ý¿â£¬ËùÓзÇPDOÀ©Õ¹½«»áÔÚPHP6±»´ÓÀ©Õ¹ÖÐÒÆ³ý¡£¸ÃÀ©Õ¹ÌṩPHPÄÚÖÃÀà PDOÀ´¶ÔÊý¾Ý¿â½øÐзÃÎÊ£¬²»Í¬Êý¾Ý¿âʹÓÃÏàͬµÄ·½·¨Ãû£¬½â¾öÊý¾Ý¿âÁ¬½Ó²»Í³Ò»µÄÎÊÌâ¡£
ÎÒÊÇÅäÖÃÔÚwindowsÏÂ×ö¿ª·¢Óõġ£
PDOµÄÄ¿±ê
ÌṩһÖÖÇáÐÍ¡¢ÇåÎú¡¢·½±ãµÄ API
ͳ ......

php ħ·¨ÒýÓú¯Êý

PHPÌṩÁ½¸ö·½±ãÎÒÃÇÒýÓÃÊý¾ÝµÄħ·¨ÒýÓú¯Êýmagic_quotes_gpcºÍmagic_quotes_runtime£¬ÕâÁ½¸öº¯ÊýÈç¹ûÔÚphp.iniÉèÖÃΪONµÄʱºò£¬¾Í»áΪÎÒÃÇÒýÓõÄÊý¾ÝÅöµ½µ¥ÒýºÅ'ºÍË«ÒýºÅ"ÒÔ¼°·´Ð±Ïß \ ÊÇ×Ô¶¯¼ÓÉÏ·´Ð±Ïߣ¬°ïÎÒÃÇ×Ô¶¯×ªÒë·ûºÅ£¬È·±£Êý¾Ý²Ù×÷µÄÕýÈ·ÔËÐУ¬¿ÉÊÇÎÒÃÇÔÚphp²»Í¬µÄ°æ±¾»òÕß²»Í¬µÄ·þÎñÆ÷ÅäÖÃÏ£¬ÓеÄmagic_quotes_g ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ