Welcome Guest, Not a member yet? Register   Sign In
Error 1046, No database selected, ci running in MAMP
#1

[eluser]Apocryphon[/eluser]
I have ci installed on a regular MAMP stack, and I'm working on this tutorial. However, I have only gone through the Created section, and currently I am getting a No database selected error.

Model:
Code:
<?php
class submit_model extends Model {
    
    function submitForm($school, $district) {
        $data = array(
            'school' => $school,
            'district' => $district
        );

        $this->db->insert('your_stats', $data);
    }

}

View:
Code:
<?php $this->load->helper('form'); ?>

<?php echo form_open('main'); ?>

    <p>
        &lt;?php echo form_input('school'); ?&gt;
    </p>

    <p>
        &lt;?php echo form_input('district'); ?&gt;
    </p>

    <p>
        &lt;?php echo form_submit('submit', 'Submit'); ?&gt;
    </p>

&lt;?php echo form_close(); ?&gt;

Controller:
Code:
&lt;?php
class Main extends controller {
    
    function index() {
        
        // Check if form is submitted
        if ($this->input->post('submit')) {
            $school = $this->input->xss_clean($this->input->post('school'));
            $district = $this->input->xss_clean($this->input->post('district'));
            
            $this->load->model('submit_model');
            // Add the post
            $this->submit_model->submitForm($school, $district);
        }
        $this->load->view('main_view');
    }
}

database.php
Code:
$db['default']['hostname'] = "localhost:8889";
$db['default']['username'] = "root";
$db['default']['password'] = "root";
$db['default']['database'] = "stats_test";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
$db['default']['char_set'] = "utf8";
$db['default']['dbcollat'] = "utf8_general_ci";

config.php
Code:
$config['base_url']    = "http://localhost:8888/ci/";
...
$config['index_page'] = "index.php";
...
$config['uri_protocol']    = "AUTO";

So, how come it's giving me this error message?

Code:
A Database Error Occurred
Error Number: 1046

No database selected

INSERT INTO `your_stats` (`school`, `district`) VALUES ('TJHSST', 'FairFax')


Messages In This Thread
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-01-2011, 02:52 AM
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-01-2011, 02:32 PM
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-01-2011, 03:10 PM
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-01-2011, 03:43 PM
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-01-2011, 04:11 PM
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-01-2011, 09:22 PM
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-01-2011, 11:19 PM
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-01-2011, 11:25 PM
Error 1046, No database selected, ci running in MAMP - by El Forum - 01-02-2011, 01:52 AM



Theme © iAndrew 2016 - Forum software by © MyBB