$query = $this->query("SELECT table_name as name, (auto_increment - 1) as records, index_length as indexsize, table_comment as cmt, ( data_length + index_length ) as size FROM information_schema.tables WHERE table_schema = ? AND table_name LIKE ? ORDER BY table_name", array($this->conn->db, '%'.$tablePrefix.'%'));
(I might change the number of records bit, not sure yet)
I've been trying to work out how I can duplicate this to work on SQL Server and PostgreSQL databases as well, but I have very little experience with them.
Could anyone point me in the right direction for this?
This post has been edited by Duckington: 24 April 2014 - 01:32 AM