static function GetHeader($sql){ $columnNames = DataBase::FieldsName($sql); $html = "<thead>\n<tr>\n"; foreach($columnNames as $key => $value) $html .= "<td><a href=\"".$_SERVER['PHP_SELF']."?order=$value\">".$value."</a></td>"; $html .= "<td>Opciones</td>"; $html .= "</tr>\n</thead>\n"; return $html; }
public function Insert($request){ unset($this->md5pass, $this->login, $this->security_profile_id); $column_names =DataBase::FieldsName("SELECT * FROM users"); foreach($column_names as $key => $value) $this->$value = ""; $request['password'] = md5($request['password']); ORM::DataBinding($this, $request); $insertStatement = ORM::InsertStatement($this, "users"); $affected_rows = DataBase::ExecuteNonQuery($insertStatement); if($affected_rows == 1) return true; else return false; }
public static function GetColumnNames($sql){ return DataBase::FieldsName($sql); }