Solved

Building a dynamic array from a postgresql database in PHP

Posted on 2010-09-22
3
593 Views
Last Modified: 2013-12-12
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
Comment
Question by:trojan_uk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
Sander Stad earned 500 total points
ID: 33733915
Ç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
 

Author Closing Comment

by:trojan_uk
ID: 33734072
sstad, thank you very much, you're a star. So use array_push to append each loop to $users.

Many thanks
0
 
LVL 9

Expert Comment

by:Sander Stad
ID: 33734092
You're welcome. Good luck
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

These days socially coordinated efforts have turned into a critical requirement for enterprises.
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question