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±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
index.phpÄÚÈÝ£º
$smarty->assign('name',strtotime('-0'));
$smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡
ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ
Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â
php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£
È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......