Вот код скрипта:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<style type="text/css">
body {
background-image: url(img/linen.jpg);
}
</style>
<title>Список ремонтов</title>
</head>
<body>
<?php
#-------------------------------------------------------------------------------
$server = "localhost";
$username = "user";
$password = "resu";
$base = "rprint";
mysql_connect($server, $username, $password) or
die ("Could not connect: " . mysql_error());
mysql_select_db($base);
mysql_query("SET NAMES utf8");
#-------------------------------------------------------------------------------
$res1 = mysql_query ("SELECT id, mag, addres, prn, inv_n, sn, zak_n,date_zak, statrem,
problem, comment FROM rem");
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
echo ("
<style type=\"text/css\">
<!--
body { font: 12px Arial; color: black; }
h3 { font-size: 16px; text-align: center; }
table { width: 90%; border-collapse: collapse; margin: 0px auto; background: #33FF99; }
td { padding: 3px; text-align: center; vertical-align: middle; }
.buttons { width: auto; border: double 1px #666666; background: #D6D6D6; }
tr.marked{background-color: yellow;}
-->
</style>
<body>
<center><img src='img/comfy-logo.png'></br>
<h3>Перечень ремонтов</h3><form name=search action=filtr.php method='post'>
<p>Введите инв номер:<br/><input type=text name='inv_n'/></br>
<p><input type='submit' name='submit' value='поиск'>
</form>
<hr>
<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\">
<tr style=\"border: solid 1px #000\">
<td><b>№</b></td>
<td align=\"center\"><b>Магазин</b></td>
<td align=\"center\"><b>Адрес</b></td>
<td align=\"center\"><b>Принтер</b></td>
<td align=\"center\"><b>инв№</b></td>
<td align=\"center\"><b>S/N</b></td>
<td align=\"center\"><b>Номер SD</b></td>
<td align=\"center\"><b>Дата заявки</b></td>
<td align=\"center\"><b>состояние заявки</b></td>
<td align=\"center\"><b>Проблема</b></td>
<td align=\"center\"><b>Комментарий</b></td>
</tr>
");
/* Цикл вывода данных из базы конкретных полей */
while ($row = mysql_fetch_array($res1)) {
echo "<tr >\n";
echo "<td >".$row['id']."</td>\n";
echo "<td>".$row['mag']."</td>\n";
echo "<td>".$row['addres']."</td>\n";
echo "<td>".$row['prn']."</td>\n";
echo "<td>".$row['inv_n']."</td>\n";
echo "<td>".$row['sn']."</td>\n";
echo "<td>".$row['zak_n']."</td>\n";
echo "<td>".$row['date_zak']."</td>\n";
echo "<td>".$row['statrem']."</td>\n";
echo "<td>".$row['problem']."</td>\n";
echo "<td>".$row['comment']."</td>\n</tr>\n";
}
if ($row['statrem'] === 'в работе'){
}
echo ("</table>\n");
echo "<hr>";
echo "<input type=button value='новый ремонт' onclick=parent.location='newrem.php'>";
?>
</body>
</html>
|