Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- $db = new PDO("mysql:host=$hostname;dbname=$database;port=$port", $username, $password);
- $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $query = "SELECT * FROM registrations WHERE exported = 0";
- $stmt = $db->prepare($query);
- $stmt->execute();
- while($row = $stmt->fetch())
- {var_dump($row);}
- }
- catch(PDOException $e)
- {
- echo $e->getMessage();
- echo $sql;
- }
- ** output **
- object(PDOStatement)#2 (1) {
- ["queryString"]=>
- string(52) "SELECT * FROM `registrations` WHERE `exported` = '0'"
- }
Add Comment
Please, Sign In to add comment