What do I change the variables to for SQL database

Status
Not open for further replies.

mmorning16

New Member
Messages
3
Reaction score
0
Points
0
I am setting up a football pool and i am using a prebuilt php site. The only insturctions I got were to edited a config.php. I created a database in mysql and created the user account and I uploaded all the files to my public_html folder but I am not sure what I should be changed or what to change it to. Any ideas?

below is what is in the config.php
PHP:
<?php
//modify vars below
$db_host = 'localhost';
$db_user = 'root';
$db_password = 'connect';
$database = 'nflpickem';
$db_prefix = 'nflp_';
$siteUrl = 'http://localhost/personal/phppickem.com/application/';
$allow_signup = true;
$show_signup_link = true;
$user_names_display = 3; // 1 = real names, 2 = usernames, 3 = usernames w/ real names on hover
//set timezone offset, hours difference between your server's timezone and eastern
define('SERVER_TIMEZONE_OFFSET', 1);
 

vv.bbcc19

Community Advocate
Community Support
Messages
1,524
Reaction score
92
Points
48
Hi
create a database, create a user and the password.Allow this user full control on the database by adding user to the database.
All this can be done from cPanel and by hitting Mysql database icon
Then
use them here..you need to change those which are put in bold

<?php
//modify vars below
$db_host = 'localhost';
$db_user = 'mmorning_databasename';
$db_password = 'password_that_you_have_set';
$database = 'mmorning_databasename_you_have_set';
$db_prefix = 'nflp_';
$siteUrl = 'folder in which you kept the files -hint- can be found from cPanel ';
$allow_signup = true;
$show_signup_link = true;
$user_names_display = 3; // 1 = real names, 2 = usernames, 3 = usernames w/ real names on hover
//set timezone offset, hours difference between your server's timezone and eastern
define('SERVER_TIMEZONE_OFFSET', 1);
 

mmorning16

New Member
Messages
3
Reaction score
0
Points
0
$db_user = 'mmorning_databasename';

is that supposed to be the user name?

$siteUrl = 'folder in which you kept the files -hint- can be found from cPanel ';

I put the files in the Html folder under a phppicks folder, was I supposed to uplaod them some place else? Not sure where I should be looking in the control panel.

BTW THANK YOU for the thelp. I apprciate it.
 
Status
Not open for further replies.
Top