¼¸ÖÖ³£ÓÃ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
Ïà¹ØÎĵµ£º
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
¡¡¡ ......
×î½üдһ¸ö¹ØÓÚ¶ÁÈ¡ÖÐÎÄÎļþÃûµÄСCASEÖÐÓöµ½Á˲»PHP²»Ö§³ÖÖÐÎÄÎļþÃûµÄÎÊÌâ
ÎҵĻ·¾³£º
WINDOWS+Appach +mysql
phpÒ³ MYSQL¾ùΪ±àÂëUTF-8
½â¾ö·½·¨ÈçÏ£º
ÔÚMYSQLÖÐÈ¡³öµÄÖÐÎÄÎļþÃûת»»Æä±àÂë
$fileName=iconv("UTF-8","GBK",$fileName); ......
²Ù×÷ϵͳ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 ......
PDOΪºÎÎï
POD£¨PHP Data Object£©À©Õ¹ÔÚPHP5ÖмÓÈ룬PHP6Öн«Ä¬ÈÏʶÓÃPDOÁ¬½ÓÊý¾Ý¿â£¬ËùÓзÇPDOÀ©Õ¹½«»áÔÚPHP6±»´ÓÀ©Õ¹ÖÐÒÆ³ý¡£¸ÃÀ©Õ¹ÌṩPHPÄÚÖÃÀà PDOÀ´¶ÔÊý¾Ý¿â½øÐзÃÎÊ£¬²»Í¬Êý¾Ý¿âʹÓÃÏàͬµÄ·½·¨Ãû£¬½â¾öÊý¾Ý¿âÁ¬½Ó²»Í³Ò»µÄÎÊÌâ¡£
ÎÒÊÇÅäÖÃÔÚwindowsÏÂ×ö¿ª·¢Óõġ£
PDOµÄÄ¿±ê
ÌṩһÖÖÇáÐÍ¡¢ÇåÎú¡¢·½±ãµÄ API
ͳ ......
PHPÌṩÁ½¸ö·½±ãÎÒÃÇÒýÓÃÊý¾ÝµÄħ·¨ÒýÓú¯Êýmagic_quotes_gpcºÍmagic_quotes_runtime£¬ÕâÁ½¸öº¯ÊýÈç¹ûÔÚphp.iniÉèÖÃΪONµÄʱºò£¬¾Í»áΪÎÒÃÇÒýÓõÄÊý¾ÝÅöµ½µ¥ÒýºÅ'ºÍË«ÒýºÅ"ÒÔ¼°·´Ð±Ïß \ ÊÇ×Ô¶¯¼ÓÉÏ·´Ð±Ïߣ¬°ïÎÒÃÇ×Ô¶¯×ªÒë·ûºÅ£¬È·±£Êý¾Ý²Ù×÷µÄÕýÈ·ÔËÐУ¬¿ÉÊÇÎÒÃÇÔÚphp²»Í¬µÄ°æ±¾»òÕß²»Í¬µÄ·þÎñÆ÷ÅäÖÃÏ£¬ÓеÄmagic_quotes_g ......