Db new mysqli 'localhost bashiru bashiru4u bashiru not connecting
It looks like you're trying to connect to a MySQL database using the mysqli
extension in PHP, but it's not working. Let's troubleshoot this together!
Here are a few things to check:
- Database credentials: Make sure the username, password, and database name are correct. In your code, it seems like you're using
bashiru
as the username, password, and database name. Are you sure that's correct? - Server connection: Ensure that your MySQL server is running and listening on the correct port (usually 3306). You can check this by running
netstat -tlnp | grep 3306
(on Linux/macOS) ornetstat -an | findstr 3306
(on Windows). - PHP configuration: Verify that the
mysqli
extension is enabled in your PHP configuration. You can check this by runningphp -m
(on Linux/macOS) orphp -m
(on Windows) and looking formysqli
in the list of enabled extensions. - Error handling: Make sure you're handling errors properly. In your code, you're not checking for any errors or exceptions. You can use the
mysqli_error()
function to get the error message if the connection fails.
Here's an updated version of your code with some error handling:
<?php
$servername = 'localhost';
$username = 'bashiru';
$password = 'bashiru4u';
$dbname = 'bashiru';
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: ". $conn->connect_error);
}
echo "Connected successfully";
?>
If you're still having issues, please provide more details about your environment, such as the PHP version, MySQL version, and operating system you're using.