Advertisement
Guest User

Untitled

a guest
Apr 10th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.32 KB | None | 0 0
  1. $servername = "localhost";
  2.         $username = "Oglasi";
  3.         $password = "Oglasi";
  4.         $dbname = "oglasi";
  5.  
  6.         $link = new mysqli($servername, $username, $password, $dbname);
  7.         if ($link->connect_error) {
  8.             die("Connection failed: " . $link->connect_error);
  9.         }
  10.         $stmt = $link->prepare("delete from komentarji where idKomentarja = ?");
  11.         $stmt->bind_param("i", $idKomentarja);
  12.  
  13.         $stmt->execute();
  14.     }
  15.     public static function top5(){
  16.         $servername = "localhost";
  17.         $username = "Oglasi";
  18.         $password = "Oglasi";
  19.         $dbname = "oglasi";
  20.  
  21.         $link = new mysqli($servername, $username, $password, $dbname);
  22.         if ($link->connect_error) {
  23.             die("Connection failed: " . $link->connect_error);
  24.         }
  25.  
  26.         /* create a prepared statement */
  27.         if ($stmt = mysqli_prepare($link, "SELECT * FROM komentarji order by datumKomentarja desc limit 5 ")) {
  28.             $stmt->execute();
  29.             $result = $stmt->get_result();
  30.             while ($row = $result->fetch_assoc()) {
  31.                 $oglas=new Komentar($row["idOglasa"],$row["vsebinaKomentarja"],$row["vzdevekKomentatorja"],$row["emailKomentatorja"],$row["idKomentarja"]);
  32.                 $komentarji[]=$oglas;
  33.         }
  34.         return $komentarji;
  35.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement