mysqli::mysqli(): php_network_getaddresses: getaddrinfo failed: Name or service not known
Problem is with this line.
$mysqli = new mysqli('$host','$user','$pass','$database');
Change it to
$mysqli = new mysqli($host,$user,$pass,$database);
In PHP variables within single quotes are not interpolated with their values.
Check PHP's variable parsing mechanism here
gokul
Updated on June 18, 2022Comments
-
gokul almost 2 years
<?php function getMysqlConnection($host, $user, $pass, $database) { global $mysqli; global $Mysqlerror; $mysqli = new mysqli('$host', '$user', '$pass', '$database'); if (empty($mysqli->connect_errorno) == false) { $Mysqlerror = "true"; } else { $Mysqlerror = "false"; } }
I have created a function as above which implement connection on given MySQL user credentials and I implemented this function by using
<?php require 'myFunc.php'; getMysqlConnection("localhost", "wronguser", "wrongpass", " test"); echo $Mysqlerror;
Although i used wrong password and username the Mysqlerror is false . I also used or die function nothing happen
Warning: mysqli::mysqli(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /opt/lampp/htdocs/mysite/myFunc.php on line 5
Warning: mysqli::mysqli(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known in /opt/lampp/htdocs/mysite/myFunc.php on line 5
I restarted lampp as usual it showed
Starting XAMPP for Linux 1.8.0... XAMPP: Starting Apache with SSL (and PHP5)... XAMPP: Starting MySQL... Warning: World-writable config file '/opt/lampp/etc/my.cnf' is ignored XAMPP: Starting ProFTPD... /opt/lampp/share/lampp/alladdons: line 23: /opt/lampp/share/addons/: is a directory XAMPP for Linux started.
Is the problem with my code or with my server some thing. How to fix it?
-
gokul over 11 yearsactually this made the same warning. I am on a project that get users mysql data and get connection. So I used this function to redurn $Mysqlerror if they had given wrong data