Advertisement
Manonimova

Do pokazania

May 29th, 2018
260
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.03 KB | None | 0 0
  1. #####################PHP - CONN_CFG.PHP
  2. <div style="background: lightblue;">
  3. <?php
  4. session_start();
  5. $servername = "localhost";
  6. $username = "root";
  7. $password = "";
  8. $db="mariolka";
  9. $conn = mysqli_connect($servername, $username, $password, $db);
  10. if (!$conn) {
  11.     die("Connection failed: " . mysqli_connect_error());
  12. }
  13. else {
  14. echo "Connected successfully";
  15. require_once("sesja.php");
  16. }
  17.  
  18.  
  19. $sql2 = "SELECT count(tresc) as licznik from posty";
  20. $count = mysqli_query($conn, $sql2);
  21. if (mysqli_num_rows($count)>0) {
  22.         while($row2 = mysqli_fetch_assoc($count)) {
  23.             echo "<br>";
  24.             $p1=$row2['licznik'];
  25.             echo $p1;
  26.             echo "<br>";
  27.             $p2=$_SESSION["offset"]+1;
  28.             echo $p2;
  29.             if ($p2==$p1) {
  30.                 require_once("restart.php");
  31.             }
  32.         }
  33. }
  34. else {
  35.     echo "Error: " . $sql . "<br>" . mysqli_error($conn);
  36. }
  37.  
  38. $oFF= $_SESSION["offset"];
  39. $sql = "SELECT * FROM `posty` LIMIT 1 OFFSET $oFF";
  40. $result = mysqli_query($conn, $sql);
  41. if (mysqli_num_rows($result)>0) {
  42.     while($row = mysqli_fetch_assoc($result)) {
  43.         echo "<br>"."ID_test: ".$row["id_posta"];
  44.     }
  45. }
  46. else {
  47.     echo "Error: " . $sql . "<br>" . mysqli_error($conn);
  48. }
  49. ?>
  50. </div>
  51. #####################PHP - SESJA.PHP
  52. <?php
  53. //session_start();
  54. if (isset($_SESSION["offset"])) {
  55.     $_SESSION["offset"]=$_SESSION["offset"]+1;
  56. }
  57. else {
  58.     $_SESSION["offset"] = 0;
  59. }
  60. ?>
  61. #####################PHP - RESTART.PHP
  62. <?php
  63. //session_start();
  64. session_destroy();
  65. ?>
  66. #####################INDEX.PHP w którym w sumie nie ma PHP xD
  67. <!DOCTYPE html>
  68. <html>
  69. <head>
  70. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  71. <meta charset="utf-8">
  72. <meta name="viewport" content="width=device-width, initial-scale=1">
  73. </head>
  74. <body>
  75.  
  76. <button>Sram psa jak srand</button>
  77. <div id="div"> </div>
  78. <script>
  79. //var xD;
  80. $("button").click(function(){
  81.     $.get("conn_cfg.php", function(data, status){
  82.         //$.get( "conn_cfg.php", { name: "John", time: "2pm" } );
  83.         document.getElementById("div").innerHTML=data;
  84.        
  85.     });
  86. });
  87.  
  88.  
  89.  
  90. </script>
  91. </body>
  92. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement