[leojwinter]

I'm trying to code a log in and registration feature but I'm having trouble connecting to my MySQL server, I'm sure all my credentials are correct, just not sure I've applied them correctly.

I named both the database and username the same as an example, still no connection. It wants to connect to a table in the database called 'users'.

Thanks a lot.

Connection code:

PHP Code:

<?php

$username = $_POST['username'];
$password = $_POST['password'];

if ($username && $password) {
    $connect = mysql_connect("mysql16.000webhost.com", "a6128086_users", "password") or die ("Couldn't connect!");
    mysql_select_db("a6128086_users", $connect) or die("Unable to locate database.");    
}
else
    die("Please enter a Username and Password.");

?>

[d3iti]

Hi,
Are you getting any error MySQL server?
Would be good to see error returns on the connection MySQL server.

[leojwinter]

Originally Posted by d3iti

Hi,
Are you getting any error MySQL server?
Would be good to see error returns on the connection MySQL server.

Hi, only error I receive is the one I setup.

"Please enter a Username and Password."

[d3iti]

One way to see what problems you have with the piece of code you've written before is changing that part of code with the following code:

PHP Code:

<?php

$username = $_POST['username'];
$password = $_POST['password'];

if ($username && $password) {
    $connect = mysql_connect("mysql16.000webhost.com", "a6128086_users", "password") or die ("Couldn't connect!" .mysql_error());
    mysql_select_db("a6128086_users", $connect) or die("Unable to locate database." .mysql_error());    
}
else
    die("Please enter a Username and Password.");

?>

[diwanguard]

<?php

if(!defined('INCLUDE_CHECK')) die('You are not allowed to execute this file directly');


/* Database config */

$db_host = 'mysql3.000webhost.com';
$db_user = 'MySQL user name';
$db_pass = 'MySQL user pass';
$db_database = 'MySQL database name';

/* End config */



$link = mysql_connect($db_host,$db_user,$db_pass) or die('Unable to establish a DB connection');

mysql_select_db($db_database,$link);
mysql_query("SET names UTF8");

?>

[biazzotto]

If you are using <form action="file.php" method="GET">, try replacing

PHP Code:

$username = $_POST['username'];
$password = $_POST['password']; 


with

PHP Code:

$username = $_GET['username'];
$password = $_GET['password'];