prepare("
UPDATE bvn_phone_logs
SET bvn=?, status=?
WHERE id=?
");
$stmt->bind_param("ssi",$bvn,$status,$id);
$stmt->execute();
$stmt->close();
header("Location: ".$_SERVER['PHP_SELF']);
exit;
}
/* ================= STATS ================= */
function countTx($conn,$cond){
$r=$conn->query("SELECT COUNT(*) c FROM bvn_phone_logs WHERE $cond");
return $r->fetch_assoc()['c'];
}
$today=date("Y-m-d");
$week=date("Y-m-d",strtotime("monday this week"));
$month=date("Y-m-01");
$d=countTx($conn,"DATE(created_at)='$today'");
$w=countTx($conn,"DATE(created_at)>='$week'");
$m=countTx($conn,"DATE(created_at)>='$month'");
/* ================= DATA ================= */
$res=$conn->query("SELECT * FROM bvn_phone_logs ORDER BY id DESC");
?>
BVN Admin