Student performance management system-PHP Tutorial-php.cn

Student performance management system

WBOY

Release： 2016-07-25 09:09:53

Original

1585 people have browsed it

Basic functions: 1. Realize the maintenance of students’ basic information (add, delete and modify); 2. Realize the maintenance of course information (add, delete and modify); 3. Realize the management of course selection (course selection, withdrawal); 4. Realize the performance management (entry), Statistics on student and course average grades

$conn=mysql_connect("localhost","root","123456") or die('Connection failed'); //Connect to the server
mysql_select_db("YGGL",$conn) or die('Failed to connect to database'); //Select database
mysql_query("SET NAMES 'gb2312'"); //Set character set
$Number=@$_GET['Number']; //Get number
$Name =@$_GET['Name']; //Get the name
$Depart=@$_GET['Depart']; //Get the department name
//The getsql function that generates the query statement
function getsql($Num,$Na ,$Dep)
{
$sql="select * from Employees where ";
$note=0;
if($Num)
{
//If the number is filled in, set the query conditions after the where clause
$ sql.="EmployeeID like '%$Num%'";
$note=1;
}
if($Na)
{
//If the name is filled in, connect the query conditions after $sql
if($note ==1)
$sql.=" and Name like '%$Na%'";
else
$sql.="Name like '%$Na%'";
$note=1;
}
if( $Dep&&($Dep!="All Departments"))
{
if($note==1)
$sql.=" and DepartmentID=(select DepartmentID from Departments
where DepartmentName='$Dep')";
else
{
$sql.="DepartmentID=(select DepartmentID from Departments
where DepartmentName='$Dep')";
$note=1;
}
}
if($note==0)
{
/ /If no conditions are set, query all records
$sql="select * from Employees";
}
return $sql; //Return SQL statement
}
$sql=getsql($Number,$Name,$Depart ); //Get the query statement
$result=mysql_query($sql);
$total=mysql_num_rows($result);
$page=isset($_GET['page'])?$_GET['page']: 1; //Get the value of page in the address bar, if it does not exist, set it to 1
$num=5; //Display 5 records per page
$url='8_1.php'; //URL of this page
// Page number calculation
$pagenum=ceil($total/$num); //Get the total page number, which is also the last page
$page=min($pagenum,$page); //Get the home page
$prepg=$page- 1; //Previous page
$nextpg=($page==$pagenum? 0: $page+1); //Next page
$new_sql=$sql." limit ".($page-1)* $num.",".$num; //Query statement to find $num records
$new_result=mysql_query($new_sql);
if($new_row=mysql_fetch_array($new_result))
{
//If there is a query As a result, employee information will be output in table form
echo "

Employee information query results echo "";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
do
{
list($number,$name,$edu ,$birthday,$sex,$workyear,$phone,$add,$depid)=$new_row;
//SQL statement to find department name
$d_sql="select DepartmentName from Departments where DepartmentID=$depid"; $d_result =mysql_query($d_sql);
$d_row=mysql_fetch_row($d_result);
echo "
"; //Output number
echo "
"; //Output academic qualifications
if($sex=='1')
echo "
";
$timeTemp=strtotime($birthday); //Parse the date and time into a UNIX timestamp
$date=date("Y-n-j" ,$timeTemp); //Use the date function to convert the time into "year-month-day" format
echo "
"; //Output the date of birth
echo "
"; //Output the name of the department
echo "
";
}while($new_row=mysql_fetch_array($new_result));
echo "

number
echo "
Name Education Gender Date of Birth Department

$number $name< /td>"; //Output name
echo "
$edu Male";
else

echo "
Female $date $ d_row[0]

";
//Start paging navigation bar code
$pagenav="";
if($prepg)
$pagenav.="< ;a href='$url?page=$prepg&Number=$Number&Name=$Name&Depart=$Depart'>
Previous page ";
for($i=1;$i<=$pagenum; $i++)
{
if($page==$i) $pagenav.=$i." ";
else
$pagenav.="