Base Path for Link Tag


Base Path for Links:
It is not required to give a complete URL for every link. You can get rid of it if you will use
<base> tag in your header. This tag is used to give a base path for all the links. So your
browser will concatenate given relative path to this base path and will make a complete URL.
For example we have used following base tag in all the pages at domain.com:
<head>
</head>
So now if you will use
<a href=”/test/index.htm”>
then it will be considered as <a href=”http://www.domain.com//test/index.htm”&gt;

Page Refresh and Redirect Using HTML meta Tag


Document Refreshing:
You can specify a duration after which your web page will keep refreshing. If you want your
page keep refreshing after every 10 seconds then use the following
syntax.
<head>
<meta http-equiv=”refresh” content=”10″ />
</head>
Page Redirection:
You can specify a page redirection using Meta Tag. Following is an example of redirecting
current page to another page. You can specify a duration after which page will b
e redirected.
<head>
<meta http-equiv=”refresh” content=”10; url=http://www.tutorialspoint.com” />
</head>

MySQL database backup and restore using PHP


<!-- MySQL database backup and restore using PHP -->

<!DOCTYPE html>
<?php
if(isset($_POST['username']) && isset($_POST['password']) && isset($_POST['databasename'])) {
$username = trim($_POST['username']);
$password = trim($_POST['password']);
$databasename = trim($_POST['databasename']);
$backupRestore = $_POST['backupRestore'];

if ($backupRestore == 'backup'){
$data = $_POST['data'];
$now = str_replace(":", "", date("Y-m-d H:i:s"));
$outputfilename = $databasename . '-' . $now . '.db';
$outputfilename = str_replace(" ", "-", $outputfilename);

//Dump the MySQL database
if ($data == "wd"){
//With data
exec('mysqldump -u '. $username .' -p'. $password .' '. $databasename .' > '. $outputfilename);
}
else{
//Without data
exec('mysqldump --no-data -u '. $username .' -p'. $password .' '. $databasename .' > '. $outputfilename);
}

//Download the database file
header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename='.basename($outputfilename));
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
header('Content-Length: ' . filesize($outputfilename));
ob_clean();
flush();
readfile($outputfilename);

//After download remove the file from server
exec('rm ' . $outputfilename);

}
else{//Restore the database

$target_path = getcwd();
$databasefilename = $_FILES["databasefile"]["name"];

//Upload the database file to current working directory
move_uploaded_file($_FILES["databasefile"]["tmp_name"], $target_path . '/' . $databasefilename);

//Restore the database
exec('mysql -u '. $username .' -p'. $password .' '. $databasename .' < '. $databasefilename);

//Remove the file from server
exec('rm ' . $databasefilename);
}
}
?>
<html>
<head>
<title>MySQL database backup</title>
http://code.jquery.com/jquery-1.9.1.min.js

$(document).ready(function() {
$(".restoreFile").hide();
});
function checkParameters(){
var username = $.trim($("#username").val());
var password = $.trim($("#password").val());
var databasename = $.trim($("#databasename").val());
if (username == ""){
alert("Plsease enter mysql username.");return false;
}
else if (password == ""){
alert("Plsease enter mysql password.");return false;
}
else if (databasename == ""){
alert("Plsease enter mysql database name.");return false;
}
else if($("#restore").is(':checked')){
var filename = $(".restoreFile").val();
if(filename == ""){
alert("Please choose a file.");return false;
}
else{
var valid_extensions = /(\.db|\.sql)$/;
if (!valid_extensions.test(filename)){
alert('Invalid file format.');return false;
}
}
}
else{
return true;
}
}
function showHide(id){
if (id == "backup"){
$(".backupRadio").show();
$(".restoreFile").hide();
}
else{
$(".backupRadio").hide();
$(".restoreFile").show();
}
}

</head>
<body>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>" onsubmit="return checkParameters();" enctype="multipart/form-data">
<table border="0" bgcolor="#C0C0C0" align="center" width="40%">
<tr>
<td colspan="3" align="center"><b>Please enter the following parameters</b></td>
</tr>
<tr>
<td>MySQL username*</td>
<td>:</td>
<td><input type="text" id="username" name="username" /></td>
</tr>
<tr>
<td>MySQL password*</td>
<td>:</td>
<td><input type="text" id="password" name="password" /></td>
</tr>
<tr>
<td>MySQL database name*</td>
<td>:</td>
<td><input type="text" id="databasename" name="databasename" /></td>
</tr>
<tr>
<td colspan="2">Backup <input type="radio" name="backupRestore" id="backup" value="backup" checked="true" onclick="showHide(this.id);" /></td>
<td>

With data
With out data
</td>
</tr>
<tr>
<td>Restore <input type="radio" name="backupRestore" id="restore" value="restore" onclick="showHide(this.id);" /></td>
<td></td>
<td><input class="restoreFile" type="file" name="databasefile" /></td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" value="Submit"/></td>
</tr>
</table>
</form>
</body>
</html>