Mega Code Archive
TAB_STRUCT Class Is supporting Class for the DBXML Class
<![CDATA[
<?
/*
This is the supporting class that retrieves the tables views and creates the backup of the views .
This is an extension of the DBXML Class .
U will need this class to work with DBXML properly.
Any bugs or class design issuez in this class please mail "TAB_STRUCT : Bug Mail " in the subject line.
Any bugs or class design issuez in DBXML please mail "DBXML : Bug Mail " in the subject line.
if anybody have any job oppz for PHP or want support please feel free to contact me.It wuld b of great help.
NOTE: Be careful about the " '.A single change will cause problem in viewing the XML file.
The next class is coming for generation DTDs customised ones!!!
Thank you for the support
*/
class TAB_STRUCT
{
function xml_tbl_create($tbl)
{
$creat="";
$sql = "SHOW CREATE TABLE ".$tbl."";
$res = mysql_query($sql) or die(mysql_error());
$creat="<create_table value=\"".$tbl."\">";
while ($row = mysql_fetch_assoc($res))
{
$creat=$creat.$row["Create Table"]."</create_table>";
}
return $creat;
}
function tbl_struct_xml($db,$tbl,$fnme)
{
$tt="";
mysql_select_db($db) or die("Could not select database");
$fnme=$fnme.$tbl."_STRUCT.xml";
$sql = "DESC ".$db.".".$tbl."";
$res = mysql_query($sql) or die(mysql_error());
$ft=fopen($fnme,"w");
$tt="<?xml version=\"1.0\"?".">"."<xml><".$db."><".$tbl."_struct>".TAB_STRUCT::xml_tbl_create($tbl).TAB_STRUCT::gen_insert($db,$tbl);
while ($row = mysql_fetch_assoc($res))
{
$tt=$tt."<field_start><name>".$row["Field"]."</name><type>".$row["Type"]."</type><is_null>".$row["Null"]."</is_null><is_key>".$row["Key"]."</is_key><default_value>".$row["Default"]."</default_value></field_start>";
}
$tt=$tt."</".$tbl."_struct></".$db."></xml>";
$bw=fwrite($ft,$tt);
$d=fclose($ft);
Return $d;
}
function show_db_status($db)
{
$stat="";
$fnme="C:\\".$db."_status.xml";
$sql="SHOW TABLE STATUS";
mysql_select_db($db) or die("Could not select database");
$t_stat= mysql_query($sql) or die(mysql_error());
$ft=fopen($fnme,"w");
$stat="<?xml version=\"1.0\"?".">"."<xml><".$db.">";
while ($row = mysql_fetch_assoc($t_stat))
{
$stat=$stat."<table><name>".$row"Name"]."</name><records>".$row["Rows"]."</records><row_format>".$row["Row_format"]."</row_format><type>".$row["Type"]."</type></table>";
}
$stat=$stat."</".$db."></xml>";
$bw=fwrite($ft,$stat);
$d=fclose($ft);
Return $d;
}
function gen_insert($db,$tbl)
{
$fd = mysql_list_fields($db,$tbl);
$col = mysql_num_fields($fd);
$ins="<insert_prototype value=\"".$tbl."\">INSERT INTO ".$tbl." ( ";
$ins=$ins.mysql_field_name($fd,0);
for ($i = 1; $i < $col; $i++)
{
$ins=$ins." , ".mysql_field_name($fd, $i);
}
$ins=$ins.") VALUES(";
for ($i = 0; $i < $col; $i++)
{
$k=mysql_field_type($fd,$i);
switch($k)
{
case "int" : $ins=$ins." , ";
break;
case "real" : $ins=$ins."0.00, ";
break;
case "float" : $ins=$ins." 0.0, ";
break;
case "varchar(100)" : $ins=$ins."\'vchr100\',";
break;
case "varchar(50)" : $ins=$ins."\'vchr50\' ,";
break;
case "char" : $ins=$ins.",";
break;
case "blob" : $ins=$ins."'blob',";
break;
case "string" : $ins=$ins."'',";
break;
default : $ins=$ins.",";
break;
}
}
$ins=$ins.")</insert_prototype>";
return $ins;
}
}
?>
]]>