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
while(!feof($file_handle))
{
$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);
fwrite($newfile,$import);
if(feof($file_handle))
{break;} //If file ends, break loop
}
fclose($newfile);
//MySQL newfile insertion stuff goes here
$f++;
}
fclose($file_handle);

Advertisements

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.’api.mailchimp.com/3.0/lists/’.$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;

PHP script for Fibonacci number

PHP script for first 20 Fibonacci numbers
<?php
$count = 0 ;
$c1 = 0;
$c2 = 1;
echo $c1.” , “;
echo $c2.” , “;
while ($count < 20 )
{
$c3 = $c2 + $c1 ;
echo $c3.” , “;
$c1 = $c2 ;
$c2 = $c3 ;
$count = $count + 1;
}
?>

<?php
/* Find number odd or even */
$num = 32;
$even = ($num % 2 == 0);
$odd = ($num % 2 != 0);
?>