[SOLVED] get values from views to model

[eluser]rochellecanale[/eluser]
hello just want to ask how can i get a value from my views directly to my model function...
I created a simple code below:

my view:

Code:

echo form_open('main_controller/add_db');
echo "<label>Create database</label>";
echo "&lt;input type='text' name='database' required='required' /&gt;";
echo "&lt;input type='submit' value='ADD'  /&gt;";
echo form_close();

my controller:

Code:

public function main_controller(){
        $this->main_model->adddb();
        $this->main_model->usedb();
        $this->load->view('add_table');
}

my model:

Code:

$database = $this->input->post('database');

public function adddb(){
      $queryadd = "CREATE DATABASE ".$database;
}

But when i proceed to add_table.php which is my next page after submitting the form
it displays database error.

Code:

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

CREATE DATABASE ;

How can i call/get the values from my form?