Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

Transitioning to PDO/MySQL. SELECT and COUNT statement - Die if no records

How do I fix this query to die (kill script) if no results imported?


$query18 = "SELECT * FROM Download";
$conn->query($query18);       

$totalrecords=$conn->query('SELECT FOUND_ROWS()')->fetch(PDO::FETCH_COLUMN); // Get result count

Open in new window

0
lawrence_dev
Asked:
lawrence_dev
1 Solution
 
GaryCommented:
For a select it wouldn't be normal to have a try/catch, simple because the query should be correct and if there is a problem it's one time solution.
Bit different when doing inserts as you will need to know what went wrong.

But anyway
try {
    //  Your query stuff here
}
catch (PDOException $e) {
    die("Oops: " . $e->getMessage() );
}

Open in new window

0
 
lawrence_devAuthor Commented:
Thanks Gary!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now