PHP MySQL INSERT 查询未插入所有值

Question

我有这个变量:

$cliente = mysqli_real_escape_string($conn, htmlentities($_GET["cliente"]));
$metatickt = mysqli_real_escape_string($conn, htmlentities($_GET["metatickt"]));
$metaext = mysqli_real_escape_string($conn, htmlentities($_GET["metaext"]));
$metaenc = mysqli_real_escape_string($conn, htmlentities($_GET["metaenc"]));
$uf = mysqli_real_escape_string($conn, htmlentities($_GET["estado"]));

我正在尝试执行此查询:

$queryInst = "INSERT  meta_control (mes,cliente,meta_exit,meta_tickt,meta_enc,uf)"
          . " VALUES (MONTH(NOW()),'" . $cliente . "','" . $metaext . "','" . $metatickt . "','" . $metaenc . "','" . $uf . "')";
 mysqli_query($conn, $queryInst);

但是当我检查数据库时，唯一不为 NULL 的列是 mes。造成这种情况的原因是什么？

Answer 1

您应该使用正确的查询。 插入

$queryInst = "INSERT INTO meta_control (mes,cliente,meta_exit,meta_tickt,meta_enc,uf)"
              . " VALUES (MONTH(NOW()),'" . $cliente . "','" . $metaext . "','" . $metatickt . "','" . $metaenc . "','" . $uf . "')";
mysqli_query($conn, $queryInst);