D
D
Daria2020-01-08 18:09:20
PHP
Daria, 2020-01-08 18:09:20

Incorrect integer value: '$id_ML' for column `log_bd`.`order_list`.`id_ML` at row 1 what is the error?

Good evening!
faced such problem:
I have a form which has to write down the received data from the user in a DB.
I made the form, the request was written, it is presented below, but nothing works, the database is connected, previously there were other requests that work fine, I checked the request in phpmyadmin in the console, everything works, I can’t understand anything (I’m attaching a screenshot of the error itself and the database below).

$id_ML = $_POST['id_ML'];
$id_customer = $_POST['id_customer'];
$id_TC = $_POST['id_TC'];
$date_order = $_POST['date_order'];
$level_order = $_POST['level_order'];
$price_order = $_POST['price_order'];
$db_table = "order_list";

$query_5 = 'INSERT INTO `order_list` (`id_ML`, `id_customer`, `id_TC`, `date_order`, `level_order`, `price_order`) VALUES ( "$id_ML", "$id_customer", "$id_TC", "$date_order", "$level_order", "$price_order")';
$result_5 = mysqli_query($connect,$query_5) or die("Not connected" . mysqli_error($connect));

5e15f03a40d34941703224.png
5e15f068db05b672292931.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
X
xmoonlight, 2020-01-08
@Yen13Sky

$id_ML = $_POST['id_ML'];
$id_ML is an invalid integer variable.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question