-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathfunctions.php
executable file
·167 lines (140 loc) · 15.6 KB
/
functions.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
<?php
session_start();
include "h.conn.php";
$reg_id = $_SESSION['reg_id'];
function assign_values(){
$name_applicant = addslashes($_POST['name_applicant']);
$name_father = addslashes($_POST['name_father']);
$permanent_address = addslashes($_POST['permanent_address']);
$present_address = addslashes($_POST['present_address']);
$mobile = addslashes($_POST['mobile']);
$phone_no = addslashes($_POST['phone_no']);
$dob = $_POST['dob'];
$dob = preg_replace('#(\d{2})/(\d{2})/(\d{4})#', '$3-$1-$2', $dob); //changing date format for mysql insertion..
$nationality = addslashes($_POST['nationality']);
$place_birth = addslashes($_POST['place_birth']);
$caste = addslashes($_POST['caste']);
for($i=0;$i<5;$i++)
{
$exam_name[$i] = (isset($_POST['exam'.$i.'_name'])?addslashes($_POST['exam'.$i.'_name']):"");
$exam_year[$i] = (isset($_POST['exam'.$i.'_year'])?addslashes($_POST['exam'.$i.'_year']):"");
$exam_percentage[$i] = (isset($_POST['exam'.$i.'_percentage'])?addslashes($_POST['exam'.$i.'_percentage']):"");
$exam_divn[$i] = (isset($_POST['exam'.$i.'_divn'])?addslashes($_POST['exam'.$i.'_divn']):"");
$exam_institute[$i] = (isset($_POST['exam'.$i.'_institute'])?addslashes($_POST['exam'.$i.'_institute']):"");
$exam_univ[$i] = (isset($_POST['exam'.$i.'_univ'])?addslashes($_POST['exam'.$i.'_univ']):"");
}
for($i=0;$i<5;$i++)
{
$post_name[$i] = (isset($_POST['post'.$i.'_name'])?addslashes($_POST['post'.$i.'_name']):"");
$post_from[$i] = (isset($_POST['post'.$i.'_from'])?addslashes($_POST['post'.$i.'_from']):"");
$post_to[$i] = (isset($_POST['post'.$i.'_to'])?addslashes($_POST['post'.$i.'_to']):"");
$post_total_year[$i] = (isset($_POST['post'.$i.'_total_year'])?addslashes($_POST['post'.$i.'_total_year']):"");
$post_total_month[$i] = (isset($_POST['post'.$i.'_total_month'])?addslashes($_POST['post'.$i.'_total_month']):"");
$post_institute[$i] = (isset($_POST['post'.$i.'_institute'])?addslashes($_POST['post'.$i.'_institute']):"");
$post_pay[$i] = (isset($_POST['post'.$i.'_pay'])?addslashes($_POST['post'.$i.'_pay']):"");
}
$national_paper_conf_count = addslashes($_POST['national_paper_conf_count']);
$national_paper_conf_desc = addslashes($_POST['national_paper_conf_desc']);
$international_paper_conf_presented_count = addslashes($_POST['international_paper_conf_presented_count']);
$international_paper_conf_presented_desc = addslashes($_POST['international_paper_conf_presented_desc']);
$no_paper_published_journal_national = addslashes($_POST['no_paper_published_journal_national']);
$no_paper_published_journal_international = addslashes($_POST['no_paper_published_journal_international']);
$no_paper_published_books = addslashes($_POST['no_paper_published_books']);
$no_paper_published_patents = addslashes($_POST['no_paper_published_patents']);
$no_phd_guided_sole = addslashes($_POST['no_phd_guided_sole']);
$no_phd_guided_supervisor = addslashes($_POST['no_phd_guided_supervisor']);
$no_projects_as_coordinator_sf_completed = addslashes($_POST['no_projects_as_coordinator_sf_completed']);
$no_projects_as_coordinator_sf_ongoing = addslashes($_POST['no_projects_as_coordinator_sf_ongoing']);
$no_projects_as_coordinator_s_completed = addslashes($_POST['no_projects_as_coordinator_s_completed']);
$no_projects_as_coordinator_s_ongoing = addslashes($_POST['no_projects_as_coordinator_s_ongoing']);
$dosubmit = date('Y-m-d');
$particulars_prof_exp_other = addslashes($_POST['particulars_prof_exp_other']);
$certificates = addslashes($_POST['certificates']);
}
function upload_all_images(){
}
function save_form(){
$submitted = 0;
assign_values();
upload_all_images();
$save1_query = "UPDATE user_info SET name_applicant = '".$name_applicant."',name_father = '".$name_father."',permanent_address = '".$permanent_address."',present_address = '".$present_address."',mobile = '".$mobile."',phone_no = '".$phone_no."',dob = '".$dob."',nationality = '".$nationality."',place_birth = '".$place_birth."',caste = '".$caste."' WHERE reg_id = '".$reg_id."' ";
$save1_result = mysql_query($save1_query) or die(mysql_error());
$save2_query = "UPDATE user_exams SET exam1_name = '".$exam_name[0]."',exam1_year = '".$exam_year[0]."',exam1_percentage = '".$exam_percentage[0]."',exam1_divn = '".$exam_divn[0]."',exam1_institute = '".$exam_institute[0]."',exam1_univ = '".$exam_univ[0]."', exam2_name = '".$exam_name[1]."',exam2_year = '".$exam_year[1]."',exam2_percentage = '".$exam_percentage[1]."',exam2_divn = '".$exam_divn[1]."',exam2_institute = '".$exam_institute[1]."',exam2_univ = '".$exam_univ[1]."',exam3_name = '".$exam_name[2]."',exam3_year = '".$exam_year[2]."',exam3_percentage = '".$exam_percentage[2]."',exam3_divn = '".$exam_divn[2]."',exam3_institute = '".$exam_institute[2]."',exam3_univ = '".$exam_univ[2]."',exam4_name = '".$exam_name[3]."',exam4_year = '".$exam_year[3]."',exam4_percentage = '".$exam_percentage[3]."',exam4_divn = '".$exam_divn[3]."',exam4_institute = '".$exam_institute[3]."',exam4_univ = '".$exam_univ[3]."',exam5_name = '".$exam_name[4]."',exam5_year = '".$exam_year[4]."',exam5_percentage = '".$exam_percentage[4]."',exam5_divn = '".$exam_divn[4]."',exam5_institute = '".$exam_institute[4]."',exam5_univ = '".$exam_univ[4]."' WHERE reg_id = '".$reg_id."' ";
$save2_result = mysql_query($save2_query) or die(mysql_error());
$save3_query = "UPDATE user_earlier_posts SET post1_name = '".$post_name[0]."',post1_from = '".$post_from[0]."',post1_to = '".$post_to[0]."',post1_total_year = '".$post_total_year[0]."',post1_total_month = '".$post_total_month[0]."',post1_pay = '".$post_pay[0]."',post2_name = '".$post_name[1]."',post2_from = '".$post_from[1]."',post2_to = '".$post_to[1]."',post2_total_year = '".$post_total_year[1]."',post2_total_month = '".$post_total_month[1]."',post2_pay = '".$post_pay[1]."',post3_name = '".$post_name[2]."',post3_from = '".$post_from[2]."',post3_to = '".$post_to[2]."',post3_total_year = '".$post_total_year[2]."',post3_total_month = '".$post_total_month[2]."',post3_pay = '".$post_pay[2]."',post4_name = '".$post_name[3]."',post4_from = '".$post_from[3]."',post4_to = '".$post_to[3]."',post4_total_year = '".$post_total_year[3]."',post4_total_month = '".$post_total_month[3]."',post4_pay = '".$post_pay[3]."',post5_name = '".$post_name[4]."',post5_from = '".$post_from[4]."',post5_to = '".$post_to[4]."',post5_total_year = '".$post_total_year[4]."',post5_total_month = '".$post_total_month[4]."',post5_pay = '".$post_pay[4]."' WHERE reg_id = '".$reg_id."'";
$save3_result = mysql_query($save3_query) or die(mysql_error());
$save4_query = "UPDATE user_other_details SET national_paper_conf_count='".$national_paper_conf_count."', national_paper_conf_desc='".$national_paper_conf_desc."',international_paper_conf_presented_count='".$international_paper_conf_presented_count."',international_paper_conf_presented_desc='".$international_paper_conf_presented_desc."',no_paper_published_journal_national='".$no_paper_published_journal_national."', no_paper_published_journal_national='".$no_paper_published_journal_international."',no_paper_published_books='".$no_paper_published_books."', no_paper_published_patents='".$no_paper_published_patents."',no_phd_guided_sole='".$no_phd_guided_sole."',no_phd_guided_supervisor='".$no_phd_guided_supervisor."',no_projects_as_coordinator_sf_completed='".$no_projects_as_coordinator_sf_completed."',no_projects_as_coordinator_sf_ongoing='".$no_projects_as_coordinator_sf_ongoing."',no_projects_as_coordinator_s_completed='".$no_projects_as_coordinator_s_completed."',no_projects_as_coordinator_s_ongoing='".$no_projects_as_coordinator_s_ongoing."',particulars_prof_exp_other='".$particulars_prof_exp_other."',certificates='".$certificates."',submitted='".$submitted."' WHERE reg_id='".$reg_id."'";
$save4_result = mysql_query($save4_query) or die(mysql_error());
}
function submit_form(){
$reg_id = $_SESSION['reg_id'];
$name_applicant = addslashes($_POST['name_applicant']);
$name_father = addslashes($_POST['name_father']);
$permanent_address = addslashes($_POST['permanent_address']);
$present_address = addslashes($_POST['present_address']);
$mobile = addslashes($_POST['mobile']);
$phone_no = addslashes($_POST['phone_no']);
$dob = $_POST['dob'];
$dob = preg_replace('#(\d{2})/(\d{2})/(\d{4})#', '$3-$1-$2', $dob); //changing date format for mysql insertion..
$nationality = addslashes($_POST['nationality']);
$place_birth = addslashes($_POST['place_birth']);
$caste = addslashes($_POST['caste']);
for($i=0;$i<5;$i++)
{
$exam_name[$i] = (isset($_POST['exam'.$i.'_name'])?addslashes($_POST['exam'.$i.'_name']):"");
$exam_year[$i] = (isset($_POST['exam'.$i.'_year'])?addslashes($_POST['exam'.$i.'_year']):"");
$exam_percentage[$i] = (isset($_POST['exam'.$i.'_percentage'])?addslashes($_POST['exam'.$i.'_percentage']):"");
$exam_divn[$i] = (isset($_POST['exam'.$i.'_divn'])?addslashes($_POST['exam'.$i.'_divn']):"");
$exam_institute[$i] = (isset($_POST['exam'.$i.'_institute'])?addslashes($_POST['exam'.$i.'_institute']):"");
$exam_univ[$i] = (isset($_POST['exam'.$i.'_univ'])?addslashes($_POST['exam'.$i.'_univ']):"");
}
for($i=0;$i<5;$i++)
{
$post_name[$i] = (isset($_POST['post'.$i.'_name'])?addslashes($_POST['post'.$i.'_name']):"");
$post_from[$i] = (isset($_POST['post'.$i.'_from'])?addslashes($_POST['post'.$i.'_from']):"");
$post_to[$i] = (isset($_POST['post'.$i.'_to'])?addslashes($_POST['post'.$i.'_to']):"");
$post_total_year[$i] = (isset($_POST['post'.$i.'_total_year'])?addslashes($_POST['post'.$i.'_total_year']):"");
$post_total_month[$i] = (isset($_POST['post'.$i.'_total_month'])?addslashes($_POST['post'.$i.'_total_month']):"");
$post_institute[$i] = (isset($_POST['post'.$i.'_institute'])?addslashes($_POST['post'.$i.'_institute']):"");
$post_pay[$i] = (isset($_POST['post'.$i.'_pay'])?addslashes($_POST['post'.$i.'_pay']):"");
}
$national_paper_conf_count = addslashes($_POST['national_paper_conf_count']);
$national_paper_conf_desc = addslashes($_POST['national_paper_conf_desc']);
$international_paper_conf_presented_count = addslashes($_POST['international_paper_conf_presented_count']);
$international_paper_conf_presented_desc = addslashes($_POST['international_paper_conf_presented_desc']);
$no_paper_published_journal_national = addslashes($_POST['no_paper_published_journal_national']);
$no_paper_published_journal_international = addslashes($_POST['no_paper_published_journal_international']);
$no_paper_published_books = addslashes($_POST['no_paper_published_books']);
$no_paper_published_patents = addslashes($_POST['no_paper_published_patents']);
$no_phd_guided_sole = addslashes($_POST['no_phd_guided_sole']);
$no_phd_guided_supervisor = addslashes($_POST['no_phd_guided_supervisor']);
$no_projects_as_coordinator_sf_completed = addslashes($_POST['no_projects_as_coordinator_sf_completed']);
$no_projects_as_coordinator_sf_ongoing = addslashes($_POST['no_projects_as_coordinator_sf_ongoing']);
$no_projects_as_coordinator_s_completed = addslashes($_POST['no_projects_as_coordinator_s_completed']);
$no_projects_as_coordinator_s_ongoing = addslashes($_POST['no_projects_as_coordinator_s_ongoing']);
$dosubmit = date('Y-m-d');
$particulars_prof_exp_other = addslashes($_POST['particulars_prof_exp_other']);
$certificates = addslashes($_POST['certificates']);
$submitted = 1;
$submit1_query = "UPDATE user_info SET name_applicant = '".$name_applicant."',name_father = '".$name_father."',permanent_address = '".$permanent_address."',present_address = '".$present_address."',mobile = '".$mobile."',phone_no = '".$phone_no."',dob = '".$dob."',nationality = '".$nationality."',place_birth = '".$place_birth."',caste = '".$caste."' WHERE reg_id = '".$reg_id."' ";
$submit1_result = mysql_query($submit1_query) or die(mysql_error());
$submit2_query = "UPDATE user_exams SET exam1_name = '".$exam_name[0]."',exam1_year = '".$exam_year[0]."',exam1_percentage = '".$exam_percentage[0]."',exam1_divn = '".$exam_divn[0]."',exam1_institute = '".$exam_institute[0]."',exam1_univ = '".$exam_univ[0]."', exam2_name = '".$exam_name[1]."',exam2_year = '".$exam_year[1]."',exam2_percentage = '".$exam_percentage[1]."',exam2_divn = '".$exam_divn[1]."',exam2_institute = '".$exam_institute[1]."',exam2_univ = '".$exam_univ[1]."',exam3_name = '".$exam_name[2]."',exam3_year = '".$exam_year[2]."',exam3_percentage = '".$exam_percentage[2]."',exam3_divn = '".$exam_divn[2]."',exam3_institute = '".$exam_institute[2]."',exam3_univ = '".$exam_univ[2]."',exam4_name = '".$exam_name[3]."',exam4_year = '".$exam_year[3]."',exam4_percentage = '".$exam_percentage[3]."',exam4_divn = '".$exam_divn[3]."',exam4_institute = '".$exam_institute[3]."',exam4_univ = '".$exam_univ[3]."',exam5_name = '".$exam_name[4]."',exam5_year = '".$exam_year[4]."',exam5_percentage = '".$exam_percentage[4]."',exam5_divn = '".$exam_divn[4]."',exam5_institute = '".$exam_institute[4]."',exam5_univ = '".$exam_univ[4]."' WHERE reg_id = '".$reg_id."' ";
$submit2_result = mysql_query($submit2_query) or die(mysql_error());
$submit3_query = "UPDATE user_earlier_posts SET post1_name = '".$post_name[0]."',post1_from = '".$post_from[0]."',post1_to = '".$post_to[0]."',post1_total_year = '".$post_total_year[0]."',post1_total_month = '".$post_total_month[0]."',post1_pay = '".$post_pay[0]."',post2_name = '".$post_name[1]."',post2_from = '".$post_from[1]."',post2_to = '".$post_to[1]."',post2_total_year = '".$post_total_year[1]."',post2_total_month = '".$post_total_month[1]."',post2_pay = '".$post_pay[1]."',post3_name = '".$post_name[2]."',post3_from = '".$post_from[2]."',post3_to = '".$post_to[2]."',post3_total_year = '".$post_total_year[2]."',post3_total_month = '".$post_total_month[2]."',post3_pay = '".$post_pay[2]."',post4_name = '".$post_name[3]."',post4_from = '".$post_from[3]."',post4_to = '".$post_to[3]."',post4_total_year = '".$post_total_year[3]."',post4_total_month = '".$post_total_month[3]."',post4_pay = '".$post_pay[3]."',post5_name = '".$post_name[4]."',post5_from = '".$post_from[4]."',post5_to = '".$post_to[4]."',post5_total_year = '".$post_total_year[4]."',post5_total_month = '".$post_total_month[4]."',post5_pay = '".$post_pay[4]."' WHERE reg_id = '".$reg_id."'";
$submit3_result = mysql_query($submit3_query) or die(mysql_error());
$submit4_query = "UPDATE user_other_details SET national_paper_conf_count='".$national_paper_conf_count."', national_paper_conf_desc='".$national_paper_conf_desc."',international_paper_conf_presented_count='".$international_paper_conf_presented_count."',international_paper_conf_presented_desc='".$international_paper_conf_presented_desc."',no_paper_published_journal_national='".$no_paper_published_journal_national."', no_paper_published_journal_national='".$no_paper_published_journal_international."',no_paper_published_books='".$no_paper_published_books."', no_paper_published_patents='".$no_paper_published_patents."',no_phd_guided_sole='".$no_phd_guided_sole."',no_phd_guided_supervisor='".$no_phd_guided_supervisor."',no_projects_as_coordinator_sf_completed='".$no_projects_as_coordinator_sf_completed."',no_projects_as_coordinator_sf_ongoing='".$no_projects_as_coordinator_sf_ongoing."',no_projects_as_coordinator_s_completed='".$no_projects_as_coordinator_s_completed."',no_projects_as_coordinator_s_ongoing='".$no_projects_as_coordinator_s_ongoing."',particulars_prof_exp_other='".$particulars_prof_exp_other."',certificates='".$certificates."',submitted='".$submitted."', dosubmit='".$dosubmit."' WHERE reg_id='".$reg_id."'";
$submit4_result = mysql_query($submit4_query) or die(mysql_error());
}
if(isset($_GET['type']) && $_GET['type']=='save')
{
save_form();
}
elseif(isset($_GET['type']) && $_GET['type']=='submit')
{
submit_form();
}
else
{
echo "Invalid request. . .";
}
?>