Viewing file:  identitycardbranch.php (8.77 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","mitm_user","mitmpass838"); //(host, username, password)
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("mitm_ailwssor_database") or die("Unable to select database"); //select which database we're using
$field = 'branch';
// 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://www.mitmgroup.com/data/files/".$row['photo_upload'] .">";
echo "<BODY TOPMARGIN=\"50\" LEFTMARGIN=\"50\" MARGINWIDTH=\"0\" MARGINHEIGHT=\"0\">\n";
echo " \n";
echo " <TABLE BORDER=\"0\" CELLPADDING=\"0\" CELLSPACING=\"0\">\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"9\"><IMG SRC=\"images/school_big_6[1]_1.jpg\" WIDTH=\"362\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"9\"><IMG SRC=\"images/school_big_6[1]_2.jpg\" WIDTH=\"362\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"9\"><IMG SRC=\"images/school_big_6[1]_3.jpg\" WIDTH=\"362\" BORDER=\"0\" HEIGHT=\"63\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"9\"><IMG SRC=\"images/school_big_6[1]_4.jpg\" WIDTH=\"362\" BORDER=\"0\" HEIGHT=\"4\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"3\"><IMG SRC=\"images/school_big_6[1]_5.jpg\" WIDTH=\"241\" BORDER=\"0\" HEIGHT=\"15\"></TD>\n";
echo " <TD COLSPAN=\"5\"></TD>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_7.jpg\" WIDTH=\"17\" BORDER=\"0\" HEIGHT=\"15\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"9\"><IMG SRC=\"images/school_big_6[1]_8.jpg\" WIDTH=\"362\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_9.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD COLSPAN=\"3\" ROWSPAN=\"12\" align=\"left\" valign=\"top\"><h5>NAME:- $name <br>FATHER'S:- $father <br>DOB:- $DOB <br>\n";
echo " SUBJECT:- $Subject <br>ROLL NO:- $id <br></h5>\n";
echo " \n";
echo " \n";
echo " </TD>\n";
echo " <TD COLSPAN=\"5\"><IMG SRC=\"images/school_big_6[1]_11.jpg\" WIDTH=\"120\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD ROWSPAN=\"2\"><IMG SRC=\"images/school_big_6[1]_12.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"19\"></TD>\n";
echo " <TD COLSPAN=\"3\"><IMG SRC=\"images/school_big_6[1]_13.jpg\" WIDTH=\"102\" BORDER=\"0\" HEIGHT=\"3\"></TD>\n";
echo " <TD COLSPAN=\"2\" ROWSPAN=\"5\"><IMG SRC=\"images/school_big_6[1]_14.jpg\" WIDTH=\"18\" BORDER=\"0\" HEIGHT=\"56\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_15.jpg\" WIDTH=\"9\" BORDER=\"0\" HEIGHT=\"16\"></TD>\n";
echo " <TD ROWSPAN=\"7\" align=\"left\" valign=\"top\"> $phtoo </TD>\n";
echo " <TD ROWSPAN=\"7\"><IMG SRC=\"images/school_big_6[1]_17.jpg\" WIDTH=\"3\" BORDER=\"0\" HEIGHT=\"98\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_18.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"2\"></TD>\n";
echo " <TD ROWSPAN=\"6\"><IMG SRC=\"images/school_big_6[1]_19.jpg\" WIDTH=\"9\" BORDER=\"0\" HEIGHT=\"82\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_20.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"26\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_21.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"9\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_22.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"13\"></TD>\n";
echo " <TD COLSPAN=\"2\"><IMG SRC=\"images/school_big_6[1]_23.jpg\" WIDTH=\"18\" BORDER=\"0\" HEIGHT=\"13\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_24.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"31\"></TD>\n";
echo " <TD COLSPAN=\"2\"><IMG SRC=\"images/school_big_6[1]_25.jpg\" WIDTH=\"18\" BORDER=\"0\" HEIGHT=\"31\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_26.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD COLSPAN=\"2\"><IMG SRC=\"images/school_big_6[1]_27.jpg\" WIDTH=\"18\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD ROWSPAN=\"3\"><IMG SRC=\"images/school_big_6[1]_28.jpg\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"27\"></TD>\n";
echo " <TD COLSPAN=\"3\"><IMG SRC=\"images/school_big_6[1]_29.jpg\" WIDTH=\"102\" BORDER=\"0\" HEIGHT=\"2\"></TD>\n";
echo " <TD COLSPAN=\"2\"><IMG SRC=\"images/school_big_6[1]_30.jpg\" WIDTH=\"18\" BORDER=\"0\" HEIGHT=\"2\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"5\"><IMG SRC=\"images/school_big_6[1]_31.jpg\" WIDTH=\"120\" BORDER=\"0\" HEIGHT=\"4\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/school_big_6[1]_32.gif\" WIDTH=\"9\" BORDER=\"0\" HEIGHT=\"21\"></TD>\n";
echo " <TD COLSPAN=\"2\" ROWSPAN=\"2\"><h5> \"PRINCIPAL\" </h5></TD>\n";
echo " <TD COLSPAN=\"2\" ROWSPAN=\"2\"><IMG SRC=\"images/school_big_6[1]_34.jpg\" WIDTH=\"18\" BORDER=\"0\" HEIGHT=\"24\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"2\" ROWSPAN=\"2\"><IMG SRC=\"images/school_big_6[1]_35.jpg\" WIDTH=\"29\" BORDER=\"0\" HEIGHT=\"13\"></TD>\n";
echo " <TD COLSPAN=\"3\"><IMG SRC=\"images/school_big_6[1]_36.jpg\" WIDTH=\"222\" BORDER=\"0\" HEIGHT=\"3\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD COLSPAN=\"7\"><IMG SRC=\"images/school_big_6[1]_37.jpg\" WIDTH=\"333\" BORDER=\"0\" HEIGHT=\"10\"></TD>\n";
echo " </TR>\n";
echo " <TR>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"2\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"27\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"212\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"1\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"9\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"90\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"3\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"1\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo " <TD><IMG SRC=\"images/space.gif\" WIDTH=\"17\" BORDER=\"0\" HEIGHT=\"1\"></TD>\n";
echo "</TR>\n";
echo "</TABLE>\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>
<div>
</div>
</div>
</form>
</div>
<input type="button" name="printbutton" value="Print ID" onclick="return print1('print2')"/>
<!-- The PNG image will be added here -->
|