$donor_id = hall($hall) . $roll;
$dept = department($deptcode);
$join_date = date("Y-m-d");
$time = strtotime('01/01/2015');
$ftime = date('Y-m-d', $time);
$last_date_of_donation = $ftime;
$no_of_donation = 0;
$role = "donor";
$home_district = $_POST['home_district'];
$current_location = $_POST['current_lacation'];
if (isset($_SESSION['login_volunteer'])) {
$added_by = $_SESSION['login_volunteer'];
} else {
$added_by = $_SESSION['login_admin'];
}
add_donor($donor_id, $name, $nickname, $hall, $dept, $blood_group, $mobile, $birth_day, $weight, $join_date, $last_date_of_donation, $no_of_donation, $email, $role, $added_by, $home_district, $current_location);
}
function add_donor($donor_id, $name, $nickname, $hall, $dept, $blood_group, $mobile, $birth_day, $weight, $join_date, $last_date_of_donation, $no_of_donation, $email, $role, $added_by, $home_district, $current_location)
{
$sql = "INSERT INTO `donor`(`donor_id`,`name`,`nickname`,`hall`,`dept`,`blood_group`,`mobile`,`birth_day`,`weight`,`join_date`,`last_date_of_donation`,`no_of_donation`,`email`,`role`,`added_by`,`home_district`,`current_location` )VALUES ('{$donor_id}','{$name}','{$nickname}','{$hall}','{$dept}','{$blood_group}','{$mobile}','{$birth_day}','{$weight}','{$join_date}','{$last_date_of_donation}','{$no_of_donation}','{$email}','{$role}','{$added_by}','{$home_district}','{$current_location}')";
if (mysql_query($sql)) {
echo '<script type="text/javascript">
window.onload = function () { alert("Donor Added!!"); }
</script>';
header("location:all_donor_detail_process.php?q={$donor_id}");
} else {
$errx = "\n" + mysql_errno() + " : " + mysql_error();
//echo $errx;
echo '<script type="text/javascript">
window.onload = function () { alert("Failed!!\\nDonor already Added!!"); }
</script>';
function add_donor($tittle, $last_date, $details, $entry_date, $type)
{
$sql = "INSERT INTO `notice`(`tittle`,`last_date`,`details`,`entry_date`,`type`) VALUES ('{$tittle}','{$last_date}','{$details}','{$entry_date}', '{$type}')";
if (mysql_query($sql)) {
echo '<script type="text/javascript">
window.onload = function () { alert("Notice Added!!"); }
</script>';
} else {
$errx = "\n" + mysql_errno() + " : " + mysql_error();
//echo $errx;
echo '<script type="text/javascript">
window.onload = function () { alert("Failed!!!!"); }
</script>';
}
}
add_donor($tittle, $last_date, $details, $entry_date, $type);
} else {
session_start();
if (!(isset($_SESSION['login_volunteer']) || isset($_SESSION['login_admin']))) {
header("Location:index.php");
die;
}
$type = urldecode(filter_var(trim($_GET['q'])));
}
?>
<html>
<head>
