Kode_Omut

Untitled

Jan 21st, 2019
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. Первый файл
  2.  
  3. require_once("2.php");
  4. if($connection == false){
  5. echo "Error!";
  6. echo mysqli_connect_errno();
  7. exit();
  8. }
  9. if (isset($_GET['page'])){
  10. $page = $_GET['page'];
  11. } else {
  12. $page = 1;
  13. }
  14. $limit = 12;
  15. $number = ($page * $limit) - $limit;
  16. $res_count = mysqli_query($connection, "SELECT COUNT(*) FROM zakaz1 ");
  17. $row = mysqli_fetch_row($res_count);
  18. $total = $row[0];
  19. $str_pag = ceil($total / $limit);
  20. $query = mysqli_query($connection, "SELECT * FROM zakaz1 ORDER BY Nomer DESC LIMIT $number, $limit");
  21. ?>
  22.  
  23. <?php
  24. //============================================================================================ТАБЛИЦА
  25. echo "<table class='table table-inverse' align='center'>";
  26. echo "<th>Номер заказаᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ </th><th>Дата заказаᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ </th><th>Суммаᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ ᅠ </th>";
  27. //=============================================================================================
  28. for ($i = 1; $i <=$str_pag; $i++){
  29. echo " <a href=1.php?page=".$i.">".$i."</a> ";
  30. }
  31. if(mysqli_num_rows($query) == 0){
  32. echo "There are no records!";
  33. } else {
  34.  
  35. echo "<br/>";
  36. while($article = mysqli_fetch_assoc($query)){
  37.  
  38. 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>";
  39.  
  40.  
  41. Второй файл==========================================================================================================================
  42.  
  43. include_once '2.php'; // подключаем скрипт
  44.  
  45. $Nomer = $_GET['Nomer'];
  46.  
  47. mysql_query("DELETE FROM zakaz1 WHERE Nomer='$Nomer'")
  48.  
  49. mysql_close();
  50.  
  51. echo "Новость успешно удалена!!!";
Advertisement
Add Comment
Please, Sign In to add comment