PHP MySQL INSERT query not inserting all values

Question

I have this variables :

$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"]));

And I'm trying to do this query :

$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);

But when I check my db the only column that is not NULL is mes. What could be the cause to this?

Consider using a prepared statement instead of manually embedding strings in a query. It will prevent SQL injection and make it harder to improperly escape strings. — Mr. Llama
– Mr. Llama, Commented Jun 20, 2016 at 17:00
Can you var_dump() the values before running, for instance $uf and see what it is showing? I would assume it's the values as "mes" is the only one your not pushing variables through too. — Matt The Ninja
– Matt The Ninja, Commented Jun 20, 2016 at 17:01
Since mes is the only value that gets inserted correctly, and is the only value you don't grab from htmlentities, your $_GET values must be messing up somehow. — Aroic
– Aroic, Commented Jun 20, 2016 at 17:02
Are those values coming from a form? If so, you'd likely want $_POST instead of $_GET. — Chris Forrence
– Chris Forrence, Commented Jun 20, 2016 at 17:03

ManoDestra · Accepted Answer · 2016-06-20 17:28:47Z

1

You should have to use proper query. INSERT INTO

$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);

edited Jun 20, 2016 at 17:28

ManoDestra

6,5236 gold badges29 silver badges52 bronze badges

answered Jun 20, 2016 at 17:10

Manoj S Kadlag

2502 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex · Accepted Answer · 2016-06-20 17:07:35Z

0

You are probably getting an SQL error. You should check for such errors using mysqli_error($conn) - http://php.net/manual/en/mysqli.error.php. In this case you probably have an error caused by the absence of the INTO keyword in your SQL query, which should be INSERT INTO .... http://dev.mysql.com/doc/refman/5.7/en/insert.html

answered Jun 20, 2016 at 17:07

Alex

14.7k5 gold badges45 silver badges60 bronze badges

Collectives™ on Stack Overflow

PHP MySQL INSERT query not inserting all values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related