Top "Pdo" questions

How to apply bindValue method in LIMIT clause?

Here is a snapshot of my code: $fetchPictures = $PDO->prepare("SELECT * FROM pictures WHERE album = :albumId ORDER BY id …

php mysql sql pdo bindvalue

PDO PHP Fetch Class

I am learning pdo in php , so as to make database access easier and more efficient .One explanation i have …

php pdo

PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?

This is what I've read so far about PDO::ATTR_EMULATE_PREPARES: PDO's prepare emulation is better for performance since …

php mysql pdo

get number of rows with pdo

I have a simple pdo prepared query: $result = $db->prepare("select id, course from coursescompleted where person=:p"); $result …

mysql pdo rows

PDO binding values for MySQL IN statement

I have an issue with PDO that I'd really like to get an answer for after being plagued by it …

php mysql pdo sql-in

How do I set ORDER BY params using prepared PDO statement?

I'm having problems using params in the ORDER BY section of my SQL. It doesn't issue any warnings, but prints …

php mysql pdo

How do I select a MySQL database to use with PDO in PHP?

I want to select a MySQL database to use after a PHP PDO object has already been created. How do …

php mysql pdo

PDO were rows affected during execute statement

I have found many ways to use the exec statement for PDO, but I'm not sure it helps me. My …

php mysql pdo prepared-statement

'PDOException' with message 'SQLSTATE[HY000] [2002] zend framework

Any one plz tell me why i am getting this error ?? firstly my internet connection was good today its not …

mysql zend-framework pdo zend-db

Get query back from PDO prepared statement

Is there a way to retrieve the query that was used to generate a PDO Prepared statement object?

php mysql pdo