codeigniter A Database Error Occurred

Question

Can someone help me?

I am a beginner and trying to make wearing CodeIgniter authentication, but when I try to make an error like this

A Database Error Occurred

Error Number: 1046

No database selected

SELECT * FROM (`user`) WHERE `user_username` = 'amanda' AND user_passwordMD5("12345") =

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

Line Number: 330

thanx

Answer 1

please make sure you have setup database configuration in application/config/database.php file

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = '';
$db['default']['database'] = 'my_database';

Answer 2

Check the database.php file in application/config/

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = 'mypassword';
$db['default']['database'] = 'my_database'; // here is the database selection

Answer 3

Open the file application/config/database.php file and change the following line:

$db['default']['dbdriver'] = 'mysql';

To:

$db['default']['dbdriver'] = 'mysqli';

This shift to mysqli saved by day.

Answer 4

Lost connection to MySQL server during query Line Number: 337

Answer 5

people who critic here should have not only education but also common sense. they should know also what time I made this comment and what was my reputation score. It is not only about giving an answer but the giving also the suggestion a beginner can pin-point the problem. I could have given the answer but just after posting my comment someone already given answer. Look below - best among anyone given here

$config['hostname'] = "localhost";
$config['username'] = "username";
$config['password'] = "password";
$config['database'] = "database";
$config['dbdriver'] = "mysql";
$config['dbprefix'] = "";
$config['pconnect'] = FALSE;
$config['db_debug'] = TRUE;
$config['cache_on'] = FALSE;
$config['cachedir'] = "";
$config['char_set'] = "utf8";
$config['dbcollat'] = "utf8_general_ci";