課程
/后端開發
/PHP
/PHP進階篇
那mysqli怎么連接呢？求大神
2017-05-03
源自：PHP進階篇 7-3
正在回答
正解！
放狗過來 提問者
<?php? ?
???? ?
????/*?Connect?to?a?MySQL?server??連接數據庫服務器?*/? ?
????$link?=?mysqli_connect(? ?
????????????????'localhost',??/*?The?host?to?connect?to?連接MySQL地址?*/? ?
????????????????'user',??????/*?The?user?to?connect?as?連接MySQL用戶名?*/? ?
????????????????'password',??/*?The?password?to?use?連接MySQL密碼?*/? ?
????????????????'world');????/*?The?default?database?to?query?連接數據庫名稱*/? ?
????if?(!$link)?{? ?
???????printf("Can't?connect?to?MySQL?Server.?Errorcode:?%s?",?mysqli_connect_error());? ?
???????exit;? ?
????}? ?
????/*?Send?a?query?to?the?server?向服務器發送查詢請求*/? ?
????if?($result?=?mysqli_query($link,?'SELECT?Name,?Population?FROM?City?ORDER?BY?Population?DESC?LIMIT?5'))?{? ?
????????print("Very?large?cities?are:?");? ?
????????/*?Fetch?the?results?of?the?query?返回查詢的結果?*/? ?
????????while(?$row?=?mysqli_fetch_assoc($result)?){? ?
????????????printf("%s?(%s)?",?$row['Name'],?$row['Population']);? ?
????????}? ?
????????/*?Destroy?the?result?set?and?free?the?memory?used?for?it?結束查詢釋放內存?*/? ?
????????mysqli_free_result($result);? ?
????/*?Close?the?connection?關閉連接*/? ?
????mysqli_close($link);? ?
?????>?
舉報
輕松學習PHP中級課程，進行全面了解，用PHP快速開發網站程序
2 回答請問怎么連接數據庫？
3 回答連接數據庫出現警告怎么解決
2 回答關于mysqli query的插入語句
1 回答連接數據庫出錯
3 回答數據庫連接失敗....
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號-11 京公網安備11010802030151號
購課補貼聯系客服咨詢優惠詳情
慕課網APP您的移動學習伙伴
掃描二維碼關注慕課網微信公眾號
2017-05-03
正解！
2017-05-03
<?php? ?
???? ?
????/*?Connect?to?a?MySQL?server??連接數據庫服務器?*/? ?
????$link?=?mysqli_connect(? ?
????????????????'localhost',??/*?The?host?to?connect?to?連接MySQL地址?*/? ?
????????????????'user',??????/*?The?user?to?connect?as?連接MySQL用戶名?*/? ?
????????????????'password',??/*?The?password?to?use?連接MySQL密碼?*/? ?
????????????????'world');????/*?The?default?database?to?query?連接數據庫名稱*/? ?
???? ?
????if?(!$link)?{? ?
???????printf("Can't?connect?to?MySQL?Server.?Errorcode:?%s?",?mysqli_connect_error());? ?
???????exit;? ?
????}? ?
???? ?
????/*?Send?a?query?to?the?server?向服務器發送查詢請求*/? ?
????if?($result?=?mysqli_query($link,?'SELECT?Name,?Population?FROM?City?ORDER?BY?Population?DESC?LIMIT?5'))?{? ?
???? ?
????????print("Very?large?cities?are:?");? ?
???? ?
????????/*?Fetch?the?results?of?the?query?返回查詢的結果?*/? ?
????????while(?$row?=?mysqli_fetch_assoc($result)?){? ?
????????????printf("%s?(%s)?",?$row['Name'],?$row['Population']);? ?
????????}? ?
???? ?
????????/*?Destroy?the?result?set?and?free?the?memory?used?for?it?結束查詢釋放內存?*/? ?
????????mysqli_free_result($result);? ?
????}? ?
???? ?
????/*?Close?the?connection?關閉連接*/? ?
????mysqli_close($link);? ?
?????>?