codehaven - php snippets - coding help
[wd_asp elements=’search’ ratio=’100%’ id=1]
octopus energy discount code

PDO – Basic connection and fetch

3rd October 2014

MySql

mysql codehaven category

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$data = $conn->query('SELECT * FROM table1 WHERE myname = ' . $conn->quote($name));

foreach($data as $row) {
print_r($row);
}
} catch(PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}