我有一个while循环,从中从数据库中获取名称,我如何将从数据库中提取的所有名称添加到数组中
以下是如何从数据库中获取名称
<?php $a = mysqli_query($connecDB, "SELECT * FROM video WHERE post_id='$puser'");
while( $b = mysqli_fetch_array($a)){?>
name: <?php echo $b['name'];?><br>
<?php } ?>
这导致
name: example1
name: example2 & so on......
我想把所有这些名字放进这样的数组->
array("example1", "example2", "example3");
您需要创建一个新的数组变量,并为该数组变量赋值,如下所示:-
<?php
$new_array = array(); // create an empty array variable
$a = mysqli_query($connecDB, "SELECT * FROM video WHERE post_id='$puser'");
while( $b = mysqli_fetch_array($a)){
$new_array[] = $b['name']; // assign value to array
}
echo "<pre/>";print_r($new_array); // print array
?>
输出应该看起来像您想要的:-array("example1"、"example2"、"sample3")
您可以将结果推送到一个数组中。试试这个:
$names = array();
while( $b = mysqli_fetch_array($a)) {
array_push($names, b['name']);
}
这将推送到$names数组,$names
将如下所示:
array("name1", "name2", "name3");
您可以使用此代码
while( $b = mysqli_fetch_array($a)) {
$name[]=b['name'];
}
使用此:
<?php
$names = array(); // create an empty array variable
$a = mysqli_query($connecDB, "SELECT * FROM video WHERE post_id='$puser'");
while( $b = mysqli_fetch_array($a)){
**array_push($names, b['name']);** //USE PUSH TO ADD VALUES AND THIS WILL AUTOMATICALLLY SEPARATE WITH A ","
}
echo "<pre/>";print_r($new_array);
?>