PHP _ _Db::escape Examples

Example #1

File: db.php Project: kengoldfarb/underscore_libs

<?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;

Example #2

File: _DbTest.php Project: kengoldfarb/underscore_libs

 public function testEscape()
 {
     $db = new _Db();
     $str = "somethin' is goin' on";
     $escapedStr = $db->escape($str);
     $this->assertEquals("somethin\\' is goin\\' on", $escapedStr);
 }