Does anyone know if there is a way to get the size/usage of a SQL database in PHP? I have a custom site that connects to 3 databases and I was working on a control panel page to show the usage and max capacity of each database but I have been unable to find out how to do this.
Google has shown a few SQL specific ways of getting database size, such as sp_databases, but nothing that works directly with PHP.
My web server is hosted and I do not have direct access to the SQL databases, other than through phpmyadmin. That application shows the usage and capacity of each DB, so surely there is a way I can pull that information for my own app as well?
Question
Nimec
Does anyone know if there is a way to get the size/usage of a SQL database in PHP? I have a custom site that connects to 3 databases and I was working on a control panel page to show the usage and max capacity of each database but I have been unable to find out how to do this.
Google has shown a few SQL specific ways of getting database size, such as sp_databases, but nothing that works directly with PHP.
My web server is hosted and I do not have direct access to the SQL databases, other than through phpmyadmin. That application shows the usage and capacity of each DB, so surely there is a way I can pull that information for my own app as well?
Any help is greatly appreciated.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts