Форумы портала PHP.SU

PHP:
скопировать код в буфер обмена
<?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&nbsp;</th>";
echo "<th>Улица&nbsp;</th>";
echo "<th axis='num:alt'>Width&nbsp;</th>";
echo "<th axis='num:alt'>Квартира&nbsp;</th>";
echo "<th axis='num:alt'>Radius&nbsp;</th>";
echo "<th axis='num'>Price&nbsp;</th>";
echo "<th>Prices&nbsp;</th>";
echo "<th axis='num'>Sellers&nbsp;</th>";
echo "<th>Season&nbsp;</th>";
echo "<th axis='num:alt'>Status&nbsp;</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">';
$result = mysql_query("SELECT * FROM `user_profiles`") or trigger_error(mysql_error());
while($row = mysql_fetch_array($result)){
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'] ) )
{
  $items = array();
  foreach( $_GET['row'] as $value ) {
    if ( ctype_digit($value) ) $items[] = $value;
  }
  if ( count($items) > 0 ) {
    $ids = implode( ',', $items );
    $query = 'DELETE FROM items WHERE id IN ('.$ids.')';
    mysql_query( $query );
  }
  header( 'Location: '.$_SERVER['PHP_SELF'] );
}
 
?>