StudentDetails/edit.php at master · asangam/StudentDetails · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<?php
mysql_connect("localhost","root","");
mysql_select_db("college");

$edit_record=$_GET['edit'];
$query="select * from students where id='$edit_record'";
$run=mysql_query($query);
while($row=mysql_fetch_array($run))
{
	$edit_id=$row['id'];
	$s_name=$row['student_name'];
	$school_name=$row['school_name'];
	$roll_no=$row['roll_no']; //there are the name of the forms name after row
	$result=$row['result'];
}

 ?>

<html>
	<head>
		<title>Student Details</title>
	</head>
	<body>

		<form action="edit.php?edit_form=<?php echo $edit_id; ?>" method="post">
		<table border="44px" width="500px" align="center">
			<tr>
				<td colspan="2" bgcolor="teal">
				<h1>Update Student Details</h1>

				</td>
			</tr>

			<tr>
				<td>Student Name:</td>
				<td><input type="text" name="name" value="<?php echo $s_name ?>" ></td>
			</tr>

			<tr>
				<td>School Name:</td>
				<td><input type="text" name="school" value="<?php echo $school_name ?>"></td>
			</tr>

			<tr>
				<td>Roll No.</td>
				<td><input type="text" name="rollno" value="<?php echo $roll_no ?>"></td>
			</tr>

			<tr>
				<td>Result</td>
				<td><input type="text" name="result" value="<?php echo $result ?>"></td>
			</tr>

			<tr>
				<td colspan="2"> <input type="submit" name="update" value="Update Now">
				</td>
			</tr>

		</table>

		</form>
		</body>
		</html>

		<?php
			mysql_connect("localhost","root","");
			mysql_select_db("college");

			if(isset($_POST['update']))
			{
				$edit_id=$_GET['edit_form'];
				$name=$_POST['name'];
				$school=$_POST['school'];
				$roll=$_POST['rollno'];
				$result=$_POST['result'];

				$query1="update students set student_name='$name',school_name='$school',roll_no='$roll',result='$result' where id='$edit_id'";
				 if(mysql_query($query1))
				 {
				 	echo " <script>window.open('firstdbCollege.php','_self') </script>";
				 }
			}
		 ?>