/**
* Créer une instance User à partir de données présente dans la table User
* @param $data string | int
* @return User
**/
public function getDatas($data)
{
$valid = new Form();
if ($valid->validEmail($data)) {
$q = $this->_db->query('SELECT * FROM User
WHERE email = "' . $data . '"') or die(print_r($q->errorInfo()));
} elseif (is_string($data)) {
$q = $this->_db->query('SELECT * FROM User
WHERE name = "' . $data . '"') or die(print_r($q->errorInfo()));
} else {
$data = (int) $data;
$q = $this->_db->query('SELECT * from User
WHERE id = ' . $data);
}
$donnees = $q->fetch(PDO::FETCH_ASSOC);
return new User($donnees);
}
/**
* Créer une instance User à partir de données présente dans la table User
* @param $data string | int
* @return User
**/
public function getDatas($data)
{
$valid = new Form();
if ($valid->validEmail($data)) {
$q = $this->_db->prepare('SELECT * FROM User
WHERE email = :email') or die(print_r($q->errorInfo()));
$q->execute(array('email' => $data));
} elseif (is_string($data)) {
$q = $this->_db->prepare('SELECT * FROM User
WHERE name = :name') or die(print_r($q->errorInfo()));
$q->execute(array('name' => $data));
} else {
$data = (int) $data;
$q = $this->_db->prepare('SELECT * FROM User
WHERE id = :id') or die(print_r($q->errorInfo()));
$q->execute(array('id' => $data));
}
$donnees = $q->fetch(PDO::FETCH_ASSOC);
return new User($donnees);
}
