PHP - Dynamic Array ID

[Berk]

Hey fellas,
So I'm trying to create a class for calling user's motto but I need to use like

    $stmt = $db->prepare("SELECT * FROM users WHERE username = :u");
    $stmt->bindParam(':u', $_SESSION['user']['username']);
    $stmt->execute();
    $fetch = $stmt->fetchAll();
   //  print_r($fetch);
    $this->motto = $fetch[0][12];

as you can see, I have to use [0] before the [12] (motto column). I want it to be dynamic, and I don't know how to search this in google, what would be your opinions/suggestions?

 

[MayoMayn]

Hey fellas,
So I'm trying to create a class for calling user's motto but I need to use like

    $stmt = $db->prepare("SELECT * FROM users WHERE username = :u");
    $stmt->bindParam(':u', $_SESSION['user']['username']);
    $stmt->execute();
    $fetch = $stmt->fetchAll();
   //  print_r($fetch);
    $this->motto = $fetch[0][12];

as you can see, I have to use [0] before the [12] (motto column). I want it to be dynamic, and I don't know how to search this in google, what would be your opinions/suggestions?

I don't know how you couldn't find This, because a simply search came up with a Stack Overflow answer, also you could look up all the arguments available for fetch and fetchAll

But you should do

$user = $stmt->fetch(PDO::FETCH_ASSOC);
$this->motto = $user->motto;

And you can't bind a param to an array value, you gotta define it as an variable first and then pass that.

$username = $_SESSION['user']['username']
// ...
$stmt->bindParam(':u', $username, PDO::PARAM_STR);

 

[Berk]

I don't know how you couldn't find This, because a simply search came up with a Stack Overflow answer, also you could look up all the arguments available for fetch and fetchAll

But you should do

$user = $stmt->fetch(PDO::FETCH_ASSOC)
$this->motto = $user->motto

Notice: Trying to get property of non-object. I guess, I need to do it manually or what.

 

[Markshall]

Not quite sure what you mean? Do you mean where you can pass a user ID and a column name through to a function and it returns the value of the column related to that user?

If so, I think it'd be something like this (bear in mind I've not coded PHP in a long while)

function getUserInfo($column, $user='') {
  if ($user == '') $user = $_SESSION['user']['username'];
  $stmt = $db->prepare("SELECT $column FROM users WHERE username = :u LIMIT 1");
  $stmt->bindParam(':u', $user);
  $stmt->execute();
  $usr = $stmt->fetch(PDO::FETCH_OBJ);
  return $usr->{$column};
}

Then you can either use it like:

echo getUserInfo('motto');

...to get the motto of the current logged in user

echo getUserInfo('motto', 'Markshall');

...to get the motto of the user Markshall

 

[MayoMayn]

Notice: Trying to get property of non-object. I guess, I need to do it manually or what.

What are you on about?
You asked for what I just posted, wtf.
Just change it to PDO::FETCH_NUM

 

[Berk]

Not quite sure what you mean? Do you mean where you can pass a user ID and a column name through to a function and it returns the value of the column related to that user?

If so, I think it'd be something like this (bear in mind I've not coded PHP in a long while)

function getUserInfo($column, $user='') {
  if ($user == '') $user = $_SESSION['user']['username'];
  $stmt = $db->prepare("SELECT :column FROM users WHERE username = :u LIMIT 1");
  $stmt->bindParam([':column' => $column, ':u' => $user]);
  $stmt->execute();
  $usr = $stmt->fetch(PDO::FETCH_OBJ);
  return $usr->{$column};
}

Then you can either use it like:

echo getUserInfo('motto');

...to get the motto of the current logged in user

echo getUserInfo('motto', 'Markshall');

...to get the motto of the user Markshall

stdClass Object ( [?] => motto )
Notice: Undefined property: stdClass::$motto
I've changed code abit and encounter this issue, as your code's bindParam returns error.
code:

if ($user == '') $user = $_SESSION['user']['username'];
  $stmt = $db->prepare("SELECT :column FROM users WHERE username = :u LIMIT 1");
  $stmt->bindParam(':column',$column);
  $stmt->bindParam(':u', $user);
  $stmt->execute();
  $usr = $stmt->fetch(PDO::FETCH_OBJ);
  print_r($usr);
 
  return $usr->{$column};

I couldn't think of anything, maybe you'd know? @Markshall

 

[BIOS]

stdClass Object ( [?] => motto )
Notice: Undefined property: stdClass::$motto
I've changed code abit and encounter this issue, as your code's bindParam returns error.
code:

if ($user == '') $user = $_SESSION['user']['username'];
  $stmt = $db->prepare("SELECT :column FROM users WHERE username = :u LIMIT 1");
  $stmt->bindParam(':column',$column);
  $stmt->bindParam(':u', $user);
  $stmt->execute();
  $usr = $stmt->fetch(PDO::FETCH_OBJ);
  print_r($usr);
 
  return $usr->{$column};

I couldn't think of anything, maybe you'd know? @Markshall

You can't bind table or column names.

Hold on and I'll throw something together.

Edit:

Try something along the lines of this - haven't ran it so may need adjusting to your needs but gives an idea.

function getInfo($data, $user) {

    $allowed = array('username', 'motto', 'etc');

    if (in_array($data, $allowed)) {
        $col = $data;
    } else {
        $col = 'null';
    }

    $stmt = $db->prepare("SELECT $col FROM users WHERE username = :u LIMIT 1");
    $stmt->bindParam(':u', $user);
    $stmt->execute();
    
    return $stmt->fetch(PDO::FETCH_OBJ)->{$col};

}
print getInfo('motto', 'john');

 

[Berk]

You can't bind table or column names.

Hold on and I'll throw something together.

Edit:

Try something along the lines of this - haven't ran it so may need adjusting to your needs but gives an idea.

function getInfo($data, $user) {

    $allowed = array('username', 'motto', 'etc');

    if (in_array($data, $allowed)) {
        $col = $data;
    } else {
        $col = 'null';
    }

    $stmt = $db->prepare("SELECT $col FROM users WHERE username = :u LIMIT 1");
    $stmt->bindParam(':u', $user);
    $stmt->execute();
   
    return $stmt->fetch(PDO::FETCH_OBJ)->{$col};

}
print getInfo('motto', 'john');

Thank you, this one worked perfectly.

 

[Weasel]

You can't bind table or column names.

Hold on and I'll throw something together.

Edit:

Try something along the lines of this - haven't ran it so may need adjusting to your needs but gives an idea.

function getInfo($data, $user) {

    $allowed = array('username', 'motto', 'etc');

    if (in_array($data, $allowed)) {
        $col = $data;
    } else {
        $col = 'null';
    }

    $stmt = $db->prepare("SELECT $col FROM users WHERE username = :u LIMIT 1");
    $stmt->bindParam(':u', $user);
    $stmt->execute();
   
    return $stmt->fetch(PDO::FETCH_OBJ)->{$col};

}
print getInfo('motto', 'john');

Please don't execute a query with SELECT NULL if it's not allowed. Just replace $col = 'null'; with return false; for the sake of proper engineering.