/** * Check if $table exists in the selected DB * * @param string $table - Table name that exists in the selected db * @return boolean */ public static function lookupTable($table, $target = "h2owirelessnow") { $query = " Select count(*) count From systables \n Where tabtype ='T'\n And tabname = :table\n "; $var_arr = compact('table'); try { $db = new PDOConnector($target); $ret = $db->selectRecords($query, $var_arr); $db->close(); return $ret[0]['count'] ? true : false; } catch (PDOException $e) { self::displayError("System error occurred.", "Please go back", $e); } }
protected function _execute($query, $var_arr) { try { $db = new PDOConnector($this->db); $ret = $db->executeQuery($query, $var_arr); $this->affectedRowCounts = $db->affectedRowCounts; $db->close(); return $this->affectedRowCounts; } catch (PDOException $e) { Util::displayError("System error occurred.", "Please go back", $e); } }