How did vbulletin close the database

[hurricane_sh]

I can't see any db close statement in php files like showthread.php. I wrote my own php file which uses the $db object, does it look right? Thanks!


require_once('./global.php');

$result = $db->query_first("select .....");
.....
$db->free_result($result);
$db->close();

[nhawk]

Closing the database with the close like you have it isn't needed unless it's a persistent connection. A regular database connection is automatically closed at the end of execution of the script.

[hurricane_sh]

Many thanks for your reply!

[kh99]

$db->close() is called in most vb scripts - it's in function exec_shut_down() which is called from print_output(), which is the last function called in most scripts. (You can see it in the eval() at the end of showthread.php).

[hurricane_sh]

Thanks for the detailed explanation, Kevin!