I’m trying to connect my database with php, I’ve got this error:
Warning: mysqli::mysqli(): (HY000/1045): Access denied for user ‘typen’@’localhost’ (using password: NO) in C:wamp64wwwLogin test 2.0connectivity.php on line 7
My data base name is: "typen" it’s run on a whampserver (localhost) And as far as I know I don’t have a password set for my database, I don’t even have a password for phpmyadmin.
Имеем стандартную форму подключения:
$connection = mysqli_connect("127.0.0.1", "root", "", "my_db");
if (!$connection) <
echo "ERROR." . PHP_EOL;
exit;
>echo "success" . PHP_EOL;
Подключаемся без ошибок.
Делаю 2 файлика
1) db.php
$connection = mysqli_connect(
$config[‘db’][‘server’],
$config[‘db’][‘username’],
$config[‘db’][‘password’],
$config[‘db’][‘name’]
);
$config = array(
‘title’ => ‘#’,
‘vk_url’ => ‘#’,
‘db’ => array(
‘server’ => ‘127.0.0.1’,
‘username’ => ‘root’,
‘password’ => »,
‘name’ => ‘my_db’
)
);
require "db.php";
по сути тоже самое только данные берутся из конфига
стандартный вариант работает без проблем
мой вариант не пускает меня к БД по причине:
Warning: mysqli_connect(): (HY000/1045): Access denied for user »@’localhost’ (using password: NO) in E:OpenServerOpenServerdomainslocalhostmysiteincludsdb.php on line 6
Connection error!
Access denied for user »@’localhost’ (using password: NO)
дамп
<
["server"]=> string(9) "localhost"
["username"]=> string(4) "root"
["password"]=> string(0) ""
["name"]=> string(6) "my_db" > >
. user сетается как пустое значение
Access denied for user »@’localhost’
Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES) in C:UsersxampphtdocsPHP_Login_Scriptconfig.php on line 6
Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:UsersxampphtdocsPHP_Login_Scriptlogin.php on line 10
Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:UsersxampphtdocsPHP_Login_Scriptlogin.php on line 11
Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in C:UsersxampphtdocsPHP_Login_Scriptlogin.php on line 15
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:UsersxampphtdocsPHP_Login_Scriptlogin.php on line 16
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:UsersxampphtdocsPHP_Login_Scriptlogin.php on line 19
I’m getting this error above on localhost even if my config file is like this:
This used to work, but now it doesn’t anymore. Is there any problem with this code or is it not working now? This is the tutorial I am working on right now.