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µÄ±£Áô×Ö£¬Òª¼Ó``²Å¿ÉÒÔ
Ïà¹ØÎÊ´ð£º
mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´
ÎÒÓõĵÄÊÇiis smtp
<?php
$to = 'xueyuxia1988@sohu.com';
$subject = 'the subject';
$message = 'hello';
$ ......
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
»òÕßÔÚjsÎļþÀïµ÷ÓÃphpÎļþдµÄseesion£¿
PHP¸ÕÈëÃÅѧϰ,ÓÑÇé¶¥Ò»¸ö
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
//echo '<script>alert("ok");< ......