pdo Archives - IT Nursery

PHP, Programming

IT Nursery

What are the disadvantages of using persistent connection in PDO

In PDO, a connection can be made persistent using the PDO::ATTR_PERSISTENT attribute. According to the php manual – Persistent connections are not closed ...

June 4, 2022
0 Comments

PHP, Programming

IT Nursery

PHP PDO: charset, set names?

I had this previously in my normal mysql_* connection: mysql_set_charset("utf8",$link); mysql_query("SET NAMES 'UTF8'"); Do I need it for the PDO? And where should ...

May 30, 2022
0 Comments

PHP, Programming

IT Nursery

Row count with PDO

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

May 28, 2022
0 Comments

Can PHP PDO Statements accept the table or column name as parameter?

Why can’t I pass the table name to a prepared PDO statement? $stmt = $dbh->prepare('SELECT * FROM :table WHERE 1'); if ($stmt->execute(array(':table' => ...

May 21, 2022
0 Comments

Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

Migration error on Laravel 5.4 with php artisan make:auth [Illuminate\Database\QueryException] SQLSTATE...

May 19, 2022
0 Comments

mysqli or PDO – what are the pros and cons? [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

May 12, 2022
0 Comments

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 driver. This is ...

May 11, 2022
0 Comments

What is the difference between bindParam and bindValue?

What is the difference between PDOStatement::bindParam() and PDOStatement::bindValue()? 7 Answers 7

May 8, 2022
0 Comments

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 to run some ...

May 8, 2022
0 Comments

Can I bind an array to an IN() condition in a PDO query?

I’m curious to know if it’s possible to bind an array of values to a placeholder using PDO. The use case here is ...

April 29, 2022
0 Comments