How to use PDO database connection in PHP

H

<?php
$string = ‘Test’; # user submitted data
try {
#connection
$conn = new PDO(‘mysql:host=localhost;dbname=myDB’, $db_username, $db_password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$data = $conn->query(‘SELECT * FROM myTable WHERE name = ‘ . $conn->quote($string)); // $conn->quote used to protect SQL injection
foreach($data as $rows) {
print_r($rows);
}
} catch(PDOException $e) {
echo ‘ERROR: ‘ . $e->getMessage();
}
?>

About the author

swati nuna
By swati nuna

Category