Description
This package contains classes for handling database transactions from within QueryPath.
The tools here use the PDO (PHP Data Objects) library to execute database functions.
Using tools in this package, you can write QueryPath database queries that query an RDBMS and then insert the results into the document.
Example:
<?php
$template = '<?xml version="1.0"?><tr><td class="colOne"/><td class="colTwo"/><td class="colThree"/></tr>';
$qp =
qp(QueryPath::HTML_STUB
, 'body') // Open a stub HTML doc and select <body/> ->append('<table><tbody/></table>')
->dbInit($this->dsn)
->queryInto('SELECT * FROM qpdb_test WHERE 1', array(), $template)
->doneWithQuery()
->writeHTML();
?>
The code above will take the results of a SQL query and insert them into a n HTML table.
If you are doing many database operations across multiple QueryPath objects, it is better to avoid using QPDB::dbInit(). Instead, you should call the static QPDB::baseDB() method to configure a single database connection that can be shared by all QueryPath instances.
Thus, we could rewrite the above to look like this:
<?php
$template = '<?xml version="1.0"?><tr><td class="colOne"/><td class="colTwo"/><td class="colThree"/></tr>';
$qp =
qp(QueryPath::HTML_STUB
, 'body') // Open a stub HTML doc and select <body/> ->append('<table><tbody/></table>')
->queryInto('SELECT * FROM qpdb_test WHERE 1', array(), $template)
->doneWithQuery()
->writeHTML();
?>
Note that in this case, the QueryPath object doesn't need to call a method to activate the database. There is no call to dbInit(). Instead, it checks the base class to find the shared database.
(Note that if you were to add a dbInit() call to the above, it would create a new database connection.)
The result of both of these examples will be identical. The output looks something like this:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta>
<title>Untitled</title>
</head>
<body>
<table>
<tbody>
<tr>
<td class="colOne">Title 0</td>
<td class="colTwo">Body 0</td>
<td class="colThree">Footer 0</td>
</tr>
<tr>
<td class="colOne">Title 1</td>
<td class="colTwo">Body 1</td>
<td class="colThree">Footer 1</td>
</tr>
<tr>
<td class="colOne">Title 2</td>
<td class="colTwo">Body 2</td>
<td class="colThree">Footer 2</td>
</tr>
<tr>
<td class="colOne">Title 3</td>
<td class="colTwo">Body 3</td>
<td class="colThree">Footer 3</td>
</tr>
<tr>
<td class="colOne">Title 4</td>
<td class="colTwo">Body 4</td>
<td class="colThree">Footer 4</td>
</tr>
</tbody>
</table>
</body>
</html>
Note how the CSS classes are used to correlate DB table names to template locations.
Classes defined in this file
CLASS NAME | DESCRIPTION |
| QPDB |
Provide DB access to a QueryPath object. |