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

Ò»ÖÖ²»´íµÄ´ÓSQLתMysqlÊý¾Ý¿âµÄ·½·¨

Äê³õµÄʱºòÒ»Ö±ÔÚ×öÒ»¸öÍøÕ¾MSSQL2000->MySQL5µÄÇ¨ÒÆ¹¤×÷£¬ÒòΪ²ÉÓÃÁ˲»Í¬µÄ³ÌÐòϵͳ£¬ËùÒÔÖ÷ÒªÎÊÌâÔÚÊý¾ÝµÄÇ¨ÒÆ¡£ÓÉÓÚ2¸öϵͳÊý¾Ý¿â½á¹¹²îÒì·Ç³£´ó£¬²»·½±ã²ÉÈ¡SQLSERVERÀïµ¼ÈëMYSQLµÄODBCÊý¾ÝÔ´µÄ¹¦ÄÜ£¨Ò²²»ÍƼöÕâô×ö£¬×Ö¶ÎÀàÐ͵Ȳ»Í¬µã»á¸ãËÀÈ˵ġ«£©£¬Òò´Ë¾ÍÔÚWINDOWSÏÂ×Ô¼ºÐ´PHP½Å±¾´ÓSQLSERVERÀï¶ÁÊý¾Ý£¬È»ºó°´ÕÕÐÂϵͳµÄÐèÒª´¦ÀíÖ®ºó²åÈëMYSQLÀïÃæ£¬Áé»îÒ²±È½Ï·½±ã¡£Êµ¼Ê¹ý³ÌÖ÷ÒªÓÐÏÂÃæ¼¸¸öÎÊÌ⣺
1¡¢Êý¾Ý¿âµÄÁ¬½Ó£¬Ö÷ÒªÊÇÁ¬½ÓSQLSERVER¡£Ö÷ÒªÓÐ3ÖÖ·½·¨£º
1.1ÀûÓÃPHPÖеÄmssql_ϵÁк¯Êý£¬Õâ¸öÓëʹÓÃmysql_ϵÁк¯ÊýÀàËÆ£¬²»¹ýÒª´ò¿ªphp.iniÖÐÏà¹ØÀ©Õ¹£¨extension=php_mssql.dll£©¡£
1.2ÀûÓÃODBCÁ¬½Ó£¬ÓÉÓÚ³éÏóÁ˾ßÌåÊý¾Ý¿â£¬ËùÒÔûÓа취ÀûÓÃÊý¾Ý±í×Ö¶ÎÃû=>Êý×é¼üÃûµÄÌØÐÔ£¬ÔÚÕë¶Ô¾ßÌåÓ¦ÓÃʱ²»ÊǺܷ½±ã£¬´úÂëÐÎʽ£º
 
$conn=odbc_connect("datasource","username","password");
$sql="select*fromnews";
$cur=odbc_exec($conn,$sql);
while(odbc_fetch_row($cur)){
$field1=odbc_result($cur,1);
$field2=odbc_result($cur,2);
//dosomething
}
1.3ʹÓÃPDO-PHP5ÖмÓÈëÊý¾Ý¶ÔÏó³éÏó²ã£¬×÷Ϊ¹Ù·½ÍƳöµÄÊý¾Ý·ÃÎʽӿڣ¬ÓŵãÓкܶ࣬±ÈÈçÖ§³Ö²ÎÊý°ó¶¨ÒÔ·ÀÖ¹SQL×¢È룻¶ÔÓÚ²»Í¬Êý¾Ý¿â¼ÓÔØ²»Í¬Çý¶¯¼´¿É£¬³ÌÐò´úÂëÊÇÒ»Öµģ¬±ãÓÚÒÆÖ²µÈµÈ£¬ÏàÐÅÓ¦¸ÃÊÇ´óÊÆËùÇ÷¡£²»¹ýÓÉÓÚÓÃÁËPHP5ȫеÄÃæÏò¶ÔÏóÌØÐÔ£¬ÐèÒªPHP5µÄÖ§³Ö£¬5.1¿ÉÒÔÖ±½ÓʹÓã¬5ÐèҪװPECL£¬ÁíÍ⻹ҪÐÞ¸ÄPHP.ini£¬Ôö¼Ó£ºextension=php_pdo_mysql.dllºÍextension=php_pdo_mssql.dll£¬Êµ¼Ê´úÂëÈçÏÂ:
 
try{
$DBH=newPDO("mssql:dbname=XXX;host=localhost",¡¡
"root","password");//ConnecttoDB
}catch(PDOException$e){
print"Error!:".$e->getMessage();//ErrorMessage
die();
}
$stmt=$DBH->prepare("SELECT*fromnews");//StmtHandle$stmt
if($stmt->execute()){
while($row=$stmt->fetch()){
//dosomething
}
}
$stmt2=$mssql->prepare("INSERTINTOnews¡¡
(title,author)VALUES(:title,:author)");
$stmt2->bindParam(':title',$title);
$stmt2->bindParam(':author',$author);
$stmt2->execute();
$DBH=null;//CloseConnectionÕâÀïÒªÌáÐÑϵÄÊÇMSSQLÀïÃæÊÇûÓÐMYSQLÖÐLIMITÕâ¸öÓï·¨µÄ¡£
 
2¡¢TEXT×ֶα»½Ø¶ÏµÄÎÊÌâ¡£
ÉÏÃæ³¢ÊÔÁË3ÖÖÁ¬½ÓÊý¾Ý¿â·½·¨£¬ÊÇÒòΪµ±³õÁ¬ÉÏMSSQLºóSELECT³öÀ´µÄÊý¾Ý×ÜÊÇÖ»ÓÐ4K³¤¶È


Ïà¹ØÎĵµ£º

MySql³£ÓÃÃüÁî

1. Êý¾Ý¿â
Çл»Êý¾Ý¿â£º  use mydb
2. ʼþ
 ²é¿´Ê¼þ£º   show events
 Æô¶¯µ÷¶ÈÆ÷:  set global event_scheduer = 1;
 ²é¿´ÊÇ·ñÆô¶¯£º show variables like 'event_scheduler';
3. ±¸·Ý
ÔÚadministatorÖеÄbackupÖÐÎÞ·¨±¸·ÝÊý¾Ý¿âµÄʼþ¡£ÐèÒªÊÖ¶¯½«´´½¨Ê¼þµÄ½Å±¾Ìí¼Óµ½sql±¸ ......

windowsÏÂPHP5+APACHE+MYSQLÍêÕûÅäÖÃ

Èí¼þ°æ±¾:
php-5.2.13-Win32
apache_2.2.9-win32-x86-no_ssl-r2.msi(×¢Ò⣺APACHE 2.2.X°æ±¾ÒÔÉÏÒªÔö¼Ó²å¼þ²ÅÖ§³ÖPHP 5µÄ)
mysql-5.1.44-win32.msi
ÏÈ×°µÄphp5,Ö±½Ó½âѹÎļþµ½C:\php(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷Éϰ²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó× ......

CentOS+Apache+Mysql+Php°²×°¼°ÓÅ»¯ÅäÖÃС¼Ç


±¾ÎÄÈí¼þµÄÏÂÔØµØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......

Fedora 8ÏÂÓÃYum°²×°Apache+PHP+MySQL»·¾³


fedora8 ÓÃyumÀ´¹ÜÀí°²×°Apache+PHP+MysqlµÄ»ù±¾°²×°¡£
1. °²×°Apahce, PHP, Mysql, ÒÔ¼°phpÁ¬½Ómysql¿â×é¼þ¡£
yum -y install httpd php mysql mysql-server php-mysql
2. ÅäÖÿª»úÆô¶¯·þÎñ
/sbin/chkconfig httpd on             [ÉèÖÃapache·þÎñÆ÷httpd·þÎñ¿ª»úÆô¶¯]
......

mySQLµÄÖÐÎÄ×Ö·û´¦Àí

1.Ê×ÏÈ£¬ÉèÖÃÊý¾Ý¿âÖ§³ÖÖÐÎÄgb2312/gbk¡£
¾ßÌå·½·¨£º
´ò¿ªmySQLÎļþ¼Ð£¬ÐÞ¸Ämy.iniÅäÖÃÎļþ¡£
[client]
port=3306
default-character-set=gb2312
ÒÔ¼°
[mysqld]쵀
default-character-set=gb2312
Ð޸쬱£´æ£¬ÖØÆô¡£ÈôÉèΪSystem·þÎñ£¬¿ÉÒÔÔÚ¿ØÖÆÃæ°å-¹ÜÀí¹¤¾ß-·þÎñÖÐÕÒµ½mySQL·þÎñ£¬ÖØÆô¡£
2.±£Ö¤Web ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ