php

<?php

        function connect_base()
                {
                $base = new mysqli("localhost","root","","base");
                if($base->connect_error)
                        die("connect error: ".$base->connect_error);
                return $base;
                }

        function select_list()
                {
                $base = connect_base();
                $list = "SELECT * FROM list";
                if($res = $base->query($list))
                        {if($res->num_rows > 0)
                               {$row = $res->fetch_all();}}
                else
                        echo $base->error;
                return $row;
                }

        function delete()
                {
                $base = connect_base();
                if(isset($_GET['del']))
                        {
                        $id = $_GET['del'];
                        $sql = "DELETE FROM list WHERE id = ?";
                        if($stmt = $base->prepare($sql))
                                {
                                $stmt->bind_param("i",$id);
                                $stmt->execute();
                                $stmt->close();
                                header("Location: /1/1.php");
                                }
                        else
                                echo "Запрос к БД не прошел".$base->error;
                        }
                }

        function record()
        {
                $base = connect_base();
                if(isset($_POST['firstname']))
                {
                        $first = $_POST['firstname'];
                        $last = $_POST['lastname'];
                        $first = mysqli_real_escape_string($base, $first);
                        $last = mysqli_real_escape_string($base, $last);
                               if($first !='' && $last !='')
                                {
                                       $sql = "INSERT INTO list VALUES(NULL, '$first','$last')";
                                       if($base->query($sql))
                                               header("Location: /sqli/my1.php");
                                       else
                                               echo "Запрос к БД не прошел".$base->error;
                                }
                               else
                                       echo "Заполните все поля";
                }
        }
?>