File: C:/xampp/htdocs/cmykDe/CNYplate/Rank.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=utf-8"><title>FograPlat 報表 </title><basefont face="Verdana">
</head>
<body>
<!-- standard page header begins -->
<p>
<a name="DETAILS"></a>
<table width="1280" cellspacing="0" cellpadding="5">
<tr>
<td></td>
</tr>
<tr>
<td bgcolor="Navy"><font size="-1" color="White"><b>FograPlate 報表 : List</b></font></td>
</tr>
</table>
<!-- standard page header ends -->
<p>
<table nowrap style="width=1280; text-align:left; table-layout:fixed" cellspacing="1" >
<tbody>
<tr>
<font size="-1">
<td nowrap style="width:120px;">日期</td>
<td nowrap style="width:80px;">機型</td>
<td nowrap style="width:80px;">色版</td>
<td nowrap style="width:80px;">版數</td>
<td nowrap style="width:80px;">版底濃度</td>
<td nowrap style="width:80px;">滿版濃度</td>
<td nowrap style="width:80px;">40%網點</td>
<td nowrap style="width:80px;">70%網點</td>
<td nowrap style="width:80px;">版材</td>
<td nowrap style="width:80px;">f-Step</td>
<td nowrap style="width:80px;">顯影時間</td>
<td nowrap style="width:80px;">顯影溫度</td>
<td nowrap style="width:80px;">工作</td>
<td nowrap style="width:80px;">人員</td>
</font>
</tr>
</tbody>
</table>
<?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!");
$query = "SELECT * from fplate order by id desc";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
while($row = mysql_fetch_object($result))
{
?>
<table nowrap style="width=1280; text-align:left; table-layout:fixed" cellspacing="1" >
<tbody>
<tr>
<td nowrap style="width:120px;"><?php echo $row->date; ?> </td>
<td nowrap style="width:80px;"><?php echo $row->ctp; ?> </td>
<td nowrap style="width:80px;"><?php echo $row->pt; ?> </td>
<td nowrap style="width:80px;"><?php echo $row->pNo;?> </td>
<td nowrap style="width:80px;"><?php echo $row->paper;?> </td>
<td nowrap style="width:80px;"><?php echo $row->SID;?> </td>
<td nowrap style="width:80px;"><?php echo $row->T25;?> </td>
<td nowrap style="width:80px;"><?php echo $row->T50;?> </td>
<td nowrap style="width:80px;"><?php echo $row->size; ?> </td>
<td nowrap style="width:80px;"><?php echo $row->fStep; ?> </td>
<td nowrap style="width:80px;"><?php echo $row->dvTime; ?> </td>
<td nowrap style="width:80px; "><?php echo $row->dvTemp; ?> </td>
<td nowrap style="width:80px;"><?php echo $row->filter.",".$row->chem.",".$row->wash;?> </td>
<td nowrap style="width:80px;"><?php echo $row->stf;?> </td>
<td nowrap style="width:80px;"> <a href="tvireport.php?tvifile=<?php echo $row->filename;?> ">
<?php echo $row->filename;?> </a> </td>
</tr>
</tbody>
</table>
<p>
<?php
}
mysql_close($connection);
?>
<!-- standard page footer begins -->
<p>
<table width="1280" cellspacing="0" cellpadding="5">
<tr>
<td align="center"><font size="-2">Everything here is copyright © <a href="http://www.fredkuo.idv.tw/wordpress/">Fred Kuo</a>, 2010. All rights reserved.<br> <a href="http://www.fredkuo.idv.tw/wordpress/?tag=fogra">Read more.</a></td>
</tr>
</table>
<!-- standard page footer ends -->
</body>
</html>