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