File: C:/xampp/htdocs/ACProof/admin/list.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/
*/
// list.php - display list of all press releases
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<!-- 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>基本資料作業</font></td>
</tr>
</table>
<!-- standard page header ends -->
<p>
<?php $host="127.0.0.1";
$user="root";
$pass="fredsql";
$db="fograproof";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
//$link = mssql_connect("MACBOOK7", "sa", "fred5697");
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
$query = "SELECT * from ACdevice order by id desc";
$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))
{
?>
<font size="-1"><b> <?php echo $row->ddes;?></b> </font>
<br>
<font size="-2"><a href="edit.php?id=<?php print $row->id; ?>">edit</a> | <a href="delete.php?id=<?php print $row->id; ?>">delete</a></font>
<p>
<?php
}
mysql_close($connection);
?>
<font size="-2"><a href="add.php">add new</a></font>
<br>
<br>
<font size="-2"><a href="../acindex.php">Home</a></font>
<!-- standard page footer begins -->
<p>
<table width="100%" 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>, 2011. All rights reserved.<br><a href="http://www.fredkuo.idv.tw/wordpress">Read more.</a></td>
</tr>
</table>
<!-- standard page footer ends -->
</body>
</html>