Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

PHP MVC ³õ̽

ÏÐÀ´Óпգ¬Ñ§Ï°Ò»ÏÂPHPµÄMVCģʽ£¬³äʵһÏÂ×ÔÎÒ£¬²»ÖÁÓÚÂäºó¡£¿´Á˸ö¼òµ¥µÄʾÀý
£¬×öµã¼Ç¼¡£
µ¥µãÈë¿Ú£º
1. ËùÓгÌÐò¶¼ÊÇͨ¹ýindex.phpÀ´½øÐе÷Óõģ¬ÕâÒª¿¿.htaccessÎļþÀ´½øÐпØÖÆ¡£
2. URL router¿ÉÒÔÓɵ¥¶ÀµÄRouterÀàÀ´½øÐÐControllerµÄÑ¡Ôñ£¬Ò²¿ÉÒÔ·ÅÔÚindex.phpÖнøÐÐÑ¡Ôñ¡£
3. Config×îºÃ·Åµ½µ¥¶ÀµÄÎļþÖУ¬½á ......

Óà PHP ¶ÁÈ¡ºÍ±àд XML DOM


Óà PHP ¶ÁÈ¡ºÍ±àд XML DOM
ʹÓà DOM ¿â¡¢SAX ½âÎöÆ÷ºÍÕýÔò±í´ïʽ
ÓÐÐí¶à¼¼Êõ¿ÉÓÃÓÚÓà PHP ¶ÁÈ¡ºÍ±àд XML¡£±¾ÎÄÌṩÁËÈýÖÖ·½·¨¶ÁÈ¡ XML£ºÊ¹Óà DOM ¿â¡¢Ê¹Óà SAX ½âÎöÆ÷ºÍʹÓÃÕýÔò±í´ïʽ¡£»¹½éÉÜÁËʹÓà DOM ºÍ PHP Îı¾Ä£°å±àд XML¡£
Óà PHP ¶ÁÈ¡ºÍ±àд¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨XML£©¿´ÆðÀ´¿ÉÄÜÓеã¿Ö²À¡£Êµ¼ÊÉÏ£¬XML ºÍËüµÄË ......

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¶ÁÈ¡xmlÊý¾Ý


½ñÌ칤×÷ÉÏÅöµ½Ò»¸öÎÊÌâ ÓÉÓÚÎÒÃǵÄÏîÄ¿Êý¾ÝÌ«ÉÙ ËùÒÔÐèÒª´Óweb searchÄDZ߽èµ÷Êý¾Ý£¬ËûÃÇÖ»¸øÎÒÃÇÌṩÁËÒ»¸öxmlµÄ½Ó¿Ú¡£Òò´Ë£¬ÎÒÃÇÐèÒª°ÑxmlµÄÊý¾Ýת»¯³Éhtml³ÊÏÖ¸ø´ó¼Ò¡£ÓÉÓÚÏîÄ¿ÊÇ»ùÓÚphpµÄ£¬ËùÒÔ¾ÍÞðÆúÁËÓÃjsÀ´¶ÁÈ¡xmlÑ¡ÔñÁ˼ÌÐøÊ¹ÓÃphp¡£²»¹ý£¬ÎÒÒÔǰ´ÓÀ´Ã»ÓÐ×ö¹ý´ËÀàµÄ³¢ÊÔ ËùÒÔÕÒÁ˺ܶàÍøÉÏ×ÊÁÏͬʱ²ÎÕÕÁËphpµÄ¹¤× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ