Comment convertir ce script en PDO

Question

Bonjour, 
Je voudrais avoir le corigé exacte de ce script mysql en PDO
elseif(isset($_POST['login'])) {
	$query = mysql_query("select password from settings where id = '1'");
	$password = mysql_result($query, 0);
	if($password == md5($_POST['password'])) {
		$_SESSION['admin'] = "logged";
		header("Location: " . $siteurl ."admin/index.php");



Merci d'avance

avion-f16 · Answer

$pdo = new PDO('mysql:host=localhost;dbname=la_base','root','');
$query = $pdo->query('SELECT password FROM settings WHERE id=1');
$password = $query->fetchColumn(0);
if($password == md5($_POST['password'])) {
	$_SESSION['admin'] = "logged";
	header("Location: " . $siteurl ."admin/index.php");

Comment convertir ce script en PDO

1 réponse

Discussions similaires

Newsletters