/** * 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 _selectRecords($query, $var_arr) { try { $db = new PDOConnector($this->db); $ret = $db->selectRecords($query, $var_arr); $db->close(); return $ret; } catch (PDOException $e) { Util::displayError("System error occurred.", "Please go back", $e); } }