pdo Archives - 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 … Read more

PHP PDO: charset, set names?

by IT Nursery

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 … Read more

Row count with PDO

by IT Nursery

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

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

by IT Nursery

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’ => … Read more

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

by IT Nursery

Migration error on Laravel 5.4 with php artisan make:auth [Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max … Read more