PHPä¯ÀÀ±íÖеļǼ
Òªä¯ÀÀ±íÖеļǼÐèÒªÖ´ÐÐÒÔϼ¸²½²Ù×÷£º
(1) Ö´ÐÐÒÔÏÂSQLÓï¾ä£º
select field1,field2,field3,...from $table_name
ÆäÖÐfield1,field2,field3±íʾµÄÊÇÐèÒª´Ó±íÖвéѯµÄ×Ö¶ÎÃû³Æ£º$table_nameΪ±íµÄÃû³Æ¡£
(2)ʹÓÃPHP MSSQLÀà¿âÖеÄmssql_fetch_array()º¯Êý¶ÁȡִÐÐSQLÓï¾äËù·µ»ØµÄ½á¹û¼¯¡£¸Ãº¯ÊýµÄÓï·¨¸ñʽÈçÏ´úÂ룺
mssql_fetch_array(resource result [,int result_type])
ÆäÖвÎÊýresultΪº¯Êýmssql_query()ËùÖ´ÐеÄSQL½á¹û¼¯£»²ÎÊýresult_typeΪ·µ»Ø½á¹ûÊý×éµÄÀàÐÍ£¬Ä¬ÈÏΪ¼È¿ÉÒÔÓÃÊýÖµÒ²¿ÉÒÔÓÃ×Ö¶ÎÃû×÷Êý×éÔªËØ¡£¸Ãº¯Êý½«·µ»ØÒ»¸ö½á¹ûÊý×é¡£
ÁíÍ⻹¿ÉÒÔÓÃmssql_num_rows()º¯ÊýÀ´»ñÈ¡½á¹û¼¯ÖмǼµÄÊýÄ¿¡£¸Ãº¯Êý¸ñʽ£º
mssql_num_rows(resource result)
ÒÔÉÏ´úÂëÖвÎÊýresultΪº¯Êýmssql_query()ËùÖ´ÐеÄsql½á¹û¼¯¡£¸Ãº¯Êý½«¸ù¾Ý½á¹û¼¯µÄÐÐÊý£¬·µ»ØÏàÓ¦µÄÊýÖµ¡£
(3)ͨ¹ýwhileÑ»·¶Á³ö½á¹û¼¯ÖеÄÿÌõ¼Ç¼¡£
<?php
$hostname="datahost";
$dbuser="sa";
$dbpasswd="123";
$dbname="tempdb";
$conn=mssql_connect($datahost,$dbuser,$dbpasswd);
mssql_select_db($dbname);
$t_name="my_table";
$select_t="select id,name from $t_name";
$result=mssql_query($select_t,$conn);
$re_num=mssql_num_rows($result);
echo"<font color=#666666>±íÖÐĿǰ¹²ÓмǼ</font>";
echo "<strong><font color=green>".$re_num."</font></strong>";
echo "<font color=#666666>Ìõ</font>";
echo "<p>";
while ($rows=mssql_fetch_array($result))
{
echo "<font color=#666666>±àºÅ£º</font><strong><font color=green>".$rows[id]."</font></strong>";
echo "<font color=#666666>ÐÕÃû£º</font><strong><font color=green>".$rows[name]."</font></strong>";
echo "<p>";
}
mssql_close($conn);
?>
½á¹ûÑÝʾ£ºhttp://mingking.limewebs.com/db/select_fields.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(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷Éϰ²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó× ......
1. ÓÃPHP´òÓ¡³öǰһÌìµÄʱ¼ä£¬´òÓ¡¸ñʽÊÇ2007Äê5ÔÂ10ÈÕ 22:21:21
2. PHP´úÂëÈçÏ£º
$a="hello";
$b=&$a;
unset($b);
$b="world";
echo $a;
Æä½á¹ûÊÇ£¿
3. PHP´úÂëÈçÏ£º
$str="cd";
$$str="landog";
$$str.="ok";
echo $cd;
Æ ......
PHPÖÐÒýÓÃÖ¸µÄÊDz»Í¬µÄÃû×Ö·ÃÎÊͬһ¸ö±äÁ¿ÄÚÈÝ. µ«ÕâÓë£ÃÓïÑÔÖеÄÖ¸ÕëÊÇÓвî±ðµÄ£®£ÃÓïÑÔÖеÄÖ¸ÕëÀïÃæ´æ´¢µÄÊDZäÁ¿µÄÄÚÈÝÔÚÄÚ´æÖдæ·ÅµÄµØÖ·¡£
¹ØÓÚ¶Ô±äÁ¿£¬º¯Êý»òÕßÀàµÄÒýÓò»¶à˵£¬µ«ÒªËµÒ»ÏÂunsetÒ»¸öÒýÓã¬Ê¾Àý£º
<?php
$a = "hello";
$b =&$a;
unset($b);
echo '$a:'.$a;
//output:$a:hello
?> ......
Linux°æ±¾£º Red Hat Enterprise Linux 5
Nginx°æ±¾£º nginx 0.8.34
PHP°æ±¾£º php 5.2.13
MySQL°æ±¾£º5.0.22
phpËùÐèÖ§³Ö¿â£ºlibiconv¡¢libmcrypt¡¢mhash¡¢mcrypt
1¡¢±àÒë°²×°phpËùÐèÖ§³Ö¿â
# tar zxvf libiconv-1.13.tar.gz
# cd libiconv-1.13/
# ./configure --prefix=/usr/local
# make &a ......
Ïò±íÖÐÌí¼Ó¼Ç¼£¬Í¨³£ÒªÊ¹ÓÃÈçϵÄSQLÓï¾ä¡£
INSERT INTO $table_name(field1,field2,field3,......)values('value1','value2','value3'......)
ÆäÖÐ$table_name Ϊָ¶¨µÄ±íÃû£»field1¡¢field2¡¢field3·Ö±ðΪ±íÖÐ×Ö¶ÎÃû£»value1¡¢value2¡¢value3Ôò·Ö±ðΪ×Ö¶Îfield1¡¢field2¡¢field3Ëù¶ÔÓ¦µÄÖµ¡£
ʵÀýÈçºÎÌí¼Óмͼ£º
& ......