HigKecedege
New Member
Currently, I'm opening a database connection in my app's initialization. It's a fairly small app, PHP if that's relevant.Should I be connecting to the database, making calls, then closing and repeating this process for each database function I write?For example, I have the following function which grabs the $db variable from my app's initialization.\[code\]function get_all_sections(){ global $db; $sql = 'select * from sections'; if (!$db->executeSQL($sql, $result)) { throw new Exception($db->getDatabaseError()); exit(); } $sections = array(); for ($i = 0; $i < $db->numberOfRows($result); $i++) { $sections[] = new Section($db->fetchArray($result, MYSQLI_ASSOC)); } return $sections;}\[/code\]Would it be better if I opened the connection then closed it after I fetched the rows? That seems like a lot of connections that are opened and closed.