<?php if (!defined('_LIB')) { define('_LIB', realpath(dirname(__FILE__) . '/../') . '/src/_Libs/'); } require_once _LIB . '/_Db.php'; use _\_Db; $host = 'localhost'; $username = '******'; $password = '******'; $dbName = 'foo'; $db = new _Db($host, $username, $password, $dbName); $id = 1; $escapedId = $db->escape($id); $sql = "SELECT * FROM bars WHERE id='{$escapedId}'"; $db->query($sql); if ($row = $db->getRow()) { $thing = $row['col_name']; } echo $thing;
public function testStaticGetRow() { // Test 3 $this->clearDb(); $this->insertRows(1000); $db = new _Db(); for ($i = 0; $i < 1000; $i++) { $sql = "SELECT * FROM _testtable WHERE _key='key_{$i}'"; $db->query($sql); $row = $db->getRow(); $this->assertEquals("val_{$i}", $row['_value']); } }