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);
 
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡
ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ
Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â
php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£
È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä
Id value state dattime
101 32.3 0 ......