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;

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!

FTP Error in WordPress

The error usually occurs when the following code is missing from wp-config.php file; define('FS_METHOD','direct');

Simple method to connect database using PHP.

$servername = "localhost"; $username = "root"; $password = ""; $dbname = "jjmtmain"; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } else { echo "Connected to database."; } /* In further operations you can use the $conn object for the database connection. For eg. $q = mysqli_query($conn, "select * from user where email='$userid'"); $r = mysqli_fetch_array($q); echo $name = $r['name']; */

PHP Code Snipes

Search This Blog