³õѧPHP,Êý¾Ý¼¯Ôõô´¦Àí³ÉÊý×é - PHP / »ù´¡±à³Ì
±ÈÈçÎҵIJéѯÓï¾äÊÇ"select username,sex,age from users"
ÎÒÔõôÄܰѲ鵽µÄ½á¹ûÓëÊý×é°ó¶¨
Çë¸ø³öÍêÕû´úÂë
$sql = "select username,sex,age from users";
$query= mysql_query($sql);
while($fetch=mysql_fetch_array($query)){
$array[] = array(
'sex' => $fetch['sex'],
'username' => $fetch['username'],
'age' => $fetch['age'],
);
}
PHP code:
$result = mysql_query($_sql, $this->m_database) ;
// »ñµÃ²éѯµÄ½á¹û´æÈëArray
$queryResult = array ();
while ( $row = mysql_fetch_assoc ( $result ) ) {
$queryResult [] = $row ;
}
// ÊÍ·Å
mysql_free_result ( $result );
// ²éѯµÄ½á¹û·µ»ØArray
return $queryResult;
ÆäÖÐ $_sqlÊÇÒªÖ´ÐеÄsqlÓï¾ä£¬$this->m_database ¿ÉÒÔÌæ»»³ÉÄãÒª²éѯµÄÊý¾Ý¿â×Ö·û´®
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
²ËÄñÇó¾È£¡£¡
ÏÖÔÚÎÒÊÖÍ·ÓÐÒ»¸öphp+oracleµÄÍøÕ¾¡£¡£·þÎñÆ÷ÊÇlinuxϵͳ
Çë¸÷λ¸æËßÎÒÈçºÎ·¢²¼¡£¡£¡£ÎÒÊÇÐÂÊÖ¡£Ð»Ð»ÁË£¡£¡
°²×°Ò»¸öapache£¬°ÑphpÎļþ·Åµ½apacheµÄ·¢²¼Ä¿Â¼Ï£¬ ......
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......
ÎÒ×öµÄ×¢²áÊÇÖ§³ÖÖÐÎĵ쬵±Óû§ÊäÈëÓû§ÃûÖ®ºó£¬µã»÷¼ì²éÓû§Ãû°´Å¥£¬Ö»ÓÐÌØ¶¨µÄijЩºº×Ö²»ÄÜ×¢²á£¬¶øÇÒÌáʾµÄÐÅÏ¢ÊÇ´íÎóµÄ£¬ÆäËûµÄºº×Ö¶¼¿ÉÒÔ£¬¶øÇÒµã»÷¼ì²éÓû§Ãû°´Å¥ºóµÄÌáʾÐÅÏ¢£¬Ò²¶¼ÕýÈ·£¬ÇëÎÊÈçºÎ½â¾ö¡£
Äã ......