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