Warning: mysqli_connect(): (HY000/1045): Access denied for user '$username'@'localhost' (using password: YES) in .php file

Question

I'm new to php ,trying to solve my issue(connecting with database at line 12) over here please help...!! seen similar questions over here but they haven't helped me..!! my code is as follows:

<?php 
session_start();

// variable declaration
$username = "";
$password ="";
$db='register';


// connect to database
$db = mysqli_connect('localhost', '$username','$password', 'register') or die("unable to connect");
?>

Use double quote for variable substitution: `"$username", "$password"` — endo64, Jun 09 '19 at 17:03
Still getting the same error as above tried with double quotes and without quotes.... — Adithya Kondra, Jun 09 '19 at 17:11
Try adding [mysqli_connect_error()](https://www.php.net/manual/en/mysqli.connect-error.php) to see what error is being reported. — Nigel Ren, Jun 09 '19 at 17:18

score 0 · Answer 1 · answered Jun 09 '19 at 17:01

The problem is with your quotes. Single quotes ’ don’t expand variables so the username is sent as $username as the error shows. You need double quotes to expand, or in this case no quotes because you just want to pass the values from the variables:

$db = mysqli_connect('localhost', $username, $password, 'register') or die("unable to connect");

Warning: mysqli_connect(): (HY000/1045): Access denied for user '$username'@'localhost' (using password: YES) in .php file

1 Answers1