Undefined class constant MYSQL ATTR INIT COMMAND with pdo

Question

db   new PDO  mysql dbname xnews host localhost port      LOCAL DB PORT              LOCAL DB USER              LOCAL DB PASS             array PDO  MYSQL ATTR INIT COMMAND   gt    SET NAMES  UTF8               reports      Undefined class constant    MYSQL ATTR INIT COMMAND     Is it renamed

User · Answer

I just tried with PHP 5 2  and that constant seems to exists    var dump PDO  MYSQL ATTR INIT COMMAND     Gives me    int 1002    But it seems there is a bug in PHP 5 3  that causes this constant to not exists anymore -- or  at least  not when the mysqlnd driver is used  and it s the one that s configured by default   I suppose a temporary solution  as suggested on this bug report  could be to directly use the integer 1002 value  instead of the contant     But note that you should go back to using the constant as soon as possible -- as this makes the code easier to understand

User · Answer

I just had the same error  with PHP 5 2 6   and all I had to do is enable the MySQL-specific PDO driver  TL DR In your php ini file  you should have the following line  uncommented    extension php pdo mysql dll on Windows extension php pdo mysql so on Linux Mac   Longer explanation   open php ini in a text editor  e g  its default path on Windows  C  Program Files  x86  PHP v5 X php ini  substitute v5 x with the version you installed  or C  Windows php ini  etc  or on Linux   etc php5 apache2 php ini  e g  this is the path on Ubuntu  or  etc php5 cli php ini   etc php5 cgi php ini  etc  or you can get to know where it is like this   php --ini   find  i  quot Loaded quot  in Windows command prompt OR php --ini   grep  quot Loaded quot  in Linux Mac terminal using phpinfo    and looking for the line  quot Loaded Configuration File quot      and remove the semicolon from the beginning of the following line  to uncomment it     extension php pdo mysql dll on Windows  OR  extension php pdo mysql so on Linux Mac   of course  if this line doesn t exist  you should paste it so as a result the expected line would look like this in php ini   extension php pdo mysql dll on Windows OR extension php pdo mysql so on Linux Mac     You may need to restart your web server    That solved my problem

User · Answer

Using the int value 1002 seems to work for PHP 5 3 0   public static function createDB          dbHost  localhost        dbName  project        dbUser  admin        dbPassword  whatever        dbOptions array 1002   gt   SET NAMES utf8         return new DB  dbHost   dbName   dbUser   dbPassword  dbOptions      function createConnexion         return new PDO           mysql host  this- gt dbHost dbname  this- gt dbName            this- gt dbUser           this- gt dbPassword           this- gt dbOptions

User · Answer

I got the same error  on debian6  when I had not yet installed php5-mysql   So I installed it  then restarted apache2  apt-get install php5-mysql  etc init d apache2 restart   Then the error went away   If you have the same error on Ubuntu  instead of      etc init d apache2 restart     Type     service apache2 restart

User · Answer

For anyone coming along later  like I did  and seeing this    I was receiving the same error because I did not have the extension  quot enabled quot  in my php ini file  I would imagine you might also get this error if you have recently upgraded your php version and did not properly update your php ini file  If you are receiving this error shortly after upgrading your php version  the info below might help you out  PHP 7 4 slightly changed its syntax in the php ini file  Now  to enable the mysql pdo  make sure extension pdo mysql is uncommented in your php ini file   line 931 in the default php ini setup  The line used to be   extension php pdo mysql dll on Windows extension php pdo mysql so on Linux Mac  as Sk8erPeter pointed out  but the  dll and  so endings are to be deprecated and so it is best practice to begin getting rid of those endings and using just extension  lt ext gt  The below is pulled from the default php ini-production file from the php 7 4 zip download under  quot Dynamic Extensions quot    Note   The syntax used in previous PHP versions   extension  so  and  extension  php  dll   is supported for legacy reasons and may be deprecated in a future PHP major version  So  when it is possible  please move to the new  extension  lt ext gt   syntax

User · Answer

You could try replacing it with 1002 or issuing your initialization query right after opening a connection

User · Answer

It appears to only be availabe using the mysqlnd driver  Try replacing it with the integer it represents  1002  if I am not mistaken

User · Answer

I got this error this morning  I just did a fresh install of Fedora 14 and was trying to get my local projects back online    I was missing php-mysql  I installed it via yum and the error is now gone

User · Answer

For Centos I was missing php-mysql library   yum install php-mysql  service httpd restart   There is no need to enable any extension in php ini  it is loaded by default

User · Answer

This is due to a PHP 5 3 0 bug on Windows where MYSQL ATTR INIT COMMAND is not available  The PHP bug report is   http   bugs php net bug php id 47224  If you are experiencing this  please update your WAMP product to a version that uses PHP 5 3 1 or later version

User · Answer

For me it was missing MySQL PDO  I recompiled my PHP with the --with-pdo-mysql option  installed it and restarted apache and it was all working

[php] Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' with pdo

Examples related to php

Examples related to pdo