FTP Error in WordPress

The error usually occurs when the following code is missing from wp-config.php file;

define('FS_METHOD','direct');

Comments

Restoring MySQL on XAMMP

Follow these steps and save your time and databases:- Go to your XAMMP installation, it’s mostly in C drive . Now inside mysql folder rename the folder data to data-old (or any other name you like) Create a new folder data under mysql folder Copy the contents of backup folder to the new data folder Now copy all your database folders that are in data-old folder to the new data folder (skip the mysql, performance_scheme and phpmyadmin folder) And the last, copy the ibdata1 file from data-old folder and replace it inside new data folder Restart your MYSQL server from XAMPP control panel . And done!

Export to Excel using header disposition

$output.="YOUR HTML TABLE HERE"; header("Content-Type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=excel.xls"); echo $output;

Setting default timezone in php.

Most of the time in shared hosting, default server time seems to be different than local timezone. You can change the default timezone using following snippet. date_default_timezone_set("Asia/Kolkata"); $dateTime = date("Y-m-d H:i:s", time()); //For full reference, visit. https://www.php.net/manual/en/timezones.php

PHP Code Snipes

Search This Blog