Debug sql Query If failed

Question

I have query like below

function getConnected($host,$user,$pass,$db) {

   $mysqli = new mysqli($host, $user, $pass, $db);

   if($mysqli->connect_error) 
     die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());

   return $mysqli;
}

$sqli= getConnected('localhost','db','pass','user');



    if ($data = $sqli->query("INSERT INTO `buy_diet`.`rcat` (`cat`, `id`) VALUES ('$cat', '$idea');")) {
     echo $data;
    }
    else
    {
    echo "fail";
    }

above code always failing..database is connected and all other queries like select , update etc are working fine , But INSERT query is failing...I have tried to copy the exact statement and run the query in phpmyadmin ,its working but not in above php code.

So how can I debug whats the problem.Right now I get only this error (bool)false , How to see detailed error.

Have you tried printing the SQL in the script itself just for debugging purpose? and then try to run that printed query in the db directly and see if it gives any error. — Pratip Ghosh
– Pratip Ghosh, Commented Dec 30, 2014 at 12:31

Niels Keurentjes · Accepted Answer · 2014-12-30 12:29:31Z

1

Replace echo "fail" with echo $sqli->error to see the actual problem.

answered Dec 30, 2014 at 12:29

Niels Keurentjes

42.1k9 gold badges103 silver badges138 bronze badges

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

1 Comment

Vishnu Over a year ago

Thanks :) I had not given the user previlage of insert

Community · Accepted Answer · 2017-05-23 11:50:29Z

0

Just look at the mysql error log file to get the exact problem. To get the log file use this link How to see log files in MySQL?

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Dec 30, 2014 at 12:31

Kiren S

3,1178 gold badges43 silver badges73 bronze badges

Collectives™ on Stack Overflow

Debug sql Query If failed

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related