Database connection error

phpboyhelp

I keep getting this error:

Warning: mysqli_connect(): (42000/1044): Access denied for user 'p04294726'@'%.dmu.ac.uk' to database 'cottage' in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 10
(This the correct error)

Can anyone help me to fix it

Here is the full php code



		define ("QUERY", "INSERT INTO customers (title, forename, surname, addressone, addresstwo, city, postcode, phone, email, username, password) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,)");

		$title = $_POST['title'];
		$forename = $_POST['name'];
    	        $surname = $_POST['surname'];
		$addressone = $_POST['firstadd'];
		$addresstwo= $_POST['secondadd'];
		$city = $_POST['city'];
		$postcode = $_POST['postcode'];
    	        $phone = $_POST['phone'];
		$email = $_POST['email'];
		$username = $_POST['user'];
		$password = $_POST['password'];

	$statement = mysqli_prepare($connection, QUERY);

	mysqli_stmt_bind_param($statement,
		            "sssssssisss",   
					$_POST['title'],
					$_POST['name'],
					$_POST['surname'],
					$_POST['firstadd'],
					$_POST['secondadd'],
					$_POST['city'],
					$_POST['postcode'],
					$_POST['phone'],
					$_POST['email'],
					$_POST['user'],
					$_POST['password']);

	mysqli_stmt_execute($statement);


	switch(mysqli_stmt_errno($statement))
	{
		case 0:
				 $addcottageComplete = true;
		     	        $addcottageOutcomeMessage = "Customer " .                      $_POST['name'] . " added";
			 break;

		default:
				$addcottageComplete = true;
		    	$addcottageOutcomeMessage = mysqli_stmt_error($statement);
		}

		echo $addcottageOutcomeMessage;

		include ("index.html");

		mysqli_stmt_close($statement);

		mysqli_close($connection);

bradgrafelman

In the future, you might not want to post your MySQL login credentials for the world to see. Also, when posting PHP code, please use the board's [PHP][/PHP] tags as they make your code much easier to read. Please go back and edit your post now to include these tags.

phpboyhelp wrote:
Can anyone help me to fix it

Yes, your webhost or database provider can. As the error message states, there is a problem with your login credentials.

peytonrm

Your code looks fine, as stated above you probably just don't have an account setup on the database server.

A few tips: Your query would be much better defined as a variable than a constant. Constants are for things that get declared and then never modified or redeclared. In this example that's probably ok, but in just about any other application you will certainly want more than one query. Also, indices in your $POST variables should be quoted (i.e. $POST['name']). PHP allows it if you don't quote, but it's not good practice and will generate warnings in strict mode.

phpboyhelp

I have some the changes given to me but i am still receiving the error

Warning: mysqli_connect(): (42000/1044): Access denied for user 'p04294726'@'%.dmu.ac.uk' to database 'cottage' in H:\p3t\phpappfolder\public_php\project\addcustomer.php on line 10

bradgrafelman

Again, this isn't an error we can solve for you - talk to your database provider.

NogDog

Unless my eyes are just not seeing it, you have not shown us the code where the mysqli_connect() is being done. Therefore, it's pretty hard for us to debug that error.