Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > PHP Forum
Reload this Page Size of Table
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Unregistered, Check out the Coder Battles in the Announcement and Game forums.

PHP Forum Use this forum to discuss all aspects of PHP Development. PHP is a server-side, cross-platform, HTML embedded scripting language that lets you create dynamic web pages.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-18-2006, 08:03 AM
dirkfirst dirkfirst is offline
Programming Professional
  
Join Date: May 2006
Posts: 338
Credits: 0
Rep Power: 11
dirkfirst is on a distinguished road
Default Size of Table
how can i get a size of a table in bytes , anyone knows ??
__________________
DirkFirst
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 05-20-2006, 07:33 AM
Crane's Avatar   
Crane Crane is offline
Programming Expert
  
Join Date: Nov 2005
Posts: 399
Credits: 1
Rep Power: 13
Crane is on a distinguished road
Default Database size using MySQL and PHP
Code:
$sql = "SHOW TABLE STATUS";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
{
            $total = $row['Data_length']+$row['Index_length'];
}
echo($total);
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 08-06-2006, 12:44 PM
Lop's Avatar   
Lop Lop is offline
Speaks fluent binary
  
Join Date: May 2006
Posts: 1,148
Credits: 112
Rep Power: 16
Lop will become famous soon enough
Default
Should work perfect. Did you get this working?
__________________
Lop
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC API - Special Table and Column Names Tronman Database & Database Programming 0 07-30-2007 12:52 PM
Othello program!! 24 hours left! siren C and C++ 1 06-14-2007 11:18 AM
Flex, bison multifunction calculator annatsos C and C++ 1 01-04-2007 06:00 AM
Directory Size John PHP Forum 5 08-06-2006 01:02 PM
Working with TADO Table MrDiaz Pascal/Delphi 0 07-03-2006 06:28 PM


All times are GMT -5. The time now is 04:38 AM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

Xav ........ 1024.41
MeTh0Dz|Reb0rn ........ 974.08
morefood2001 ........ 850.04
John ........ 841.93
WingedPanther ........ 661.52
marwex89 ........ 575.59
Brandon W ........ 456.18
chili5 ........ 292.12
orjan ........ 187.41
Steve.L ........ 181.88

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 79%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads