Witam. Probuje dostac sie do bazy uzywajac pdo.
connectDB:
$dsn = 'mysql:host=localhost;dbname=book_lovers';
$dbuser='root';
$dbpassword = '';
$dbconn = new PDO($dsn, $dbuser, $dbpassword);
index.php
include_once('./Scripts/connectdb.php');
$sql ="SELECT * FROM favourite_books;";
$a=$stmt=$dbconn->prepare($sql);
$stmt->execute();
$result=$stmt->fetchAll();
// $result = mysqli_query($dbconn, $sql);
print_r($a->errorInfo());
//close that database connection
$stmt->closeCursor();
Error code
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1049] Unknown database 'book_lovers' in D:\wamp\www\sarahsphp\Scripts\connectdb.php on line 12
Wszystkie nazwy sa poprawne. Kopiowalem juz kilka razy. Jakies pomysly?