我正在編寫一個 PHP 腳本連接到數(shù)據(jù)庫獲取數(shù)組中的所有訂單。（$結(jié)果）我想遍歷數(shù)組并獲取所有“userName”問題是，通過下面的代碼，我只能獲取數(shù)組中每個“userName”的第一個字符。我想要一個包含所有“userName”的數(shù)組。<?php$dbhost = 'localhost';$dbuser = 'user';$dbpass = 'password';$dbname = 'dbname';//Create database connection$dblink = new mysqli($dbhost, $dbuser, $dbpass, $dbname);$sql = "select * from ordertest";$retval = mysqli_query($dblink, $sql) or die(mysqli_error($dblink));$result = mysqli_fetch_array($retval, MYSQLI_ASSOC);if (mysqli_num_rows($retval) > 0) { $arr = json_decode($result, true); foreach ($result as $key => $value) { echo $value["userName"]; }} else { echo $sql;}
1 回答
慕運(yùn)維8079593
TA貢獻(xiàn)1876條經(jīng)驗(yàn) 獲得超5個贊
解決方案應(yīng)該是：
<?php
? ? $sql = "select * from ordertest";
? ? // retrieve query result from DB
? ? $retval = mysqli_query($dblink, $sql) or die(mysqli_error($dblink));
? ??
? ? // if result not empty
? ? if (mysqli_num_rows($retval) > 0) {
? ? ? ? // retrieve single row from $retval
? ? ? ? while ($result = mysqli_fetch_array($retval, MYSQLI_ASSOC)) {
? ? ? ? ? ? echo $result["userName"];
? ? ? ? ? ? echo "\n";
? ? ? ? }
? ? } else {
? ? ? ? echo $sql;
? ? }
- 1 回答
- 0 關(guān)注
- 121 瀏覽
添加回答
舉報(bào)
0/150
提交
取消