PHPÁ¬½ÓSQL Server·þÎñÆ÷
1.ʹÓÃPHPµÄMSSQL,ÐèÒª¼ÓÔØPHPµÄMSSQLÀ©Õ¹¡£¾ßÌå·½·¨ÊÇ´ò¿ªphp.iniÎļþ£¬ÕÒµ½ÏÂÃæÒ»ÐдúÂ룺
;extension=php_mssql.dll
È¥µôÐÐÊ׵ķֺţ¬È»ºó±£´æΪphp.iniÎļþ£¬¼´Íê³ÉPHPµÄMSSQLÀ©Õ¹µÄ¼ÓÔØ¡£
2.PHPÁ¬½ÓSQL ServerµÄ±ØÒªÌõ¼þ
a. SQL Server·þÎñÆ÷µÄÖ÷»úÃû³Æ¡£
b. ÔÊÐí¶Ô·þÎñÆ÷Á¬½ÓµÄÓû§Ãû¡£
c. Óû§¶ÔÓ¦µÄÃÜÂë¡£
d. Æô¶¯SQL Server·þÎñ¡£
ͬʱ¾ß±¸ÒÔÉÏÌõ¼þ£¬²ÅÄÜʵÏÖ¶ÔSQL ServerµÄÁ¬½Ó¡£
ʹÓÃPHPµÄMSSQLÀ©Õ¹¿âÖеÄmssql_connect()º¯Êý¿ÉÒÔʵÏÖ¶ÔÖ¸¶¨SQL Server·þÎñÆ÷µÄÁ¬½Ó¡£¸Ãº¯ÊýµÄÓï·¨¸ñʽÈçÏ£º
resource mssql_connect([string servername[,string username[,string password[,bool new_link]]]])
ÒÔÉÏ´úÂëµÄ¸÷¸ö²ÎÊýµÄÒâÒåÈçÏ£º
a. ²ÎÊýservernameΪ½øÐÐÁ¬½ÓµÄSQL Server·þÎñÆ÷µÄÃû³ÆÒÔ×Ö·û´®±íʾ¡£
b. ²ÎÊýusernameΪSQL ServerµÄÓû§Ãû£¬ÒÔ×Ö·û´®±íʾ¡£
c. ²ÎÊýpasswordΪָ¶¨Óû§Á¬½Óµ½·þÎñÆ÷µÄÃÜÂ룬ÒÔ×Ö·û´®±íʾ¡£
d. ²ÎÊýnew_linkΪ²¼¶ûÐͱäÁ¿£¬¸Ã²ÎÊýÖ¸¶¨ Èç¹ûÁ¬½ÓÒѾ´ò¿ªÊÇ·ñ´ò¿ªÒ»¸öеÄÁ¬½Ó£¬Ä¬ÈÏֵΪfalse¡£
Ö´Ðиú¯Êý£¬Èç¹ûÄܹ»³É¹¦Á¬½Óµ½SQL Server·þÎñÆ÷£¬º¯Êý½«·µ»ØÒ»¸öÁ¬½Ó±êʶ£»Èç¹û²»ÄÜÁ¬½Óµ½SQL Server·þÎñÆ÷Ôò·µ»Øfalse¡£
ʵÀý£º
<?php
$hostname="datahost";//MSSQL·þÎñÆ÷µÄIPµØÖ·»ò·þÎñÆ÷µÄÃû×Ö
$dbuser="sa";//MSSQL·þÎñÆ÷µÄÕʺÅ
$dbpassword="123";//MSSQL·þÎñÆ÷µÄÃÜÂë
$conn=mssql_connect($hostname,$dbuser,$dbpassword);//Á¬½ÓMSSQL
if($conn)
{
echo "<font color=green>Á¬½Ó³É¹¦£¡</font>";
}
else
{
echo "<font color=red>Á¬½Óʧ°Ü£¡</font>";
}
mssql_close($conn);//¹Ø±ÕÊý¾Ý¿â
?>
½á¹û£ºhttp://mingking.limewebs.com/db/conn.php
Ïà¹ØÎĵµ£º
Èí¼þ°æ±¾:
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(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷ÉÏ°²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó× ......
ΪʲôҪͬ²½SQL Server 2000 Êý¾Ý¿â£¬Ëü¶¼ÓÃÔÚʲô³¡ºÏ
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Êý¾Ý¿â·þÎñÆ÷³öÎÊÌâʱÎÒÃÇÒ²ÓÐÆäÕý³£¹¤×÷ʱµÄ±¸·Ý
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Ò»Ì¨·þÎñÆ÷¸ºÔز»Æðʱ£¬¿ÉÒÔÓÃÀ´×ö¸ºÔؾùºâ
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Êý¾Ý¿â·þÎñÆ÷¿ÉÒÔÎÞ¼ä¶Ï£¬ÎÞËðʧǨÒÆ
Ö÷·þÎñÆ÷±»¹¥»÷»òµ±»úʱÁíһ̨·þÎñͬ²½»ú¿ÉÒÔÓ¦¼±
¡£¡£¡£¡£¡£¿ÉÒÔ˵ ......
±¾ÎÄÈí¼þµÄÏÂÔصØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......
1 <?php
2 $doc = new DOMDocument('1.0', 'utf-8');
3 $doc->load('./articles.xml');
4
5 $xpath = new DOMXPath($doc);
6 /*
7 * $xpath = domxml_open_file("articles.xml");
8 */
......
1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
Collations·³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCol ......