6 replies to this topic

[Bioshox]

Hey Guy's

Another questions about my installer, I just can't get this bit working.

I have an input section so user's can add there MySQL details and it creates a config.php file for connecting ect, but when I use variables for the database name and database username it throws out a connection error, but when I don't it connects fine

here's the code im using when it connects

$host = $_POST['host'];

$user = $_POST['user'];

$name = $_POST['name'];

$password = $_POST['password'];


		//Host | Database User | Database Password

		mysql_connect($host, "game", $password) or die(mysql_error());

		

		//Database Name

		mysql_select_db("game") or die(mysql_error());

and when it doesnt

$host = $_POST['host'];

$user = $_POST['user'];

$name = $_POST['name'];

$password = $_POST['password'];


		//Host | Database User | Database Password

		mysql_connect($host, $user, $password) or die(mysql_error());

		

		//Database Name

		mysql_select_db($name) or die(mysql_error());

[John]

What error does it throw? :closedeyes:

[Bioshox]

Oop's, my bad!

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'game'@'10.**.0.**' (using password: YES) in /install/mysql.php on line 31


Access denied for user 'game'@'10.**.0.**' (using password: YES)

[webcodez]

works fine for me... but try:

EDIT: nvm, thought you were having trouble on the mysql_select_db part.

[Bioshox]

Weird, I'll get someone to try it on there own host.

But WebCodez, would you be interested in helping me develop the piece of software I am currently working on, if so PM me :)

[webcodez]

Sure, always in for new projects of web applications :)

Pmed.

[banker]

Just curious, but isn't this a harder way to connect to your database vs. using a simple include() statement?

Define the connection details in the include() file. Since its php, the data is not visible, even if accessed directly.
You will also remove the headache of having to sanitize inputs that came from your form.