Login

08-09-2013, 06:11 AM

[eluser]davy_yg[/eluser]
I have the following code:

mmahasiswa.php

Code:
&lt;?php

class Mmahasiswa extends CI_Model{

  function tambah(){

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

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

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

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

  $data = array (

     'nim' => $nim,

     'nama' => $nama,

     'ipk' => $ipk,

     'jurusan' => $jurusan

    );

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

 }

}

?&gt;

cmahasiswa.php

Code:
&lt;?php

class cmahasiswa extends CI_controller{

  function tambahdata() {

   if ($this->input->post('submit')) {

    $this->load->model('mmahasiswa');

    $this->mmahasiswa->tambah();

    redirect('cmahasiswa/index');

   }

  $this->load->view('tambahmahasiswa');

 }

}

?&gt;

tambahmahasiswa.php

Code:
&lt;html&gt;

&lt;head&gt;&lt;title> Menginput Mahasiswa &lt;/title&gt;&lt;/head>

&lt;body&gt;

<h2>Input Mahasiswa</h2>

&lt;?php echo form_open('cmahasiswa/tambahdata'); ?&gt;

<table>

 <tr>

  <td><strong> NIM </strong></td>

  <td> : </td>

  <td> &lt;?php echo form_input('nim'); ?&gt;</td>

 </tr>

 <tr>

  <td><strong> Nama </strong></td>

  <td> : </td>

  <td> &lt;?php echo form_input('nama'); ?&gt;</td>

 </tr>

 <tr>

  <td><strong> IPK </strong></td>

  <td> : </td>

  <td> &lt;?php echo form_input('ipk'); ?&gt;</td>

 </tr>

 <tr>

  <td><strong> Jurusan </strong></td>

  <td> : </td>

  <td> &lt;?php echo form_input('jurusan'); ?&gt;</td>

 </tr>

 <tr>

  <td><br /> &lt;?php echo form_submit('submit','Simpan','id="submit"') ?&gt; </td>

 </tr>

</table>

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

&lt;/body&gt;

&lt;/html&gt;

When I run this url: http://localhost/mahasiswa/index.php/cma...tambahdata

A Database Error Occurred

Unable to select the specified database: mahasiswa

Filename: C:\xampp\htdocs\mahasiswa\system\database\DB_driver.php

Line Number: 140

Why is it ?

(I have mahasiswa database in phpmyadmin)

08-09-2013, 06:26 AM

[eluser]noideawhattotypehere[/eluser]
Any other database function works?
Paste your config/database.php (hide password if you have set any)

08-09-2013, 07:14 AM

[eluser]davy_yg[/eluser]
config/database.php

Code:
$active_group = 'default';

$active_record = TRUE;

$db['default']['hostname'] = 'localhost';

$db['default']['username'] = '';

$db['default']['password'] = '';

$db['default']['database'] = 'mahasiswa';

$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';

$db['default']['swap_pre'] = '';

$db['default']['autoinit'] = TRUE;

$db['default']['stricton'] = FALSE;

08-09-2013, 07:22 AM

[eluser]sv3tli0[/eluser]
A possible problem is if you have more than one SQL servers at your local..

You have to set server port ("localhost:3306") to the server which you use Smile

Another problem is if your mysql user don't have access to the table.. you can check that with setting the root username for testing..

Settings - pconnect and db_debug, can cause bugs depending on your local settings. (you can try to disable them one by one just for a test)

08-09-2013, 07:31 AM

[eluser]davy_yg[/eluser]

I only use one mysql server (xampp).

Setting for root username:

root localhost No ALL PRIVILEGES