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 ¶ÁÈ¡ºÍ±àд XML DOM
ʹÓà DOM ¿â¡¢SAX ½âÎöÆ÷ºÍÕýÔò±í´ïʽ
ÓÐÐí¶à¼¼Êõ¿ÉÓÃÓÚÓà PHP ¶ÁÈ¡ºÍ±àд XML¡£±¾ÎÄÌṩÁËÈýÖÖ·½·¨¶ÁÈ¡ XML£ºÊ¹Óà DOM ¿â¡¢Ê¹Óà SAX ½âÎöÆ÷ºÍʹÓÃÕýÔò±í´ïʽ¡£»¹½éÉÜÁËʹÓà DOM ºÍ PHP Îı¾Ä£°å±àд XML¡£
Óà PHP ¶ÁÈ¡ºÍ±àд¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨XML£©¿´ÆðÀ´¿ÉÄÜÓеã¿Ö²À¡£Êµ¼ÊÉÏ£¬XML ºÍËüµÄË ......
°²×°»·¾³£ºVMware Workstation 5.5.0 build-18463
Linux°æ±¾£ºRed Hat Enterprise Linux AS (2.6.9-42.EL)
Èí¼þ°æ±¾£ºMySQL5 - mysql-5.0.37.tar.gz
¡¡¡¡¡¡¡¡¡¡Apache2 - httpd-2.2.4.tar.gz
¡¡¡¡¡¡¡¡¡¡PHP5 - php-5.2.1.tar.gz
¡¡¡¡¡¡¡¡¡¡(½«ÒÔÉÏÎļþ±£´æÖÁ/home/tmpĿ¼)
[MySQL]
# cd /home/tmp (½øÈëѹËõ°ü ......
ΪʲôҪͬ²½SQL Server 2000 Êý¾Ý¿â£¬Ëü¶¼ÓÃÔÚʲô³¡ºÏ
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Êý¾Ý¿â·þÎñÆ÷³öÎÊÌâʱÎÒÃÇÒ²ÓÐÆäÕý³£¹¤×÷ʱµÄ±¸·Ý
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Ò»Ì¨·þÎñÆ÷¸ºÔز»Æðʱ£¬¿ÉÒÔÓÃÀ´×ö¸ºÔؾùºâ
Êý¾Ýʵʱ±¸·Ýͬ²½£¬Êý¾Ý¿â·þÎñÆ÷¿ÉÒÔÎÞ¼ä¶Ï£¬ÎÞËðÊ§Ç¨ÒÆ
Ö÷·þÎñÆ÷±»¹¥»÷»òµ±»úʱÁíһ̨·þÎñͬ²½»ú¿ÉÒÔÓ¦¼±
¡£¡£¡£¡£¡£¿ÉÒÔ˵ ......
PHPÖÐÒýÓÃÖ¸µÄÊDz»Í¬µÄÃû×Ö·ÃÎÊͬһ¸ö±äÁ¿ÄÚÈÝ. µ«ÕâÓë£ÃÓïÑÔÖеÄÖ¸ÕëÊÇÓвî±ðµÄ£®£ÃÓïÑÔÖеÄÖ¸ÕëÀïÃæ´æ´¢µÄÊDZäÁ¿µÄÄÚÈÝÔÚÄÚ´æÖдæ·ÅµÄµØÖ·¡£
¹ØÓÚ¶Ô±äÁ¿£¬º¯Êý»òÕßÀàµÄÒýÓò»¶à˵£¬µ«ÒªËµÒ»ÏÂunsetÒ»¸öÒýÓã¬Ê¾Àý£º
<?php
$a = "hello";
$b =&$a;
unset($b);
echo '$a:'.$a;
//output:$a:hello
?> ......