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±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
zend guard¼ÓÃܵÄphpÊÇ¿ÉÒÔÆÆ½âµÄ£¬ÓÐµÄ ËµÊÇʹÓú¯Êý»ìÏý¿ÉÒÔ¸üÄÑÆÆ½âһЩ¡£ÔõôʹÓÃÄØ¡£
»òÕß´ó¼Ò¸æËßÎÒÄÄÖÖ¼ÓÃÜ·½Ê½¸ü°²È«¡£Ð»Ð»ÁË¡£
ÎÒĿǰµÄzend guard°æ±¾ÊÇ4.0.1
ÎÞ½â
ÒýÓÃ
ÎÞ½â
²»¿ÉÄܰɡ£ÔÚÍøÉϲéÁ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
index.phpÄÚÈÝ£º
$smarty->assign('name',strtotime('-0'));
$smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......
mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......