PHP SQL·µ»ØÊý×éûÓÐË÷Òý - PHP / »ù´¡±à³Ì
±íAÖÐ×Ö¶ÎtebleÓÐÁ½ÌõÊý¾Ý
²éѯA±ítable×ֶβ¢Í³¼ÆÊýÄ¿»ñµÃÁË×Ö¶ÎÃûΪnumֵΪ2
´úÂë:$temp=$data->query($sql)
ÏÖÔÚÎÒÒªÏÔʾÕâ¸öͳ¼Æecho $temp[0]['num'] µ«ÊǿյÄ
È»ºóÎÒÓÃprint_r($temp)ÏÔʾµÄÊÇArray ( [] => Array ( [num] => 1 ) )
ΪʲôËüûË÷ÒýÁË?
֨װ֮ºó¾ÍÕâÑùÁË...ÊÇÎÒµÄphpiniÄÄÅäÖõÄÎÊÌâÂð?
¶ÔÁË,ÒÔǰÓõÄphp°æ±¾ÊÇ5.2.9 ֨װºóÓõÄÊÇ5.2.13
$dataµÄquery·½·¨ÊÇ:
PHP code:
function query($sql){
$result = mysql_query($sql,$this->con);
while ($row = mysql_fetch_assoc($result)){
$array[$i++] = $row;
}
PHP code:
function query($sql)//·µ»Ø¶à¸ö¡£
{
$rss=array();
$result=mysql_query($sql);
if(mysql_num_rows($result)!=0)
{
while($row=mysql_fetch_assoc($result))
{
$rss[]=$row;
}
}
return $rss;
}
PHP code:
<?php
function query($sql){
$result = mysql_query($sql,$this->con);
return mysql_fetch_assoc($result);
}
?>
#1Â¥µÄ¿ÉÐÐ
ÕâÑù¾Í¿ÉÒÔÁË
function query($sql){
$result = mysql_query($sql,$this->con);
 
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ĿǰÔÚÎ人ÕÒ¹¤×÷
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
±±¾©2ÄêPHP¾ÑéÇó¼æÖ°
½Ó·Ö
·¹ý½Ó·Ö£¡.¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
jf~~~~~~~~~~~~~~Ö§³Ö
ßÀ¡£¡£ÎÒÃÇÐèÒª¼æÖ°£¬¿ÉÊÇÔõôÁªÏµÄãѽ£¿
¶¥¡£¡£¡£ »Ø¸´ÄÚÈÝ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
º¼ÖÝÄãÈ¥²»È¥°¡ ¡£¡£¡£¡£¡ ......
mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......