How to allow break tag in EXCEL file using php

require_once "xlsxwriter.class.php"; 
$writer = new XLSXWriter();
$writer->writeSheetRow('Sheet1', $row, $row_options = array('wrap_text'=>true));

Password protecting your site using .htaccess / .htpasswd

1. Update .htaccess file to the root of your site with the following content:

AuthName "Authorisation Required"
AuthUserFile "/path/to/.htpasswd"
AuthType Basic
require valid-user
ErrorDocument 401 "Authorisation Required"
2. Create & upload the .htpasswd file to ‘AuthUserFile’ path with the following content:
3. generate about line using username & password uaing this site

Split large SQL file into small files using PHP code

Please find below code to Split large SQL file into small files

$file_handle = fopen(‘sql/file.sql’,’r’); //open big file with fopen
$f = 1; //new file number
$newfile = fopen(‘sql/splitfile-‘ . $f . ‘.sql’,’w’); //create new file to write to with file number
for($i = 1; $i <= 3000; $i++) //for 3000 lines
$import = fgets($file_handle);
{break;} //If file ends, break loop
//MySQL newfile insertion stuff goes here

MailChimp integration with PHP CURL API

$memberHash = md5($email);
$api_key = ‘XXXXXXXXXXXXXX-us19’;  //API KEY
$server = ‘us19.’;
$list_id = “XXXXXXX”; // LIST ID
$auth = base64_encode( ‘user:’.$api_key );
$data = array(
‘apikey’ => $api_key,
’email_address’ => $email,
‘status’ => ‘subscribed’,
‘merge_fields’ => array(
‘NAME’ => $name,
$json_data = json_encode($data);
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, ‘https://\’.$server.’’.$list_id.’/members/’.$memberHash);
curl_setopt($ch, CURLOPT_HTTPHEADER, array(‘Content-Type: application/json’,
‘Authorization: Basic ‘.$auth));
curl_setopt($ch, CURLOPT_USERAGENT, ‘PHP-MCAPI/2.0’);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 10);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, “PUT”);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_POSTFIELDS, $json_data);
$result = curl_exec($ch);
$result_obj = json_decode($result);
echo $result_obj->status;