<?php<\/p>\n
\/\/Example of fetching data from a database using PDO objects<\/p>\n
# using the shortcut ->query() method here since there are no variable
\n# values in the select statement.<\/p>\n
try {<\/p>\n
$dbhost = “localhost”;
\n$dbname\u00a0\u00a0 \u00a0= “users”;
\n$dbusername = “root”;
\n$dbpass = “”;<\/p>\n
\/\/Connect to the database
\n$dbh = new PDO(“mysql:host=” . $dbhost . “;dbname=” . $dbname, $dbusername, $dbpass);<\/p>\n
\/\/the sql query
\n$sql = “SELECT * FROM users”;<\/p>\n
\/\/statment handle
\n$sth = $dbh->query($sql);<\/p>\n
# setting the fetch mode
\n$sth->setFetchMode(PDO::FETCH_ASSOC);<\/p>\n
echo(“——————————————–<br\/>”);
\necho(“An example of a while loop<br\/>”);
\nwhile($row = $sth->fetch()) {
\necho( $row[“first_name”] . “<br\/>” );
\n$table[] = $row;
\n}<\/p>\n
$dbh = null;<\/p>\n
}\u00a0 catch (PDOException $e) {
\nprint “Error!: ” . $e->getMessage() . “<br\/>”;
\ndie();
\n}<\/p>\n
echo(“<br\/><br\/>”);<\/p>\n
echo(“——————————————–<br\/>”);
\necho(“An example of looping around an array<br\/>”);<\/p>\n
if ($table) {\u00a0\u00a0 \u00a0\/\/Check if there are any rows to be displayed
\n\/\/Retrieve each element of the array
\nforeach($table as $d_row) {
\necho( $d_row[“first_name”] . ” ” . $d_row[“last_name”] . “<br\/>” );
\n}
\n}<\/p>\n
echo(“——————————————–<br\/>”);
\necho(“An example of printing one element from the array<br\/>”);
\necho($table[0][“first_name”]);<\/p>\n
?><\/p>\n
<?php<\/p>\n
\/\/Example of fetching data from a database using PDO objects<\/p>\n
\/\/This uses a prepared statement using named values<\/p>\n
try {<\/p>\n
$dbhost = “localhost”;
\n$dbname\u00a0\u00a0 \u00a0= “users”;
\n$dbusername = “root”;
\n$dbpass = “”;<\/p>\n
$first_name = “%paul%”;<\/p>\n
\/\/Connect to the database
\n$dbh = new PDO(“mysql:host=” . $dbhost . “;dbname=” . $dbname, $dbusername, $dbpass);<\/p>\n
\/\/the sql query using a named placeholder
\n$sql = “SELECT * FROM users WHERE first_name LIKE :first_name “;<\/p>\n
\/\/statment handle
\n$sth = $dbh->prepare($sql);<\/p>\n
$sth->execute(array(“:first_name” => $first_name));<\/p>\n
$sth->setFetchMode(PDO::FETCH_ASSOC);<\/p>\n
echo(“<br\/><br\/>”);
\necho(“——————————————–<br\/>”);
\necho(“An example of printing values from a select statement with parameters<br\/>”);<\/p>\n
while($row = $sth->fetch()) {
\necho( $row[“first_name”] . “<br\/>” );
\n$table[] = $row;
\n}<\/p>\n
$dbh = null;<\/p>\n
}\u00a0 catch (PDOException $e) {
\nprint “Error!: ” . $e->getMessage() . “<br\/>”;
\ndie();
\n}<\/p>\n
?><\/p>\n","protected":false},"excerpt":{"rendered":"
<?php \/\/Example of fetching data from a database using PDO objects # using the shortcut ->query() method here since there are no variable # values in the select statement. try { $dbhost = “localhost”; $dbname\u00a0\u00a0 \u00a0= “users”; $dbusername = “root”;…<\/span><\/p>\n