<?PHP
// соединение с базой данных
require_once 'connect.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ru" lang="ru">
<head>
<title>Таблица</title>
<meta content="text/html; charset=windows-1251" http-equiv="Content-Type" />
<title>Таблица 2000 строк с фильтрацией</title>
<link rel='stylesheet' href='classes.css' type='text/css'>
<link rel='stylesheet' href='tabsort1.css' type='text/css'>
<script type='text/javascript'>var d0 = new Date()</script>
<script type='text/javascript' src='tabtools1.js'></script>
<script type='text/javascript' src='tabsort1.js'></script>
</head>
<?PHP
// Отображаем результаты
echo '<p>Таблицы, имеющиеся в базе данных: </p>';
echo "<table class='sortable' id='t' border=1 >";
echo "<col class='id'><col class='name'><col class='width'><col class='profile'><col class='radius'><col class='price'><col class='prices'><col class='sellers'><col class='season'><col class='status'>";
echo "<thead>";
echo "<tr>";
echo "<th axis='num'>ID </th>";
echo "<th>Улица </th>";
echo "<th axis='num:alt'>Width </th>";
echo "<th axis='num:alt'>Квартира </th>";
echo "<th axis='num:alt'>Radius </th>";
echo "<th axis='num'>Price </th>";
echo "<th>Prices </th>";
echo "<th axis='num'>Sellers </th>";
echo "<th>Season </th>";
echo "<th axis='num:alt'>Status </th>";
echo "</tr>";
echo "</thead>";
//Удаляем, если что
if (isset($_GET['del'])) { $result = mysql_query('DELETE FROM `user_profiles` WHERE `ID` = "'.$_GET['del'].'"'); if ($result) {
echo "<p>Товар удален.</p>";
} else {
echo "<p>Произошла ошибка.</p>";
}
}
//Получаем данные
echo '<form action="'.$_SERVER['PHP_SELF'].'" method="GET">';
foreach($row AS $key => $value) { $row[$key] = stripslashes($value); } echo "<tr>";
echo "<td valign='top'>" .$row['id']. "</td>";
echo "<td axis='num' valign='top'>" .$row['mes']. "</td>";
echo "<td valign='top'>" .$row['dom']. "</td>";
echo "<td valign='top'>" .$row['kvar']. "</td>";
echo "<td valign='top'>" .$row['password']. "</td>";
echo "<td valign='top'>" .$row['phon']. "</td>";
echo "<td valign='top'>" .$row['van1']. "</td>";
echo "<td valign='top'>" .$row['van2']. "</td>";
echo "<td valign='top'><a href=?del={$row['id']}>Delete</a></td> ";
echo '<td><input type="checkbox" name="row[]" value="'.$row['id'].'" /></td>';
echo "</tr>";
}
echo "</table>";
echo '<input type="submit" name="submitForm" value="Удалить отмеченные" />';
if ( isset ( $_GET['row'] ) ) {
foreach( $_GET['row'] as $value ) {
}
if ( count($items) > 0
) { $query = 'DELETE FROM items WHERE id IN ('.$ids.')';
}
header( 'Location: '.$_SERVER['PHP_SELF'] ); }
?>