[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 "<input type='text' name='database' required='required' />";
echo "<input type='submit' value='ADD' />";
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?