File: C:/xampp/htdocs/PBNCT9/pSearch.php
<?php
extract($_REQUEST);
session_start();?>
<?php
/*
All source code copyright and proprietary Melonfire, 2002. All content, brand names and trademarks copyright and proprietary Melonfire, 2002. All rights reserved. Copyright infringement is a violation of law.
This source code is provided with NO WARRANTY WHATSOEVER. It is produced and meant for illustrative purposes only, and is NOT recommended for use in ProductionPBN environments.
Read more articles like this one at http://www.melonfire.com/community/columns/trog/ and http://www.melonfire.com/
*/
// add.php - add a new press release
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5"><title>Job Report--</title>
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css">
<style type="text/css">
@import url("../crony_css.css");
</style>
<basefont face="Verdana">
</head>
<body link="#0000FF" vlink="#0000FF">
<!-- standard page header begins -->
<p> </p>
<table width="100%" cellspacing="0" cellpadding="5">
<tr>
<td></td>
</tr>
<tr>
<td bgcolor="Navy"><font size="-1" color="White"><b>ProductionPBN report:: <?php echo $barcode."/".""."/".$date_s."~".$date_e; ?></b></font></td>
</tr>
</table>
<p><!-- standard page header ends --></p>
<TABLE STYLE="table-layout:fixed" WIDTH=800>
<tbody>
<td style="width:190px;"�ƥX</td>
<td style="width:276px;">��</td>
</tr>
</tbody>
</table>
<p>
<?php
$host="127.0.0.1";
$user="root";
$pass="hpwebadmin";
$db="tvicheck-st";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
if ($barcode<>'') {
$query = "SELECT * from ProductionPBN where po='$barcode' and strip='CT9' group by po order by ddate";
//echo $query;
}
else {
$query = "SELECT * from ProductionPBN where ddate between '$date_s' and '$date_e' and strip='CT9' group by po order by ddate";
//echo $query;
}
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
// if records present
// iterate iii through resultset
// print title with links to edit and delete scripts
while($row = mysql_fetch_object($result)) { ?>
<TABLE STYLE="table-layout:fixed" WIDTH=800>
<tr>
<td style="width:190px;"><a href='./linegraph.php?po=<?php echo $row->po;?>'><?php echo $row->po;?></a></td>
<td style="width:276px;"><?php echo $row->ddate;?></td>
</tr>
<tr>
<td style="width:190px;"><a href='./linegraphDT.php?po=<?php echo $row->po;?>'><?php echo $row->po;?>-DT</a></td>
<td style="width:276px;"><?php echo $row->ddate;?></td>
</tr>
</table>
<?php }
mysql_close($connection); ?>
</body>
</html>