git-svn-id: svn://presbrey.mit.edu/sql/mitsql@40 a142d4bd-2cfb-0310-9673-cb33a7e74f58

[sql-web.git] / lib / dbaccess.lib.php

<?php

require_once('joe.lib.php');

function DBMaster($sql) {
	sessTime($sql);
	$res = mysql_query($sql);
	if (mysql_error()) die($sql."<br />\n".mysql_error());
	sessTime();
	return $res;
}
function DBSlave($sql) {
	sessTime($sql);
	$res = mysql_query($sql);
	sessTime();
	return $res;
}

function DBSelect($sql) { return DBSlave($sql); }
function DBInsert($sql) { DBMaster($sql); return mysql_insert_id(); }
function DBUpdate($sql) { DBMaster($sql); }
function DBDelete($sql) { DBMaster($sql); }
function DBGrant($sql) { DBMaster($sql); }
function DBRevoke($sql) { DBMaster($sql); }
function DBSet($sql) { DBMaster($sql); }
function DBShow($sql) { return DBSlave($sql); }

function calcDBSize($tdb) {
   $sql_result = "SHOW TABLE STATUS FROM `" .mysql_escape_string($tdb)."`";
//   $result = @mysql_db_query($tdb,$sql_result);
   $result = DBShow($sql_result);

   if($result) {
       $size = 0;
       while ($data = mysql_fetch_array($result)) {
             $size += $data["Data_length"] + $data["Index_length"];
       }
       mysql_free_result($result);
       return $size;
   }
   else {
       return null;
   }
}

?>