Bonjour
Est ce la bonne méthode ?
<?php
class Manager
{
// Database login
const DB_HOST = 'localhost';
const DB_NAME = 'python';
const DB_USER = 'root';
const DB_PWD = '';
// Login to database
protected function dbConnect()
{
try
{
$db = new PDO('mysql:host='.self::DB_HOST.';dbname='.self::DB_NAME.';charset=utf8', self::DB_USER, self::DB_PWD);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
die('Connection error: ' . $e->getMessage() );
}
return $db;
}
}
<?php
require_once('model/Manager.php');
class UserManager extends Manager
{
// Getter
public function getUser($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT * FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserUsername($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_username FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserEmail($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_email FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserPassword($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_password FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserFirstName($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_first_name FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserLastName($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_last_name FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserLanguage($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_language FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserCountry($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_country FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserBirthDate($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_birth_date FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserGender($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_gender FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserCreationDate($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_creation_date FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserPresentation($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_presentation FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserFacebook($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_facebook FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserTwitter($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_twitter FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserTwitch($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_twitch FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserYoutube($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_youtube FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserIsActive($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_is_active FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
public function getUserIsBanned($user_id)
{
$db = $this->dbConnect();
$query = $db->prepare('SELECT user_is_banned FROM user WHERE user_id=:user_id');
$query->bindParam(':user_id', $user_id);
$query->execute();
$user = $query->fetch();
return $user;
}
// Setter
public function setUserEmail($user_id, $user_email)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_email=:user_email WHERE user_id=:user_id');
$query->bindParam(':user_email', $user_email);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserPassword($user_id, $user_password)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_password=:user_password WHERE user_id=:user_id');
$query->bindParam(':user_password', $user_password);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserFirstName($user_id, $user_first_name)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_first_name=:user_first_name WHERE user_id=:user_id');
$query->bindParam(':user_first_name', $user_first_name);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserLastName($user_id, $user_last_name)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_last_name=:user_last_name WHERE user_id=:user_id');
$query->bindParam(':user_last_name', $user_last_name);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserLanguage($user_id, $user_language)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_language=:user_language WHERE user_id=:user_id');
$query->bindParam(':user_language', $user_language);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserCountry($user_id, $user_country)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_country=:user_country WHERE user_id=:user_id');
$query->bindParam(':user_country', $user_country);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserBirthDate($user_id, $user_birth_date)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_birth_date=:user_birth_date WHERE user_id=:user_id');
$query->bindParam(':user_birth_date', $user_birth_date);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserGender($user_id, $user_gender)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_gender=:user_gender WHERE user_id=:user_id');
$query->bindParam(':user_gender', $user_gender);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserPresentation($user_id, $user_presentation)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_presentation=:user_presentation WHERE user_id=:user_id');
$query->bindParam(':user_presentation', $user_presentation);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserFacebook($user_id, $user_facebook)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_facebook=:user_facebook WHERE user_id=:user_id');
$query->bindParam(':user_facebook', $user_facebook);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserTwitter($user_id, $user_twitter)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_twitter=:user_twitter WHERE user_id=:user_id');
$query->bindParam(':user_twitter', $user_twitter);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserTwitch($user_id, $user_twitch)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_twitch=:user_twitch WHERE user_id=:user_id');
$query->bindParam(':user_twitch', $user_twitch);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
public function setUserYoutube($user_id, $user_youtube)
{
$db = $this->dbConnect();
$query = $db->prepare('UPDATE user SET user_youtube=:user_youtube WHERE user_id=:user_id');
$query->bindParam(':user_youtube', $user_youtube);
$query->bindParam(':user_id', $user_id);
$query->execute();
}
}
Lire la suite >