This following given code is to make the address change request by student from his profile. Save the code with "changeaddress.php" name in student directory.
The code is given below :
<?php
include("../db.php");
include("../functions.php");
if (isset($_GET['edit']))
{ $enrolmentno = $_GET['edit']; }
$result = mysql_query("select name, address, city, state, pincode, program_code from program_details as pd, student_detail as sd where pd.enrolmentno = $enrolmentno and sd.enrolmentno = $enrolmentno");
$getresult = mysql_fetch_array($result);
$name = $getresult['name'];
$address = $getresult['address']."n";
$address .= $getresult['city']." - ";
$address .= $getresult['pincode'];
$pcode = $getresult['program_code'];
$result = mysql_query("select enrolmentno from student_request where enrolmentno = $enrolmentno");
$getresult = mysql_fetch_array($result);
if(isset($_POST['submit']))
{
$address = $_POST['add1'].$_POST['add2'].$_POST['add3'];
$city = $_POST['city'];
$state = $_POST['state'];
$pincode = $_POST['pin'];
if($getresult['enrolmentno'])
{
mysql_query("UPDATE student_request SET enrolmentno=$enrolmentno, address='$address', city='$city', state='$state',pincode=$pincode, address_status =1 WHERE enrolmentno=$enrolmentno");
}
else
{
echo "<script language='javascript'>alert('Enrolment Number Not Found.')</script>";
}
header("Location: successful.php?edit=$enrolmentno");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US">
<head>
<title>Welcome To Online Admission(Student Zone)</title>
<link rel="STYLESHEET" type="text/css" href="../styles/admission_form.css" />
<script Language="javascript">
function validate()
{
if(admission_form.add1.value=="")
{
alert("Address 1 must be filled.");
return false;
}
if(admission_form.city.value=="")
{
alert("City must be filled.");
return false;
}
if(admission_form.state.selectedIndex==0)
{
alert("State must be selected.");
return false;
}
return true;
}
</script>
</head>
<body >
<?php include("header.php");?>
<div class='mainDiv'>
<div><font size="4" name="sans-serif" color="white"><div class="heading" align="center"><b>Welcome To Distance Education University Online Admission Form</b></br>Student Zone</div></font></br></br>
<div align="center">
<form id='admission_form' action="" method="post">
<table>
<tr>
<td>
<label class='labels'>Name : </label>
</td>
<td>
<?php echo $name; ?>
</td>
</tr>
<tr>
<td>
<label class='labels'>Program Code : </label>
</td>
<td>
<?php echo $pcode; ?>
</td>
</tr>
<tr>
<td><label class='labels'>Full Address : </label></td>
<td><pre><?php echo $address; ?></pre></td>
</tr>
<tr><tr><td colspan=2><div>New Address to be change :</div></td></tr>
<td>
<label class='labels'>Address Line 1 : </label>
</td>
<td>
<input type="text" name="add1"><span class='required'>*</span>
</td>
</tr>
<tr>
<td>
<label class='labels'>Address Line 2 : </label>
</td>
<td>
<input type="text" name="add2">
</td>
</tr>
<tr>
<td>
<label class='labels'>Address Line 3 : </label>
</td>
<td>
<input type="text" name="add3">
</td>
</tr>
<tr>
<td>
<label class='labels'>City </label>
</td>
<td>
<input type="text" name="city"><span class='required'>*</span>
</td>
</tr>
<tr>
<td>
<label class='labels'>State : </label>
</td>
<td>
<select name="state">
<?php state(); ?>
</select><span class='required'>*</span>
</td>
</tr>
<tr>
<td>
<label class='labels'>Pincode</label>
</td>
<td>
<input type="text" name="pin"><span class='required'>*</span>
</td>
</tr>
<tr><td> </td></tr>
<tr>
<td colspan=3 align="center">
<input type="submit" name="submit" value="Submit" onclick="return validate();">
</td>
</tr>
</table>
</form>
</div>
</div></br>
<?php include("footer.php");?>
</body>
</html>
The code is given below :
<?php
include("../db.php");
include("../functions.php");
if (isset($_GET['edit']))
{ $enrolmentno = $_GET['edit']; }
$result = mysql_query("select name, address, city, state, pincode, program_code from program_details as pd, student_detail as sd where pd.enrolmentno = $enrolmentno and sd.enrolmentno = $enrolmentno");
$getresult = mysql_fetch_array($result);
$name = $getresult['name'];
$address = $getresult['address']."n";
$address .= $getresult['city']." - ";
$address .= $getresult['pincode'];
$pcode = $getresult['program_code'];
$result = mysql_query("select enrolmentno from student_request where enrolmentno = $enrolmentno");
$getresult = mysql_fetch_array($result);
if(isset($_POST['submit']))
{
$address = $_POST['add1'].$_POST['add2'].$_POST['add3'];
$city = $_POST['city'];
$state = $_POST['state'];
$pincode = $_POST['pin'];
if($getresult['enrolmentno'])
{
mysql_query("UPDATE student_request SET enrolmentno=$enrolmentno, address='$address', city='$city', state='$state',pincode=$pincode, address_status =1 WHERE enrolmentno=$enrolmentno");
}
else
{
echo "<script language='javascript'>alert('Enrolment Number Not Found.')</script>";
}
header("Location: successful.php?edit=$enrolmentno");
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US">
<head>
<title>Welcome To Online Admission(Student Zone)</title>
<link rel="STYLESHEET" type="text/css" href="../styles/admission_form.css" />
<script Language="javascript">
function validate()
{
if(admission_form.add1.value=="")
{
alert("Address 1 must be filled.");
return false;
}
if(admission_form.city.value=="")
{
alert("City must be filled.");
return false;
}
if(admission_form.state.selectedIndex==0)
{
alert("State must be selected.");
return false;
}
return true;
}
</script>
</head>
<body >
<?php include("header.php");?>
<div class='mainDiv'>
<div><font size="4" name="sans-serif" color="white"><div class="heading" align="center"><b>Welcome To Distance Education University Online Admission Form</b></br>Student Zone</div></font></br></br>
<div align="center">
<form id='admission_form' action="" method="post">
<table>
<tr>
<td>
<label class='labels'>Name : </label>
</td>
<td>
<?php echo $name; ?>
</td>
</tr>
<tr>
<td>
<label class='labels'>Program Code : </label>
</td>
<td>
<?php echo $pcode; ?>
</td>
</tr>
<tr>
<td><label class='labels'>Full Address : </label></td>
<td><pre><?php echo $address; ?></pre></td>
</tr>
<tr><tr><td colspan=2><div>New Address to be change :</div></td></tr>
<td>
<label class='labels'>Address Line 1 : </label>
</td>
<td>
<input type="text" name="add1"><span class='required'>*</span>
</td>
</tr>
<tr>
<td>
<label class='labels'>Address Line 2 : </label>
</td>
<td>
<input type="text" name="add2">
</td>
</tr>
<tr>
<td>
<label class='labels'>Address Line 3 : </label>
</td>
<td>
<input type="text" name="add3">
</td>
</tr>
<tr>
<td>
<label class='labels'>City </label>
</td>
<td>
<input type="text" name="city"><span class='required'>*</span>
</td>
</tr>
<tr>
<td>
<label class='labels'>State : </label>
</td>
<td>
<select name="state">
<?php state(); ?>
</select><span class='required'>*</span>
</td>
</tr>
<tr>
<td>
<label class='labels'>Pincode</label>
</td>
<td>
<input type="text" name="pin"><span class='required'>*</span>
</td>
</tr>
<tr><td> </td></tr>
<tr>
<td colspan=3 align="center">
<input type="submit" name="submit" value="Submit" onclick="return validate();">
</td>
</tr>
</table>
</form>
</div>
</div></br>
<?php include("footer.php");?>
</body>
</html>
0 Comments:
Post a Comment