态
$cn = curl_init();
$url = 'https://URL';
curl_setopt($cn, CURLOPT_URL, $url);
curl_setopt($cn, CURLOPT_RETURNTRANSFER, TRUE);
$output = curl_exec($cn);
$aOutput = json_decode($output, TRUE);
//var_dump($aOutput);
$curl_error = curl_error($cn);
print_r($curl_error);
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
foreach($aOutput as $key => $data) {
var_dump($key['average_price']);
// var_dump($data[$key]["Average_Price"]);
// $sql = "INSERT INTO Market('type_id', 'average_price', 'adjusted_price')
// VALUES ($data);";
}
array(10763) {
[0]=>
array(3) {
["average_price"]=>
float(381907.23)
["adjusted_price"]=>
float(383184.18)
["type_id"]=>
int(32772)
}
[1]=>
array(3) {
["average_price"]=>
float(54090.07)
["adjusted_price"]=>
float(57340.16)
["type_id"]=>
int(32774)
}
我试图将整个多维阵列添加到我的数据库中。我遇到的主要问题是foreach循环。
我尝试了$ array [$ key] [$ column],还有许多其他方法,但是在倾倒变量时我只会零。
我尝试过,$ key ['faluse_price']等仍然返回null。
最简单的注释:
如果您的$ aoutput数组为
array(10763) {
[0]=>
array(3) {
["average_price"]=>float(381907.23)
["adjusted_price"]=>float(383184.18)
["type_id"]=>int(32772)
}
[1]=>
array(3) {
["average_price"]=>float(54090.07)
["adjusted_price"]=>float(57340.16)
["type_id"]=>int(32774)
}
....
然后
foreach($aOutput as $key => $data) {
// $key = 0
// $data = array(3) {
["average_price"]=>float(381907.23)
["adjusted_price"]=>float(383184.18)
["type_id"]=>int(32772)
}
// So what you want is $data['average_price']
您可以通过不使用HTE键来简化这一点,只需做
foreach($aOutput as $data) {
// $data = array(3) {
["average_price"]=>float(381907.23)
["adjusted_price"]=>float(383184.18)
["type_id"]=>int(32772)
}
// So what you want is $data['average_price']