Codeigniter MySQL Connection

Question

As per my knowledge, if I connect MySQL, I have to close the connection immediately after executing the script otherwise it will stay opened.

My question is does codeigniter close the MySQL connection each time after executing the script? If not, how do I perform it ?

make sure persistent connection is set to false in config file $db['default']['pconnect'] = FALSE;. Default value is true. — Kamran
– Kamran, Commented Jun 1, 2016 at 8:43

Rejoanul Alam · Accepted Answer · 2016-06-01 06:25:04Z

1

But if you want to close explicitly you can

$this->db->close();

answered Jun 1, 2016 at 6:25

Rejoanul Alam

5,4004 gold badges42 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stack Programmer · Accepted Answer · 2018-11-12 20:36:55Z

1

Codeigniter closes its database connection. But to manually do that within your class you can use the following

$this->db->close();

Stack Programmer

6796 silver badges18 bronze badges

answered Jun 1, 2016 at 6:24

lightup

6748 silver badges19 bronze badges

lesquishy · Accepted Answer · 2016-06-01 06:06:57Z

0

It should do yes. But its good practice to close it any way.

$connect->close();

$connect being:

$connect = new mysqli($servername, $username, $password, $dbname);

answered Jun 1, 2016 at 6:06

lesquishy

1371 gold badge1 silver badge6 bronze badges