<?php
if(isset($_POST['submit']) && !empty($_POST['submit'])) {
if (isset($_POST['from_date'],$_POST['to_date']) && !empty($_POST['from_date']) && !empty($_POST['to_date'])) {
$from_date = $_POST['from_date'];
$to_date = $_POST['to_date'];
$stmt = $db->prepare("SELECT jobID, sent_date_time,total_base,delivered,failed,invalid,pending
FROM sent_report
WHERE sent_date between ? AND ?") or die($db->error);
$stmt->bind_param('ss',$from_date,$to_date);
$stmt->execute();
//grab a result set
$resultSet = $stmt->get_result();
if($resultSet->num_rows) {
while($row = $resultSet->fetch_object()) {
$sent_records[] = $row;
}
$resultSet->free();
}
if (!count($sent_records)) {
echo "No records";
} else {
echo "Total Records(SELECT BY DATE) = ".count($sent_records)."<br>";
foreach ($sent_records as $sr) {
echo "JOB ID = ".$sr->jobID."<br>";
echo "SENT DATE TIME = ".$sr->sent_date_time."<br>";
echo "TOTAL BASE = ".$sr->total_base."<br>";
echo "DELIVERED = ".$sr->delivered."<br>";
echo "FAILED = ".$sr->failed."<br>";
echo "INVALID = ".$sr->invalid."<br>";
echo "PENDING = ".$sr->pending."<br>";
echo "<br>";
echo "<br>";
echo "<br>";
}
}
}
} else {
$stmt = $db->query("SELECT jobID, sent_date_time,total_base,delivered,failed,invalid,pending
FROM sent_report") or die($db->error);
if($stmt->num_rows) {
while($row = $stmt->fetch_object()) {
$sent_records[] = $row;
}
$stmt->free();
}
if (!count($sent_records)) {
echo "No Sent Items Found During All records";
} else {
echo "Total Records = ".count($sent_records)."<br>";
foreach ($sent_records as $sr) {
echo "JOB ID = ".$sr->jobID."<br>";
echo "SENT DATE TIME = ".$sr->sent_date_time."<br>";
echo "TOTAL BASE = ".$sr->total_base."<br>";
echo "DELIVERED = ".$sr->delivered."<br>";
echo "FAILED = ".$sr->failed."<br>";
echo "INVALID = ".$sr->invalid."<br>";
echo "PENDING = ".$sr->pending."<br>";
echo "<br>";
echo "<br>";
echo "<br>";
}
}
}
?>