Top "Pdo" questions

PDOException “could not find driver”

I have just installed Debian Lenny with Apache, MySQL, and PHP and I am receiving a PDOException could not find …

php mysql pdo lamp

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO

I've looked through all the other StackOverflow (and google) posts with the same problem, but none seemed to address my …

php sql mysql pdo mysql-error-1064

PDOException SQLSTATE[HY000] [2002] No such file or directory

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH …

php mysql laravel pdo

Row count with PDO

There are many conflicting statements around. What is the best way to get the row count using PDO in PHP? …

php mysql pdo

Installing PDO driver on MySQL Linux server

I was suggested, not long ago, to change my code to use PDO in order to parameterize my queries and …

php mysql pdo phpmyadmin installation

PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused

I am trying to use a PHP connection to connect MySQL Database which is on phpmyadmin. Nothing fancy about the …

php mysql pdo

PHP PDO: charset, set names?

I had this previously in my normal mysql_* connection: mysql_set_charset("utf8",$link); mysql_query("SET NAMES 'UTF8'"); …

php mysql pdo

PHP 7 RC3: How to install missing MySQL PDO

I am trying to setup webserver with PHP 7 RC3 + Nginx on Ubuntu 14.04 (for test purposes). I installed Ubuntu in Vagrant …

php mysql ubuntu pdo php-7

PHP PDO returning single row

UPDATE 2: So is this the most optimized it can get? $DBH = new PDO( "connection string goes here" ); $STH = $DBH -&…

php pdo

PDO get the last ID inserted

I have a query, and I want to get the last ID inserted. The field ID is the primary key …

php mysql database pdo