no display

chinna

hi...i have problem to view in report page...where all my data not displayed...please help me...i use the same coding anothe page to display data...it work fine...but giving problem in report page...here i attach my coding...

<?php
include "db1.php";
session_start();
$t_id=$_REQUEST['t_id'];

?>


<!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=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style4 {font-size: 18px}
.style11 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }
.style8 {font-size: 12px}
.style9 {font-family: Verdana, Arial, Helvetica, sans-serif}
h3{background-color:#C0F5FA}
.style12 {font-size: 9px}
-->
</style>
<link href="payment.css" rel="stylesheet" type="text/css" />
</head>

<body>

<table width="700" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="395"><img src="images/computer copy.jpg" width="72" height="69" />E-Payment Voucher</td>
    <td width="305">TRANSACTION CODE:<? echo $t_id;?> </td>
  </tr>
</table><br />
<p><u>SMT Technologies SDN BHD.(279566-x)</u></p>
<table width="760" border="0" cellspacing="0" cellpadding="0">
  <?
$sql3="select * from voucher where t_id='$t_id'";
$result3=mysql_query($sql3)or die(mysql_error());
@$r3=mysql_fetch_assoc($result3);
?>

  <tr>
    <td width="160"><span class="style11">Prepared By </span></td>
    <td width="220"><span class="style11"><? echo $r3['prepare_by'];?> </span> </td>
    <td width="160"><span class="style11">Emp No </span></td>
    <td width="220"><span class="style9 style8"><? echo $r3['emp_1'];?> </span></td>
  </tr>
  <tr>
    <td><span class="style11">E-mail Address </span></td>
    <td><span class="style11"><? echo $r3['email'];?> </span></td>
    <td><span class="style11">Designation</span></td>
    <td><span class="style9 style8"><? echo $r3['designation'];?> </span></td>
  </tr>
  <tr>
    <td><span class="style11">Date/Time</span></td>
    <td><span class="style11"><?php echo date ("m/d/Y ");echo date ("g:i a")?></span></td>
    <td><span class="style11">Dept </span></td>
    <td><span class="style9 style8"><? echo $r3['department'];?> </span></td>
  </tr>
  <tr>
    <td><span class="style11">Sect Manager </span></td>
    <td><span class="style11"><? echo $r3['selectmanager'];?> </span></td>
  </tr>
</table><br />
<table width="700" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><h3><u>Voucher Details</u></h3></td>
  </tr>
</table><br />


<table width="400" height="120" border="0" cellpadding="0" cellspacing="0">
  <tr>

<td width="160" height="54"><span class="style11">Purpose</span></td>
<td width="240"><div class="style9" id="style1">
<textarea name="purpose" id="purpose"  width="300">
<? echo @$r['purpose'];?></textarea>
</div> 
  <span class="style9"><input name="t_id" type="hidden" value="<? echo $t_id;?>" /><br />
  </span></td>
  </tr>


 <tr>
   <td height="22"><span class="style11">Pay to </span></td>
   <td class="style11"><input name="pay_to" type="text" class="style9" id="pay_to" value="<? echo $r['pay_to'];?>"></td>
</tr>


<tr>
<td height="22"><span class="style11">Employee No </span></td>

<td class="style11"><input name="employee" type="text" class="style9" id="employee" value="<? echo $r['emp_2'];?>" /></td>
</tr>
<tr>


<td height="22"><span class="style11">ECER</span></td>

<td class="style11"><input name="ecer" type="text" class="style9" id="ecer"  value="<? echo $r['ecer'];?>"/></td>
</tr>
</table>
<br />
<br />
<br />
<table width="730" border="0" cellspacing="0" cellpadding="1">
  <tr>
    <td width="51" height="30" bgcolor="#8BE3ED"></td>
    <td width="1"></td>
    <td width="153" bgcolor="#8BE3ED"><div align="center" class="style9">
      <div align="center"><span class="style8">ACCOUNT NO</span>:</div>
    </div></td>
    <td width="1"></td>
    <td width="91" bgcolor="#8BE3ED"><div align="center" class="style8">ITEM</div></td>
    <td width="1"></td>
    <td width="165"bgcolor="#8BE3ED"><div align="center" class="style8">DESCRIPTION</div></td>
    <td width="1"></td>
    <td width="105" bgcolor="#8BE3ED"><div align="center" class="style8">AMOUNT (RM)</div></td>
    <td width="1"></td>
    <td width="160" bgcolor="#8BE3ED">&nbsp;</td>
  </tr>
</table>
<table width="730" border="0" cellspacing="0" cellpadding="1">
  <? ##################################################### ?>
  <?
  $sql2="select * from details where t_id ='$t_id'";
  $result2=mysql_query($sql2)or die(mysql_error());
  while($r2=mysql_fetch_assoc($result2))
  {
  ?>
  <tr>
    <td width="51" bgcolor="#CAF3F7"></td>
    <td width="1"></td>
    <td width="153" bgcolor="#CAF3F7"><? echo $r2['acc_no'];?> </td>
    <td width="1"></td>
    <td width="91" bgcolor="#CAF3F7"><? echo $r2['item'];?> </td>
    <td width="1"></td>
    <td width="165" bgcolor="#CAF3F7"><? echo $r2['description'];?> </td>
    <td width="1"></td>
    <td width="105" bgcolor="#CAF3F7"><? echo $r2['amount'];?> </td>
    <td width="1"></td>
    <td width="160" bgcolor="#CAF3F7"></td>
  </tr>
  <?
  }
  ?>
</table>
<br /> 

<table width="700" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="49"></td>
    <td width="49"></td>
    <td width="49"></td>
    <td width="49"></td>
    <td width="49"></td>
    <td width="49"></td>
    <td width="49"></td>
    <td width="188" align="right"></td>
    <td width="93"><span class="style11">Total Amount</span>: </td>
    <td width="71"><div align="center" class="style9">
        <div align="left" class="style8">RM
          <?php
$sql = "select SUM(amount) AS total from details";
$result = mysql_query($sql) or die(mysql_error());
$r = mysql_fetch_array($result);
$total = $r['total'];  

echo "$total"; ?>
        </div>
    </div></td>
    <td width="1" align="right"></td>
    <td width="4" align="right"></td>
  </tr>
</table><br />
<p><u>Attachment</u></p>
<p>Remark:</p>
<br /> 
</FORM>

<p>&nbsp;</p>
<form name="form2" id="form2" action="" method="post">
<input type="button" value="Print" onClick="javascript:window.print();"
name="print">
<input type="submit" name="close" value="Close" onclick="window.close()" />
</form>
</body>
</html>

sumone please help me...realy blur

Installer

Is anything displayed? Do you get an error message? Do you have error reporting turned on?

chinna

no error....just no display at all....

Bunkermaster

make sure your include doesn't have any output it would break the session start and would trigger an error. dDepending on your server settings the error might not be displayed at all and the script would be stopped. No display.

I suggest you comment the include or move the session_start above the include and retry. See if the page loads.

chinna

i tried so many ways...i just not understand why the data not display...let me explain...in aftersave.php page..the data will be display...so when i click print preview button it will open new page with print preview...it called..print_preview.php...the coding is same..why the data displaye in aftersave.php page but not in print_preview.php...realy blurrrrrrr

Installer

If you didn't answer my third question because you don't know, you should find out.

I'd say there's appoximately an 87.8 percent chance that you don't have error reporting/display on, and that your script is causing a fatal error which you're not made aware of because you don't have error reporting/display on.

bradgrafelman

Doing a phpinfo() will tell you about display_errors, error_reporting, etc.

On my production server, I log errors instead of displaying them. When I want to debug a script in-place, rather than moving it to a development server (and therefore taking it out of the environment that's causing the errors), I simply place include 'debug.php' at the top of the script, because in my defualt includes directory, I've created debug.php that looks like this:

<?php
ini_set('log_errors', 'Off');
ini_set('display_errors', 'On');
error_reporting(E_ALL);
?>

chinna

i still cant figure it out,,,here i submit my full coding

<?php
ini_set('log_errors', 'Off');
ini_set('display_errors', 'On');
error_reporting(E_ALL);
?> 
<?php
session_start();
include "db1.php";
if(isset($_REQUEST['t_id'])) { $t_id = $_REQUEST['t_id']; } else { $t_id = ""; }
?>
<!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=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
h3 {background-color:#C0F5FA}
.style9 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 9px;
}
.style11 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; }

</style>
<link href="payment.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style12 {font-size: 18px}
-->
</style>
</head>

<body>
<form name="form1" method="post" target="mainFrame"> 
<table width="700" border="0" cellpadding="0" cellspacing="0" bgcolor="#CCCCCC">
  <tr>
    <td width="89" bgcolor="#FFFFFF"><img src="images/computer copy.jpg" width="72" height="69" /></td>
    <td width="611" bgcolor="#FFFFFF"><p class="style12">&nbsp;</p>
    <p class="style12">Manager Approval</p></td>
  </tr>
</table>
<table width="700" border="0" cellspacing="0" cellpadding="0">
  <tr>
  </tr>
</table>
<p>&nbsp;</p>
<table width="400" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="81" bgcolor="#C0F5FA">Prepare by </td>
    <td width="2" bgcolor="#FFFFFF"></td>
    <td width="210" bgcolor="#C0F5FA">Transaction Code </td>
    <td width="2" bgcolor="#FFFFFF"></td>
    <td width="107" bgcolor="#C0F5FA"></td>
  </tr>

<?
$sql4="select * from voucher where t_id='$t_id'";
$result4=mysql_query($sql4)or die(mysql_error());
$r4=mysql_fetch_assoc($result4);
?>
  <tr>
    <td bgcolor="#DDF2F4"><div align="center"><span class="style11"><?  echo $r4['prepare_by'];?></span></div></td>
    <td bgcolor="#FFFFFF"></td>
    <td bgcolor="#DDF2F4"><?php echo $t_id;?></td>
    <td bgcolor="#FFFFFF"></td>
    <td bgcolor="#DDF2F4"><span class="style9"><u>
	 <a href="managerview.php?t_id=<? echo $t_id;?>" target="_blank" >Print Preview</a>
  </tr>
</table>
<input name="t_id" type="hidden" value="<? echo $t_id;?>" />
</form>
</body>
</html>

thanks in advanced..

Roger_Ramjet

chinna wrote:
so when i click print preview button it will open new page with print preview...it called..print_preview.php...

YOUR CODE

<a href="managerview.php?t_id=<? echo $t_id;?>" target="_blank" >Print Preview</a>

So the question is: what is the name of the file, managerview.php or print_preview.php?

If managerview.php did not exist then you should get a 404 error, so presumably it does exist - just does not produce any output.

chinna

i just change the page name...but its same function

Roger_Ramjet

OK, well there are a number of dodgy things in your codes.

Debugging 101

Change the target to a test.php page and just print_r the POST, GET and REQUEST arrays. See what is being sent.

In your particular case you are using t_id twice in the form so I expect that to mess you up.

You are also mixing short and long php tags - are short tags enabled: deprecated so stop using them. If not then your form will be missing those vars.