Hacking Google Maps and Google Earth (ExtremeTech)

(Dana P.) #1

Chapter 5 — Storing and Sharing Information 89


Listing 5-26: Inserting Data with PHP (PDO)

<?php


try {
$dbh = new PDO(‘mysql:host=localhost;dbname=google_maps’,’maps’,’maps’);
} catch (PDOException $e) {
print “Error!: “. $e->getMessage(). “
”;
die();
}


$dbh->exec(“insert into restaurants values(0,-0.6391666,52.911111,’China
Inn’)”);


$dbh = null;


?>


Although more detailed examples of inserting and updating the database are beyond the scope
of this book, examples are provided as part of the applications presented in the remainder of
the book.


Extracting Data from the Database


When extracting data from the database, the typical procedure is to execute the SELECTstate-
ment and then iterate over the returned rows to extract the information required. The best way
to achieve this is through the use of a prepared statement. This provides the most flexible
method for extracting information from the database on a row-by-row basis.


An example of this through the Perl/DBD interface is shown in Listing 5-27.


Listing 5-27: Extracting Data on a Row-by-Row Basis

#!/usr/bin/perl


use DBI;
use Data::Dumper;


my $dbh = DBI-



connect(“DBI:mysql:database=google_maps;host=mysql.mcslp.pri”,’maps’,’maps’);



if ($dbh)
{


Continued
Free download pdf