Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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);
 


Ïà¹ØÎÊ´ð£º

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

Ïëѧphp - PHP / »ù´¡±à³Ì

Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡

ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ

Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â

php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£

È¥ÂòÊ¥¾­°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ