Database

mattyk3001

Sep 6 2008, 03:59 PM

<?php
$c = mysql_connect('localhost', 'root', 'p1kap1ka');
mysql_select_db('lite2', $c);
$mykey=256573440;
?>

In this code where shall I post my database name (and my database name should it contain my hosting name so before it there should be a165_game For example? or should it just be game?) and where shall I put the user password?

Comment/Reply (w/o sign-up)

faulty.lee

Sep 6 2008, 04:15 PM

QUOTE(mattyk3001 @ Sep 6 2008, 11:59 PM)

<?php
$c = mysql_connect('localhost', 'root', 'p1kap1ka');
mysql_select_db('lite2', $c);
$mykey=256573440;
?>

In this code where shall I post my database name (and my database name should it contain my hosting name so before it there should be a165_game For example? or should it just be game?) and where shall I put the user password?

According to MySQL manual

mysql_connect ( [string server [, string username [, string password [, bool new_link [, int client_flags]]]]] )

So clearly "root" in your code is the username and "p1kap1ka" is your password.

As for database name,

mysql_select_db ( string database_name [, resource link_identifier] )

So, it would be "lite2".

When you create your database in cpanel, you should have the database name generated for you. The lasttime I did, it appended my username along with it like you suggested. Anyway, you should check the generated name in cpanel instead of mere guessing.

Comment/Reply (w/o sign-up)

mattyk3001

Sep 6 2008, 04:23 PM

The name of the database that is given to me by mysql is a1663202_game should it be a1663202_game or just "game". And in the script should the database name be entered where the script says "lite2"?

EDIT:
So what you are saying is the database name should be written in localhost and the username and password in the other sections? or should it just be left as local host username password?

for example looking like this.

<?php
$c = mysql_connect('localhost', 'a1663202_user', 'PASSWORD');
mysql_select_db('a1663202_game', $c);
$mykey=256573440;
?>

Comment/Reply (w/o sign-up)

faulty.lee

Sep 6 2008, 04:38 PM

Yap

Comment/Reply (w/o sign-up)

mattyk3001

Sep 6 2008, 04:40 PM

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a1663202_user'@'localhost' (using password: YES) in /home/a1663202/public_html/mysql.php on line 2

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/a1663202/public_html/mysql.php on line 3

These are the two error messages i'm then getting when i am trying to access the game and sign up.

Comment/Reply (w/o sign-up)

Darasen

Sep 7 2008, 01:34 AM

Using local host is assuming that the database is stored on the same physical server that is serving the PHP pages. This is not always the case.

Comment/Reply (w/o sign-up)

faulty.lee

Sep 7 2008, 04:03 AM

QUOTE(mattyk3001 @ Sep 7 2008, 12:40 AM)

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'a1663202_user'@'localhost' (using password: YES) in /home/a1663202/public_html/mysql.php on line 2

Access denied means your login or password is wrong. Check the database creation page for more information on this. Sometime, they also provide the connection string which you can refer to.

QUOTE(mattyk3001 @ Sep 7 2008, 12:40 AM)

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/a1663202/public_html/mysql.php on line 3

Since you can't connect to the server, you do not have a valid MySQL-Link resource that you can select your database with. You need to get pass line 2 before line 3 will execute properly.

Comment/Reply (w/o sign-up)

yordan

Sep 8 2008, 03:45 PM

Probably your user name is also a1663202_game
Did you try connecting with PhpMyadmin in order to see what happens ?
Usually, when kind people create a database for you, they provide you with :
1) server name (usually localhost, but sometime it's something different)
2) database name
3) database username
4) database username password

Comment/Reply (w/o sign-up)