(PHP should auto close connections when page is exited since about version 5.6 but it doesn't always happen.)Īnd always close the connection as soon as possible (when all access to the database has completed). Or you will possibly end up with many open connections that are no longer in use but will count in currently open connections. mysqli_error($con)) Įither in an include file or on the individual page, make sure you always close the connection at every possible exit point of the script (so in error traps and end of page load) $con = mysqli_connect($dblocation,$dbusername,$dbpassword,$db) or die('Error in connect string: '. Which leads me to another Tip, when writing your PHP code and you have an open connection e.g.: However, if you have many or one that is accessed by many pages/apps you have to be aware of the connection limit the host has set for the MySQL, as if you have too many connections at one time users will get error messages like 'Cannot connect to database - Too many connections!'Īlso bear in mind your host may set a limit on the number of databases you are allowed or the maximum size of all databases. On one I have over 200 databases, as I create them for testing and forget to delete them WebPlus X6 makes it easy for you to create your own website, even if youve never made one before. I don't have a problem with many MySQL databases on one hosting account. Assume each one providing data for a micro application in its own unique folder? Hey Hi Steve, is there some issue with many MySql data bases on a domain? from a hosting perspective (assuming you have 25 db's to use).

Serif webplus x6 download full