if($_POST["do"]=="update") { $roll=$_POST["roll"]; $answer=$_POST["answer"]; $name=$_POST["name"]; $result=$_POST["result"]; $gpa1=$_POST["gpa1"]; $gpa2=$_POST["gpa2"]; $gpa3=$_POST["gpa3"]; $gpa4=$_POST["gpa4"]; $gpa5=$_POST["gpa5"]; $gpa6=$_POST["gpa6"]; $gpa7=$_POST["gpa7"]; $value1=$_POST["value1"]; $value2=$_POST["value2"]; $value3=$_POST["value3"]; $value4=$_POST["value4"]; $value5=$_POST["value5"]; $value6=$_POST["value6"]; $value7=$_POST["value7"]; $cgpa=$_POST["cgpa"]; $status=$_POST["status"]; $query="update student33 set name='$name',answer='$answer',result='$result',gpa1='$gpa1',gpa2='$gpa2',gpa3='$gpa3',gpa4='$gpa4',gpa5='$gpa5',gpa6='$gpa6',gpa7='$gpa7',value1='$value1',value2='$value2',value3='$value3',value4='$value4',value5='$value5',value6='$value6',value7='$value7',cgpa='$cgpa',status='$status' where roll=$roll"; mysql_query($query); echo "
Successfully Updated in DATABASE
"; include("search16.php"); } ?>
Student Database
$roll=$_GET["roll"]; $query="select * from student33 where roll='$roll'"; $result=mysql_query($query); while ($row = mysql_fetch_array($result)) { ?>
ADD STUDENT RECORD
Full Name
Adm No
Session
Input tutorial
FIRST SEMESTER YEAR ONE
S/NO
COURSE CODE
COURSE TITLE
UNIT
GRADE
GRADE POINT
1
COM 211
SCIENTIFIC PROGRAMMING LANGUAGE USING OO JAVA
6
2
COM 212
INTRODUCTION TO THE INTERNET
4
3
COM 213
COMPUTER APPLICATION PACKAGES I
6
4
COM 214
DATA STRUCTURE AND ALGORITHMS
4
5
COM 215
INTRODUCTION TO SYSTEM ANALYSIS
3
6
COM 216
PC UPGRADE AND MAINTAINANCE
6
7
OTM 217
CITIZENSHIP EDUCATION II
2
TOTAL UNITS
31
TOTAL GP
GPA to Date
CGPA to Date
STATUS
} ?>
Go Back to Home