SQL Results as PHP Array

Question

I am trying to solve this. Maybe this is absolutly incorrect, I need some help.

I have a table like this:

INSERT INTO `municipios` (`id`, `provincia`, `municipio`) VALUES (1, 1, 'Alegría-Dulantzi'), (2, 1, 'Amurrio'), (3, 1, 'Añana'), (4, 1, 'Aramaio'), (5, 1, 'Armiñón'),

And this is my handler:

    $query = "SELECT * FROM municipios WHERE provincia='1'";
$result = mysql_query($query);      
while ($row = mysql_fetch_array($result)) {                 
    $groups = array(
    $row{'id'} => array(
        'name' => $row{'municipio'},
        'description' => 'Agrupación electoral de ' . $row{'municipio'},
        'status' => 'public',
        'enable_forum' => 1,
        ),
        );
}

With this I got just the last result. I have tried another options, but doesn´t work.

Use of my mysql_* is not recommended. It is deprecated and will not be supported in later versions of PHP. — christopher
– christopher, Commented May 6, 2013 at 18:39

au_stan · Accepted Answer · 2013-05-06 18:47:41Z

2

Something like this should solve your issue:

$groups[] = array(
     $row['id'] => array(
        'name' => $row['municipio'],
        'description' => 'Agrupación electoral de ' . $row['municipio'],
       'status' => 'public',
       'enable_forum' => 1,
     ),
  );

However, may i suggest your use PDO. There is a pretty good article http://net.tutsplus.com/tutorials/php/why-you-should-be-using-phps-pdo-for-database-access/ that should get you going in the right direction.

answered May 6, 2013 at 18:47

au_stan

4,2112 gold badges21 silver badges24 bronze badges

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

3 Comments

Fernando Marcet Manrique Over a year ago

Thank you very much for the answer... but I tried this before, and doesn´t work. The groups are created, but there is not any description, name... this is the result in the sql table: INSERT INTO wp_bp_groups VALUES (1, 1, '', '', '', '', 1, '2013-05-05 08:56:26'); INSERT INTO wp_bp_groups VALUES (2, 1, '', '', '', '', 1, '2013-04-25 02:32:08'); INSERT INTO wp_bp_groups VALUES (3, 1, '', '', '', '', 1, '2013-05-03 22:22:55'); I will try PDO. Thank you again.

Fernando Marcet Manrique Over a year ago

Same trouble with PDO. Groups are created, but no data inside. This is my code: $DBH = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password); $STH = $DBH->query('SELECT * FROM municipios WHERE provincia=1'); $STH->setFetchMode(PDO::FETCH_ASSOC); while($row = $STH->fetch()) { $groups[] = array( $row['id'] => array( 'name' => $row['municipio'], 'description' => 'Agrupación electoral de ' . $row['municipio'], 'status' => 'private', 'enable_forum' => 1, ), ); }

au_stan Over a year ago

what is the output of $row ?

Rikkouri · Accepted Answer · 2013-05-06 18:46:01Z

0

Is this an issue with the way you're appending the groups array? I think your overwriting the array every time u set a value. Try using array_push() to append to groups.

Let us know of that helps!

array_push() http://php.net/manual/en/function.array-push.php

answered May 6, 2013 at 18:46

Rikkouri

872 silver badges9 bronze badges

Collectives™ on Stack Overflow

SQL Results as PHP Array

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related