Advertisement
Guest User

Untitled

a guest
Mar 5th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.85 KB | None | 0 0
  1. <?php
  2. $db_host = "sql.your.server";
  3. $db_user = "login";
  4. $db_pass = "p@$$w0|^d";
  5. $db_name = "name";
  6.  
  7. $mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
  8. if (mysqli_connect_errno() != 0) {
  9.     echo '<p>Wystąpił błąd połączenia: ' . mysqli_connect_error() . '</p>';
  10.     exit();
  11. } else {
  12.     $mysqli->set_charset("utf8");
  13. }
  14.  
  15.  
  16. $query = $mysqli->query("SELECT a ,b ,c
  17. FROM `sample_arts` art
  18. JOIN `sample_users` users ON (users.id = art.author)
  19. WHERE art.deleted = 0
  20. LIMIT 10");
  21. while ($arts = $query->fetch_assoc()) {
  22.     echo "<li>" . $arts['a'] . "</li>";
  23. }
  24.  
  25.  
  26. // insert do bazy
  27.  
  28. $query = $mysqli->prepare("INSERT INTO `sample_arts_test` (`title`, `date_add`, `text`, `author`)
  29.            VALUES (?, now(), ?, ?  )");
  30. $query->bind_param('sss', $new_art['title'], $new_art['text'], $author);
  31. $query->execute();
  32.  
  33.  
  34. $mysqli->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement