» know results of ward

[insert_php]

$roll=isset($_GET[“roll_no”]) ? addslashes($_GET[“roll_no”]):””;
$dob=isset($_GET[“dob”]) ? addslashes($_GET[“dob”]):””;
?>

Roll Number:
DOB:
CLASS:


get_results(“SELECT * FROM student_result1 WHERE (roll_no = ‘”. $roll_no .”‘ AND dob = ‘”. $dob .”‘)”);

if(!$student)
{
echo “No Record Found”;
}

foreach($student as $row)
{
?>

SAINIK SCHOOL BIJAPUR
HALF YEARLY REPORT CARD (ACADEMIC SESSION-2017-18)
 ROLL NO roll_no; ?>  NAME student_name; ?>  CLASS class; ?>
SCHOLASTIC AREAS
 SUBJECT  PER TEST (10)  NOTE BOOK (5)  SUB ENRICHMENT (5)  HALF TEARLY (80)  MARKS OBTAINED (100)  GRADE
 ENGLISH  t1_pre_eng; ?>  t1_ntbk_eng; ?>  t1_suben_eng; ?>  t1_hfyr_eng; ?>  t1_total_eng; ?>  t1_grade_eng; ?>
 HINDI  t1_pre_hin; ?>  t1_ntbk_hin; ?>  t1_suben_hin; ?>  t1_hfyr_hin; ?>  t1_total_hin; ?>  t1_grade_hin; ?>
 KANNADA/ SANSKRI  t1_pre_ks; ?>  t1_ntbk_ks; ?>  t1_suben_ks; ?>  t1_hfyr_ks; ?>  t1_total_ks; ?>  t1_grade_ks; ?>
 MATHEMATICS  t1_pre_mat; ?>  t1_ntbk_mat; ?>  t1_suben_mat; ?>  t1_hfyr_mat; ?>  t1_total_mat; ?>  t1_grade_mat; ?>
 SCIENCE  t1_pre_sci; ?>  t1_ntbk_sci; ?>  t1_suben_sci; ?>  t1_hfyr_sci; ?>  t1_total_sci; ?>  t1_grade_sci; ?>
 SOCIAL SCIENCE  t1_pre_ssc; ?>  t1_ntbk_ssc; ?>  t1_suben_ssc; ?>  t1_hfyr_ssc; ?>  t1_total_ssc; ?>  t1_grade_ssc; ?>
 CO-SCHOLASTIC AREAS
 WORK EDUCATION  
 ART EDUCATION   
 HEALTH & PHYSICAL EDUCATION   
 DISCIPLINE  

get_results(“SELECT * FROM student_result2 WHERE (roll_no = ‘”. $roll_no .”‘ AND dob = ‘”. $dob .”‘)”);

if(!$student)
{
echo “No Record Found”;
}
foreach($student as $row)
{
?>

SAINIK SCHOOL BIJAPUR
(ACADEMIC SESSION-2017-18)
DETAILS OF MARKS OBTAINED PERIODIC TESTS
 Serial No. roll_no; ?>
 ROLL NO roll_no; ?>
 NAME OF THE CADET student_name; ?>
 HOUSE hse; ?>
 DOB dob; ?>
 CLASS class; ?>
 SUBJECT  MAXIMUM  FIRST PT  SECOND PT
 ENGLISH  40  pt1_eng; ?>  pt2_eng; ?>
 HINDI/SANSKRIT/KANNADA  40  pt1_hks; ?>  pt2_hks; ?>
 MATHEMATICS  40  pt1_math; ?>  pt2_math; ?>
 SCIENCE  40  pt1_sci; ?>  pt2_sci; ?>
 PHYSICS  13  pt1_phy; ?>  pt2_phy; ?>
 CHEMISTRY  14  pt1_che; ?>  pt2_che; ?>
 BIOLOGY  13  pt1_bio; ?>  pt2_bio; ?>
 SOCIAL SCIENCE  40  pt1_ssc; ?>  pt2_ssc; ?>
 HISTORY  23  pt1_his; ?>  pt2_his; ?>
 GEOGRAPHY  17  pt1_geo; ?>  pt2_geo; ?>
 NCC  40  pt1_ncc; ?>  pt2_ncc; ?>

get_results(“SELECT * FROM student_result3 WHERE (roll_no = ‘”. $roll_no .”‘ AND dob = ‘”. $dob .”‘)”);

if(!$student)
{
echo “No Record Found”;
}

foreach($student as $row)
{
?>

SAINIK SCHOOL BIJAPUR
HALF YEARLY REPORT CARD (ACADEMIC SESSION-2017-18)
 ROLL NO roll_no; ?>  NAME student_name; ?>  CLASS class; ?>
 
 SUBJECT  FIRST TERMINAL(40)  PREBOARD EXAM-1  PREBOARD EXAM-2  ANNUAL EXAMINATION
 ENGLISH  ft_eng; ?>  pe_eng; ?>  pe2_eng; ?>  ae_eng; ?>
 MATH  ft_math; ?>  pe_math; ?>  pe2_math; ?>  ae_math; ?>
 PHYSICS  ft_phy; ?>  pe_phy; ?>  pe2_phy; ?>  ae_phy; ?>
 CHEMISTRY  ft_che; ?>  pe_che; ?>  pe2_che; ?>  ae_che; ?>
 BIOLOGY / COMPUTER SCIENCE  ft_bio-cs; ?>  pe_bio-cs; ?>  pe2_bio-cs; ?>  ae_bio-cs; ?>
 TOTAL  ft_tot; ?>  pe_tot; ?>  pe2_tot; ?>  ae_tot; ?>


[/insert_php]