PHP won't connect to mySQL databse

[a09hopper]

<?php
        $database = array();
        $database['host'] = "localhost";
        $database['port'] = '3306';
        $database['name'] = "forumtest";
        $database['username'] = "root";
        $database['password' = "Password";

        $link = mysql_connect($database['host], $database['username'], $database['password']);

        if ($link) {
        echo "Connected to a database".$database['name'];
        }else{
        echo connect to a database"$database['name'] . "failed<br/>";
        echo "Error: ".mysql_error();
        }
?>

This is my code for a test to connect to a database however, there seems to be a problem with the code as when I try to connect it just gives me a error 500. I would appreciate any help.

[benanamen]

Toss that code in the trash. It has been obsolete for over a decade and is now completely removed from PHP. You need to use PDO.

Edited July 27, 2016 by benanamen

[ginerjm]

And don't ever post REAL credentials on the internet!

 

Plus - why use an array when you have the values handy?

[cyberRobot]

You are missing some quotes and other components. You could try the following:

<?php
$database = array();
$database['host'] = "localhost";
$database['port'] = '3306';
$database['name'] = "forumtest";
$database['username'] = "root";
$database['password'] = "Password";
 
$link = mysql_connect($database['host'], $database['username'], $database['password']);
 
if ($link) {
    echo "Connected to a database".$database['name'];
}else{
    echo "connect to a database" . $database['name'] . "failed<br/>";
    echo "Error: ".mysql_error();
}
?>

With that said, the mysql_* functions were removed in the newest version of PHP, as benanamen was hinting at. More information can be found here:

http://php.net/manual/en/mysqlinfo.api.choosing.php

Edited July 27, 2016 by cyberRobot