Display result one same page(template) using Php

linegreen04 · 03:47 PM

Dear all
I'm Using these codes for displaying my results and getting displayed but there is some problem as i got display on other page which has no images,header,(my template look) so i want to ask how to display that on my template (using my header or etc as on my home page look).

PHP Code:


			
<?php
$db=mysql_connect('mysqlX.000webhost.com','axxxxx','xxxxx');
mysql_select_db('axxxxx', $db);

$result = mysql_query('SELECT student.Roll, student.Stream, Marks.Session, student.Name, student.Mother_Name, student.Father_Name, Marks.Total_Marks, Marks.Grade, Marks.Result'
        . ' FROM student'
        . ' INNER JOIN Marks'
        . ' ON student.Roll=Marks.Roll LIMIT 0, 30 ',$db);


echo "<table border='1'>
<tr>
<td>Roll</td>
<td>Stream</td>
<td>Session</td>
<td>Name</td>
<td>Mother Name</td>
<td>Father Name</td>
<td>Total Mark's</td>
<td>Grade</td>
<td>Result</td>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['Roll'] . "</td>";
  echo "<td>" . $row['Stream'] . "</td>";
  echo "<td>" . $row['Session'] . "</td>";
  echo "<td>" . $row['Name'] . "</td>";
  echo "<td>" . $row['Mother_Name'] . "</td>";
  echo "<td>" . $row['Father_Name'] . "</td>";
  echo "<td>" . $row['Total_Marks'] . "</td>";
  echo "<td>" . $row['Grade'] . "</td>";
  echo "<td>" . $row['Result'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
?>

grace1004 · 05-14-2012, 10:44 PM

The following is an example:

Code:

<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>SAMPLE SITE</title>
<link rel="stylesheet" href="global.css">
</head>
<body>
<?  
//Put header or top menu file
include 'header.html';
include 'top_menu.php'; 
?>
<br>
<table style="border-width:1; border-style:solid;" border="0" cellpadding="0" cellspacing="0" width="938">
  <tr>
    <td width="210" height="376" valign="top">
	  <?  
      //To put login menu
      include 'left_login.php';  

      //To put left menu
      include 'main_left.php';  
      ?>
    </td>

// Put your php script
<?php
$db=mysql_connect('mysqlX.000webhost.com','axxxxx','xxxxx');
mysql_select_db('axxxxx', $db);
.
.
.
echo "</table>";

//Put footer file 
include 'footer.html';
?>

</body>
</html>