public static function getByLogin($login)
{
$user = null;
try {
$statement = DB::getInstance()->prepare('SELECT login, password, firstName, lastName, sex, email, birthDate AS birthDate, address, postalCode, city, phoneNumber FROM ' . self::getTableName() . ' where login=?');
$statement->bindParam(1, $login);
$statement->execute();
if ($rs = $statement->fetch(PDO::FETCH_OBJ)) {
$user = new User($rs->login, $rs->password, $rs->firstName, $rs->lastName, $rs->sex, $rs->email, $rs->birthDate, $rs->address, $rs->postalCode, $rs->city, $rs->phoneNumber);
}
} catch (PDOException $e) {
die('Error!: ' . $e->getMessage() . '<br/>');
}
return $user;
}
/**
* getByUser function. Get all Favorite of $user in db.
*
* @access public
* @static
* @param User object - $user
* @return Favorite Objects Array
*/
public static function getByUser($user)
{
$favorites = array();
try {
$statement = DB::getInstance()->prepare('SELECT * FROM ' . self::getTableName() . ' where login=?');
$statement->bindValue(1, $user->getLogin());
$statement->execute();
while ($rs = $statement->fetch(PDO::FETCH_OBJ)) {
$recipe = RecipeDAO::getById($rs->recipeId);
$favorites[$rs->recipeId] = new Favorite($recipe, $user);
}
} catch (PDOException $e) {
die('Error!: ' . $e->getMessage() . '<br/>');
}
return $favorites;
}
foreach ($params as $key => $param) {
$statement->bindValue($key, $param);
}
}
$statement->execute();
} catch (PDOException $e) {
die('Error sqlExecute : ' . $e->getMessage() . '<br/>');
}
}
include DATA_PATH . 'db-schema.sql.php';
Db::$dbHost = empty($_POST['dbURI']) ? 'localhost' : $_POST['dbURI'];
Db::$dbPort = empty($_POST['dbPort']) ? '3306' : $_POST['dbPort'];
Db::$dbUser = empty($_POST['dbUser']) ? 'root' : $_POST['dbUser'];
Db::$dbPwd = empty($_POST['dbPwd']) ? '' : $_POST['dbPwd'];
Db::$dbName = empty($_POST['dbName']) ? 'cocktails' : $_POST['dbName'];
Db::$tablePrefix = $_POST['tablePrefix'];
$sql = getSqlSchema(Db::$dbName, Db::$tablePrefix);
if (isset($_POST['createDatabase']) && $_POST['createDatabase'] == true) {
// create the database if needed.
try {
$dbh = new PDO('mysql:host=' . Db::$dbHost . ';port=' . Db::$dbPort, Db::$dbUser, Db::$dbPwd);
$dbh->exec($sql['base']['create']) or die('Erreur lors de la création de la base<br />' . print_r($dbh->errorInfo(), true));
} catch (PDOException $e) {
die("DB ERROR: " . $e->getMessage());
}
}
if (isset($_POST['dropTables']) && $_POST['dropTables'] == true) {
sqlExecute($sql['User']['drop']);
sqlExecute($sql['favorite']['drop']);
}
sqlExecute($sql['User']['create']);
