[eluser]FuriKuri[/eluser]
[quote author="Jamongkad" date="1186597946"]Hi Furikuri,
If you check the config folder in your CodeIgniter directory there is a file called "database.php". It looks like this...
Here you can set the database. The comments are pretty self explanatory...[/quote]
Heres mine:
Code:
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
/*
| -------------------------------------------------------------------
| DATABASE CONNECTIVITY SETTINGS
| -------------------------------------------------------------------
| This file will contain the settings needed to access your database.
|
| For complete instructions please consult the "Database Connection"
| page of the User Guide.
|
| -------------------------------------------------------------------
| EXPLANATION OF VARIABLES
| -------------------------------------------------------------------
|
| ['hostname'] The hostname of your database server.
| ['username'] The username used to connect to the database
| ['password'] The password used to connect to the database
| ['database'] The name of the database you want to connect to
| ['dbdriver'] The database type. ie: mysql. Currently supported:
mysql, mysqli, postgre, odbc, mssql
| ['dbprefix'] You can add an optional prefix, which will be added
| to the table name when using the Active Record class
| ['pconnect'] TRUE/FALSE - Whether to use a persistent connection
| ['db_debug'] TRUE/FALSE - Whether database errors should be displayed.
| ['active_r'] TRUE/FALSE - Whether to load the active record class
| ['cache_on'] TRUE/FALSE - Enables/disables query caching
| ['cachedir'] The path to the folder where cache files should be stored
|
| The $active_group variable lets you choose which connection group to
| make active. By default there is only one group (the "default" group).
|
*/
$active_group = "default";
$db['default']['hostname'] = "mysql5-12";
$db['default']['username'] = "animesaifuri";
$db['default']['password'] = "***************";
$db['default']['database'] = "animesaifuri";
$db['default']['dbdriver'] = "mysql";
$db['default']['dbprefix'] = "";
$db['default']['active_r'] = TRUE;
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = "";
?>
The database is already set, in fact when i access the first controller (login) it can connect to the database and querys work well, but after that, when its redirect to the next page i got this error.
Error!
Cannot make MySQL server connection.
When i access the same web at localhost i can connect and interact with my mysql database without any problem, so i figure theres any difference between the localhost server (xampp) and the remote host.
Any idea?
