File: C:/xampp/htdocs/Xerox/pSearch.php
<?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 production 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>�L��d��--</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>�L��d��:: <?php echo $barcode."/".$press."/".$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;">�����Ǹ�</td>
<td style="width:276px;">��</td>
</tr>
</tbody>
</table>
<p>
<?php
$host="127.0.0.1";
$user="root";
$pass="fredsql";
$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 ($PO<>'') {
$query = "SELECT * from Xdata where PO='$PO' group by PO";
echo $query;}
else{
$query = "SELECT PO,ddate from Xdata where ddate between '$date_s' and '$date_e' group by PO";
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>
</table>
<?php }
mysql_close($connection); ?>
</body>
</html>