Viewing file:  identitycardsingle.php (7.62 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<div id="print2">
<div id="talltweets">
<script type="text/javascript">
function print1(strid)
{
if(confirm("Do you want to print?"))
{
var values = document.getElementById(strid);
var printing =
window.open('','','left=0,top=0,width=550,height=400,toolbar=0,scrollbars=0,sta?tus=0');
printing.document.write(values.innerHTML);
printing.document.close();
printing.focus();
printing.print();
printing.close();
}
}
</script>
<?php
// Get the search variable from URL
$var = @$_GET['ID'] ;
$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","rcgi_feesuser","rb!fee838rb!fee838"); //(host, username, password)
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("rcgi_fees") or die("Unable to select database"); //select which database we're using
$field = 'roll_no';
// 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))
{
$photo="<img border='0' width='70' height='100' src=http://www.mitmgroup.com/data/files/".$row['photo_upload'] .">";
$id=$row[roll_no];
$name=$row[stduentname];
$father=$row[studentfathername];
$addres=$row[address];
$Subject=$row[subject1];
$year=$row[cyear];
$DOB=$row[dob];
$phtoo="<img border='0' width='90' height='100' src=http://fees.rcgi.in/data/files/".$row['photo'] .">";
$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>
<div>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META CONTENT="text/html; charset=iso-8859-1" HTTP-EQUIV="Content-Type">
<META NAME="Generator" CONTENT="PhotoImpact">
</HEAD>
<BODY TOPMARGIN="50" LEFTMARGIN="50" MARGINWIDTH="0" MARGINHEIGHT="0">
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="0">
<TR>
<TD COLSPAN="9"><IMG SRC="images/school_big_6[1]_1.jpg" WIDTH="362" BORDER="0" HEIGHT="1"></TD>
</TR>
<TR>
<TD COLSPAN="9"><IMG SRC="images/school_big_6[1]_2.jpg" WIDTH="362" BORDER="0" HEIGHT="1"></TD>
</TR>
<TR>
<TD COLSPAN="9"><IMG SRC="images/school_big_6[1]_3.jpg" WIDTH="362" BORDER="0" HEIGHT="63"></TD>
</TR>
<TR>
<TD COLSPAN="9"><IMG SRC="images/school_big_6[1]_4.jpg" WIDTH="362" BORDER="0" HEIGHT="4"></TD>
</TR>
<TR>
<TD COLSPAN="3"><IMG SRC="images/school_big_6[1]_5.jpg" WIDTH="241" BORDER="0" HEIGHT="15"></TD>
<TD COLSPAN="5"></TD>
<TD><IMG SRC="images/school_big_6[1]_7.jpg" WIDTH="17" BORDER="0" HEIGHT="15"></TD>
</TR>
<TR>
<TD COLSPAN="9"><IMG SRC="images/school_big_6[1]_8.jpg" WIDTH="362" BORDER="0" HEIGHT="1"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_9.jpg" WIDTH="2" BORDER="0" HEIGHT="1"></TD>
<TD COLSPAN="3" ROWSPAN="12" align="left" valign="top"><h5>NAME:-<?PHP echo $name ?><br>FATHER'S:-<?PHP echo $father ?><br>DOB:-<?PHP echo $DOB ?><br>
SUBJECT:-<?PHP echo $Subject ?><br>ROLL NO:-<?PHP echo $id ?><br></h5>
</TD>
<TD COLSPAN="5"><IMG SRC="images/school_big_6[1]_11.jpg" WIDTH="120" BORDER="0" HEIGHT="1"></TD>
</TR>
<TR>
<TD ROWSPAN="2"><IMG SRC="images/school_big_6[1]_12.jpg" WIDTH="2" BORDER="0" HEIGHT="19"></TD>
<TD COLSPAN="3"><IMG SRC="images/school_big_6[1]_13.jpg" WIDTH="102" BORDER="0" HEIGHT="3"></TD>
<TD COLSPAN="2" ROWSPAN="5"><IMG SRC="images/school_big_6[1]_14.jpg" WIDTH="18" BORDER="0" HEIGHT="56"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_15.jpg" WIDTH="9" BORDER="0" HEIGHT="16"></TD>
<TD ROWSPAN="7" align="left" valign="top"><?PHP echo $phtoo ?></TD>
<TD ROWSPAN="7"><IMG SRC="images/school_big_6[1]_17.jpg" WIDTH="3" BORDER="0" HEIGHT="98"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_18.jpg" WIDTH="2" BORDER="0" HEIGHT="2"></TD>
<TD ROWSPAN="6"><IMG SRC="images/school_big_6[1]_19.jpg" WIDTH="9" BORDER="0" HEIGHT="82"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_20.jpg" WIDTH="2" BORDER="0" HEIGHT="26"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_21.jpg" WIDTH="2" BORDER="0" HEIGHT="9"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_22.jpg" WIDTH="2" BORDER="0" HEIGHT="13"></TD>
<TD COLSPAN="2"><IMG SRC="images/school_big_6[1]_23.jpg" WIDTH="18" BORDER="0" HEIGHT="13"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_24.jpg" WIDTH="2" BORDER="0" HEIGHT="31"></TD>
<TD COLSPAN="2"><IMG SRC="images/school_big_6[1]_25.jpg" WIDTH="18" BORDER="0" HEIGHT="31"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_26.jpg" WIDTH="2" BORDER="0" HEIGHT="1"></TD>
<TD COLSPAN="2"><IMG SRC="images/school_big_6[1]_27.jpg" WIDTH="18" BORDER="0" HEIGHT="1"></TD>
</TR>
<TR>
<TD ROWSPAN="3"><IMG SRC="images/school_big_6[1]_28.jpg" WIDTH="2" BORDER="0" HEIGHT="27"></TD>
<TD COLSPAN="3"><IMG SRC="images/school_big_6[1]_29.jpg" WIDTH="102" BORDER="0" HEIGHT="2"></TD>
<TD COLSPAN="2"><IMG SRC="images/school_big_6[1]_30.jpg" WIDTH="18" BORDER="0" HEIGHT="2"></TD>
</TR>
<TR>
<TD COLSPAN="5"><IMG SRC="images/school_big_6[1]_31.jpg" WIDTH="120" BORDER="0" HEIGHT="4"></TD>
</TR>
<TR>
<TD><IMG SRC="images/school_big_6[1]_32.gif" WIDTH="9" BORDER="0" HEIGHT="21"></TD>
<TD COLSPAN="2" ROWSPAN="2"><h5><?php echo "PRINCIPAL" ?></h5></TD>
<TD COLSPAN="2" ROWSPAN="2"><IMG SRC="images/school_big_6[1]_34.jpg" WIDTH="18" BORDER="0" HEIGHT="24"></TD>
</TR>
<TR>
<TD COLSPAN="2" ROWSPAN="2"><IMG SRC="images/school_big_6[1]_35.jpg" WIDTH="29" BORDER="0" HEIGHT="13"></TD>
<TD COLSPAN="3"><IMG SRC="images/school_big_6[1]_36.jpg" WIDTH="222" BORDER="0" HEIGHT="3"></TD>
</TR>
<TR>
<TD COLSPAN="7"><IMG SRC="images/school_big_6[1]_37.jpg" WIDTH="333" BORDER="0" HEIGHT="10"></TD>
</TR>
<TR>
<TD><IMG SRC="images/space.gif" WIDTH="2" BORDER="0" HEIGHT="1"></TD>
<TD><IMG SRC="images/space.gif" WIDTH="27" BORDER="0" HEIGHT="1"></TD>
<TD><IMG SRC="images/space.gif" WIDTH="212" BORDER="0" HEIGHT="1"></TD>
<TD><IMG SRC="images/space.gif" WIDTH="1" BORDER="0" HEIGHT="1"></TD>
<TD><IMG SRC="images/space.gif" WIDTH="9" BORDER="0" HEIGHT="1"></TD>
<TD><IMG SRC="images/space.gif" WIDTH="90" BORDER="0" HEIGHT="1"></TD>
<TD><IMG SRC="images/space.gif" WIDTH="3" BORDER="0" HEIGHT="1"></TD>
<TD><IMG SRC="images/space.gif" WIDTH="1" BORDER="0" HEIGHT="1"></TD>
<TD><IMG SRC="images/space.gif" WIDTH="17" BORDER="0" HEIGHT="1"></TD>
</TR>
</TABLE>
</BODY>
</HTML>
</div>
</div>
</form>
</div>
<input type="button" name="printbutton" value="Print ID" onclick="return print1('print2')"/>
<!-- The PNG image will be added here -->
|