php²éѯÊý¾Ý¿âµÄÆæ¹ÖÎÊÌâ - PHP / »ù´¡±à³Ì
php²éѯÊý¾Ý¿âµÄÆæ¹ÖÎÊÌâ
Êý¾Ý¿âÖÐÓÐÁ½¸ö±í£¬·Ö±ðΪgroupÓëperson£¬¶¼Ö»ÓÐÒ»Ìõ¼Ç¼£¨È·È϶¼ÓÐÒ»Ìõ¼Ç¼£©
ͨ¹ýÒÔÏÂÓï¾ä²éѯÊý¾Ý¿â£º
PHP code:
$mysqli = new mysqli("127.0.0.1", "root", "123456", "testdb");
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$query = "select * from person";
if ($result = $mysqli->query($query)) {
while ($obj = $result->fetch_assoc()) {
printf ("%s (%s)\n", $obj["idPerson"], $obj["idPerson"]);
}
$result->close();
}
$mysqli->close();
²éѯ½á¹ûÄܹ»ÕýÈ·ÏÔʾ£¬µ«ÊÇͨ¹ýselect * from group²éѯgroup±í£¬¾Í²é²»µ½Êý¾Ý
select * from `group`
groupÊÇmysqlµÄ±£Áô×Ö£¬Òª¼Ó``²Å¿ÉÒÔ
Ïà¹ØÎÊ´ð£º
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
Í ......
ÏÖÓÐÒ»PHP¿Õ¼ä£¬Ö§³ÖMYSQLÊý¾Ý¿â
Ϊ½ÚÊ¡·ÑÓã¬ÏÖÏëͨ¹ýÓòÃûתÏòĿ¼ÐÎʽ½øÐйÜÀí£¨¼´½«ÓòÃûA¼Ç¼£Û°üÀ¨¶¥¼¶ÓòÃû¼°¶þ¼¶ÓòÃû£Ý¶¼Ö¸Ïòͬһ¿Õ¼ä£©
È磺·ÃÎÊÓòÃû abcd.cn Ö±½Ó·ÃÎÊÍøÕ¾¸ùĿ¼
·ÃÎʶþ¼¶ÓòÃû ef.abcd.cn ......
ÔÚÏÂһѧϰPHP¿ìÒª°ëÄêÁË£¬µ«ÊÇPHP»¹ÊDz»ÖªµÀÔõôÑù°ÑPHPÔËÓõ½ÏÖʵÖУ¬Ï£ÍûÓиßÊÖÓÃPHP×öºÃÁ˵Ķ«Î÷£¬¹©Ð¡µÜѧϰ²Î¿¼Ò»Ï£¬ÒÔ±ãÌá¸ß×Ô¼ºµÄˮƽ¡£
QQ£º766139989
ÏëÒª×öºÃµÄ¶«Î÷£¬ Ϊʲô²»È¥Ï¸ö¿ªÔ´µÄ³ÌÐòÀ´¿´ ......
phpÔõÃ´Ìæ»»Ç°ÃæµÚÒ»¸ö¡°$¡±
Äã²»寫Çå³þ,讓ÈËÔõ麼幫Äã...
¸ß¹ÀÎÒµÄ漢語ˮƽ...»òÄãµÄ±í達ÄÜÁ¦
ÒýÓÃ
Äã²»寫Çå³þ,讓ÈËÔõ麼幫Äã...
¸ß¹ÀÎÒµ ......