Tim Tehn lab d 2 - 3.dala

<?php

class db
{

    private $conn="";
    private $servername = "localhost";
    private $username = "root";
    private $password = "root";
    private $database="NikolaUpite";


    public function __construct() {

        $this->conn=new mysqli($this->servername, $this->username, $this->password,$this->database);
        echo "Successful connection. <br>";
        // check connection
        if ($this->conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }
    }



    public function printAllRecords() {


        $sql = "SELECT id, name, phonenumber, nickname, phonetype FROM phonebook";

        $result = $this->conn->query($sql);

        if ($result->num_rows > 0) {
        // output data of each row
            echo "<br>";
            while($row = $result->fetch_assoc()) {
                echo "ID: " . $row["id"]. " ||  Name: " . $row["name"]. " || Nickname: " . $row["nickname"]. "  ||  Phone number: " . $row["phonenumber"] . "  ||  Phone type: " . $row["phonetype"] . "<br>";
            }
        } else {
            echo "0 results";
        }

    }


    public function addNewRecord($id, $name, $phonenumber, $nickname, $phonetype) {

        $sql = "INSERT INTO phonebook (id, name, phonenumber, nickname, phonetype)
        VALUES ($id, '$name', '$phonenumber', '$nickname', $phonetype)";

        if ($this->conn->query($sql) === TRUE) {
            echo "New record created successfully <br>";
        } else {
            echo "Error: " . $sql . "<br>" . $this->conn->error;
        }
    }


    public function deleteRecord($id) {

        $sql = "DELETE FROM phonebook WHERE id=$id";

        if ($this->conn->query($sql) === TRUE) {
            echo "Record deleted";
        } else {
            echo "Error deleting record: " . $this->conn->error;
        }
    }


    public function updateRecord($id, $nickname) {

        $sql = "UPDATE phonebook SET nickname='$nickname  WHERE id=$id";

        if ($this->conn->query($sql) === TRUE) {
            echo "Record updated";
        } else {
            echo "Error updating record: " . $this->conn->error;
        }
    }


}



// How to use our object
$mydatabase=new db();
$mydatabase->addNewRecord("NULL","agnese","3231321","agneese","371");
//$mydatabase->deleteRecord("4");
//$mydatabase->updateRecord("6","andis3333");
$mydatabase->printAllRecords();




?>