yii2 create zip file

Function

 public function actionFullbackup() { $BackupFileName = 'Placio_'.date('d-m-Y'); // Get real path for our folder $rootPath = realpath(Yii::getAlias('@frontend')."/../"); // Initialize archive object $zip = new \ZipArchive(); $zip->open($BackupFileName.'.zip', \ZipArchive::CREATE | \ZipArchive::OVERWRITE); // Create recursive directory iterator /** @var SplFileInfo[] $files */ $files = new \RecursiveIteratorIterator( new \RecursiveDirectoryIterator($rootPath), \RecursiveIteratorIterator::LEAVES_ONLY ); foreach ($files as $name => $file) { // Skip directories (they would be added automatically) if (!$file->isDir()) { // Get real and relative path for current file $filePath = $file->getRealPath(); //$relativePath = substr($filePath, strlen($rootPath) + 1); $relativePath = substr($filePath, strlen($rootPath) + 1); // Add current file to archive $zip->addFile($filePath, $relativePath); } } echo $BackupFileName.'.zip'; exit; // Zip archive will be created only after closing object $zip->close(); }
 

yii2 create zip file

Automatically Publish Blog Updates on Twitter, Facebook Page

Now onwards when you post something on your blog or website, it will automatically posted on Facebook Page and on your Facebook status and tweets are also made automatically on Twitter.You just need to follow some simple steps:

1. Build your blog or website feeds.

• Login to Feedburner.
• Add your website or Bog's web address to it
• Identify your blog's feed and you are done.

 2. Add Blog feed to Twitter

• Login To Feedburner again and select your feedburner feed for your blog.
• Now click on Publicize Tab.
• Click on Socialize on Left sidebar.
• Socialize Settings will come up and Click on Add a Twitter account button.
• Twitter window will open, login to it using Twitter username and password.
• Follow the steps and verify your twitter account with Feedbuner.
• Now, when your twitter account is added to Feedburner, your blog's new updates are automatically posted on Twitter on behalf of  you.

3.  Add Blog feed for  Posting Automatically on Facebook Page.

• Login to Facebook.
• Search for "RSS Graffiti" App on Facebook and click on Go to App button.
• Click on Add new Publishing plan and name it.
• RSS Graffiti Setting will open.
• Now, click on Add a New Source button.
• Now in Feed setup, add Feed Title (your blog name) and Feedburner feed URL.
• Now click on save changes and turn on the publishing plan.
• In Target side, Choose your Facebook Page as Target and  Publish on behalf of .

4. Blog Updates on your Facebook status.

• Again Go to RSS Graffiti app on Facebook.
• Click on Add new publishing plan and name your new plan.
• Follow the above steps except for target side.
• In Target side, Choose Facebook User as Target and as Publish on Behalf of.
• Click on save and turn on the publishing.

Now when you made a new post on your blog it will automatically published on Facebook page and news feed and on Twitter also.

how to backup MYSQL Database in PHP :: how to create a backup database script in php

Other option than using mysql dump

The below is a tested php code to backup database in .sql file

The above code will create a .sql file in the location you have set in the code.To backup data time to time say in every day you have to hit this php file after each day to do that in:

PHP FUNCTION 

function Backuptables()
{
$link = mysql_connect('localhost','root','');
mysql_select_db('placio_new',$link);
mysql_query("SET NAMES 'utf8'");
$tables = '*';

$dir = Yii::getAlias('@frontend')."/";

//get all of the tables
if($tables == '*')
{
$tables = array();
$result = mysql_query('SHOW TABLES');
while($row = mysql_fetch_row($result))
{
$tables[] = $row[0];
}
}
else
{
$tables = is_array($tables) ? $tables : explode(',',$tables);
}
$return='';
//cycle through
foreach($tables as $table)
{
$result = mysql_query('SELECT * FROM '.$table);
$num_fields = mysql_num_fields($result);

//$return.= 'DROP TABLE '.$table.';';
$row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table));
$return.= "\n\n".$row2[1].";\n\n";

for ($i = 0; $i < $num_fields; $i++) 
{
while($row = mysql_fetch_row($result))
{
$return.= 'INSERT INTO '.$table.' VALUES(';
for($j=0; $j<$num_fields; $j++) 
{
$row[$j] = addslashes($row[$j]);
$row[$j] = str_replace("\n","\\n",$row[$j]);
if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; }
if ($j<($num_fields-1)) { $return.= ','; }
}
$return.= ");\n";
}
}
$return.="\n\n\n";
}

//save file
$way = $dir.'Placio_'.date('d-m-Y h-i-s').'.sql';
$handle = fopen($way,'w+');
fwrite($handle,$return);
fclose($handle);
echo $way;
}

how to backup MYSQL Database in PHP :: how to create a backup database script in php