singly mysql field in an associative array

Question

I currently have this code:

$res= $mysqli->query("SELECT titre FROM Bibliographie WHERE Nom_Auteur LIKE '%$auteur%'"); 

while ($row=$res->fetch_assoc()) {
    var_dump($row);
}

The outcome is:

array(1) {
    ["titre"]=>
    string(65) "Le droit privé dans les Pays-Bas méridionaux du 12e au 18e siècle"
}
 array(1) {
    ["titre"]=>
    string(41) "Le droit foncier à Bruxelles au moyen-âge"  
} 
array(1) {
    ["titre"]=>
    string(78) "Les sûretés personnelles dans les Pays-Bas méridionaux du XIe au XVIIIe siècle"
}
array(1) {
    ["titre"]=>
    string(44) "Chartes du chapitre de St-Gudule à Bruxelles"
}

But I want the outcome to be:

[0] => "Le droit privé dans les Pays-Bas méridionaux du 12e au 18e siècle"
[1] => "Le droit foncier à Bruxelles au moyen-âge"
[2] => "Chartes du chapitre de St-Gudule à Bruxelles"

I can't get my head around this and need some help obtaining this simple outcome...

Gerald Schneider · Accepted Answer · 2015-04-23 13:33:36Z

2

You can achieve your desired result this way:

$result = array();
while ($row=$res->fetch_assoc()) {
    $result[] = $row['titre'];
} 
var_dump($result);

answered Apr 23, 2015 at 13:33

Gerald Schneider

17.8k10 gold badges64 silver badges79 bronze badges

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

Comments

Bhavesh G · Accepted Answer · 2015-04-24 07:00:21Z

1

You have various options to do this,

1) You can use fetch_all() method instead of fetch_assoc() to get all data in one variable at once and then you can flattern the array using this function.

$res= $mysqli->query("SELECT titre FROM Bibliographie WHERE Nom_Auteur LIKE '%$auteur%'"); 
$result = array_map(function($ary) {return $ary['titre'];}, $res->fetch_all());
// Just two lines of code. No big deal

2) As Gerald Schneider suggested,

$res= $mysqli->query("SELECT titre FROM Bibliographie WHERE Nom_Auteur LIKE '%$auteur%'"); 

$result = array();
while ($row=$res->fetch_assoc()) {
     $result[] = $row['titre'];
} 
var_dump($result);
// simple and easy to understand

edited Apr 24, 2015 at 7:00

answered Apr 23, 2015 at 14:22

Bhavesh G

3,0285 gold badges47 silver badges69 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:06:13Z

0

Try using while ($row=$res->fetch_array()){var_dump($row);} instead. See Mysqli fetch_assoc vs fetch_array

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Apr 23, 2015 at 13:11

Ben Marshall

1,7642 gold badges18 silver badges36 bronze badges

Collectives™ on Stack Overflow

singly mysql field in an associative array

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related