Restore backup file in mysql using php

      <?php
$dbhost = 'localhost:3036';
$dbuser = 'root';
$dbpass = 'rootpassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
$table_name = "employee";
$backup_file  = "/tmp/employee.sql";
$sql = "LOAD DATA INFILE '$backup_file' INTO TABLE $table_name";
mysql_select_db('test_db');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not load data : ' . mysql_error());
}
echo "Loaded  data successfully\n";
mysql_close($conn);
?>     

Backup Mysql Database using php script

 <?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}
$table_name = "table_name";
$backup_file  = "path:\table_name";
$sql = "SELECT * INTO OUTFILE '$backup_file' FROM $table_name";

mysql_select_db('DB_name');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
  die('Could not take data backup: ' . mysql_error());
}
echo "Backedup  data successfully\n";
mysql_close($conn);
?>

--------------------------- Another Method----------------------------

      <?php
$dbhost = 'localhost:3036';
$dbuser = 'root';
$dbpass = 'rootpassword';
$backup_file = $dbname . date("Y-m-d-H-i-s") . '.gz';
$command = "mysqldump –opt -h $dbhost -u $dbuser -p $dbpass ".
           "test_db | gzip > $backup_file";

system($command);
?>     

Object Oriented Programming - OOP PHP using static

class and public method

<?php
class dateNow
{
protected $_dateNow='';

public function getCurrentDate()
{
$_dateNow=date("y-m-d");
return $_dateNow;
}

public function future_date()
{
$abc=date("y-m-d",strtotime("+ 7 days"));
return $abc;
}

}

$magicdate=new dateNow();
echo $magicdate->getCurrentDate();
echo '<br />';
echo $magicdate->future_date();
?>

Create class and method

<?php
class dateNow
{
protected $_dateNow='';

public function getCurrentDate()
{
$_dateNow=date("y-m-d");
return $_dateNow;
}


}
$call_date=new dateNow();
echo $call_date->getCurrentDate();
?>