date picker

Java Script required for date picker

Two file required for date picker 
<script type="text/JavaScript" src="js/jquery-ui.js"></script>
<link href="css/jquery-ui-1.7.3.custom.css" type="text/css" rel="stylesheet" />

<script language="JavaScript">
$(document).ready(function(){ 
	$('.datepicker').datepicker({
		changeMonth: true,
		changeYear: true,
		dateFormat: 'dd-mm-yy',
		onSelect: function() {		
		}
	});	
});
</script>

Date picker required file

simple mail format

$message = 'Hello Admin,<br><br>Today is the [event] of [user_name].<br><br>Thanks ';
$search 	= array('[event]', 
                  '[user_name]');
$replace	= array($event, 
		 $adminName);
						
 $message =str_replace($search,$replace,$message);
		
 $headers  = "From: ".$config->siteName."<".$config->siteEmail.">\r\n";
 $headers .= "Reply-To: ".$config->siteName." <".$config->siteEmail.">\r\n";
 $headers .= 'MIME-Version: 1.0' . "\n";
 $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
 @mail(ToMail, subject , $message ,$headers );	

searching from date to date

$date_added_from 	= isset($_REQUEST['date_added_from']) ? utility::setFormatedDate($_REQUEST['date_added_from']) : "";
$date_added_to 	= isset($_REQUEST['date_added_to']) 	? utility::setFormatedDate($_REQUEST['date_added_to']) : "";
if($date_added_from && $date_added_to) {
    $where	.= " AND date_added BETWEEN '$date_added_from 00:00:00' and '$date_added_to 23:59:59' ";
    $next_page_condition.="&date_added_from=".$_REQUEST['date_added_from']."&date_added_to=".$_REQUEST['date_added_to']." ";
}else if($date_added_from){
	$where	.= " AND date_added >= '$date_added_from' ";
    $next_page_condition.="&date_added_from=".$_REQUEST['date_added_from'];
}else if($date_added_to){
	$where	.= " AND date_added <= '$date_added_to' ";
    $next_page_condition.="&date_added_to=".$_REQUEST['date_added_to'];
}

Fetch table content

`

<?php
$site_id = $config->siteId;
echo $sql = "SELECT * FROM site_shipping_policy WHERE site_id = $site_id ORDER BY shipping DESC";
$result = $db->query($sql);
$data = "";	
echo "<pre>";	
if ($db->num_rows($result) > 0){
	while($row = $db->next_record($result)){
		print_r($row);
	}
}
?>

`

Download CSV

if(isset($_REQUEST['downloadCsv']) && $_REQUEST['downloadCsv'] !=""){
	ob_clean();	
	$filename 	= "myFile.csv";
	header('Content-type: application/csv');
	header('Content-Disposition: attachment; filename='.$filename);
	echo $output;
	exit;	
}