Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $servername = "localhost";
- $username = "Oglasi";
- $password = "Oglasi";
- $dbname = "oglasi";
- $link = new mysqli($servername, $username, $password, $dbname);
- if ($link->connect_error) {
- die("Connection failed: " . $link->connect_error);
- }
- $stmt = $link->prepare("delete from komentarji where idKomentarja = ?");
- $stmt->bind_param("i", $idKomentarja);
- $stmt->execute();
- }
- public static function top5(){
- $servername = "localhost";
- $username = "Oglasi";
- $password = "Oglasi";
- $dbname = "oglasi";
- $link = new mysqli($servername, $username, $password, $dbname);
- if ($link->connect_error) {
- die("Connection failed: " . $link->connect_error);
- }
- /* create a prepared statement */
- if ($stmt = mysqli_prepare($link, "SELECT * FROM komentarji order by datumKomentarja desc limit 5 ")) {
- $stmt->execute();
- $result = $stmt->get_result();
- while ($row = $result->fetch_assoc()) {
- $oglas=new Komentar($row["idOglasa"],$row["vsebinaKomentarja"],$row["vzdevekKomentatorja"],$row["emailKomentatorja"],$row["idKomentarja"]);
- $komentarji[]=$oglas;
- }
- return $komentarji;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement