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
Ïà¹ØÎÊ´ð£º
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
¾ÍÊÇÎÒÔÚij¸öÍøÒ³²åÈëÁËÒ»¸öphpÁ´½Ó
ÎÒÏë»ñµÃÄǸöÍøÖ·µÄµØÖ·¶øÇÒÒªÊä³ötxt¸ñʽ»òÆäËû¸ñʽ¡£Ó¦¸ÃÈçºÎʵÏÖ£¿£¿£¿
ÒýÓÃ
PHP code
<?php
if(!file_exists("ceshi.txt")){
fopen("ceshi. ......
¾ÍÊÇÎÒÔÚij¸öÍøÒ³²åÈëÁËÒ»¸öphpÁ´½Ó
ÎÒÏë»ñµÃÄǸöÍøÖ·µØÖ·µØÖ·À¸µÄurl¶øÇÒÒªÊä³ötxt¸ñʽ»òÆäËû¸ñʽ¡£Ó¦¸ÃÈçºÎʵÏÖ£¿£¿£¿
»¹ÓоÍÊÇдÈëµ½.txt ÎļþÀÔõôȥÅжÏÊÇ·ñÖØ¸´¡£
$_sever[request_uri]
Â¥Ö÷¸øµã·Ö ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......