function connect()
{
	$host = '127.0.0.1';
	$db   = 'dvd';
	$user = 'root';
	$pass = '';
	$charset = 'utf8';

	$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
	$opt = [
	    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
	    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
	    PDO::ATTR_EMULATE_PREPARES   => false,
	];
	try
	{
		$pdo = new PDO($dsn, $user, $pass, $opt);
		return $pdo;
	}
	catch (Exception $e)
	{
	        die('Erreur : ' . $e->getMessage());
	}
}


function injection_image($titre,$image)
{
	$dbh = connect();

	$stmt = $dbh->prepare("INSERT INTO affiche (nom, url) VALUES (:nom, :url)");
	$stmt->bindParam(':nom', $titre);
	$stmt->bindParam(':url', $image);
	try {
		$stmt->execute();
		$lastId = $dbh->lastInsertId();
		return $lastId;
	}
	catch(PDOException $e)
	{
		$dbh = null;
		return false;
	}

}