student management

Student Admin


session_start();
if((!isset($_SESSION[‘stduid2’]))&&(!isset($_SESSION[‘stdpwd2’])))
{
header(‘Location: default.php’) ;
}
include_once(“bg.php”);
ob_start();

$wel=”You are Logged in as “;
echo $wel.$_SESSION[‘stduid2’];
echo “&nbsp”.”&nbsp”;
echo ‘‘;

 

 




Sri Shanmuka Matriculation Higher Secondary School

(Bypass School)

Student Management System

User-Id Password

if(isset($_POST[‘loger’]))
{
$uid = mysql_real_escape_string($_POST[‘uid’]);
$pwd = mysql_real_escape_string($_POST[‘pwd’]);
$result = mysql_query(“SELECT * FROM user WHERE eid=’$uid’ AND pwd=’$pwd'”);

if($row = mysql_fetch_array($result))
{
$_SESSION[‘stduid2’]=$row[‘eid’];//stores userid session
$_SESSION[‘stdpwd2’]=$row[‘pwd’];//stores password session
header(‘location:dashboard.php’);
}
else
{
echo ‘‘;
}
}

 

Master-Password

if(isset($_POST[‘master’]))
{
$s=$_SESSION[‘stduid2’];
$mpwd = mysql_real_escape_string($_POST[‘mpwd’]);
$result = mysql_query(“SELECT * FROM user WHERE eid=’$s’ AND mpwd=’$mpwd'”);

if($row = mysql_fetch_array($result))
{
$_SESSION[‘maspwd2’]=$row[‘mpwd’];//stores password session
header(‘location:enroll_name_del.php’);
}
else
{
echo ‘‘;
}
}


 

Edit by Admission number

ADMISSION NO.

Edit by Student Name

STUDENT NAME:

if(isset($_GET[‘editbyname’]))
{
$name=mysql_real_escape_string($_GET[‘name’]);
$sql = mysql_query(“SELECT * FROM stud_adm WHERE name LIKE ‘%$name%'”);
echo mysql_num_rows($sql);
echo ““.” result found”;
echo “

“;
echo “
“;
//And we display the results
while($row = mysql_fetch_assoc($sql))
{
echo “
“; $admno=$row[‘adm_no’]; echo “
“;
echo “
“;
echo “
“;
echo “
“;
}
echo “

Photo Admission No. Name More Details
“.”
“;
echo “
“.”
“.$row[‘adm_no’].”
“.”
“.$row[‘name’].”
“;
echo “
Edit details“;
echo “

 

“;
}
?>

echo “

“;
echo “”;
?>
 

Add/Change Photo


ADMISSION NO.
2.ADMSSION YEAR

3.TRANSFER CERTIFICATE

5.DATE OF BIRTH

1.NAME OF STUDENT
4.NAME OF THE VILLAGE/TOWN
6.GENDER

7.RELIGION
8.CASTE
9.COMMUNITY

 

10.LIVING WITH PARENTS/GUARDIAN

(a)Name of the father/Guardian
(b)Father/Guardian’s Educational Qualification & Occupation
(c)Full Address with Pin Code
(d)Contact No.

 

FOR OFFICE USE

11.CLASS


12.MEDIUM

13.GROUP

14.DATE OF ADMISSION
15.EMIS Number


if(isset($_POST[‘upd’]))
{
$adm_no=mysql_real_escape_string($_POST[‘adm_no’]);
$tc_issue=mysql_real_escape_string($_POST[‘tc_issue’]);
$year=mysql_real_escape_string($_POST[‘year’]);
$twnvill=mysql_real_escape_string($_POST[‘twnvill’]);
$dob=mysql_real_escape_string($_POST[‘dob’]);
$gen=mysql_real_escape_string($_POST[‘gen’]);
$religion=mysql_real_escape_string($_POST[‘religion’]);
$caste=mysql_real_escape_string($_POST[‘caste’]);
$comunit=mysql_real_escape_string($_POST[‘comunit’]);
$fname=mysql_real_escape_string($_POST[‘fname’]);
$f_ed_qua=mysql_real_escape_string($_POST[‘f_ed_qua’]);
$f_add_pin=mysql_real_escape_string($_POST[‘f_add_pin’]);
$ph_no=mysql_real_escape_string($_POST[‘ph_no’]);
$cls_adm=mysql_real_escape_string($_POST[‘cls_adm’]);
$cls_sec=mysql_real_escape_string($_POST[‘cls_sec’]);
$grop_adm=mysql_real_escape_string($_POST[‘grop_adm’]);
$med_adm=mysql_real_escape_string($_POST[‘med_adm’]);
$dat_adm=mysql_real_escape_string($_POST[‘dat_adm’]);
$emis_no=mysql_real_escape_string($_POST[’emis_no’]);

$sql=”UPDATE stud_adm SET tc_issue=’$tc_issue’,year=’$year’,twnvill=’$twnvill’,dob=’$dob’,gen=’$gen’,religion=’$religion’,caste=’$caste’,comunit=’$comunit’,fname=’$fname’,f_ed_qua=’$f_ed_qua’,
f_add_pin=’$f_add_pin’,ph_no=’$ph_no’,cls_adm=’$cls_adm’,cls_sec=’$cls_sec’,grop_adm=’$grop_adm’,med_adm=’$med_adm’,dat_adm=’$dat_adm’,emis_no=’$emis_no’ WHERE adm_no=’$adm_no'”;

$result= mysql_query($sql);

if($result)
{
echo “

 

Updated Successfully” ;
}
else
{
echo “Failed to Update”;
}
}
?>



$sql=”SELECT * FROM last_entry WHERE id=’1′”;
$result=mysql_query($sql);
if($row=mysql_fetch_array($result))
{
echo ‘Last Entry for Admission ‘;
echo “”;
echo “&nbsp”;
echo $row[‘adm_no’];
}
else
{
echo “Last Entry not Found”;
}


 

ADMISSION NO. STUDENT NAME

$sql=”SELECT * FROM last_entry WHERE id=’1′”;
$result=mysql_query($sql);
if($row=mysql_fetch_array($result))
{
echo ‘Last Entry for Admission ‘;
echo “”;
echo “&nbsp”;
echo $row[‘adm_no’];
}
else
{
echo “Last Entry not Found”;
}

 


 

ADMISSION NO.


if(isset($_GET[‘deleteconfirm’]))
{
$admno=$_GET[‘admno’];
$sql1=”DELETE FROM stud_id WHERE adm_no=’$admno'”;
$result1=mysql_query($sql1);

if($result1)
{
//Admission delete
$sql2=”DELETE FROM stud_adm WHERE adm_no=’$admno'”;
$result2=mysql_query($sql2);

//extra1
$sql5=”DELETE FROM extra1 WHERE adm_no=’$admno'”;
$result5=mysql_query($sql5);

//extra2
$sql6=”DELETE FROM extra2 WHERE adm_no=’$admno'”;
$result6=mysql_query($sql6);

//extra3
$sql7=”DELETE FROM extra3 WHERE adm_no=’$admno'”;
$result7=mysql_query($sql7);

echo “”;
echo “

 

“.”Deleted Successfully”.”

 

“;
echo ‘

‘;
}
else
{
echo “

“.”Failed to Delete/ Adminssion Number not Exists”.”

 

“;
echo ‘

‘;
echo ‘

‘;
}
}
else
{
echo “”;
echo “

 

“.”Unauthorized Entry”.”

 

“;
echo ‘

‘;
}
ob_end_flush();

?>


 

ADMISSION NO.


 

PHOTO NAME OF STUDENT


Class


  

}
else
{
echo “

 

“.”No Such Admission found”.”

 

“;
echo ‘

‘;
echo “”;
echo ‘

‘;
}
ob_end_flush();
?>

User-Id Password

if(isset($_POST[‘loger’]))
{
$uid = mysql_real_escape_string($_POST[‘uid’]);
$pwd = mysql_real_escape_string($_POST[‘pwd’]);
$result = mysql_query(“SELECT * FROM principal WHERE uid=’$uid’ AND pwd=’$pwd'”);

if($row = mysql_fetch_array($result))
{
$_SESSION[‘stduid’]=$row[‘uid’];//stores userid session
$_SESSION[‘stdpwd’]=$row[‘pwd’];//stores password session
header(‘location:dashboard.php’);
}
else
{
echo “

“.”Invalid Username or Password”.”
“;
}
}
?>
include_once(“bg.php”);
ob_start();
session_start();
if((!isset($_SESSION[‘stduid2’]))&&(!isset($_SESSION[‘stdpwd2’])))
{
header(‘Location: default.php’) ;
}

if(isset($_POST[‘enroll’]))
{
$admno=mysql_real_escape_string($_POST[‘admno’]);
$name=mysql_real_escape_string($_POST[‘name’]);
$sql1=”INSERT INTO stud_id(adm_no) VALUES(‘$admno’)”;

$result1 = mysql_query($sql1);
if($result1)
{
//Admission entry
$sql2=”INSERT INTO stud_adm(adm_no,name)
VALUES(‘$admno’,’$name’)”;
$result2 = mysql_query($sql2);

//Last Entry
$sql5=”UPDATE last_entry SET adm_no=’$admno’,name=’$name’ WHERE id=’1′”;
$result5 = mysql_query($sql5);

//extra1 entry
$sql6=”INSERT INTO extra1(adm_no,name)
VALUES(‘$admno’,’$name’)”;
$result6 = mysql_query($sql6);

//extra2 entry
$sql7=”INSERT INTO extra2(adm_no,name)
VALUES(‘$admno’,’$name’)”;
$result7 = mysql_query($sql7);

//extra3 entry
$sql8=”INSERT INTO extra3(adm_no,name)
VALUES(‘$admno’,’$name’)”;
$result8 = mysql_query($sql8);

echo “”;
echo “

 

“.”Enrolled Successfully”.”

 

“;
echo ‘

‘;
}
else
{
echo “”;
echo “

“.”Admission Number already Exists/ Invalid details”.”

 

“;
echo ‘

‘;
echo ‘

‘;
}
}
else
{
echo “”;
echo “

 

“.”Unauthorized Entry”.”

 

“;
echo ‘

‘;

}
ob_end_flush();

?>

if((!isset($_SESSION[‘stduid2’]))&&(!isset($_SESSION[‘stdpwd2’])))
{
echo “
“.””.”
“.””.”
“.””;
echo “

 

You are Logged out

 

“;
echo ‘

‘;
}
?>

if(isset($_POST[‘phupd’]))
{
$admno=mysql_real_escape_string($_POST[‘adm_no’]);
$photo = $_FILES[‘image’][‘name’];
$random_digit=rand(0000,9999);
$random_digits=rand(0000,9999);
$new_file_name=$random_digit.$random_digits. urlencode($photo);
$target= “images/student/”.$new_file_name;
$img=$new_file_name;
$sql=”UPDATE stud_adm SET img=’$img’ WHERE adm_no=’$admno'”;
$result= mysql_query($sql);
$immo=move_uploaded_file($_FILES[‘image’][‘tmp_name’],$target);
echo “

 

Photo Updated Successfully” ;
}
?>

 



 

Search by Admission number

ADMISSION NO.

Search by Student Name

STUDENT NAME:

if(isset($_GET[‘view’]))
{
$name=mysql_real_escape_string($_GET[‘name’]);
$cls_adm=mysql_real_escape_string($_GET[‘cls_adm’]);
$sql = mysql_query(“SELECT * FROM stud_adm WHERE name LIKE ‘%$name%’ AND cls_adm=’$cls_adm'”);
echo mysql_num_rows($sql);
echo ““.” result found”;
echo “

“;
echo “
“;
//And we display the results
while($row = mysql_fetch_assoc($sql))
{
echo “
“; $admno=$row[‘adm_no’]; echo “
“;
echo “
“;
echo “
“;
echo “
“;
echo “
“;
}
echo “

Photo Admission No. Name Class More Details
“.”
“;
echo “
“.”
“.$row[‘adm_no’].”
“.”
“.$row[‘name’].”
“.”
“.$row[‘cls_adm’].”&nbsp'”.$row[‘cls_sec’].”‘
“;
echo “
View More“;
echo “

 

“;
}
?>

 


echo “
“;
echo “

“;
?>

ADMISSION NO.
 

2.ADMSSION YEAR


3.TRANSFER CERTIFICATE


5.DATE OF BIRTH

1.NAME OF STUDENT
4.NAME OF THE VILLAGE/TOWN
6.GENDER

7.RELIGION
8.CASTE
9.COMMUNITY

 

10.LIVING WITH PARENTS/GUARDIAN

(a)Name of the father/Guardian
(b)Father/Guardian’s Educational Qualification & Occupation
(c)Full Address with Pin Code
(c)Contact No.

 

FOR OFFICE USE

11.CLASS ADMITTED

&nbsp
12.MEDIUM

13.GROUP

14.DATE 15.EMIS number

Wallpapers for Desktop with yellow, bcolors, pictures, background, colour, gallery, abstract

Wallpapers for Desktop with yellow, bcolors, pictures, background, colour, gallery, abstract

Pin It on Pinterest