Mysql pdo is stopping the script if there is any error

Question

My curent code:

$title = $_POST["title"];
$content = $_POST["content"];
$description = $_POST["summary"];
$tags = $_POST["tags"];
$query = $connect->prepare("INSERT INTO tutorials (title, date, content, description, tags) VALUES (:title, :date, :content, :description, :tags)");
$query->bindParam(":title", $title);
$query->bindParam(":date", $date);
$query->bindParam(":content", $content);
$query->bindParam(":description", $description);
$query->bindParam(":tags", $tags);
$result = $query->execute();
if($result)
{ echo "ok"; } else { echo "not ok"; }

The column title has unique feature if this helps; for some reasons I tried everything from official page the script is stopping if there is any error and I don't want that. If the insert was successfully done I get the "ok" message but if there is any error I don't even get the "not ok" message, the script is dying without any error.

EDIT: The error is stored into a log file on my hosting server but I want to not killing the rest of the webpage in browser.

The error should be found in your php error log file on the web server. — PajuranCodes, Apr 07 '18 at 14:12
Yes it is there, but I want to get the error in html as well without killing the rest of the page. — John, Apr 07 '18 at 14:13
I'm guessing you should check for an exception: https://stackoverflow.com/a/32648423 — Jared Farrish, Apr 07 '18 at 14:13
Flip it around and use exceptions `if (! $result) throw Exception("not ok");` — Robert, Apr 07 '18 at 14:14

Mysql pdo is stopping the script if there is any error

0 Answers0