PHP How to split multi dimensional array into single array?

Question

Simple code that i use to get array results:

require_once 'connect_to_mysql.php';
$sql = "SELECT * FROM protect";
$result = mysqli_query($conn, $sql);
$db_array = array();
    if (mysqli_num_rows($result) > 0){
        while ($row = mysqli_fetch_assoc($result)){
            $db_array[] = $row;
        }
    }
    echo '<pre>';
    print_r($db_array);
    echo '</pre>';

I get the following array from database:

Array
(
    [0] => Array
        (
            [id] => 1
            [words] => cat
            [keyword] => nice cat
        )

    [1] => Array
        (
            [id] => 2
            [words] => good dog
            [keyword] => dog training
        )

    [2] => Array
        (
            [id] => 3
            [words] => love birds
            [keyword] => birds
        )

)

i wish to get this all data in a single array like this:

Array
(
    [0] => cat
    [1] => good dog
    [2] => love birds
)

Could you please tell how i can do so? Thank you.

Why not just only add the row words to your array here: $db_array[] = $row;?! — Rizier123
– Rizier123, Commented Feb 25, 2017 at 21:08

Rajdeep Paul · Accepted Answer · 2017-02-25 21:08:17Z

4

Change your while() loop in the following way,

while ($row = mysqli_fetch_assoc($result)){
    $db_array[] = $row['words'];
}

answered Feb 25, 2017 at 21:08

Rajdeep Paul

16.9k3 gold badges21 silver badges39 bronze badges

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

Comments

Mihai · Accepted Answer · 2017-02-25 21:09:11Z

3

Just change your query,no need to get data you don`t use

$sql = "SELECT words FROM protect";

answered Feb 25, 2017 at 21:09

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

Comments

trincot · Accepted Answer · 2017-02-25 21:08:29Z

2

You can do this with the function array_column:

$smaller = array_column($db_array, 'words')

answered Feb 25, 2017 at 21:08

trincot

357k38 gold badges282 silver badges338 bronze badges

Collectives™ on Stack Overflow

PHP How to split multi dimensional array into single array?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related