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 : databasebackup.php

<?php // mysql_backup_dump.php
error_reporting(E_ALL);
 
 
// 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 = "";
 
 
// 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/>";
   die();
}
 
 
// GET A LIST OF THE DATA BASES ON THIS CONNECTION
// MAN PAGE: http://us2.php.net/manual/en/function.mysql-list-dbs.php
if (!$db_list = mysql_list_dbs($db_connection))
{
   $errmsg = mysql_errno() . ' ' . mysql_error();
   echo "<br/>NO DB LIST: ";
   echo "<br/> $errmsg <br/>";
   die();
}
 
 
// ITERATE OVER THE LIST OF NAMES TO MAKE AN ARRAY
while ($row = mysql_fetch_object($db_list))
{
    $db_names[] = $row->Database ;
}
 
 
// ANYTHING IN POST DATA YET?
if (empty($_POST["d"]))
{
// NOTHING POSTED - ASK CLIENT TO CHOOSE THE DATA BASE
    echo "<form method=\"post\">\n";
    echo "BACK UP A DATA BASE:<br/>";
    foreach ($db_names as $db_name)
    {
        echo "<input type=\"radio\" name=\"d\" value=\"$db_name\">$db_name <br/>\n";
    }
    echo "<input type=\"submit\" />\n";
    echo "</form>\n";
    die();
}
 
 
// THERE IS A RADIO BUTTON IN $_POST
if (!in_array($_POST["d"], $db_names)) die("ERROR: DATABASE {$_POST["d"]} NOT FOUND");
$db_name = $_POST["d"];
 
 
// SELECT THE MYSQL DATA BASE
// MAN PAGE: http://us2.php.net/manual/en/function.mysql-select-db.php
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');
}
 
 
// SET THE NAME OF THE BACKUP WITH A TIMESTAMP
$bkup = 'backups/mysql' . date('Ymd\THis') . $db_name . '.txt';
$fp   = fopen($bkup, "w");
 
 
// GET THE LIST OF TABLES
$sql = "SHOW TABLES";
$res = mysql_query($sql);
if (!$res) die( mysql_error() );
if (mysql_num_rows($res) == 0) die( "NO TABLES IN $db_name" );
while ($s = mysql_fetch_array($res))
{
	$tables[]	= $s[0];
}
 
 $txt="create database if not exists " .$db_name."";
  $txt.="use".$db_name."";
fwrite($fp, $txt . "\n");
  
// ITERATE OVER THE LIST OF TABLES
foreach ($tables as $table)
{
 
// WRITE THE DROP TABLE STATEMENT
    fwrite($fp,"DROP TABLE `$table`;\n");
 
// GET THE CREATE TABLE STATEMENT
    $res = mysql_query("SHOW CREATE TABLE `$table`");
    if (!$res) die( mysql_error() );
    $cre = mysql_fetch_array($res);
    $cre[1] .= ";";
    $txt = str_replace("\n", "", $cre[1]); // FIT EACH QUERY ON ONE LINE
    fwrite($fp, $txt . "\n");
 
// GET THE TABLE DATA
    $data = mysql_query("SELECT * FROM `$table`");
    $num  = mysql_num_fields($data);
    
	
	while ($row = mysql_fetch_array($data))
    {
 
// MAKE INSERT STATEMENTS FOR ALL THE VALUES
        $txt = "INSERT INTO `$table` VALUES(";
        for ($i=0; $i < $num; $i++)
        {
            $txt .= "'".mysql_real_escape_string($row[$i])."', ";
        }
        $txt = substr($txt, 0, -2);
        fwrite($fp, $txt . ");\n");
    }
}
// ALL DONE
fclose($fp);
 
// SHOW THE LINK TO THE BACKUP FILE
echo "<br/>BACKUP OF $db_name CREATED HERE:\n";
echo "<br/><a href=\"$bkup\">$bkup</a>\n";
//echo $bkup;

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

${this.title}

Code Editor : databasebackup.php