[SOLVED] Unable to connect to the database

Good morning i have a Project in a subfolder , the system work fine but i cannnot connect to db , file env its ok and if i try to connect with adminer ( similar to Phpmyadmin ) and same credential of file env It connect. Wath can i do?

You need to show us your config database file setup to be able to help you.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

You need to show us your config database file setup to be able to help you.

see my env with xxx in credential . edited name from .env to env.txt to upload

Did you try the config database settings alone to see if they work?
Also the base_url in your env.txt should have an ending backslash on it \

You can try this to see if you can connect stand alone.

PHP Code:

<?php
// Code to create the database

// Add your own username and password
$serverName = "localhost";
$userName   = "username";
$password   = "password";

// Create the Database Connection
$connId = mysqli_connect($serverName, $userName, $password);

// Check the Database Connection
if ($connId === false)
{
    exit("ERROR: Could not connect. " . mysqli_connect_error());
} 

// Create the Database
// Add your datya
$sql = "CREATE DATABASE yourDatabaseName";

// Check that the Database was created
if (mysqli_query($connId, $sql))
{
    echo "Database created successfully";
}
else
{
    echo "ERROR: Creating Database. " . mysqli_error($connId);
}

// Close the Connection
mysqli_close($connId);

?>

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

Did you try the config database settings alone to see if they work?
Also the base_url in your env.txt should have an ending backslash on it \

You can try this to see if you can connect stand alone.

PHP Code:

<?php
// Code to create the database

// Add your own username and password
$serverName = "localhost";
$userName   = "username";
$password   = "password";

// Create the Database Connection
$connId = mysqli_connect($serverName, $userName, $password);

// Check the Database Connection
if ($connId === false)
{
    exit("ERROR: Could not connect. " . mysqli_connect_error());
} 

// Create the Database
// Add your datya
$sql = "CREATE DATABASE yourDatabaseName";

// Check that the Database was created
if (mysqli_query($connId, $sql))
{
    echo "Database created successfully";
}
else
{
    echo "ERROR: Creating Database. " . mysqli_error($connId);
}

// Close the Connection
mysqli_close($connId);

?>

i Change your code :

PHP Code:

<?php
// Code to create the database

// Add your own username and password
$serverName = "localhost";
$userName   = "xxxx";
$password   = "xxxx";

// Create the Database Connection
$connId = mysqli_connect($serverName, $userName, $password);

// Check the Database Connection
if ($connId === false)
{
    exit("ERROR: Could not connect. " . mysqli_connect_error());
} 

// Create the Database
// Add your datya
$sql = "select * from xxxx.admin";

// Check that the Database was created
if (mysqli_query($connId, $sql))
{
    echo "Database created successfully";
}
else
{
    echo "ERROR: Creating Database. " . mysqli_error($connId);
}

// Close the Connection
mysqli_close($connId);

?>

and result is : Database created successfully 

In your database settings in the .env change localhost to 27.0.0.1 and see if that works.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

In your database settings in the .env change localhost to 27.0.0.1 and see if that works.

Same problem connection Is AN empty array

Did you do away with the .env file and try using the Config\Database.php settings?

This makes no sense, I use databases all the time and never have a problem.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )

Did you do away with the .env file and try using the Config\Database.php settings?

This makes no sense, I use databases all the time and never have a problem.

i try both  config/database and env same problem

---

Did you do away with the .env file and try using the Config\Database.php settings?

This makes no sense, I use databases all the time and never have a problem.

i try both  config/database and env same problem

i try to use the script at this tread :

https://forum.codeigniter.com/thread-77479.html

this is the error:

mysqli::__construct(): Headers and client library minor version mismatch. Headers:50650 Library:50528

[url=https://www.google.com/search?q=ErrorException+mysqli%3A%3A__construct%28%29%3A+Headers+and+client+library+minor+version+mismatch.+Headers%3A50650+Library%3A50528][/url]

You have a mismatch with MySQLi try using a newer version of MySQLi and PHP.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )