Insert Data into accounts_all Table
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Collect form data
$sc_id = $_POST['sc_id'];
$pro_id = $_POST['pro_id'];
$dis_id = $_POST['dis_id'];
$zon_id = $_POST['zon_id'];
$div_id = $_POST['div_id'];
$sc_name = $_POST['sc_name'];
$sc_addr = $_POST['sc_addr'];
$sc_mob = $_POST['sc_mob'];
$sc_mail = $_POST['sc_mail'];
$sc_pw = $_POST['sc_pw'];
$stat = $_POST['stat'];
$created = $_POST['created'];
$img_path = $_POST['img_path'];
$last_update = $_POST['last_update'];
// SQL query to insert data
$sql = "INSERT INTO accounts_all (sc_id, pro_id, dis_id, zon_id, div_id, sc_name, sc_addr, sc_mob, sc_mail, sc_pw, stat, created, img_path, last_update)
VALUES ('$sc_id', '$pro_id', '$dis_id', '$zon_id', '$div_id', '$sc_name', '$sc_addr', '$sc_mob', '$sc_mail', '$sc_pw', '$stat', '$created', '$img_path', '$last_update')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully.";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}
// Close the connection
$conn->close();
}
?>