Viewing file:  studentedit_registration.php (19.09 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php include ('serialno.php'); ?>
<?php
include('session.php');
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Student Admission Form</title>
</head>
<center>
<body>
<table width="823" border="0" cellspacing="0" cellpadding="0" bgcolor="#CCCCCC">
<tr>
<td colspan="4" bgcolor="#FFFF00"><?php include('header.php'); ?></td>
</tr>
<tr>
<td colspan="4" bgcolor="#FFFF00"><?php include('menubar.php'); ?></td>
</tr>
</table>
<form action="" method="get" name="form">
Enter Student Registration No:
<input type="text" name="q" />
<input type="submit" name="Submit" value="Search" />
</form>
<form id="form1" name="form1" method="post" action="registration_edit.php" enctype="multipart/form-data" >
<?php
// Get the search variable from URL
$var = @$_GET['q'] ;
$trimmed = trim($var); //trim whitespace from the stored variable
// rows to return
$limit=10;
// check for an empty string and display a message.
if ($trimmed == "")
{
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
mysql_connect("localhost","ailwssor_user","rb!ail838"); //(host, username, password)
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("ailwssor_database") or die("Unable to select database"); //select which database we're using
$field = 'lesarno';
// Build SQL Query
$query = "select * from student_admission where $field like \"$trimmed\"
order by $field"; // EDIT HERE and specify your table and field names for the SQL query
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
// If we have no results, offer a google search as an alternative
if ($numrows == 0)
{
echo " Sorry, $trimmed this Number is not found";
}
// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
// begin to show results set
$count = 1 + $s ;
// now you can display the results returned
while ($row= mysql_fetch_array($result))
{
echo "<input name=\"id\" type=\"hidden\" required=\"required\" id=\"id\" accesskey=\"1\" readonly=\"readonly\" value='$row[ID]' />";
echo "<table width=\"946\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\" bgcolor='#CCCCCC'>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td width=\"144\" bgcolor=\"#33FF33\">Serial No</td>\n";
echo " <td width=\"306\"><input name='serial' type=\"text\" required=\"required\" id='serial' accesskey=\"1\" readonly=\"readonly\" value='$row[serialno]' />\n";
echo " <input name=\"feeserial\" type=\"hidden\" required=\"required\" id=\"feeserial\" accesskey=\"1\" readonly=\"readonly\" value=\"$row[serialno]\" />\n";
echo " \n";
echo " </td>\n";
echo " <td width=\"135\" bgcolor=\"#33FF33\">Lesar No</td>\n";
echo " <td width=\"335\"><input type=\"text\" name='lesorno' id=\"lesorno\" tabindex=\"1\" value=\"$row[lesarno]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Subject 1</td>\n";
echo " <td><select name=\"subject1\" id=\"subject1\" tabindex=\"2\" selected='$row[subjec1]' required=\"required\" >\n";
echo " <option value='$row[subject1]' selected>$row[subject1]</option>\n";
echo " <option>HINDI</option>\n";
echo " <option>SANSKRIT</option>\n";
echo " <option >SOCIOLOGY</option>\n";
echo " <option>GEOGRAPHY</option>\n";
echo " <option>HOME SCIENCE</option>\n";
echo " <option>MILITRY SCIENCE</option>\n";
echo " <option>PSYCHOLOGY</option>\n";
echo " <option>NSS</option>\n";
echo " <option>NTT</option>\n";
echo " <option>CCC</option>\n";
echo " <option>BOMBAY ART</option>\n";
echo " </select></td>\n";
echo " <td bgcolor=\"#33FF33\">Admission Date</td>\n";
echo " <td><input type=\"text\" name='date' id='date' value=\"$row[tdate]\" tabindex=\"5\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Subject 2</td>\n";
echo " <td><select name=\"subject2\" id=\"subject2\" tabindex=\"3\" required=\"required\">\n";
echo " <option value='$row[subject2]' selected>$row[subject2]</option>\n";
echo " <option value='HINDI'>HINDI</option>\n";
echo " <option value='SANSKRIT'>SANSKRIT</option>\n";
echo " <option value='SOCIOLOGY'>SOCIOLOGY</option>\n";
echo " <option value='GEOGRAPHY' >GEOGRAPHY</option>\n";
echo " <option value='HOME SCIENCE'>HOME SCIENCE</option>\n";
echo " <option>MILITRY SCIENCE</option>\n";
echo " <option>PSYCHOLOGY</option>\n";
echo " <option>NSS</option>\n";
echo " <option>NTT</option>\n";
echo " <option>CCC</option>\n";
echo " <option>BOMBAY ART</option>\n";
echo " </select></td>\n";
echo " <td bgcolor=\"#33FF33\">Class</td>\n";
echo " <td><input type=\"text\" name=\"class\" id=\"class\" tabindex=\"6\" value='$row[class]'></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Subject 3</td>\n";
echo " <td><select name=\"subject3\" id=\"subject3\" tabindex=\"4\" required=\"required\" value=\"$row[subjec3]\">\n";
echo " <option value='$row[subject3]' selected>$row[subject3]</option>\n";
echo " <option>HINDI</option>\n";
echo " <option>HINDI</option>\n";
echo " <option>SANSKRIT</option>\n";
echo " <option>SOCIOLOGY</option>\n";
echo " <option>GEOGRAPHY</option>\n";
echo " <option>HOME SCIENCE</option>\n";
echo " <option>MILITRY SCIENCE</option>\n";
echo " <option>PSYCHOLOGY</option>\n";
echo " <option>NSS</option>\n";
echo " <option>NTT</option>\n";
echo " <option>CCC</option>\n";
echo " <option>BOMBAY ART</option>\n";
echo " </select></td>\n";
echo " <td bgcolor=\"#33FF33\">Date of Birth</td>\n";
echo " <td><input type=\"text\" name=\"dob\" id=\"dob\" tabindex=\"7\" value=\"$row[dob]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'> \n";
echo " <td bgcolor=\"#33FF33\">Subject (Optional)</td>\n";
echo " <td><input name=\"subject\" type=\"text\" id=\"subject\" accesskey=\"6\" tabindex=\"8\" size=\"40\" maxlength=\"40\" value=\"$row[subject]\"/></td>\n";
echo " <td bgcolor=\"#33FF33\">Year</td>\n";
echo " <td><select name=\"year\" id=\"year\" tabindex=\"9\">\n";
echo " <option>$row[cyear]</option>\n";
echo " <option>1YEAR</option>\n";
echo " <option>2YEAR</option>\n";
echo " <option>3YEAR</option>\n";
echo " </select></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Student Name</td>\n";
echo " <td><input name=\"studentname\" type=\"text\" id=\"studentname\" accesskey=\"8\" tabindex=\"10\" size=\"40\" maxlength=\"50\" value=\"$row[stduentname]\"/></td>\n";
echo " <td bgcolor=\"#33FF33\">Father's Name</td>\n";
echo " <td><input name=\"fathername\" type=\"text\" id=\"fathername\" accesskey=\"9\" tabindex=\"11\" size=\"40\" maxlength=\"50\" required=\"required\" value=\"$row[studentfathername]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Mother's Name</td>\n";
echo " <td><input name=\"mothername\" type=\"text\" id=\"mothername\" accesskey=\"10\" tabindex=\"12\" size=\"40\" maxlength=\"50\" required=\"required\" value=\"$row[studentmothername]\"/></td>\n";
echo " <td bgcolor=\"#33FF33\">Domicile Certificate</td>\n";
echo " <td><input type=\"text\" name=\"domicile\" id=\"domicile\" accesskey=\"11\" tabindex=\"13\" value=\"$row[domicileno]\" /></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Caste Certificate</td>\n";
echo " <td><input type=\"text\" name=\"castecertificate\" id=\"castecertificate\" accesskey=\"14\" tabindex=\"14\" value=\"$row[casteno]\" /></td>\n";
echo " <td bgcolor=\"#33FF33\">Income Certificate</td>\n";
echo " <td><input type=\"text\" name=\"incomecertificate\" id=\"incomecertificate\" accesskey=\"15\" tabindex=\"15\" value=\"$row[incomeno]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Category</td>\n";
echo " <td><select name=\"castename\" id=\"castename\" required=\"required\" tabindex=\"16\" >\n";
echo " <option>GENERAL</option>\n";
echo " <option>OBC</option>\n";
echo " <option>SC</option>\n";
echo " <option>ST</option>\n";
echo " <option>MINORITY</option>\n";
echo " </select>\n";
echo " </td>\n";
echo " <td bgcolor=\"#33FF33\">Sub Caste</td>\n";
echo " <td><input type=\"text\" name=\"subcaste\" id=\"subcaste\" required=\"required\" tabindex=\"17\" value=\"$row[maincaste]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Bank Name</td>\n";
echo " <td><input type=\"text\" name=\"bankname\" id=\"bankname\" accesskey=\"14\" tabindex=\"18\" value=\"$row[bankname]\"/></td>\n";
echo " <td bgcolor=\"#33FF33\">Branch Name</td>\n";
echo " <td><input type=\"text\" name=\"branchname\" id=\"branchname\" accesskey=\"15\" tabindex=\"19\" value=\"$row[branchname]\" /></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Account No</td>\n";
echo " <td><input name=\"accountno\" type=\"text\" id=\"accountno\" accesskey=\"16\" tabindex=\"20\" value=\"$row[accountno]\" /></td>\n";
echo " <td bgcolor=\"#33FF33\">Mobile No</td>\n";
echo " <td><input type=\"text\" name=\"mobileno\" id=\"mobileno\" accesskey=\"17\" tabindex=\"21\" value=\"$row[mobileno]\" /></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Address</td>\n";
echo " <td bgcolor=\"#CCCCCC\"><input type=\"text\" name='address' cols=\"40\" id=\"address\" required=\"required\" value=\"$row[address]\" tabindex=\"22\" />";
echo " <td bgcolor=\"#33FF33\">Gender</td>\n";
echo " <td><select name=\"gender\" id=\"gender\" tabindex=\"23\">\n";
echo " <option>$row[gender]</option>\n";
echo " <option>MALE</option>\n";
echo " <option>FEMALE</option>\n";
echo " </select></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Fees</td>\n";
echo " <td><input type=\"text\" name=\"totalfees\" id=\"totalfees\" tabindex=\"24\" value=\"$row[total_fees]\" disabled='disabled' /></td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td colspan=\"4\">Education Qualification</td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td colspan=\"4\"><table width=\"935\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\n";
echo " <tr align='left' valign='top'>\n";
echo " <td width=\"182\" bgcolor=\"#FFFF00\">Examination</td>\n";
echo " <td width=\"60\" bgcolor=\"#FFFF00\">Year</td>\n";
echo " <td width=\"240\" bgcolor=\"#FFFF00\">School Name</td>\n";
echo " <td width=\"144\" bgcolor=\"#FFFF00\">Board Name</td>\n";
echo " <td width=\"90\" bgcolor=\"#FFFF00\">Roll No</td>\n";
echo " <td width=\"87\" bgcolor=\"#FFFF00\">Obtained Mark</td>\n";
echo " <td width=\"88\" bgcolor=\"#FFFF00\">Total Mark</td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">High School</td>\n";
echo " <td><input name=\"hyear\" type=\"text\" id=\"hyear\" accesskey=\"18\" tabindex=\"25\" size=\"10\" maxlength=\"10\" value=\"$row[hyear]\" /></td>\n";
echo " <td><input name=\"schoolname\" type=\"text\" id=\"schoolname\" accesskey=\"19\" tabindex=\"26\" size=\"40\" value=\"$row[hschooname]\"/></td>\n";
echo " <td><input name=\"hboardname\" type=\"text\" id=\"hboardname\" accesskey=\"20\" tabindex=\"27\" value=\"UP BOARD\" value=\"$row[hboardame]\" /></td>\n";
echo " <td><input name=\"hrollno\" type=\"text\" id=\"hrollno\" accesskey=\"20\" tabindex=\"28\" size=\"15\" maxlength=\"15\" value=\"$row[hrollno]\"/></td>\n";
echo " <td><input name=\"obtainedmarks\" type=\"text\" id=\"obtainedmarks\" accesskey=\"21\" tabindex=\"29\" size=\"10\" maxlength=\"10\" value=\"$row[htotalno]\"/></td>\n";
echo " <td><input name=\"totalmarks\" type=\"text\" id=\"totalmarks\" tabindex=\"30\" size=\"8\" maxlength=\"8\" value=\"$row[htotalno]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Intemediate</td>\n";
echo " <td><input name=\"intyear\" type=\"text\" id=\"intyear\" accesskey=\"23\" tabindex=\"31\" size=\"10\" maxlength=\"10\" value=\"$row[inyear]\"/></td>\n";
echo " <td><input name=\"intschoolname\" type=\"text\" id=\"intschoolname\" accesskey=\"24\" tabindex=\"32\" size=\"40\" maxlength=\"40\" value=\"$row[inschoolname]\"/></td>\n";
echo " <td><input name=\"intbaordname\" type=\"text\" id=\"intbaordname\" tabindex=\"33\" value=\"UP BOARD\" value=\"$row[inboardname]\"/></td>\n";
echo " <td><input name=\"introllno\" type=\"text\" id=\"introllno\" tabindex=\"34\" size=\"15\" maxlength=\"15\" value=\"$row[inrollno]\"/></td>\n";
echo " <td><input name=\"intobtainedmarks\" type=\"text\" id=\"intobtainedmarks\" tabindex=\"35\" size=\"10\" maxlength=\"10\" value=\"$row[inobtainno]\" /></td>\n";
echo " <td><input name=\"inttotlamarks\" type=\"text\" id=\"inttotlamarks\" tabindex=\"36\" size=\"8\" maxlength=\"8\" value=\"$row[intotalno]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Graduation Frist Year</td>\n";
echo " <td><input name=\"graducationyear\" type=\"text\" id=\"graducationyear\" tabindex=\"37\" size=\"10\" maxlength=\"10\" value=\"$row[firstyear]\"/></td>\n";
echo " <td><input name=\"graducationschoolname\" type=\"text\" id=\"graducationschoolname\" tabindex=\"38\" value=\"RMMC Kajha Mau\" size=\"40\" maxlength=\"40\" value=\"$row[firstschool]\"/></td>\n";
echo " <td><input name=\"graducationuniv\" type=\"text\" id=\"graducationuniv\" tabindex=\"39\" value=\"VBSPU JAUNPUR\"value=\"$row[firstboard]\" /></td>\n";
echo " <td><input name=\"graducaitonrollno\" type=\"text\" id=\"graducaitonrollno\" tabindex=\"40\" size=\"15\" maxlength=\"15\" value=\"$row[firstrollno]\"/></td>\n";
echo " <td><input name=\"graducationobtainmarks\" type=\"text\" id=\"graducationobtainmarks\" tabindex=\"41\" size=\"10\" maxlength=\"10\" value=\"$row[firstobtainno]\"/></td>\n";
echo " <td><input name=\"graduationtotalmarks\" type=\"text\" id=\"graduationtotalmarks\" tabindex=\"42\" size=\"8\" value=\"$row[firsttotalno]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Graducation Second Year</td>\n";
echo " <td><input name=\"gradsecondyear\" type=\"text\" id=\"gradsecondyear\" tabindex=\"43\" size=\"10\" maxlength=\"10\" value=\"$row[secondyear]\"/></td>\n";
echo " <td><input name=\"gradsecondschool\" type=\"text\" id=\"gradsecondschool\" tabindex=\"44\" value=\"RMMC Kajha Mau\" size=\"40\" maxlength=\"40\"value=\"$row[secondschool]\" /></td>\n";
echo " <td><input name=\"gradsecondboard\" type=\"text\" id=\"gradsecondboard\" tabindex=\"45\" value=\"VBSPU JAUNPUR\" value=\"$row[secondboard]\"/></td>\n";
echo " <td><input name=\"graducationsecondroll\" type=\"text\" id=\"graducationsecondroll\" tabindex=\"46\" size=\"15\" value=\"$row[secondrollno]\"/></td>\n";
echo " <td><input name=\"gradsecondobt\" type=\"text\" id=\"gradsecondobt\" tabindex=\"47\" size=\"10\" value=\"$row[secondobtianno]\"/></td>\n";
echo " <td><input name=\"gradsecondtotal\" type=\"text\" id=\"gradsecondtotal\" size=\"8\" maxlength=\"\" tabindex=\"48\" value=\"$row[secondtotalno]\"/></td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Rashtraya Gaurav No</td>\n";
echo " <td colspan=\"2\"><input type=\"text\" name=\"rashno\" id=\"rashno\" tabindex=\"49\" value=\"$row[rashno]\" /></td>\n";
echo " <td><img border='2' width='80' height='100' src=files/".$row['photo_upload']." ></td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\">Pariyawaran No</td>\n";
echo " <td colspan=\"2\"><input type=\"text\" name=\"parino\" id=\"parino\" tabindex=\"50\" value=\"$row[parino]\"/></td>\n";
echo " <td>
</td>\n";
echo " <td colspan=\"3\">\n";
echo " </td>\n";
echo " </tr>\n";
echo " <tr align='left' valign='top'>\n";
echo " <td bgcolor=\"#33FF33\"></td>\n";
echo " <td colspan=\"2\"></td>\n";
echo " <td><input type='submit' name='update' id='update' value='Submit' /></td>\n";
echo " <td colspan=\"3\">\n";
echo " \n";
echo " \n";
echo " </td>\n";
echo " </tr>\n";
echo " </table></td>\n";
$count++ ;
}
$currPage = (($s/$limit) + 1);
//break before paging
echo "";
// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print "<a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
Prev 10</a> ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
?>
</form>
</body></center>
</html>
|