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

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


Ïà¹ØÎĵµ£º

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(°²×°µ½ÄÄÀï²¢²»»áÓÐÓ°Ï죬ƾ¸öÈËϲºÅ£¬±¾ÎÄÖеÄËùÓз¾¶¶¼ÒÔÎҵݲװ·¾¶£¬Çë´ó¼ÒÔÚ×Ô¼ºµÄ»úÆ÷Éϰ²×°µÄʱºò×¢ÒâÐÞ¸ÄΪ×Ô¼ºµÄ·¾¶)
½Ó× ......

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ÖеÄÒýÓÃ

PHPÖÐÒýÓÃÖ¸µÄÊDz»Í¬µÄÃû×Ö·ÃÎÊͬһ¸ö±äÁ¿ÄÚÈÝ. µ«ÕâÓë£ÃÓïÑÔÖеÄÖ¸ÕëÊÇÓвî±ðµÄ£®£ÃÓïÑÔÖеÄÖ¸ÕëÀïÃæ´æ´¢µÄÊDZäÁ¿µÄÄÚÈÝÔÚÄÚ´æÖдæ·ÅµÄµØÖ·¡£
¹ØÓÚ¶Ô±äÁ¿£¬º¯Êý»òÕßÀàµÄÒýÓò»¶à˵£¬µ«ÒªËµÒ»ÏÂunsetÒ»¸öÒýÓã¬Ê¾Àý£º
<?php
$a = "hello";
$b =&$a;
unset($b);
echo '$a:'.$a;
//output:$a:hello
?> ......

Nginx web+php web·þÎñÆ÷µÄ´î½¨

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 ......

PHP Ïò±íÖÐÌí¼Ó¼Ç¼

Ïò±íÖÐÌí¼Ó¼Ç¼£¬Í¨³£ÒªÊ¹ÓÃÈçϵÄSQLÓï¾ä¡£
INSERT INTO $table_name(field1,field2,field3,......)values('value1','value2','value3'......)
ÆäÖÐ$table_name Ϊָ¶¨µÄ±íÃû£»field1¡¢field2¡¢field3·Ö±ðΪ±íÖÐ×Ö¶ÎÃû£»value1¡¢value2¡¢value3Ôò·Ö±ðΪ×Ö¶Îfield1¡¢field2¡¢field3Ëù¶ÔÓ¦µÄÖµ¡£
ʵÀýÈçºÎÌí¼Óмͼ£º
& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ