• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

Building a dynamic array from a postgresql database in PHP

Hi,

I am new to PHP and need a little help with a project I am working on. Below is some code that I am using to build a 2 dimensional array:

// get all employee data
$db=new Database($_SESSION['dbname']);
 $result= $db->query('SELECT "FirstName","LastName","Initials","EmanID","EmpNumber","eMail" FROM "Employee"');
     
// dump employee details into an array
foreach ($result->result_array(FALSE) as $row)
            {
            
      $user =  array('FirstName'=>$row['FirstName'],
                                         'LastName'=>$row['LastName'],
                                         'Initials'=>$row['Initials'],
                                         'EmanID'=>$row['EmanID'],
                                         'EmpNumber'=>$row['EmpNumber'],
                                         'eMail'=>$row['eMail'],
                                         );            
      
            }
            
            // dump the $user array into the $users array
            $users = array(
                  $user
            );                  


            print_r($users);



What I am trying to achieve is something like:


$users = array(
      array('FirstName'=>'Fred', Lastname=>'Bloggs', Initials=>'P', EmanID=>'2', EmpNumber=>'123', eMail=>'foo@bar.com'),
      array('FirstName'=>'Joe', Lastname=>'Bloggs', Initials=>'D', EmanID=>'3', EmpNumber=>'456', eMail=>'foo@bar.com'),
      array('FirstName'=>'Bill', Lastname=>'Bloggs', Initials=>'Z', EmanID=>'4', EmpNumber=>'789', eMail=>'foo@bar.com'),
);

But what I get is:

Array ( [0] => Array ( [FirstName] => Bill [LastName] => Blogs [Initials] => Z[EmanID] =>4 [EmpNumber] =>789 [eMail] => foo@bar.com ) )

It seems to be overwriting the $user array through each loop so I only end up with one record. Any ideas on what I am doing wrong?


Thanks for any help
0
trojan_uk
Asked:
trojan_uk
  • 2
1 Solution
 
Sander StadSysteemontwikkelaar, Database AdministratorCommented:
Çan you try the following code:
// get all employee data
$db=new Database($_SESSION['dbname']);
$result= $db->query('SELECT "FirstName","LastName","Initials","EmanID","EmpNumber","eMail" FROM "Employee"');

$users = array();
      
// dump employee details into an array
foreach ($result->result_array(FALSE) as $row)
{

  $user =  array('FirstName'=>$row['FirstName'], 
      'LastName'=>$row['LastName'], 
      'Initials'=>$row['Initials'],
      'EmanID'=>$row['EmanID'],
      'EmpNumber'=>$row['EmpNumber'],
      'eMail'=>$row['eMail'],
  );            
  
  array_push($users, $user) 
}
            
             
print_r($users);

Open in new window

0
 
trojan_ukAuthor Commented:
sstad, thank you very much, you're a star. So use array_push to append each loop to $users.

Many thanks
0
 
Sander StadSysteemontwikkelaar, Database AdministratorCommented:
You're welcome. Good luck
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now