dropninitial.php - Site Bot

File:

dropninitial.php

Role:

Application script

Content type:

text/plain

Description:

schema init-wrapper

Class:

Site Bot
Recursive-automic site buider: static OR dynamic

Contents

Download


<?php



include "page_config.inc";

include('database.php');

include('utils.php');



global $sys_stylesheet;

echo "<html><head><link rel=stylesheet href=\"" . $sys_stylesheet . "\" type=text/css></head><body class=disp>";

$sql_dir="Sql";

$dconn = dbr_connect();





$d = dir($sql_dir);

$tablecnt=0;

$table_files=Array();

while($entry=$d->read())

{

   if($entry && ($entry != "." && $entry != ".."))

   {

      $table_files[] = $sql_dir."/".$entry;

      $tablecnt++;

   }

}

$d->close();



tdbg("tablecnt == $tablecnt");



for($i=0; $i<$tablecnt; $i++)

{

   $table = $table_files[$i];

   $table = ereg_replace("\..*$","",basename($table));

   $sql = "drop table $table";

   tdbg("$sql","green");

   $ret=dbr_query($sql);

}



tdbg(" ");



reset($table_files);

for($i=0; $i<$tablecnt; $i++)

{

   $file = $table_files[$i];

        $tmp = basename($file);

        $base = ereg_replace("\.sql","", $tmp); 

 

   tdbg("create table $base","purple");

   $fcontents = file($file);

   $sql="";

   while (list ($line_num, $line) = each ($fcontents))

   {

      $sql .= htmlspecialchars ($line). " ";

   }

   dbr_query($sql);

}

echo "</body></html>";



?>

For more information send a message to :
info at phpclasses dot org.

Copyright (c) Icontem 1999-2009	PHP Classes	- PHP Class Scripts
	PHP Book Reviews	- Reviews of books and other products

	Classes of Colin Sandy Pittendrigh	>	Site Bot	>	dropninitial.php

File: dropninitial.php

Contents