public function getSetting($settingName) { $settingName = TextMan::cleanSqlField($settingName); if (array_key_exists($settingName, $this->_settings) === true) { return $this->_settings[$settingName]; } $query = $this->_loadedClasses['dbEngine']->runSelect('settings', 'value', '`name` = \'' . $settingName . '\''); if ($this->_loadedClasses['dbEngine']->runCountRows() !== 1) { $this->_settings[$settingName] = ''; return ''; } $fetch = $this->_loadedClasses['dbEngine']->runSingleFetch(); $this->_settings[$settingName] = $fetch['value']; return $fetch['value']; }
public function runUpdate($table, $fields, $where) { $fieldsarr = ''; $table = TextMan::cleanSqlField($table); if (is_array($fields) === true) { foreach ($fields as $key => $value) { $fieldsarr .= '`' . TextMan::cleanSqlField($key) . '` = \'' . $value . '\', '; } $fieldsarr = substr($fieldsarr, 0, strlen($fieldsarr) - 2); } else { $fieldsarr = TextMan::cleanSqlField($fields); } $query = 'UPDATE `' . $table . '` SET ' . $fieldsarr . ($where === null ? '' : ' WHERE ' . $where); $this->_currentQuery = $query; //echo $query . '<br /><br />'; $this->queryResult = mysql_query($query); // or exit(mysql_error() . '<br />' . $query); return true; }