public static function getInstance()
{
if (self::$instance === NULL) {
self::$instance = new scDBCon();
}
return self::$instance;
}
public function search($search)
{
$count = 0;
$query = "SELECT * FROM " . $this->getName();
if (count($search) > 0) {
$query .= " WHERE ";
foreach ($search as $aKey => $aValue) {
if ($count > 0) {
$query .= " AND ";
}
$query .= $aKey . " = '" . $aValue . "'";
$count++;
}
}
$query .= " ORDER BY " . $this->getPrimeryKey() . " DESC;";
//echo $query;
$dbcon = scDBCon::getInstance();
$con = $dbcon->getConnection();
if ($result = $con->query($query)) {
if ($result->rowCount() > 0) {
$row = $result->fetch(PDO::FETCH_ASSOC);
foreach ($this->records as $aKey => $aValue) {
$this->updateRecord($aKey, $row[$aKey]);
}
return true;
} else {
$this->addGarbage($result->rowCount() . " record found in search() for query: " . $query);
}
} else {
$this->addGarbage("Couldnt run select query on search() ");
}
return false;
}
