₦airaland Forum

Hello house,

I am trying to run this on XAMPP's MySQl server:

try {
      $con = new PDO("MYSQL:host=locahost;dbname=db_name", "username", "password";
      $con->setAttributes(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
      $query = <<<HERE
SELECT
  CONCAT(surname, ' ', firstname) AS 'name',
  country
FROM tbl_customerdetails WHERE surname LIKE ? AND firstname LIKE ?;
HERE;
      $stmt = $con->prepare($query);
      $stmt->execute(array('J%', '%a%'));
      $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
      print "<pre>";
      print_r($result);
      print "</pre>";
 } catch (Exception $e) {
    print "ERROR: " . $e->getMessage();
 }

I get this error: driver could not be found..

I suppose the driver is supposed to come bundled with the XAMPP app itself.
App's version info: Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/7.1.1

I didn't get this error when I was running the the App version with PHP 5. Can someone help me out with this?!

paranorman:
Hello house,

I am trying to run this on XAMPP's MySQl server:

try {
      $con = new PDO("MYSQL:host=locahost;dbname=db_name", "username", "password";
      $con->setAttributes(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
      $query = <<<HERE
SELECT
  CONCAT(surname, ' ', firstname) AS 'name',
  country
FROM tbl_customerdetails WHERE surname LIKE ? AND firstname LIKE ?;
HERE;
      $stmt = $con->prepare($query);
      $stmt->execute(array('J%', '%a%'));
      $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
      print "<pre>";
      print_r($result);
      print "</pre>";
 } catch (Exception $e) {
    print "ERROR: " . $e->getMessage();
 }

I get this error: driver could not be found..

I suppose the driver is supposed to come bundled with the XAMPP app itself.
App's version info: Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/7.1.1

I didn't get this error when I was running the the App version with PHP 5. Can someone help me out with this?!

Try searching d error code on Google

Eno38151:
Try searching d error code on Google

Did that, still confused.
check out this link: http://php.net/manual/en/pdo.installation.php

What I think is that the server cannot locate/find the PDO driver in the folder specified in the php.ini config file. I checked the folder, driver was there. I check for the folder specified in the directive, it was correct. still confused but I am going to keep looking.

Thanks anyway.

paranorman:
Did that, still confused.
check out this link: http://php.net/manual/en/pdo.installation.php

What I think is that the server cannot locate/find the PDO driver in the folder specified in the php.ini config file. I checked the folder, driver was there. I check for the folder specified in the directive, it was correct. still confused but I am going to keep looking.

Thanks anyway.

Can you specify the exact error code and the printout message 4 d error​.

R u using Windows nd what version??
Do you have any database application on the system?

paranorman:
Did that, still confused.
check out this link: http://php.net/manual/en/pdo.installation.php

What I think is that the server cannot locate/find the PDO driver in the folder specified in the php.ini config file. I checked the folder, driver was there. I check for the folder specified in the directive, it was correct. still confused but I am going to keep looking.

Thanks anyway.

What OS do you use? On Ubuntu, I had the same issue with my php/laravel. You know what? If ubuntu, just use: sudo apt-get install then the driver name (from the stack trace on your command line)

Eno38151:
Can you specify the exact error code and the printout message 4 d error​.

R u using Windows nd what version??
Do you have any database application on the system?

windows 10 pro.
I have db app; Oracle's MySql workbench I don't use much since PHPMyAdmin comes in quite handy for dev purposes. No biggy, still learning. Hope you get my drift.

Dekatron:
What OS do you use? On Ubuntu, I had the same issue with my php/laravel. You know what? If ubuntu, just use: sudo apt-get install then the driver name (from the stack trace on your command line)

Nope bro, windows 10 pro.