DB reconnect failed |
I'm writing a data monitor script work with CLI this week,
Code: $this->load->database(); OK, it's looks like the re-connect was failed. Why does this error occur? How to deal with it?
Resolved;
Code: $this->db->reconnect();
In the mysqli driver, reconnect() uses mysqli::ping(), which will attempt to reconnect to the server if the mysqli.reconnect option is enabled on the server. In any case, after calling $this->db->reconnect(), you should check whether $this->db->conn_id is false before attempting to use the connection. If it is false, you could attempt to close/initialize as you did, but you should check the return value of initialize() before attempting to use the connection (as it will return false if it fails to connect/initialize).
|
Welcome Guest, Not a member yet? Register Sign In |