PHP Using Object to Retrieve DB data

Question

I am wondering if someone could help me. I am new to PHP OOP and would like some guidance with using objects.

I am making a login script and the functions I mention below are all from the class file.

Class USER{

public function userLogin($username,$password)
{   
    $statusY = "Y";

    $stmt  = $this->connection->prepare("SELECT * FROM tbl_users WHERE user_name=:userName  LIMIT 1");
    $stmt ->execute(array(":userName"=>$username));
    $row = $stmt ->fetch(PDO::FETCH_ASSOC);

        if($stmt->rowCount() == 1)
        {

        $this->_user = $row; // Assign user details

        $_SESSION['userSession'] = $row['user_id'];

        }
}


public function getUser()
{
    return $this->_user;
}

Ok so I have the getUser() function and then assign $this->_user = $row so I can retrieve the user info from the database. Now I want to acheive a couple of things from this but not sure how to go about it.

How would I go about calling $row['user_id'] in another function within the same class?

So basically

public function test()
{
$user_id = $this->_user(user_id);
$username = $this->_user(username);
}

How would I do this correctly?

Also if I want to call the information in a page such as the User Homepage.

 $user_home = new USER();
 $userID = $user_home->getUser(user_id);

 echo $userID;

If anyone could give me some guidance as to how I can move forward with this I would greatly appreciate it. Thanks

Just declare _user as class variable eg : public $_user;

Anish Chandran
– Anish Chandran

2016-08-25 08:15:24 +00:00
Commented Aug 25, 2016 at 8:15 — Anish Chandran
– Anish Chandran, Commented Aug 25, 2016 at 8:15

SaschaM78 · Accepted Answer · 2016-08-25 08:32:03Z

1

Let's start with a basic statement regarding method and class naming: I wouldn't repeat the class' topic over and over again (in the above case "user"), instead just remove it from the method name:

class User 
{
  private $info= array();
  private $authenticated= FALSE;

  public function login ($username, $password)
  {
    // do your stuff 
    ...
    // set in case that user name and password have been found
    $this->info= $row;
    $this->authenticated= TRUE;
  }

  public function isAuthenticated () 
  {
    return $this->authenticated;
  }

  /**
  * returns all info from a given user
  */
  public function get ()
  {
    return $this->info;
  }

  /**
  * returns a single field
  */
  public function getField ($fieldName) {
    if (isset($this->info[$fieldName]) {
      return $this->info[$fieldName];
    } else {
      return FALSE;
    }
  }
}

Use the getField(FIELD) method to return only a single element of the user's row and get() to return all values.

$user= new User();
$user->login ($username, $password);
if ($user->isAuthenticated()) {
  $home= $user->getField('home');
  print sprintf('%s\'s home is %s', $username, $home);
}

It's also advisable to create a class for the user database table (i.e. class UserModel) and another one handling user functions (i.e. class UserAuth) which uses the UserModel class. This makes exchanging the underlying authentication source more easy.

edited Aug 25, 2016 at 8:32

answered Aug 25, 2016 at 8:19

SaschaM78

4,5074 gold badges36 silver badges46 bronze badges

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

1 Comment

James Over a year ago

Thank you very much for your example, you have put it in prespective for me. Thanks again

Anish Chandran · Accepted Answer · 2016-08-25 08:18:31Z

0

Class USER
 {
   public $_user;

   public function userLogin($username,$password)
   {   
      $statusY = "Y";

    $stmt  = $this->connection->prepare("SELECT * FROM tbl_users WHERE user_name=:userName  LIMIT 1");
$stmt ->execute(array(":userName"=>$username));
$row = $stmt ->fetch(PDO::FETCH_ASSOC);

    if($stmt->rowCount() == 1)
    {

    $this->_user = $row; // Assign user details

    $_SESSION['userSession'] = $row['user_id'];

    }
 }


public function getUser()
 {
return $this->_user;
}
 }

answered Aug 25, 2016 at 8:18

Anish Chandran

4471 gold badge5 silver badges19 bronze badges

Collectives™ on Stack Overflow

PHP Using Object to Retrieve DB data

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related