Alumni Add Record

console.log('Debug:', " . json_encode($_SESSION['allowed'] ?? null) . ");"; echo ""; } if ($_SESSION['allowed']=="Allowed") { echo "Inside PHP sessions!"; $stdOrganizationName = ""; $stdJobTitle = ""; $stdOffAddress = ""; if(isset($_POST['login'])) { $email=$_SESSION['login']; $sq2= "SELECT * FROM alumni_data where email_address='$email'"; $res2=$myConnection->query($sq2); if($res2->num_rows>0) { echo " "; echo ""; } else { $stdName=htmlentities($_POST['stdName'], ENT_QUOTES); $stdFatherName=htmlentities($_POST['stdFatherName'], ENT_QUOTES); $campus=$_POST['campus']; $stdRegistrationNo=htmlentities($_POST['stdRegistrationNo'], ENT_QUOTES); $stdProgram = $_POST['stdProgram']; $stdDepartment = $_POST['stdDepartment']; $stdDegreeCompletionYear = $_POST['stdDegreeCompletionYear']; $stdPhoneNo = $_POST['stdPhoneNo']; $stdCell = $_POST['stdCell']; $stdAddress=htmlentities($_POST['stdAddress'], ENT_QUOTES); /* $stdAddress = htmlspecialchars($_POST['stdAddress']); */ $stdJobStatus = $_POST['stdJobStatus']; $selected1=$_POST['stdJobStatus']; if($selected1=='Yes') { $stdOrganizationName=htmlentities($_POST['stdOrganizationName'], ENT_QUOTES); $stdJobTitle=htmlentities($_POST['stdJobTitle'], ENT_QUOTES); $stdOffAddress=htmlentities($_POST['stdOffAddress'], ENT_QUOTES); } else { $stdOrganizationName="No"; $stdJobTitle = "No"; $stdOffAddress="No"; } $stdEmailAddress = $email; // to be chagnes email $stdIsNewsLetterSub = $_POST['stdIsNewsLetterSub']; date_default_timezone_set("Asia/Karachi"); $stdDt= date("Y-m-d H:i:s"); $query2 = mysqli_query($myConnection, "insert into alumni_data(name,father_name,campus,registration_no,program,department,degree_completion_year,phone_no,cell,address,job_status,organization_name,job_title,office_address,email_address,is_news_letter_sub,dt) values('$stdName','$stdFatherName','$campus','$stdRegistrationNo','$stdProgram','$stdDepartment','$stdDegreeCompletionYear','$stdPhoneNo','$stdCell','$stdAddress','$stdJobStatus','$stdOrganizationName','$stdJobTitle','$stdOffAddress','$stdEmailAddress','$stdIsNewsLetterSub','$stdDt')"); $retval = $myConnection->query($query2); $_SESSION['allowed']='Not Allowed'; echo ""; echo ""; } } } else { echo ""; } ?> Alumni Add Record

Main Heading

ALUMNI Information Form

Please fill out this field.

Enter Your Full Name

Please fill out this field.

Enter Father Name

Please select campus.

Select Campus

Please fill out this field.

Enter Registration Number

Select Degree Program

Select Department

Degree Completion Year

Phone Number (Home)

Enter Mobile Number

Enter Postal Address

Job Status(Are your Currently Working)

Organization Name

Job Title

Office / Work Address

News Letter Subcription