Use QueryPath for Fun and Profit

* @license LGPL The GNU Lesser GPL (LGPL) or an MIT-like license. */ require_once '../src/QueryPath/QueryPath.php'; require_once '../src/QueryPath/Extension/QPDB.php'; // Set the default database. QPDB::baseDB('sqlite:../test/db/qpTest.db'); // To begin, let's create a new database. We can do this outside // of QueryPath: $db = QPDB::getBaseDB(); $db->exec('CREATE TABLE IF NOT EXISTS qpdb_article (title, author, body)'); // Here's our sample article: $article = '

Use QueryPath for Fun and Profit Matt Butcher QueryPath is a great tool.

Use it in many ways.

]]>

'; // Now let's take this article and insert it into the database: $qp = qp($article); // We are going to store our insert params in here. $params = []; // First, let's get the title $params[':title'] = $qp->find('title')->text(); // Next, let's get the name: $params[':name'] = $qp->top()->find('author>last')->text() . ', ' . $qp->prev('first')->text(); // Finally, let's get the article content: $params[':body'] = $qp->top()->find('body')->text(); // Here's the query we are going to run: $sql = 'INSERT INTO qpdb_article (title, author, body) VALUES (:title, :name, :body)'; // Now we can insert this: $qp->query($sql, $params); // Finally, we can now read this information back out into an HTML document qp(QueryPath::HTML_STUB, 'body')->queryInto('SELECT * FROM qpdb_article')->writeHTML(); // Finally, we clean up: $qp->exec('DROP TABLE qpdb_article');