selectcourse.php.bak

简单实现网上选课

<?php
session_start();
include("config.php");
$Stu_id = $HTTP_SESSION_VARS[studentid];
$id1=$_GET["id"];
//echo $Stu_id;
//echo $id;

$query = "Select * from Info_student where Student_id ='$Stu_id'";
$result = mysql_query($query); 
list($Student_name,$Student_id,$Dept,$Major,$sex,$class) = mysql_fetch_array($result);

$query1 = "Select * from Info_course where Course_id ='$id1'";
$result1 = mysql_query($query1); 
list($Course_id,$Course_name) = mysql_fetch_array($result1);
//echo $Course_id;
//echo $Course_name;

	$query2 = "INSERT INTO selected (Stu_name, Stu_id, Dept,class,Major,Course_name,Course_id) VALUES ('$Student_name','$Stu_id','$Dept','$class','$Major','$Course_name','$Course_id')";   
	$result2 = mysql_query($query2); 
	if(!$result2) echo "选课错误";

	$query3 = "SELECT CollectedMan,Capacity from Info_course where Course_id ='$id1'";
	$result3 = mysql_query($query3); 
    if($row["CollectedMan"]<=$row["Capacity"]) {
	   $query4 = "UPDATE Info_course SET CollectedMan = CollectedMan + 1 where Course_id ='$id1'";
	   $result4 = mysql_query($query4); 
	   if($result4)   header("Location: selectedsuc.php");
	  }
	else echo "对不起,该课程容纳人数已满!您不能选修该课程!";

?>