How to add data in an array

Question

I have a while loop from which I'm Fetching Name from database, How can I add all the name fetched from database into that array

Here is How I fetch Name From Database

<?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 } ?>

This Results in

name: example1
name: example2 & so on......

i want to put all these name into array like this->

array("example1", "example2", "example3");

Death-is-the-real-truth · Accepted Answer · 2016-04-14 16:36:19Z

2

You need to create a new array variable and assign value to that array varaible like below:-

<?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
?>

output should be look like what you want:- array("example1", "example2", "example3");

answered Apr 14, 2016 at 16:36

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

odannyc · Accepted Answer · 2016-04-14 16:36:33Z

2

You can push the results into an array. Try this:

$names = array();
while( $b = mysqli_fetch_array($a)) {
    array_push($names, b['name']);
}

This will push to the $names array and $names will look like this:

array("name1", "name2", "name3");

answered Apr 14, 2016 at 16:36

odannyc

7189 silver badges25 bronze badges

Comments

sidzaky · Accepted Answer · 2016-04-14 16:50:58Z

1

you can use this code

while( $b = mysqli_fetch_array($a)) {
    $name[]=b['name'];
}

answered Apr 14, 2016 at 16:50

sidzaky

571 silver badge6 bronze badges

Comments

Ivan · Accepted Answer · 2016-04-14 18:06:22Z

1

Use this:

<?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);
    ?>

answered Apr 14, 2016 at 18:06

Ivan

113 bronze badges

1 Comment

Dinidu Hewage Over a year ago

if you could describe your answer a little bit with some words, it would be more useful

Collectives™ on Stack Overflow

How to add data in an array

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related