PHP mysql_fetch_array ʹÓÃÎÊÌâ
СµÜ¸Õ¸Õ½Ó´¥PHP£¬ÏÖÔÚÓöµ½ÕâÑùµÄÎÊÌ⣺
<?php
$sqlstr="select news_picaddress,news_head from news where news_pic=1";
mysql_connect("localhost","myuserid","mypassword");
$result = mysql_db_query("xinwen",$sqlstr);
printf("Return Rows Num: %d\n",mysql_num_rows($result));//Êä³ö2
printf("Return news_picaddress: %s\n",mysql_result($result,0,"news_picaddress"));//Êä³ö²éµ½µÄµØÖ·
while ($rs=mysql_fetch_array($result))
{
print_r($rs); //Êä³ö1£»
$picaddress=$rs[0]; // $picaddressΪnull
$picaddress=$rs['news_picaddress']; // $picaddressΪnull
$picaddress=$rs["news_picaddress"]; // $picaddressΪnull
}
?>
ÕâÊÇÎªÊ²Ã´ÄØ£¿ÎªÊ²Ã´mysql_resultÓÐÖµ£¬¶ømysql_fetch_array²»ÄÜÕýÈ·µÄÌáÈ¡³ö²éѯµ½µÄֵĨ£¿
printf("Return news_picaddress: %s\n",mysql_result($result,0,"news_picaddress"));//Êä³ö²éµ½µÄµØÖ·
Äã°Ñ這Ò»¾äÈ¥µô
È»ááPHP¹Ù·½強ÁÒ½¨議ÔÚPHP 4.0áá²»ÒªÓÃmysql_db_query, 應ÓÃmysql_select_db ºÍ mysql_query 來進Ðвé詢
´óÏÀ£¬
PHP code:
$sqlstr="select
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
index.phpÄÚÈÝ£º
$smarty->assign('name',strtotime('-0'));
$smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡
ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ
Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â
php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£
È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
¾ÍÊÇÎÒÔÚij¸öÍøÒ³²åÈëÁËÒ»¸öphpÁ´½Ó
ÎÒÏë»ñµÃÄǸöÍøÖ·µØÖ·µØÖ·À¸µÄurl¶øÇÒÒªÊä³ötxt¸ñʽ»òÆäËû¸ñʽ¡£Ó¦¸ÃÈçºÎʵÏÖ£¿£¿£¿
»¹ÓоÍÊÇдÈëµ½.txt ÎļþÀÔõôȥÅжÏÊÇ·ñÖØ¸´¡£
$_sever[request_uri]
Â¥Ö÷¸øµã·Ö ......