How to assign class properties dynamically using a record from MySQL database?

Question

<?php

class User {

// properties

public $table = 'users';
public $id;
public $username ;
public $password ; 
public $first_name ;
public $last_name ;

Above (id, username..., last_name) are the column of users table in MySQL Database. After fetching(I'm using PDO) a specific record from users table using id, how can I assign all records to their respective properties dynamically(a function may help that will search through all available properties and search those properties in the resulting associative array and then assign those specific values to their respective properties)?

// methods

public function set_user($id){
    global $dbh;
    // sql
    $sql = "SELECT * FROM $this->table WHERE id = {$id}";
    // return result array
    $result_arr = $dbh->pdo_query_fetch($sql);
}

$result_arr contains associative array of id, username, password, first_name and last_name.

NOTE : Here pdo_query_fetch() is a user-defined function.

Take care when someones unsets the global variable $dbh your object would not work any longer. Instead inject the PDO connection when you create the object or use a setter method, that is more save and easier to change later. — hakre
– hakre, Commented Sep 30, 2012 at 15:30

hakre · Accepted Answer · 2012-09-30 15:19:33Z

4

You're using PDO, it has that with PDO::FETCH_INTO:

PDO::query ( string $statement , int $PDO::FETCH_INTO , object $object )

See PDO::query^Docs.

It might be that your "own" database class then is "owning" you, because you started to encapsulate things too early. This might require you to add an additional function to your $dbh class and/or you might want to start to refactor.

answered Sep 30, 2012 at 15:19

hakre

200k55 gold badges454 silver badges865 bronze badges

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

3 Comments

Yousuf Memon Over a year ago

please a little more detail with an example.

hakre Over a year ago

You find an example in a related question: stackoverflow.com/questions/7282962/… , it also demonstrates one of the other fetch-modes. Also there are various similar examples discussed in other questions like stackoverflow.com/questions/747847/… and stackoverflow.com/questions/7986167/…

Alain Over a year ago

your way is sweeter, i remove my answer and +1

JvdBerg · Accepted Answer · 2012-09-30 15:18:08Z

3

I would suggest adding a method to your user class:

public function Assign( $vars = array( ) )
{
    if( is_object( $vars )) {
      $this->Assign( get_object_vars( $vars ));
      return;
    }

    foreach ( $vars as $key => $value )
      if ( property_exists( $this, $key ) )
        $this->$key = $value;
}

With this method you can set properties from another object, or a array to your existing object.

You can use it like this:

myUser = new User();
myUser->Assign($result_arr);

answered Sep 30, 2012 at 15:18

JvdBerg

21.8k8 gold badges40 silver badges55 bronze badges

Comments

air4x · Accepted Answer · 2012-09-30 15:25:50Z

1

You can use get_object_vars

$properties = get_object_vars($this);
foreach ($properties as $property => $property_value) {
  if (isset($result_arr[$property])) 
    $this->$property = $result_arr[$property];
}

edited Sep 30, 2012 at 15:25

answered Sep 30, 2012 at 15:18

air4x

5,6831 gold badge26 silver badges36 bronze badges

Comments

lupatus · Accepted Answer · 2012-09-30 15:27:33Z

1

Best would be to use PDOStatement::fetchObject (docs) or PDO::query with PDO::FETCH_INTO flag (docs) but if there is no way to do that for some reasons:

foreach ($result_arr as $key => $value) {
    if (property_exists($user, $key)) {
       $user->$key = $value;
    }
}

also you can extend User class with __set :

public function __set($key, $value) {
    // do nothing
}

it will be called on every non-accessible property call (private or not defined)

edited Sep 30, 2012 at 15:27

answered Sep 30, 2012 at 15:22

lupatus

4,24320 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to assign class properties dynamically using a record from MySQL database?

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related