[Jack Drake]

I'm having an error 500 connecting to my localhost database,

Code

<?php
try{
    // Create connection
    $conn = new mysqli("localhost", "username", "password");
}catch(Exception $e){
    echo $e;
}
echo "Connected successfully";
?>

Unfortunately, I never get an error report instead it just returns error 500 in browser
What is the cause of this error?

[Charger]

Check your error log . This ain’t enough

[Jack Drake]

The issue is that when I check the error logs it is empty?
Is there somewhere else that the error logs are located?

[MaxiPads889]

turn on error logging display, temporarily:

ini_set('display_errors', 1);

[newQuery]

The issue is that when I check the error logs it is empty?
Is there somewhere else that the error logs are located?

Check you vhost conf, you should have the path to your logs if everything was correctly setup.
Something like this:

Code

ErrorLog /var/log/error.log
LogLevel warn
CustomLog /var/log/access.log combined

[Jack Drake]

Thanks a lot for your help guys, Thankfully I was able to found that the error was that the mysqli class couldnt be found:

Code

Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/database/connect.php:4 Stack trace: #0 {main} thrown in /var/www/html/database/connect.php on line 4

I found a couple sources suggesting that i enable the mysqli extension in php.ini.
Unfortunately the same error appears when I enable it.

How can I install the mysqli class?

[Abruptum]

you can install it by "sudo apt install php7.2-mysqli"
and then restart the server with "sudo service apache2 restart"

[Quad]

Thanks a lot for your help guys, Thankfully I was able to found that the error was that the mysqli class couldnt be found:

Code

Fatal error: Uncaught Error: Class 'mysqli' not found in /var/www/html/database/connect.php:4 Stack trace: #0 {main} thrown in /var/www/html/database/connect.php on line 4

I found a couple sources suggesting that i enable the mysqli extension in php.ini.
Unfortunately the same error appears when I enable it.

How can I install the mysqli class?

Don't forget to restart your web server after enabling mysqli.

[Proxies]

I used to get this a lot, I never understood why I would get it.

What company are you hosting your server on?

[HFDone]

check if mysqli extension enabled in php.ini uncomment it

[FoxBlood]

I got the same error about one week ago, it was because I had the header set wrong, like this:
header("Location : index.php");
the problem is that space between Location and :

[Nachfolger]

I got the same error about one week ago, it was because I had the header set wrong, like this:
header("Location : index.php");
the problem is that space between Location and :

Dude this makes no sense. It's a MySQL error, nothing to do with PHP. Instead of offering useless and irrelevent information, read the thread next time.

[helios]

I'd suggest re-writing this to include some error handling. Here's an example including some comments:

PHP Code


<?php
// Start by defining your SQL database information as variables (best practice)
$db = "localhost";
$username = "username";
$password = "password";

// Create the connection
$conn = new mysqli($db, $username, $password);
// Check the connection
if ($conn->connect_error) {
    die("Database connection failed: " . $conn->connect_error);  // return this if we could not connect
} 

// Execute your query or any other code in this space, for example lets create a database
$sql = "CREATE DATABASE newDatabase";
if ($conn->query($sql) === TRUE) {    // if there are no errors connecting/executing the query
    echo "Database created successfully";
} else {
    echo "Error creating database: " . $conn->error; //otherwise return an error
}

$conn->close();  // close the connection
?>

[Squito]

Sidenote: this thread is more than a month old, probably was bumped up for post count increase.

[Charger]

I'd suggest re-writing this to include some error handling. Here's an example including some comments:

PHP Code


<?php
// Start by defining your SQL database information as variables (best practice)
$db = "localhost";
$username = "username";
$password = "password";

// Create the connection
$conn = new mysqli($db, $username, $password);
// Check the connection
if ($conn->connect_error) {
    die("Database connection failed: " . $conn->connect_error);  // return this if we could not connect
} 

// Execute your query or any other code in this space, for example lets create a database
$sql = "CREATE DATABASE newDatabase";
if ($conn->query($sql) === TRUE) {    // if there are no errors connecting/executing the query
    echo "Database created successfully";
} else {
    echo "Error creating database: " . $conn->error; //otherwise return an error
}

$conn->close();  // close the connection
?>

2019 and suggesting anything but PDO.... ok