Php database help! :)

[memphiz]

Hello this is my first post and i need to ask for some help.

i have webspace with x10hosting, i got it for a fifa10 league website i am designing. now im exellent with html but i real feel for this to work properly it needs a php database so the league table and fixtures and news etc can be updated by me and other users.

anyway to the point i have downloaded a php script called PHPfootball which is a script for football leagues which sound like just what i need.

it says in the readme to upload to your site and run the install.php and fill in the details which i did. then it says to load your site log in with the password i made in the install.php
i have done all this but it just comes up with an error when i try to load.
is there anywhere special i shud be uploading the php documents too ? atm i just uploading to the public_html folder.

when i open the install.php it asks for the followin:
Databse name
database hostname
database user
database password
i have set up a database in control panel called fifaplay my user name is that : memphiz@starka.x10hosting.com?


i am a complete beginner at php and any help would be much appretiated.

[Gouri]

If you created database in cpanel using "mysql databases" There is another option in the same window that create user for the database and link them by giving the full privillages.

Once you done

The database name will be yourcpanelusername_databasename in your case memphiz_fifaplay
username will be yourcpanelusername_username created and linked to DB memphiz_<username>
password what ever you given.

host name is localhost

[memphiz]

thank you for the reply. i put all that information

memphiz_fifaplay
localhost

memphiz_memphiz
my password

but when i try to load the index.php this is the error it says:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'your database server hostname' (3) in /home/memphiz/public_html/includes/inc.db.php on line 5

Error

Could not conect to MySQL, Make sure it is started and you used the install script

[Gouri]

Did you created the memphiz user in the database section and associated with fifaplay database by giving all the privileges

As you are giving the memphiz_ memphiz

first part is your cpanelusername and second name is the database user name

[memphiz]

yes i did mate.

[descalzo]

but when i try to load the index.php this is the error it says:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'your database server hostname' (3) in /home/memphiz/public_html/includes/inc.db.php on line 5

Error

Go to cPanel->File Manager and open /includes/inc.db.php to edit. (or however you edit files)
See if you can find a string that says 'your database server hostname'
Replace that with 'localhost'.
Save file.
See if your site works.

[memphiz]

no i open up that file and it seems to be the code for that error message:

<?php
$image_l = "<img align=center src=images/phpfootball_logo_small.gif>";
$install_l = "[<a href=install.php>Installation Script<a/>]";
require("includes/inc.config.php");
$link = mysql_connect($dbhost,$dbuser,$dbpass) or die ("$image_l<h3>Error</h3>Could not conect to MySQL, Make sure it is started and you used the install script<br>$install_l\n");
mysql_select_db("$dbname",$link) or die ("$image_l<h3>Error</h3>Could not select database, Make sure you ran the install script<br>$install_l\n");
?>
Edit:
i found a inc.config.php file and edit in there the username server etc because that it all the info it wants. now i get this message:

died while authenticating user
Debug info: SELECT Userlevel FROM Accounts WHERE Username = 'PHPSESSID' AND Password = ###

this is the link for the thing im trying to set up maybe if someone looks at the files they might realise whats wrong.

http://sourceforge.net/projects/phpfootball/files/

sorry to be a pain in the ass its probably something really simple :D

[Coonz]

sorry, that is outdated.... I'd suggest to look for something else.

[myarunachal]

just put this in Your Host : mysql-lotus.x10hosting.com


:happysad:if it works please rate me thanks

[misson]

died while authenticating user
Debug info: SELECT Userlevel FROM Accounts WHERE Username = 'PHPSESSID' AND Password = '...'

Never post a password, even if it's been hashed. Edit your post right now and replace the hash with some other string (e.g. ellipses or asterisks) as I have done.

Anyway, that error looks like a failure within the app's own authentication system, as opposed to a problem authenticating the DB user (memphiz_memphiz) with MySQL. Are you prompted for fantasy football account credentials? The user name also looks suspicious.