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']);