Hello,
I created a query insert query everything is in right order but dont know whyy its not working
function submit_report() {
global $connection;
if(isset($_POST["submit"])) {
$id = 215;
$name = "myname";
$uname = "myusername";
$date = $_POST['date'];
$campaign = $_POST['campaign'];
$t_leads = $_POST['t_leads'];
$c_leads = $_POST['c_leads'];
$open_acc = $_POST['open_acc'];
$n_sure = $_POST['n_sure'];
$l_upload = $_POST['l_upload'];
$dreport = $_POST['dreport'];
$reason = $_POST['reason'];
$comments = $_POST['comments'];
//
$insert = "INSERT INTO status_report (user_id, fullname, user_name, campaign, date, tleads, cleads, op_acc, nsure, lupload, fdelivered, reason, comments)";
$insert .= " VALUES ('$id', '$name', '$uname', '$campaign', '$date', '$t_leads', '$c_leads', '$open_acc', '$n_sure', '$l_upload', '$dreport', '$reason', '$comments')";
//
$insert_query = mysqli_query($connection, $insert);
if(confirm_query($insert_query)) {
$_SESSION["message"] = "Your report have been submitted successfully";
redirect_to("home.php");
} else {
$_SESSION["message"] = "There were some errors please re submit your report";
redirect_to("submit_rep.php");
}
}
}