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µÄ±£Áô×Ö£¬Òª¼Ó``²Å¿ÉÒÔ
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÔÚÏÂһѧϰPHP¿ìÒª°ëÄêÁË£¬µ«ÊÇPHP»¹ÊDz»ÖªµÀÔõôÑù°ÑPHPÔËÓõ½ÏÖʵÖУ¬Ï£ÍûÓиßÊÖÓÃPHP×öºÃÁ˵Ķ«Î÷£¬¹©Ð¡µÜѧϰ²Î¿¼Ò»Ï£¬ÒÔ±ãÌá¸ß×Ô¼ºµÄˮƽ¡£
QQ£º766139989
ÏëÒª×öºÃµÄ¶«Î÷£¬ Ϊʲô²»È¥Ï¸ö¿ªÔ´µÄ³ÌÐòÀ´¿´ ......
phpͬʱµ÷ÓÃ3¸öÊý¾Ý¿âÖеÄÒ»¸ö±íµÄÐÅÏ¢£¨¼ÜÉèA.a.aid=B.b.bid=C.c.cid£©£¬Çë˵Ã÷˼·¼°Êéд²¿·Ö´úÂë
ÀýÈ磺
SELECT time, goodid from dbname1.time, dbname2.goods
ÊÇÕâ¸öÒâ˼ô£¿
SELECT time, goodid from ......
phpÖÐÈçºÎÊä³öǧ·Öλ·Ö¸ô·û¡£¡£¡£¡£¡£
number_format
PHP code:
//ÊÇÕâÖÖЧ¹û°É£¿
echo number_format(123123123, 2, '.', ',');
//½á¹ûÊä³ö123,123,123.00 2ÊÇСÊýµãºóλÊý£¬µÚÈý¸ö²ÎÊýÊÇСÊýµã·Ö¸ô·û ......