Number of days b/w two dates in php

function dateDiff($start, $end) {
$start_ts = strtotime($start);
$end_ts = strtotime($end);
$diff = $end_ts – $start_ts;
return round($diff / 86400);
}
echo dateDiff(“2011-02-15”, “2012-01-16”).’days’

Simple Encryption & Decryption in php


function simple_mc_encrypt($text, $salt = "test@123"){
return trim(base64_encode(mcrypt_encrypt(MCRYPT_RIJNDAEL_128, $salt, $text, MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND))));
}
// This function will be used to decrypt data.
function simple_mc_decrypt($text, $salt = "test@123"){
return trim(mcrypt_decrypt(MCRYPT_RIJNDAEL_128, $salt, base64_decode($text), MCRYPT_MODE_ECB, mcrypt_create_iv(mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB), MCRYPT_RAND)));
}

Rijndael 128-bit CBC Encryption Function

$data = ‘Test data’;
$encrypted_data = simple_mc_encrypt($data, ENCRYPTION_KEY);
echo ‘Data to be Encrypted: ‘ . $data . ”;
echo ‘Encrypted Data: ‘ . $encrypted_data . ”;
echo ‘Encrypted Data count: ‘ . strlen($encrypted_data) . ”;
echo ‘Decrypted Data: ‘ . simple_mc_decrypt($encrypted_data, ENCRYPTION_KEY) . ”;

PHP funciton for recursive delete all sublevels of categories

function recursiveDelete($id) {
$result=mysql_query(“SELECT * FROM category WHERE id_parent=’$id'”);
if (mysql_num_rows($result)>0) {
while($current=mysql_fetch_array($result)) {
recursiveDelete($current[‘id’]);
}
}
mysql_query(“DELETE FROM category WHERE id=’$id'”);
}

PHP pagination

<?php
$num_rec_per_page=10;
if (isset($_GET[“page”])) { $page = $_GET[“page”]; } else { $page=1; };
$start_from = ($page-1) * $num_rec_per_page;
$sql = “SELECT * FROM student LIMIT $start_from, $num_rec_per_page”;
$rs_result = mysql_query ($sql); //run the query
?>
<table>
<tr><td>Name</td><td>Phone</td></tr>
<?php
while ($row = mysql_fetch_assoc($rs_result)) {
?>
<tr>
<td><?php echo $row[‘Name’]; ?></td>
<td><?php echo $row[‘Phone’]; ?></td>
</tr>
<?php
};
?>
</table>
<?php
$sql = “SELECT * FROM student”;
$rs_result = mysql_query($sql); //run the query
$total_records = mysql_num_rows($rs_result); //count number of records
$total_pages = ceil($total_records / $num_rec_per_page);

echo “<a href=’pagination.php?page=1′>”.’|<‘.”</a> “; // Goto 1st page

for ($i=1; $i<=$total_pages; $i++) {
echo “<a href=’pagination.php?page=”.$i.”‘>”.$i.”</a> “;
};
echo “<a href=’pagination.php?page=$total_pages’>”.’>|’.”</a> “; // Goto last page
?>

PHP function for clean string

function cleanString($str) {
        //$str = strip_tags($str);
        //$str = preg_replace('/<![\s\S]*?--[ \t\n\r]*>/', ' ', $str);
        $remove_this = array('%26', '%27', '%7C', '%5C', '%2D', '%2F');
        $put_this    = array(" ", " ", " ", " ","-","/");
        $str         = str_replace($remove_this, $put_this, $str);
        $clean = preg_replace("/[^a-zA-Z0-9:@ -\.,\/_|+ -\<\>\t\n\r]/", '', $str);
        //$clean = ucwords (trim($clean, ''));
        // $clean = preg_replace("/[\/_|+ -]+/", ' ', $clean);
        //$clean = preg_replace("/[\/_|+ ]+/", ' ', $clean);
        return trim($clean);
    }