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ģʽ£¬³äʵһÏÂ×ÔÎÒ£¬²»ÖÁÓÚÂäºó¡£¿´Á˸ö¼òµ¥µÄʾÀý
£¬×öµã¼Ç¼¡£
µ¥µãÈë¿Ú£º
1. ËùÓгÌÐò¶¼ÊÇͨ¹ýindex.phpÀ´½øÐе÷Óõģ¬ÕâÒª¿¿.htaccessÎļþÀ´½øÐпØÖÆ¡£
2. URL router¿ÉÒÔÓɵ¥¶ÀµÄRouterÀàÀ´½øÐÐControllerµÄÑ¡Ôñ£¬Ò²¿ÉÒÔ·ÅÔÚindex.phpÖнøÐÐÑ¡Ôñ¡£
3. Config×îºÃ·Åµ½µ¥¶ÀµÄÎļþÖУ¬½á ......
Óà PHP ¶ÁÈ¡ºÍ±àд XML DOM
ʹÓà DOM ¿â¡¢SAX ½âÎöÆ÷ºÍÕýÔò±í´ïʽ
ÓÐÐí¶à¼¼Êõ¿ÉÓÃÓÚÓà PHP ¶ÁÈ¡ºÍ±àд XML¡£±¾ÎÄÌṩÁËÈýÖÖ·½·¨¶ÁÈ¡ XML£ºÊ¹Óà DOM ¿â¡¢Ê¹Óà SAX ½âÎöÆ÷ºÍʹÓÃÕýÔò±í´ïʽ¡£»¹½éÉÜÁËʹÓà DOM ºÍ PHP Îı¾Ä£°å±àд XML¡£
Óà PHP ¶ÁÈ¡ºÍ±àд¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨XML£©¿´ÆðÀ´¿ÉÄÜÓеã¿Ö²À¡£Êµ¼ÊÉÏ£¬XML ºÍËüµÄË ......
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;
Æ ......
½ñÌ칤×÷ÉÏÅöµ½Ò»¸öÎÊÌâ ÓÉÓÚÎÒÃǵÄÏîÄ¿Êý¾ÝÌ«ÉÙ ËùÒÔÐèÒª´Óweb searchÄDZ߽èµ÷Êý¾Ý£¬ËûÃÇÖ»¸øÎÒÃÇÌṩÁËÒ»¸öxmlµÄ½Ó¿Ú¡£Òò´Ë£¬ÎÒÃÇÐèÒª°ÑxmlµÄÊý¾Ýת»¯³Éhtml³ÊÏÖ¸ø´ó¼Ò¡£ÓÉÓÚÏîÄ¿ÊÇ»ùÓÚphpµÄ£¬ËùÒÔ¾ÍÞðÆúÁËÓÃjsÀ´¶ÁÈ¡xmlÑ¡ÔñÁ˼ÌÐøÊ¹ÓÃphp¡£²»¹ý£¬ÎÒÒÔǰ´ÓÀ´Ã»ÓÐ×ö¹ý´ËÀàµÄ³¢ÊÔ ËùÒÔÕÒÁ˺ܶàÍøÉÏ×ÊÁÏͬʱ²ÎÕÕÁËphpµÄ¹¤× ......