Error message:
Db connection successful Fatal error: Uncaught Error: Call to a member function execute() on bool in /opt/lampp/htdocs/tennisdaily/app/database/db.php:9 Stack trace: #0 {main} thrown in /opt/lampp/htdocs/tennisdaily/app/database/db.php on line 9
db.php:
<?php
require('connect.php');
$sql = "SELECT * FROM users";
$stmt = $conn->prepare($sql);
$stmt->execute();
$users = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
echo "<pre>" , print_r($users). "</pre>";
connect.php:
<?php
$host = 'localhost';
$user = 'root';
$pass = "";
$db_name = "tennisdaily";
$conn = new MySQLi($host, $user, $pass, $db_name);
if ($conn->connect_error){
die('Database connection error: ' . $conn->connect_error);
}
else {
echo "Db connection successful";
}
?>
