Set MySQL config data on install PHP

Question

I've made an install script for mysql tables. I want the user to set the database configurations. The configurations for mysql is hard coded in a PHP class as public variables.

What would be best practice for creating and storing the config data on install?

score 1 · Answer 1 · answered Nov 06 '12 at 15:21

1

I recommend using a .ini file. Example:

database.config.ini:

host = "localhost"
db = "test"
user = "root"
pass = ""

To load config:

$config = parse_ini_file('database.config.ini');
print_r($config);

/*Array
(
    [host] => "localhost"
    [db] => "test"
    [user] => "root"
    [pass] => ""
)*/

answered Nov 06 '12 at 15:21

Fred Wuerges

1,965
2
21
42

@Zlatan I do not understand your question. For details on the function you can read the php documentation: http://php.net/manual/en/function.parse-ini-file.php – Fred Wuerges Nov 06 '12 at 16:34
is it readable if I access to an .ini file from my browser man? – Nov 06 '12 at 16:34
@Zlatan Yes, the browser interprets as text/plain. – Fred Wuerges Nov 06 '12 at 16:40
You can deny access from this file extension via .htaccess – Fred Wuerges Nov 06 '12 at 17:12

score 0 · Answer 2 · answered Nov 06 '12 at 12:12

0

Create a form for accept config data, during the process these content to write to a file or a xml . Then read from file config datas

answered Nov 06 '12 at 12:12

Elby

1,624
3
23
42

Is it possible to write to the PHP file instead? XML doesn't sound that safe for storing that kind of data. – user1121487 Nov 06 '12 at 12:17
Thats i am not sure,please try – Elby Nov 06 '12 at 12:19

score 0 · Accepted Answer · answered Nov 06 '12 at 13:08

0

Use PHP fwrite() to create content to an empty PHP-file. Content is defined constants of users input. Use these constants to set value to the Database configuration file.

answered Nov 06 '12 at 13:08

user1121487

2,662
8
42
63

Set MySQL config data on install PHP

3 Answers3