real_escape($_GET['val']); if(!empty($val) && $val == "edit"){ $id = $db->real_escape($_GET['id']); $record = $db->fetch_array($db->query("SELECT * FROM member WHERE id = '$id'")); $edit = true; } if(isset($_POST['save']) || isset($_POST['update'])){ $member_id = $db->real_escape($_POST['member_id']); $postal_address = $db->real_escape($_POST['postal_address']); $admission_no = $db->real_escape($_POST['admission_no']); $member_name = $db->real_escape($_POST['member_name']); $father_name = $db->real_escape($_POST['father_name']); $mobile_no = $db->real_escape($_POST['mobile_no']); $dob = date("Y-m-d",strtotime($db->real_escape($_POST['dob']))); $email_id = $db->real_escape($_POST['email_id']); $gender = $db->real_escape($_POST['gender']); $member_type = $db->real_escape($_POST['member_type']); $grecord = $db->fetch_array($db->query("SELECT member_type_id FROM member_type WHERE member_type = '$member_type'")); $member_type_id = $grecord['member_type_id']; $subject = $db->real_escape($_POST['subject']); $grecord = $db->fetch_array($db->query("SELECT subject_id FROM subject WHERE subject = '$subject'")); $subject_id = $grecord['subject_id']; $department = $db->real_escape($_POST['department']); $grecord = $db->fetch_array($db->query("SELECT department_id FROM department WHERE department = '$department'")); $department_id = $grecord['department_id']; $year = $db->real_escape($_POST['year']); $grecord = $db->fetch_array($db->query("SELECT year_id FROM year WHERE year = '$year'")); $year_id = $grecord['year_id']; $class = $db->real_escape($_POST['class']); $grecord = $db->fetch_array($db->query("SELECT class_id FROM class WHERE class = '$class'")); $class_id = $grecord['class_id']; $member_card_no = $db->real_escape($_POST['member_card_no']); $book_bank_in_hand = $db->real_escape($_POST['book_bank_in_hand']); $session = $db->real_escape($_POST['session']); $grecord = $db->fetch_array($db->query("SELECT session_id FROM session WHERE session = '$session'")); $session_id = $grecord['session_id']; $book_in_hand = $db->real_escape($_POST['book_in_hand']); $date_of_joining = date("Y-m-d",strtotime($db->real_escape($_POST['date_of_joining']))); $newspaper_in_hand = $db->real_escape($_POST['newspaper_in_hand']); $date_of_expire = date("Y-m-d",strtotime($db->real_escape($_POST['date_of_expire']))); $magzine_in_hand = $db->real_escape($_POST['magzine_in_hand']); if(!empty($_FILES['photo']['name'])){ $photo = "uploads/photo/".time().$_FILES['photo']['name']; }else{ $photo = NULL; } if(isset($_POST['save'])){ $query = "INSERT INTO member SET member_id = '$member_id', postal_address = '$postal_address', admission_no = '$admission_no', member_name = '$member_name', father_name = '$father_name', mobile_no = '$mobile_no', dob = '$dob', email_id = '$email_id', member_type = '$member_type_id', subject = '$subject_id', department = '$department_id', year = '$year_id', class = '$class_id', member_card_no = '$member_card_no', book_bank_in_hand = '$book_bank_in_hand', session = '$session_id', book_in_hand = '$book_in_hand', date_of_joining = '$date_of_joining', newspaper_in_hand = '$newspaper_in_hand', date_of_expire = '$date_of_expire', photo = '$photo', create_date = NOW(), gender = '$gender', magzine_in_hand = '$magzine_in_hand'"; if($db->query($query)){ if(!empty($_FILES['photo']['name'])){ move_uploaded_file($_FILES['photo']['tmp_name'],$photo); } $msg = " record successfully Inserted"; } else{ $error = "Error"; } }elseif(isset($_POST['update'])){ $record_id = $db->real_escape($_POST['record_id']); $rec = $db->fetch_array($db->query("SELECT * FROM member WHERE id = '$record_id'")); if(!empty($_FILES['photo']['name'])){ $photo = "uploads/photo/".time().$_FILES['photo']['name']; unlink($rec['photo']); }else{ $photo = $rec['photo']; } $query = "UPDATE member SET member_id = '$member_id', postal_address = '$postal_address', admission_no = '$admission_no', member_name = '$member_name', father_name = '$father_name', mobile_no = '$mobile_no', dob = '$dob', email_id = '$email_id', member_type = '$member_type_id', subject = '$subject_id', department = '$department_id', year = '$year_id', class = '$class_id', member_card_no = '$member_card_no', book_bank_in_hand = '$book_bank_in_hand', session = '$session_id', book_in_hand = '$book_in_hand', date_of_joining = '$date_of_joining', newspaper_in_hand = '$newspaper_in_hand', date_of_expire = '$date_of_expire', photo = '$photo', create_date = NOW(), gender = '$gender', magzine_in_hand = '$magzine_in_hand' WHERE id = '$record_id'"; if($db->query($query)){ if(!empty($_FILES['photo']['name'])){ move_uploaded_file($_FILES['photo']['tmp_name'],$photo); } $msg = "Record Updated Successfully"; }else{ $error = "Error"; } } } ?>
Success :
Error :
Add Member
Member Info
Member Id
*
Show
Postal Address
*
<?php echo $record['postal_address']?>
Admission No.
*
Gender
*
Select
>Male
>Female
Member Name
*
Father Name
*
Date Of Birth
*
Email
*
Mobile No
*
Member Type
Member Type
*
fetch_array($db->query("SELECT member_type FROM member_type WHERE member_type_id = '".$record['member_type']."'")); }?>
query("SELECT * FROM member_type ORDER BY member_type"); while($sresult = $db->fetch_array($srecord)){?>
Subject
*
fetch_array($db->query("SELECT subject FROM subject WHERE subject_id = '".$record['subject']."'")); }?>
query("SELECT * FROM subject ORDER BY subject"); while($sresult = $db->fetch_array($srecord)){?>
Department
*
fetch_array($db->query("SELECT department FROM department WHERE department_id = '".$record['department']."'")); }?>
query("SELECT * FROM department ORDER BY department"); while($sresult = $db->fetch_array($srecord)){?>
Class
*
fetch_array($db->query("SELECT class FROM class WHERE class_id = '".$record['class']."'")); }?>
query("SELECT * FROM class ORDER BY class"); while($sresult = $db->fetch_array($srecord)){?>
Library Info
Member Card No
*
Session
*
fetch_array($db->query("SELECT session FROM session WHERE session_id = '".$record['session']."'")); }?>
query("SELECT * FROM session ORDER BY session"); while($sresult = $db->fetch_array($srecord)){?>
Date Of Joining
*
Date Of Expire
*
Controller
Add New
>Save
>Update