課程
/后端開發(fā)
/PHP
/PHP進階篇
那mysqli怎么連接呢？求大神
2017-05-03
源自：PHP進階篇 7-3
正在回答
正解！
放狗過來 提問者
<?php? ?
???? ?
????/*?Connect?to?a?MySQL?server??連接數(shù)據(jù)庫服務(wù)器?*/? ?
????$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?連接數(shù)據(jù)庫名稱*/? ?
????if?(!$link)?{? ?
???????printf("Can't?connect?to?MySQL?Server.?Errorcode:?%s?",?mysqli_connect_error());? ?
???????exit;? ?
????}? ?
????/*?Send?a?query?to?the?server?向服務(wù)器發(fā)送查詢請求*/? ?
????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?返回查詢的結(jié)果?*/? ?
????????while(?$row?=?mysqli_fetch_assoc($result)?){? ?
????????????printf("%s?(%s)?",?$row['Name'],?$row['Population']);? ?
????????}? ?
????????/*?Destroy?the?result?set?and?free?the?memory?used?for?it?結(jié)束查詢釋放內(nèi)存?*/? ?
????????mysqli_free_result($result);? ?
????/*?Close?the?connection?關(guān)閉連接*/? ?
????mysqli_close($link);? ?
?????>?
舉報
輕松學(xué)習(xí)PHP中級課程，進行全面了解，用PHP快速開發(fā)網(wǎng)站程序
2 回答請問怎么連接數(shù)據(jù)庫？
3 回答連接數(shù)據(jù)庫出現(xiàn)警告怎么解決
2 回答關(guān)于mysqli query的插入語句
1 回答連接數(shù)據(jù)庫出錯
3 回答數(shù)據(jù)庫連接失敗....
Copyright ? 2025 imooc.com All Rights Reserved | 京ICP備12003892號-11 京公網(wǎng)安備11010802030151號
購課補貼聯(lián)系客服咨詢優(yōu)惠詳情
慕課網(wǎng)APP您的移動學(xué)習(xí)伙伴
掃描二維碼關(guān)注慕課網(wǎng)微信公眾號
2017-05-03
正解！
2017-05-03
<?php? ?
???? ?
????/*?Connect?to?a?MySQL?server??連接數(shù)據(jù)庫服務(wù)器?*/? ?
????$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?連接數(shù)據(jù)庫名稱*/? ?
???? ?
????if?(!$link)?{? ?
???????printf("Can't?connect?to?MySQL?Server.?Errorcode:?%s?",?mysqli_connect_error());? ?
???????exit;? ?
????}? ?
???? ?
????/*?Send?a?query?to?the?server?向服務(wù)器發(fā)送查詢請求*/? ?
????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?返回查詢的結(jié)果?*/? ?
????????while(?$row?=?mysqli_fetch_assoc($result)?){? ?
????????????printf("%s?(%s)?",?$row['Name'],?$row['Population']);? ?
????????}? ?
???? ?
????????/*?Destroy?the?result?set?and?free?the?memory?used?for?it?結(jié)束查詢釋放內(nèi)存?*/? ?
????????mysqli_free_result($result);? ?
????}? ?
???? ?
????/*?Close?the?connection?關(guān)閉連接*/? ?
????mysqli_close($link);? ?
?????>?