PHP Fatal error: Uncaught Error: Class "mysqli" not found

[newcoder1010]

Hello,

windows + php + xampp + mysql

https://www.w3schools.com/php/php_mysql_connect.asp

I am getting the error when I run the php script in terminal.

Quote

PHP Fatal error:  Uncaught Error: Class "mysqli" not found

 

<?php

echo "<br> --- CREATE DB --- <br>";

$servername = "127.0.0.1";
$username = "root";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
// Create database
$sql = "CREATE DATABASE myDB";
if ($conn->query($sql) === TRUE) {
  echo "Database created successfully";
} else {
  echo "Error creating database: " . $conn->error;
}

When I run the script on browser, I get this message

--- CREATE DB ---
Connected successfullyDatabase created successfully

But when I run the script in terminal, I get an error

Stack trace:
#0 {main}
  thrown in C:\xampp\w3schoolsPhp\httdocs\database-create.php on line 16
PS C:\xampp\w3schoolsPhp\httdocs> php database-create.php
<br> --- CREATE DB --- <br>PHP Fatal error:  Uncaught Error: Class "mysqli" not found in C:\xampp\w3schoolsPhp\httdocs\database-create.php:16
Stack trace:
#0 {main}
  thrown in C:\xampp\w3schoolsPhp\httdocs\database-create.php on line 16

php.ini

/configure --with-mysqli=/path/to/mysql_config
    
extension=bz2
extension=curl
;extension=ffi
;extension=ftp
extension=fileinfo
;extension=gd
extension=gettext
;extension=gmp
;extension=intl
;extension=imap
;extension=ldap
extension=mbstring
extension=exif      ; Must be after mbstring as it depends on it
extension=mysqli
;extension=oci8_12c  ; Use with Oracle Database 12c Instant Client
;extension=oci8_19  ; Use with Oracle Database 19 Instant Client
;extension=odbc
;extension=openssl
;extension=pdo_firebird
extension=pdo_mysql
;extension=pdo_oci
;extension=pdo_odbc
;extension=pdo_pgsql
extension=pdo_sqlite
;extension=pgsql
;extension=shmop
extension=php_mysql.dll