Problem with Insert using mysql_query()

Question

I’m working on an old system, in which makes the connection to the bank still with mysql_query.

I used very little mysql_query and the last time I used it a long time ago, I’m more used to PDO.

I’m trying to give a insert in the bank, but the function mysql_query is returning false and I cannot identify the error. I have already looked at the documentation relating to mysql_query and saw nothing wrong in my code. Someone could help me?

Follows the code:

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
  $nomeVideo    = $_POST['nomeVideo'];
  $urlVideo     = $_POST['urlVideo'];
  $dataPostagem = date('d/m/Y');

  $sql = "INSERT into video (nomeVideo, urlVideo, dataPostagem)
          VALUES($nomeVideo, $urlVideo, $dataPostagem)";

  $insert = mysql_query($sql);
  var_dump($insert); exit;

  if ($insert) {
    header('Location: video.php');
  } else {
    header('Location: video.php?return=2');
  }
}

I even changed in the BD the field dataPostagem of DATE for VARCHAR thinking this was it but it didn’t solve.

Answer 1

I think the quotation marks are missing string and at the date:

$sql = "INSERT into video (nomeVideo, urlVideo, dataPostagem)
        VALUES('$nomeVideo', '$urlVideo', '$dataPostagem')";