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
Ïà¹ØÎÊ´ð£º
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
index.phpÄÚÈÝ£º
$smarty->assign('name',strtotime('-0'));
$smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......
¾ÍÊÇÎÒÔÚij¸öÍøÒ³²åÈëÁËÒ»¸öphpÁ´½Ó
ÎÒÏë»ñµÃÄǸöÍøÖ·µÄµØÖ·¶øÇÒÒªÊä³ötxt¸ñʽ»òÆäËû¸ñʽ¡£Ó¦¸ÃÈçºÎʵÏÖ£¿£¿£¿
ÒýÓÃ
PHP code
<?php
if(!file_exists("ceshi.txt")){
fopen("ceshi. ......