1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| class DAO_User implements IDao {
private function __construct() {
}
public static function load_by_id($id) {
$sql = "SELECT `id`, `nom`, `prenom`, `initiales`, `pseudo`, `password`, `email`, `msn`, `telephone`, `voiture` FROM `table_users` WHERE `id` = '$id'";
$result = Singleton::GetInstance()->Execute($sql);
return self::construireDePuisTuple( $result );
}
public static function load_by_name($name) {
$sql = "SELECT `id`, `nom`, `prenom`, `initiales`, `pseudo`, `password`, `email`, `msn`, `telephone`, `voiture` FROM `table_users` WHERE `nom` = '$name'";
$result = Singleton::GetInstance()->Execute($sql);
return self::construireDePuisTuple( $result );
}
public static function construireDePuisTuple( $resultat )
{
$user = new User();
$user->set_nom($resultat->fields['nom']);
$user->set_prenom($resultat->fields['prenom']);
return $user;
}
} |
Partager