Array in PHP does not work

Question

I am trying to add array data from mysql. But only the last row details are getting added. I tried array_push also but did not work. Can any one help

$sql="SELECT * FROM server_details";
$result=mysqli_query($dbC,  $sql);
while ($row = mysqli_fetch_array($result))
{
$services=array( 
    $row['server_name'] => array($row['server_add'] => $row['port'])
); 
}

adeneo · Accepted Answer · 2013-04-07 10:39:51Z

2

By not creating a new array in every iteration of the loop :

$sql      = "SELECT * FROM server_details";
$result   = mysqli_query($dbC,  $sql);
$services = array();

while ($row = mysqli_fetch_array($result)) {
    $services[$row['server_name']] = array($row['server_add'] => $row['port']); 
}

answered Apr 7, 2013 at 10:39

adeneo

319k29 gold badges410 silver badges392 bronze badges

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

Comments

raina77ow · Accepted Answer · 2013-04-07 10:39:45Z

1

Perhaps you're looking for this:

$services[ $row['server_name'] ] = array($row['server_add'] => $row['port']);

In the end you'll get in your $services variable an associative array, indexed by server_name column values.

If they're not unique, you should do this instead...

$services[ $row['server_name'] ][] = array($row['server_add'] => $row['port']);

This way you'll still get the same associative array, but its values will be indexed arrays; thus you won't lose any information for records with the same server_name.

answered Apr 7, 2013 at 10:39

raina77ow

107k16 gold badges205 silver badges240 bronze badges

Collectives™ on Stack Overflow

Array in PHP does not work

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related