Viewing file:  receipt_print.php (7.69 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<style type="text/css" media="print">
@page
{
size: auto; /* auto is the initial value */
margin: 0mm; /* this affects the margin in the printer settings */
}
</style>
<?php
// Get the search variable from URL
$var ="$_post[accountname]" ;
$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 == "")
{
echo "<p>Please Registration No</p>";
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
mysql_connect("localhost","baserain_dba838","rb!bsa838mau"); //(host, username, password)
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("baserain_db838") or die("Unable to select database"); //select which database we're using
$field = 'acc_no';
// Build SQL Query
$query = "select * from new_acc 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
echo "<h3>Your Details:-</h3>";
$count = 1 + $s ;
// now you can display the results returned
while ($row= mysql_fetch_array($result))
{
$title = $row['certificate_no']." ".$row['serail_no']. "".$row['roll_no']. " " . $row['student_name']. " " .$row['date_of_birth']. " " .$row['issue_date']." ". $row['course_name'];
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n";
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">\n";
echo "<head>\n";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n";
echo "<title>Untitled Document</title>\n";
echo "</head>\n";
echo "\n";
echo "<body>\n";
echo "<table width=\"700\" border=\"0\">\n";
echo " <tr>\n";
echo " <td width=\"129\">Serial No</td>\n";
echo " <td width=\"164\">". $row['id'] ."</td>\n";
echo " <td width=\"121\"> Course Name</td>\n";
echo " <td width=\"132\">". $row['name']."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Roll No</td>\n";
echo " <td>". $row['roll_'] ."</td>\n";
echo " <td>Course End Date</td>\n";
echo " <td>". $row['end_date']. "</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Name</td>\n";
echo " <td>". $row['name'] ." </td>\n";
echo " <td>Photo</td>\n";
echo " <td rowspan=\"4\">..<img border='2' width='80' height='100' src=http://www.gccmau.org/data/files/".$row['photo']." .</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Father's Name</td>\n";
echo " <td>". $row['f_name'] ."</td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Division</td>\n";
echo " <td>". $row['division']."</td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Admission Date</td>\n";
echo " <td>". $row['start_date']."</td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td colspan=\"4\" bgcolor=\"#6699CC\">Course Details</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td bgcolor=\"#FFFFCC\">Course Name</td>\n";
echo " <td bgcolor=\"#FFFFCC\">Total Marks</td>\n";
echo " <td bgcolor=\"#FFFFCC\">Massing Marks</td>\n";
echo " <td bgcolor=\"#FFFFCC\">Obtained Marks</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course1'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no1'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course2'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no2'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course3'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no3'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course4'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no4'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course5'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no5'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td> ".$row['course6']." </td>\n";
echo " <td>" . $row['totalmarks']." </td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no6'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course7'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no7'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course8'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no8'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course9'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no9'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course10'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no10'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course11'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no11'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course12'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no12'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course13'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no13'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course14'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no14'] ."</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>". $row['course15'] ."</td>\n";
echo " <td>". $row['totalmarks'] ."</td>\n";
echo " <td>". $row['passingmarks'] ."</td>\n";
echo " <td>". $row['c_no15'] ."</td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "</body>\n";
echo "</html>\n";
echo "</center>";
$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
?>
</td>
</tr>
</table>
|