<?php
class Fly {
    public $connect;
    CONST HOST = "localhost";
    CONST USER = "root";
    CONST PASSWORD = "74123";
    CONST DB = "fly";
    public function __construct(){
        $this->connect = new mysqli(self::HOST,self::USER,self::PASSWORD,self::DB);
        mysqli_query($this->connect,"SET NAMES UTF8");
        if( !$this->connect ){
            echo 'Ошибка соединения с базой ';
        }
    }
    public function savePost($person,$organisation,$phone,$email,$fax){
        $sql =  "INSERT INTO client(person,organisation,phone,email,fax) VALUES('$person','$organisation','$phone','$email','$fax')";
        $this->connect->query($sql);
        return $this->connect->insert_id;
    }
    public function savePost2($client_id,$date,$boom,$arrival,$numFlight,$dt,$class,$note){
        $dt = time('hh:mm::ss');
        $date = date('Y-m-h');
        $sql2 = "INSERT INTO routy(id_client,date,boom,arrival,numFlight,timeFight,class,note) VALUES('$client_id','$date','$boom','$arrival','$numFlight','$dt','$class','$note')";
        $this->connect->query($sql2);
    }
    public function getAll(){
        $sql = "SELECT * FROM client";
        $result = $this->connect->query($sql);
        echo "<table border='1'><tr><td><font color='red'><b>id</td><td>Person</td><td>Organisation</td><td>Phone</td><td>Email</td><td>Fax</td><td></td></tr>";
        while ($row = $result->fetch_row()) {
            echo "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td><td>" . $row[3] . "</td><td>" . $row[4] . "</td><td>" . $row[5] .  "</td><td><a href='gbook.php?del=$row[0]'>Удалить</a>" . "</tr><br>";
        }
        echo "</table>";
        return $result;
    }
    public function cleardata($data){
        $data= strip_tags($data); // удаляет HTML и PHP тэги из строки
        $data= trim($data); // удаляет символы с начала и конца строки
        $data= mysql_escape_string($data); // экранирует строку для использования в query
        return $data;
    }
    public function deletePost($id){
        $sql = "DELETE FROM client WHERE id=$id";
        $this->connect->query($sql);
    }
    public function __destruct(){
        unset( $this->connect );
    }

}