Advertisement
Guest User

kod

a guest
Jan 2nd, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.21 KB | None | 0 0
  1. $servername = "mysql.hostinger.pl";
  2. $username = "u528067218_kuba";
  3. $password = "**********";
  4. $db = "u528067218_baza";
  5. $content = $_POST['zawartosc'];
  6. $news = $_POST['wiadomosc'];
  7. $autor = "Admin";
  8. $data = "2016-01-31";
  9. $conn = new mysqli($servername, $username, $password,$db);
  10. $ok= false ;
  11.  
  12. session_start();
  13. if ($conn->connect_error) {
  14.     die("Connection failed: " . $conn->connect_error);
  15. }
  16. if((strlen($content && $news)==0))
  17. {
  18.     echo "Pola nie mogą byc puste";
  19.     header('Location: admin.html');
  20. }
  21. else
  22. {
  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.         header('Location: zupdatowano.php');
  30.     while($row = $result->fetch_assoc()) {
  31.     echo '<table width="1000">';
  32.     echo "<tr>";
  33.        
  34.         echo  "<td>".$row['post']."</td>";
  35.         echo "<td>".$row['autor']."</td>";
  36.         echo  "<td>".$row['news']."</td>";
  37.         echo  " <td>".$row['id']."</td>";
  38.         echo "</tr>";
  39.          
  40.          
  41.          
  42.     echo "</table>";
  43.     }
  44. } else {
  45.     echo "Nie zwrócono zadnych rekordów";
  46. }
  47. $conn->close();
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement