php code to test pdo is available?

by

PDO is always installed for php 5.1+. You can check for specific db drivers that are installed or not using phpinfo(); You could try to check for specific drivers using @Mark Baker idea and checking for specific constants;

var_dump(defined(PDO::MYSQL_ATTR_LOCAL_INFILE)); // mysql
var_dump(PDO::FB_ATTR_TIME_FORMAT)); // firebird

Note that not all drivers have specific constants defined so phpinfo() remains best solution.

Using command line you can check using:

$ php -m

As an alternative of phpinfo() you can use:

extension_loaded ('PDO' ); // returns boolean
// or
extension_loaded('pdo_mysql');
// or get all extensions and search for a specific one
get_loaded_extensions();

More Related Contents:

  1. PHP PDO: charset, set names?
  2. How can I use PDO to fetch a results array in PHP?
  3. PHP PDOException: “SQLSTATE[HY093]: Invalid parameter number”
  4. What is the difference between MySQL, MySQLi and PDO? [closed]
  5. MySQL check if a table exists without throwing an exception
  6. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  7. PHP PDO – Num Rows
  8. How to solve General error: 2006 MySQL server has gone away
  9. PDO + MySQL and broken UTF-8 encoding
  10. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  11. MySQL retrieve variable from Stored Procedure in PHP PDO
  12. Calling stored procedure with Out parameter using PDO
  13. When *not* to use prepared statements?
  14. How to insert an array into a single MySQL Prepared statement w/ PHP and PDO
  15. Setting a connect timeout with PDO
  16. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  17. What is the best way to insert multiple rows in PHP PDO MYSQL?
  18. PDO MySQL: Insert multiple rows in one query
  19. How to bind LIKE values using the PDO extension?
  20. Error while using PDO prepared statements and LIMIT in query [duplicate]
  21. PDO prepared statement fetch() returning double results
  22. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  23. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  24. PHP 7 RC3: How to install missing MySQL PDO
  25. How to escape single-quote (apostrophe) in string using php
  26. PHP Laravel: No connection could be made because the target machine actively refused it
  27. PDO bindParam into one statement?
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment