Viewing file:  charactercertificate.php (13.76 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php include ('serialno.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('menubar.php'); ?></td>
</tr>
</table>
<form action="" method="get" name="form">
Enter Account 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">
<?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 = 'serialno';
// 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))
{
$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>
<table width="823" border="0" cellspacing="0" cellpadding="0" bgcolor="#CCCCCC">
<tr>
<td width="823" colspan="4" align="center"></td>
</tr>
<tr>
<td colspan="4" bgcolor="#FFFF00"</td>
</tr>
<tr>
<td colspan="4" bgcolor="#FFFF00"></td>
</tr>
<tr>
<td colspan="4" align="left" valign="top">
<table width="855" border="0" cellspacing="2" cellpadding="2">
<tr>
<td bgcolor="#33FF33"> </td>
<td colspan="3" rowspan="2"> </td>
</tr>
<tr>
<td bgcolor="#33FF33"> </td>
</tr>
<tr>
<td width="147" bgcolor="#33FF33">Serial No</td>
<td width="307"><input name="serial" type="text" required="required" id="serial" accesskey="1" readonly="readonly" value="<?php '$row[serialno]' ?>" /></td>
<td width="138" bgcolor="#33FF33">Lesar No</td>
<td width="240"><input type="text" name="lesorno" id="lesorno" accesskey="1" tabindex="1" value="<?php echo '$row[lesarno]' ?>"/></td>
</tr>
<tr>
<td bgcolor="#33FF33">Subject 1</td>
<td><select name="subject1" id="subject1" accesskey="2" tabindex="2" required="required">
<option>HINDI</option>
<option>SANSKRIT</option>
<option>SOCIAL SCIENCE</option>
<option>GEOGRAPHY</option>
<option>HOME SCIENCE</option>
<option>ARMY SCIENCE</option>
<option>PSYCHOLOGY</option>
<option>NSS</option>
<option>NTT</option>
<option>CCC</option>
<option>BOMBAY ART</option>
</select></td>
<td bgcolor="#33FF33">Admission Date</td>
<td><input type="text" name="date" id="date" value='<?php echo '$row[tdate]' ?>' tabindex="3"/></td>
</tr>
<tr>
<td bgcolor="#33FF33">Subject 2</td>
<td><select name="subject2" id="subject2" accesskey="4" tabindex="4" required="required">
<option>HINDI</option>
<option>SANSKRIT</option>
<option>SOCIAL SCIENCE</option>
<option>GEOGRAPHY</option>
<option>HOME SCIENCE</option>
<option>ARMY SCIENCE</option>
<option>PSYCHOLOGY</option>
<option>NSS</option>
<option>NTT</option>
<option>CCC</option>
<option>BOMBAY ART</option>
</select></td>
<td bgcolor="#33FF33">Class</td>
<td><input type="text" name="class" id="class" accesskey="5" tabindex="5" value="<?php echo '$row[class]' ?>"/></td>
</tr>
<tr>
<td bgcolor="#33FF33">Subject 3</td>
<td><select name="subject3" id="subject3" accesskey="3" tabindex="6" required="required">
<option>HINDI</option>
<option>SANSKRIT</option>
<option>SOCIAL SCIENCE</option>
<option>GEOGRAPHY</option>
<option>HOME SCIENCE</option>
<option>ARMY SCIENCE</option>
<option>PSYCHOLOGY</option>
<option>NSS</option>
<option>NTT</option>
<option>CCC</option>
<option>BOMBAY ART</option>
</select></td>
<td bgcolor="#33FF33">Date of Birth</td>
<td><input type="text" name="dob" id="dob" tabindex="7" value="<?php echo '$row[class]' ?>"/></td>
</tr>
<tr>
<td bgcolor="#33FF33"></td>
<td></td>
<td bgcolor="#33FF33">Year</td>
<td><select name="year" id="year" tabindex="9" value="<?php echo '$row[year]' ?>" />
<option>1 YEAR</option>
<option>2 YEAR</option>
<option>3 YEAR</option>
</select></td>
</tr>
<tr>
<td bgcolor="#33FF33">Student Name</td>
<td><input name="studentname" type="text" id="studentname" accesskey="8" tabindex="10" size="40" maxlength="50" required="required" value="<?php echo '$row[stduentname]' ?>" /></td>
<td bgcolor="#33FF33">Father's Name</td>
<td><input name="fathername" type="text" id="fathername" accesskey="9" tabindex="11" size="40" maxlength="50" required="required" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Mother's Name</td>
<td><input name="mothername" type="text" id="mothername" accesskey="10" tabindex="12" size="40" maxlength="50" required="required"/></td>
<td bgcolor="#33FF33">Domicile Certificate</td>
<td><input type="text" name="domicile" id="domicile" accesskey="11" tabindex="13" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Caste Certificate</td>
<td><input type="text" name="castecertificate" id="castecertificate" accesskey="14" tabindex="14" /></td>
<td bgcolor="#33FF33">Income Certificate</td>
<td><input type="text" name="incomecertificate" id="incomecertificate" accesskey="15" tabindex="15" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Caste</td>
<td><input type="text" name="castename" id="castename" required="required" tabindex="16" /></td>
<td bgcolor="#33FF33">Sub Caste</td>
<td><input type="text" name="subcaste" id="subcaste" required="required" tabindex="17" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Bank Name</td>
<td><input type="text" name="bankname" id="bankname" accesskey="14" tabindex="18" /></td>
<td bgcolor="#33FF33">Branch Name</td>
<td><input type="text" name="branchname" id="branchname" accesskey="15" tabindex="19" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Account No</td>
<td><input name="accountno" type="text" id="accountno" accesskey="16" tabindex="20" /></td>
<td bgcolor="#33FF33">Mobile No</td>
<td><input type="text" name="mobileno" id="mobileno" accesskey="17" tabindex="21" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Address</td>
<td bgcolor="#CCCCCC"><textarea name="Address" cols="40" id="Address" required="required" tabindex="22"></textarea></td>
<td bgcolor="#33FF33">Gender</td>
<td><select name="gender" id="gender" tabindex="23">
<option>MALE</option>
<option>FEMALE</option>
</select></td>
</tr>
<tr>
<td bgcolor="#33FF33"></td>
<td></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan="4">Education Qualification</td>
</tr>
<tr>
<td colspan="4"><table width="845" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="148" bgcolor="#FFFF00">Examination</td>
<td width="60" bgcolor="#FFFF00">Year</td>
<td width="240" bgcolor="#FFFF00">School Name</td>
<td width="144" bgcolor="#FFFF00">Board Name</td>
<td width="100" bgcolor="#FFFF00">Roll No</td>
<td width="60" bgcolor="#FFFF00">Obtained Mark</td>
<td width="49" bgcolor="#FFFF00">Total Mark</td>
</tr>
<tr>
<td bgcolor="#33FF33">High School</td>
<td><input name="hyear" type="text" id="hyear" accesskey="18" tabindex="23" size="10" maxlength="10" /></td>
<td><input name="schoolname" type="text" id="schoolname" accesskey="19" tabindex="24" size="40" /></td>
<td><input type="text" name="hboardname" id="hboardname" accesskey="20" tabindex="25" /></td>
<td><input name="hrollno" type="text" id="hrollno" accesskey="20" tabindex="26" size="15" maxlength="15" /></td>
<td><input name="obtainedmarks" type="text" id="obtainedmarks" accesskey="21" tabindex="27" size="10" maxlength="10" /></td>
<td><input name="totalmarks" type="text" id="totalmarks" accesskey="22" tabindex="28" size="8" maxlength="8" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Intemediate</td>
<td><input name="intyear" type="text" id="intyear" accesskey="23" tabindex="29" size="10" maxlength="10" /></td>
<td><input name="intschoolname" type="text" id="intschoolname" accesskey="24" tabindex="30" size="40" maxlength="40" /></td>
<td><input type="text" name="intbaordname" id="intbaordname" accesskey="25" tabindex="31" /></td>
<td><input name="introllno" type="text" id="introllno" accesskey="32" tabindex="32" size="15" maxlength="15" /></td>
<td><input name="intobtainedmarks" type="text" id="intobtainedmarks" accesskey="27" tabindex="33" size="10" maxlength="10" /></td>
<td><input name="inttotlamarks" type="text" id="inttotlamarks" accesskey="28" tabindex="34" size="8" maxlength="8" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Graduation Frist Year</td>
<td><input name="graducationyear" type="text" id="graducationyear" accesskey="29" tabindex="35" size="10" maxlength="10" /></td>
<td><input name="graducationschoolname" type="text" id="graducationschoolname" accesskey="36" tabindex="30" size="40" maxlength="40" /></td>
<td><input type="text" name="graducationuniv" id="graducationuniv" accesskey="31" tabindex="37" /></td>
<td><input name="graducaitonrollno" type="text" id="graducaitonrollno" accesskey="32" tabindex="38" size="15" maxlength="15" /></td>
<td><input name="graducationobtainmarks" type="text" id="graducationobtainmarks" accesskey="39" tabindex="33" size="10" maxlength="10" /></td>
<td><input name="graduationtotalmarks" type="text" id="graduationtotalmarks" accesskey="40" tabindex="34" size="8" /></td>
</tr>
<tr>
<td bgcolor="#33FF33">Graducation Second Year</td>
<td><input name="gradsecondyear" type="text" id="gradsecondyear" accesskey="35" tabindex="41" size="10" maxlength="10" /></td>
<td><input name="gradsecondschool" type="text" id="gradsecondschool" accesskey="35" tabindex="42" size="40" maxlength="40" /></td>
<td><input type="text" name="gradsecondboard" id="gradsecondboard" accesskey="36" tabindex="43" /></td>
<td><input name="graducationsecondroll" type="text" id="graducationsecondroll" accesskey="44" tabindex="37" size="15" /></td>
<td><input name="gradsecondobt" type="text" id="gradsecondobt" accesskey="37" tabindex="45" size="10" /></td>
<td><input name="gradsecondtotal" type="text" id="gradsecondtotal" size="8" maxlength="" tabindex="46"/></td>
</tr>
<tr>
<td bgcolor="#CCCCCC"> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="addrecod" id="addrecod" value="Submit" accesskey="47" tabindex="48" /></td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p></td>
</tr>
<tr>
<td colspan="4"><?php include('footer.php'); ?></td>
</tr>
</table></form>
</body></center>
</html>
|