PHP and 1&1 database help

PHP
1

Hi I have tried to connect to a database on 1 & 1 and aren’t getting anything show up. I got this code of 1&1 and have tried it. All it says is ‘no inpuit file selected’ .

<?php

$hostname=“xxxxxxxxxxxxx”;
$database=“xxxxxxxxxxxxxx”;
$username=“xxxxxxxxxxxxx”;
$password=“xxxxxxxxxxxxxx”;

$link = mysql_connect($hostname, $username, $password);
if (!$link) {
die('Connection failed: ’ . mysql_error());
}
else{
echo "Connection to MySQL server " .$hostname . " successful!
" . PHP_EOL;
}

$db_selected = mysql_select_db($database, $link);
if (!$db_selected) {
die ('Can\'t select database: ’ . mysql_error());
}
else {
echo ‘Database ’ . $database . ’ successfully selected!’;
}

mysql_close($link);

?>

I have very little php experience, i did create a login using php and xml but i was told to use a database because it is more secure. Does anybody know how I can connect to my database. I should be able to manage the rest tweaking my xml connect script.

2

That’s strange, because nowhere in the code you posted there is such a message.
You don’t get a “Connection failed” or “Connection successful” message?
Nor a “Can’t select database” or “Database successfully selected” message?

3

I know its got me stumped, I have little to no knowledge of php but I can link this database to a local host using xamp but it doesn’t work with an online database.

4

Is either the mysql, mysqli or PDO_mysql extensions available?

5

if the mysql extension isn’t available, shouldn’t he get a ‘unknown function’ error?

6

That error usually means there’s something configured incorrectly with your PHP installation. First disable any custom php.ini’s you may have, and any custom .htaccess files you may have then try again. If you’re still getting the error, you may have to contact your server admin to look in to it.

7

Yeah i did that and found that the problem was the hosting package, I have upgraded my package to a lunix version of the host and the script does now conect to the database. The reason they gave me was on the windows hosting package they use MS SQL instead of MY SQL. It would of been nice to know this before I started.