PHP MySQL Insert not working without error

Question

i used this code and i didnt get any errors but when i check the phpadmin and my database its all empty no data added to the table what should i do ? where is the problem?

i checked also my database and table values and my html names

<?php
    if(isset( $_POST['submit'] ) )
    {                       
        $name = $_POST['p_name'];
        $price = $_POST['p_price'];
        $type = $_POST['p_type'];
        $des = $_POST['p_desc'];
        $img = 'images/is7.jpeg';
        //***********************
        require_once 'setting.php';
        $dbc = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
        mysqli_set_charset($dbc, 'utf8');
        $query = "INSERT INTO products(name, price, type, des, img)
                        VALUES('$name', '$price', '$type', $des, '$img')";
        mysqli_query($dbc, $query);
        mysqli_close($dbc);
        header('Location: success.php');
        exit;
    }
?>

Put echo mysqli_error($dbc); after mysqli_query($dbc, $query); — Zain Farooq
– Zain Farooq, Commented May 30, 2019 at 9:38
The right tool to solve such problems is your debugger. You should step through your code line-by-line before asking on Stack Overflow. For more help, please read How to debug small programs (by Eric Lippert). At a minimum, you should edit your question to include a Minimal, Complete, and Verifiable example that reproduces your problem, along with the observations you made in the debugger. — Rohan Khude
– Rohan Khude, Commented May 30, 2019 at 10:16

Deckerz · Accepted Answer · 2019-05-30 10:33:08Z

1

Did you try to put single quotes around description variable?

Change

VALUES('$name', '$price', '$type', $des, '$img')";

To

VALUES('$name', '$price', '$type', '$des', '$img')";

Cheers

edited May 30, 2019 at 10:33

Deckerz

2,60417 silver badges33 bronze badges

answered May 30, 2019 at 9:36

Yogesh Pawar

3342 silver badges17 bronze badges

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

Comments

Ahmed Abdullah · Accepted Answer · 2019-05-30 09:46:58Z

0

"INSERT INTO products(name, price, type, des, img) VALUES('$name', '$price', '$type', '$des', '$img')";

OR
"INSERT INTO products(name, price, type, des, img) VALUES(?, ?, ?, ?, ?)";

answered May 30, 2019 at 9:46

Ahmed Abdullah

411 bronze badge

Comments

user8995024 · Accepted Answer · 2019-05-30 10:19:27Z

0

Replare this formate

<?php
$query = "INSERT INTO products(name, price, type, des, img)VALUES('$name', '$price', '$type', $des, '$img')";
?>

TO

<?php
$query = "INSERT INTO products(name, price, type, des, img)VALUES('".$name."', '".$price."', '".$type."', '".$des."', '".$img."')";
?>

In feature apply mySQL error check up to get mySQL error.

answered May 30, 2019 at 10:19

user8995024

Collectives™ on Stack Overflow

PHP MySQL Insert not working without error

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related