Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Первый файл
- require_once("2.php");
- if($connection == false){
- echo "Error!";
- echo mysqli_connect_errno();
- exit();
- }
- if (isset($_GET['page'])){
- $page = $_GET['page'];
- } else {
- $page = 1;
- }
- $limit = 12;
- $number = ($page * $limit) - $limit;
- $res_count = mysqli_query($connection, "SELECT COUNT(*) FROM zakaz1 ");
- $row = mysqli_fetch_row($res_count);
- $total = $row[0];
- $str_pag = ceil($total / $limit);
- $query = mysqli_query($connection, "SELECT * FROM zakaz1 ORDER BY Nomer DESC LIMIT $number, $limit");
- ?>
- <?php
- //============================================================================================ТАБЛИЦА
- echo "<table class='table table-inverse' align='center'>";
- echo "<th>Номер заказаᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ </th><th>Дата заказаᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ </th><th>Суммаᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ </th>";
- //=============================================================================================
- for ($i = 1; $i <=$str_pag; $i++){
- echo " <a href=1.php?page=".$i.">".$i."</a> ";
- }
- if(mysqli_num_rows($query) == 0){
- echo "There are no records!";
- } else {
- echo "<br/>";
- while($article = mysqli_fetch_assoc($query)){
- echo "<tr><td>".$article['Nomer']."</td><td>".$article['Date1']."</td><td>".$article['Sum']."</td><td><a href=del.php?Nomer=".$article['Nomer'].">Удалить</a></td></tr>";
- Второй файл==========================================================================================================================
- include_once '2.php'; // подключаем скрипт
- $Nomer = $_GET['Nomer'];
- mysql_query("DELETE FROM zakaz1 WHERE Nomer='$Nomer'")
- mysql_close();
- echo "Новость успешно удалена!!!";
Advertisement
Add Comment
Please, Sign In to add comment