如何从JSONPHP中删除多余的数组

我想从json中删除多余的数组。因此需要帮助。

这是我当前的json的显示方式：

下图显示了我需要的内容（无数组）：

这是我的php代码

define('HOST','localhost');
define('USER','appzcvfy_admin');
define('PASS','adminroot1');
define('DB','appzcvfy_sinala_short_stories');
$cOnn= mysqli_connect(HOST,USER,PASS,DB);
$sql1 = "select * from table_3";
$result1=mysqli_query($conn,$sql1);
$MainArray = array();
$Facilities = array();
$OpeningHours = array();
while ($row1=mysqli_fetch_assoc($result1)) {
$Facilities['t1_id'] = $row1['id'];
$Facilities['t1_name'] = $row1['name'];
$Facilities['t1_link'] = $row1['link'];
$Facilities['OpeningHours'] = array();
$sql2 = "SELECT * FROM table_4 WHERE (id) = ".$row1['id']."";
$result2=mysqli_query($conn,$sql2);
while ($row2=mysqli_fetch_assoc($result2)) {
$OpeningHours['t2_id'] = $row2['id'];
$OpeningHours['t2_name'] = $row2['name'];
$OpeningHours['t2_link'] = $row2['link'];
$OpeningHours['t2_url'] = $row2['url'];
array_push($Facilities['OpeningHours'],$OpeningHours);
}
array_push($MainArray,$Facilities);
}
$jsOnData= json_encode(array('server_respnose' => $MainArray),JSON_PRETTY_PRINT);
echo $jsonData;
?>


任何人都可以根据我的需要重新排列我的php代码。谢谢

假设只有一行，则不需要循环，而不是创建一个临时数组然后添加它，只需将值直接设置到元素中即可。

LR = LogisticRegression(featuresCol = 'features',labelCol = 'label',maxIter=some_iter)
LR_model = LR.fit(train)


根据RamRaider的建议，您可以将其减少为1个查询

LR_model.coefficientMatrix

而只是获取要从中输出的详细信息-请阅读他的答案以对此进行更全面的说明。

在发布之前，我刚刚看到我可能已经被表连接插入了帖子，但是无论如何〜这样做可能有助于简化事情。

define('HOST','localhost');
define('USER','appzcvfy_admin');
define('PASS','adminroot1');
define('DB','appzcvfy_sinala_short_stories');
$cOnn= mysqli_connect( HOST,USER,PASS,DB );
$data=array();
$sql='select
t3.`id` as `id1`,t3.`name` as `name1`,t3.`link` as `link11,t4.`id` as `id2`,t4.`name` as `name2`,t4.`link` as `link2`,t4.`url`
from table_3 t3
join table_4 t4 on t3.id=t4.id';
$res=$conn->query( $sql );
if( $res ){
while( $rs=$res->fetch_object() ){
$data[]=array(
't1_id' => $rs->id1,'t1_name' => $rs->name1,'t1_link' => $rs->link1,'OpeningHours' => array(
't2_id' => $rs->id2,'t2_name' => $rs->name2,'t2_link' => $rs->link2,'t2_url' => $rs->url,)
);
}
$payload=array('server response'=>$data);
$json=json_encode( $payload );
echo $json;
}
?>

,

您将其声明为array()，因此删除该位：

$Facilities['OpeningHours'] = array(); // delete this


并替换为：

array_push($Facilities['OpeningHours'],$OpeningHours);


与此：

$Facilities['OpeningHours'] = $OpeningHours;