Advertisement
Guest User

Untitled

a guest
Jan 2nd, 2016
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.09 KB | None | 0 0
  1. <?php
  2. $servername = "mysql.hostinger.pl";
  3. $username = "u528067218_kuba";
  4. $password = "*********";
  5. $db = "u528067218_baza";
  6. $content = $_POST['zawartosc'];
  7. $news = $_POST['wiadomosc'];
  8. $autor = "Admin";
  9. $data = date(Y-m-d);
  10. $conn = new mysqli($servername, $username, $password,$db);
  11. $ok= false ;
  12.  
  13. session_start();
  14. if ($conn->connect_error) {
  15.     die("Connection failed: " . $conn->connect_error);
  16. }
  17.  
  18.  if($news && $content == "")
  19.  {
  20.      header("Location:index.php");
  21.  }
  22.  else
  23.  {
  24. $conn->query("INSERT INTO tabela VALUES('$content','$news', '$data','$autor',NULL)");
  25. $sql = "SELECT * FROM tabela";
  26. $result = $conn->query($sql);
  27. if ($result->num_rows > 0) {
  28.     // output data of each row
  29.     while($row = $result->fetch_assoc()) {
  30.     echo '<table width="1000">';
  31.     echo "<tr>";
  32.        
  33.         echo  "<td>".$row['post']."</td>";
  34.         echo  "<td>".$row['data']."</td>";
  35.         echo "<td>".$row['autor']."</td>";
  36.         echo "</tr>";
  37.          
  38.          
  39.          
  40.     echo "</table>";
  41.     }
  42. } else {
  43.     echo "Nie zwrocono zadnych rekordow";
  44. }
  45. }
  46. $conn->close();
  47.  
  48.  
  49. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement