Gecko [ www.jdcpatala.org ]

Name	Size	Permission
SpryAssets	[ DIR ]	drwxr-xr-x
ckeditor	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
upload	[ DIR ]	drwxr-xr-x
Logout.php	84 B	-rw-r--r--
Session_Update.php	2.58 KB	-rw-r--r--
User_Account.php	12.6 KB	-rw-r--r--
User_Profile.php	8.57 KB	-rw-r--r--
User_Profile_permmion.php	14.71 KB	-rw-r--r--
admin_home.php	2 KB	-rw-r--r--
admin_home_old.php	10.92 KB	-rw-r--r--
attand.php	9.14 KB	-rw-r--r--
college_profile.php	8.56 KB	-rw-r--r--
college_profile_edit.php	7.15 KB	-rw-r--r--
committee_member.php	9.53 KB	-rw-r--r--
committee_member_edit.php	7.74 KB	-rw-r--r--
committee_name.php	7.26 KB	-rw-r--r--
connection.php	177 B	-rw-r--r--
courses.php	8.14 KB	-rw-r--r--
courses_edit.php	6.64 KB	-rw-r--r--
databasebackup.php	3.58 KB	-rw-r--r--
databaserestore.php	2.65 KB	-rw-r--r--
error_log	1.36 KB	-rw-r--r--
foragte_password.php	307 B	-rw-r--r--
gallery.php	8.79 KB	-rw-r--r--
gallery_edit.php	6.94 KB	-rw-r--r--
index.php	2.4 KB	-rw-r--r--
login_2.php	18.94 KB	-rw-r--r--
new_notice.php	9.16 KB	-rw-r--r--
non_teaching.php	10.16 KB	-rw-r--r--
non_teaching_edit.php	8.21 KB	-rw-r--r--
principal_message.php	8.96 KB	-rw-r--r--
principal_message_edit.php	7.35 KB	-rw-r--r--
splash_view.php	7.33 KB	-rw-r--r--
teaching.php	10.14 KB	-rw-r--r--
teaching_edit.php	8.2 KB	-rw-r--r--
teching_edit.php	8.17 KB	-rw-r--r--
tender.php	8.69 KB	-rw-r--r--
update_and_delete.php	4.1 KB	-rw-r--r--
update_attand.php	6.89 KB	-rw-r--r--
update_notice.php	6.9 KB	-rw-r--r--
user_details.php	9.24 KB	-rw-r--r--
user_reg.php	4.26 KB	-rw-r--r--
validateuser.php	685 B	-rw-r--r--
view_notice.php	1.14 KB	-rw-r--r--
welcome.php	821 B	-rw-r--r--

Code Editor : databaserestore.php

<?php // mysql_backup_restore.php
error_reporting(E_ALL);
 
// require_once("includes/function.inc.php");
//validateUser();
// PATTERN OF THE NAME OF THE BACKUP FILES
// 'backups/mysql' . date('Ymd\THis') . $db_name . '.txt';
 
 
// IMPORTANT PAGES FROM THE MANUALS
// MAN PAGE: http://us2.php.net/manual/en/ref.mysql.php
// MAN PAGE: http://us2.php.net/manual/en/mysql.installation.php
 
 
// CONNECTION AND SELECTION VARIABLES FOR THE DATABASE
$db_host = "localhost"; // PROBABLY 'localhost' IS OK
$db_user = "root";
$db_word = "";
 
 
// FIND THE BACKUP FILES
if (!$my_dir = scandir('backups',1)) die('NO BACKUP DIRECTORY FOUND');
 
// IF NOTHING POSTED YET
if (empty($_POST))
{
 
// ASK CLIENT TO CHOOSE ONE FOR RESTORE
    $x = FALSE;
    echo "<form method=\"post\">\n";
	echo "RESTORE A DATA BASE:<br/>";
    foreach ($my_dir as $my_file)
    {
        if (!preg_match('/^mysql/', $my_file)) continue;
        echo "<input type=\"radio\" name=\"d\" value=\"$my_file\">$my_file <br/>\n";
        $x = TRUE;
    }
    if (!$x) die('NO BACKUP FILES FOUND');
    echo "<input type=\"submit\" />\n";
    echo "</form>\n";
    die();
}
 
 
// THERE IS A RADIO BUTTON IN $_POST
if (!in_array($_POST["d"], $my_dir)) die("ERROR: FILE {$_POST["d"]} NOT FOUND");
 
// THE NAME OF THE BACKUP FILE
$fname = $_POST["d"];
 
// GET THE NAME OF THE DB FROM THE BACKUP FILE NAME
$db_name = $fname;
$db_name = preg_replace("/^mysql/", '', $db_name);
$db_name = preg_replace("/\.txt$/",         '', $db_name);
$db_name = substr($db_name, 15); // LENGTH 15 = strlen("date('Ymd\THis')")
 
 
// OPEN A CONNECTION TO THE DATA BASE SERVER
// MAN PAGE: http://us2.php.net/manual/en/function.mysql-connect.php

if (!$db_connection = mysql_connect("$db_host", "$db_user", "$db_word"))
{
   $errmsg = mysql_errno() . ' ' . mysql_error();
   echo "<br/>NO DB CONNECTION: ";
   echo "<br/> $errmsg <br/>";
}
 
// SELECT THE MYSQL DATA BASE
// MAN PAGE: http://us2.php.net/manual/en/function.mysql-select-db.php

//echo $fname ;die() ;
 $sqls  = file('backups/' . $fname);
 
 //echo $sqls[0] ;
 
 mysql_query($sqls[0]) or die(mysql_error() ) ;

//unset($sqls[0]) ;
//die();

if (!$db_sel = mysql_select_db($db_name, $db_connection))
{
   $errmsg = mysql_errno() . ' ' . mysql_error();
   echo "<br/>NO DB SELECTION: ";
   echo "<br/> $errmsg <br/>";
   die('NO DATA BASE');
   
}
 
// LOAD THE BACKUP DATA QUERIES
$sqls  = file('backups/' . $fname);
 
// ITERATE OVER THE QUERIES TO RELOAD THE DATA
foreach ($sqls as $sql)
{
    if (!$res = mysql_query($sql))
	{
	   $errmsg = mysql_errno() . ' ' . mysql_error();
	   echo "<br/>QUERY FAIL: ";
	   echo "<br/>$sql <br/>";
	   die($errmsg);
	}
}

?>
<br /><a href="welcome.php">Back</a>

${this.title}

Code Editor : databaserestore.php