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µÄ±£Áô×Ö£¬Òª¼Ó``²Å¿ÉÒÔ
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
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ÖÐ ÉùÃ÷±äÁ¿µÄʱºòÒ»¸ö$¸úÁ½¸ö$µÄÇø±ð
±ÈÈç˵
$var="333"; ±íʾ±äÁ¿ÃûΪ$varµÄ±äÁ¿µÄֵΪ333
$var="myvar";$$var="333";±íʾ±äÁ¿ÃûΪ$myvarµÄ±äÁ¿µÄֵΪ333
ÕâÑù˵Çå³þÁËÂð£¿
......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´
ÎÒÓõĵÄÊÇiis smtp
<?php
$to = 'xueyuxia1988@sohu.com';
$subject = 'the subject';
$message = 'hello';
$ ......