php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #30673 a mysql and other databases request
Submitted: 2004-11-03 16:04 UTC Modified: 2004-11-03 18:57 UTC
From: mazdak1 at telia dot com Assigned:
Status: Wont fix Package: Feature/Change Request
PHP Version: Irrelevant OS: irrelevant winxp pro sp1
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: mazdak1 at telia dot com
New email:
PHP Version: OS:

 

 [2004-11-03 16:04 UTC] mazdak1 at telia dot com
Description:
------------
my name is mazdak.farrokhzad
i would like to request a mysql feature that would be mysql_db_size(),mysql_table_size(),mysql_column_size()
and mysql_row_size
what it would do is that it would get the lenght of a db,table,column and row
this would make the amounts of queries less
and this could be implemented for other databases too
if this is for plugin makers could you tell the please

Reproduce code:
---------------
here i am showing an example
mysql_connect('...','...','...');
mysql_select_db('...'); --> beacause db is selected you should not need to use the db parameters for table,column,row,size
let all functions accept float
and let them return true/false
echo mysql_db_size(mixed_var)/1024.'kb';
echo mysql_table_size(mixed_var)/1024.'kb';
echo mysql_column_size(mixed_var)/1024.'kb';
echo mysql_row_size(mixed_var)/1024.'kb';

Expected result:
----------------
depends on what you have in your code above
like
4kb
1.03715kb
0.005kb
0.000072436kb

Actual result:
--------------
look above

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-11-03 18:57 UTC] georg@php.net
Not every database supports retrieval of these values. And 
those which supports it, provide SQL commands for. 
 
We will not add new functions which are simple wrappers 
for SQL commands. You can do that in your code. 
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 27 12:01:29 2024 UTC