student_edit.php

<?php include("session_start.php"); ?>

<?php include("student_authenticate.php"); ?>

<?php

// form submited code
if(isset($_POST['student_id']))
{	
	include('db_connection.php');
  
	$sql = "UPDATE student SET " . 
		"   login = '" . $_POST['login'] . 
		"', password = '" . $_POST['password'] . 
		"', name = '" . $_POST['name'] . 
		"' WHERE student_id = " . $_POST['student_id'] . " LIMIT 1;"; 

	//echo '<br />sql = ' . $sql . '<br />';
	//exit;

	if(!mysql_query($sql))
	{
		if(mysql_errno() == 1062) // rec exists
		{
			//print 'Record already exists for "' . $_REQUEST['txtFullName'] . '"';
			$_SESSION['msg'] = 'Record already exists with this login: ' . $_POST['login'];
		}
		else
		{
			$_SESSION['msg'] = mysql_errno() . '<br />Error: ' . mysql_error();
		}
	} // if(!mysql_query($sql))
	else
	{
		$_SESSION['msg'] =  'Record updated successfully.';
	}

	$_GET['student_id'] = $_POST['student_id'];

	//mysql_close($con);
	//echo "<br>end";
}


// else code
if(isset($_GET['student_id']))
{
	include('db_connection.php');
  
	$sql = 'SELECT * FROM student WHERE student_id = ' . $_GET['student_id'];
	$result = mysql_query($sql);

	//echo '<br />sql = ' . $sql . '<br />';
	//exit;

	$row = mysql_fetch_array($result);

	//mysql_close($con);
	//echo "<br>end";
}

?>

<?php include("top.php"); ?>

<?php include("student_submenu.php"); ?>

<div id="contenttext">

<div style="padding:10px">
<span class="titletext">Edit Student</span> </div>

<div class="bodytext" style="padding:12px;" align="justify">
<strong>Edit Student</strong>
<p>Here we will edit Student.</p>

<table align="center" border="1">
<form action="student_edit.php" method="post">
<tr>
	<td><strong>Student ID:</strong>		</td>
	<td>
		<?php echo $row['student_id'];?> &nbsp;
		<input type="hidden" name="student_id" value="<?php echo $row['student_id'];?>"  />
	</td>
</tr>
<tr><td><strong>Login:</strong>		</td><td><input type="text" name="login" value="<?php echo $row['login'];?>" /> 		</td></tr>
<tr><td><strong>Password:</strong>	</td><td><input type="password" name="password" value="<?php echo $row['password'];?>" />	</td></tr>
<tr><td><strong>Name:</strong>		</td><td><input type="text" name="name" value="<?php echo $row['name'];?>" />	</td></tr>
<tr><td align="center">
	<input type="button" value="Back" onclick="location.href = 'student_main.php';"/> 
</td><td align="center" />
	<input type="submit" value="Update" />
	<input type="reset" />
</td></tr>
</form>
</table>

</div>
</div>

<?php include("bottom.php"); ?>