php - 从 JSONarray 获取值
问题描述
我正在编写一个 PHP 脚本
连接到数据库
获取数组中的所有订单。($结果)
我想通过数组并获取所有说“用户名”
问题是,使用下面的代码,我只能获取数组中每个“userName”的第一个字符。我想要一个包含所有“userName”的数组。
<?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;
}
解决方案
解决方案应该是下一个:
<?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;
}
看这里的例子:PHPize.online
推荐阅读
- python - How to update json file after data preprocessing with python
- python - How to automate the activation of Flash plug-in using selenium firefox geckodriver?
- javascript - How to show an icon when text is selected using Chrome Extension
- apache-spark - Getting error while connecting kerberos secured phoenix from Spark
- css - How do I find out what CSS is determining the dimensions of my React header component?
- github - 如何从 Github 存储库中传输文件?
- python - How to extract Email, Telephone, Fax number and Address from many different html links by writing a python script?
- kubernetes - mount fuse filesystem inside kubernetes pod
- python - 类型为“NoneType”的 /signup 对象的 TypeError 没有 len()
- sql - 如何使用列值作为间隔来增加 Oracle SQL 中的日期?