Why is the database query not working?

Question

PHP

There is a request

$NameVideo = $_POST ['name'];
$idVideo = $_POST ['message'];
echo $NameVideo;
$db = mysql_connect("localhost","d9",774272722");
mysql_select_db("dlx",$db);
mysql_query("SET NAMES utf8");
$resultat = mysql_query("INSERT INTO `dlx`.`videoByMe` (`id`, `DenumireaVideo`, `VideoMixID`) VALUES (NULL, \'.$NameVideo.\', \'.$idVideo.\');");
mysql_close($db);

and nothing changes in the database

Answer 1

$NameVideo = $_POST ['name'];
$idVideo = $_POST ['message'];
echo $NameVideo;
$db = mysql_connect("localhost","d9",774272722");
mysql_select_db("dlx",$db);
mysql_query("SET NAMES utf8");
$resultat = mysql_query("INSERT INTO `dlx`.`videoByMe` (`id`, `DenumireaVideo`, `VideoMixID`) VALUES (NULL, '$NameVideo', '$idVideo')"); // тут был бардак с кавычками
if(!$resultat){
 var_dump(mysql_error()); // тут скорее всего ругнётся, что id не может быть NULL
 exit();
}
mysql_close($db);

Answer 2

Learn php.net/manual/en/book.pdo.php