if($_POST['MHAP']){
$sql = "UPDATE `message` SET status='OnHold' Where status='Pending'";
if ($conn->query($sql) === TRUE) {
echo '
';
} else {
echo'
';
}
}
if($_POST['MSAM']){
$sql = "UPDATE `message` SET status='Pending' Where status='OnHold'";
if ($conn->query($sql) === TRUE) {
echo'
';
} else {
echo'
';
}
}
if($_POST['DAHM']){
$sql = "DELETE FROM `message` WHERE status='OnHold'";
if ($conn->query($sql) === TRUE) {
echo '
';
} else {
echo'
';
}
}
if($_POST['DAM']){
$sql = "DELETE FROM `message`";
if ($conn->query($sql) === TRUE) {
echo '
';
} else {
echo'
';
}
}
?>
More info
More info
More info
Alert!
SMS are on holdError updating record!
'.$conn->error.'
Alert!
Onhold SMS Ready For ShootError updating record!
'.$conn->error.'
Alert!
Record deleted successfullyError deleting record!
'.$conn->error.'
Alert!
Record deleted successfullyError deleting record!
'.$conn->error.'
date_default_timezone_set('Asia/Dhaka'); $date = date("Y-m-d"); $to30= date('Y-m-d',mktime(0,0,0,$m,($de-30),$y)); $sql = "SELECT COUNT(*) as count FROM message WHERE date='$date'"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo $row['count']; } }?>
Today sended
date_default_timezone_set('Asia/Dhaka'); $date = date("Y-m-d"); $to30= date('Y-m-d',mktime(0,0,0,$m,($de-30),$y)); $sql = "SELECT COUNT(*) as count FROM message Where date BETWEEN '$to30' AND '$date'"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo $row['count']; } }?>
last 30days
$sql = "SELECT COUNT(*) as count FROM message"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo $row['count']; } }?>
Total Sended
Sms Status
Calendar
| « | November 2021 | » | ||||
|---|---|---|---|---|---|---|
| Su | Mo | Tu | We | Th | Fr | Sa |
| 31 | 1 | 2 | 3 | 4 | 5 | 6 |
| 7 | 8 | 9 | 10 | 11 | 12 | 13 |
| 14 | 15 | 16 | 17 | 18 | 19 | 20 |
| 21 | 22 | 23 | 24 | 25 | 26 | 27 |
| 28 | 29 | 30 | 1 | 2 | 3 | 4 |
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |