Home >Backend Development >PHP Tutorial >php uses pdo's like query statement and reports an error indirectly. MySQL server has gone away.
As shown in the picture, it is an encapsulated PDO operation, sending sql and retrieving data!
Picture description
A sql statement uses bindColumn() of pdo to implement a like query
Option parameters
Error conditions
Indirect error, luckily it can run normally, the connection is mysql installed by myself on Alibaba Cloud, my personal blog runs normally, but I don’t know why the pdo query I wrote reported an error
I have searched many times on the Internet
1. It cannot be that timeout has been set
2.max_allowed_packet is also set to 32M
As shown in the picture, it is an encapsulated PDO operation, sending sql and retrieving data!
Picture description
A sql statement uses bindColumn() of pdo to implement a like query
Option parameters
Error conditions
Indirect error, luckily it can run normally, the connection is mysql installed by myself on Alibaba Cloud, my personal blog runs normally, but I don’t know why the pdo query I wrote reported an error
I have searched many times on the Internet
1. It cannot be that timeout has been set
2.max_allowed_packet is also set to 32M
You can check the slow check log, and then analyze the slow check log