1

<?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 add()
        {
                $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 "Заполните все поля";
                }
        }
?>


<!DOCTYPE html>
<html>
        <head>
                <title>Test Page</title>
                <script src="http://code.jquery.com/jquery-2.1.0.js"></script>
                <script>
                $(document).ready(function(){
                        $('button[data-del]').click(function(){
                                var id = $(this).data('del');
                                var answer = confirm("Вы действительно хотите удалить запись с ID=" + id);
                                if(answer)
                                {
                                        location.href = "index.php?page=delete&id=" + id;
                                }
                        });
                });
                </script>
                <meta charset="utf-8">
        </head>
        <body>
        <?php if(isset($_GET['page']) && $_GET['page']=="new") { ?>
                <h2>Новая запись</h2>
                <div>
                        <fieldset>
                                <legend>Новая запись</legend>
                                <form method="POST" action="<? $_SERVER['PHP_SELF'] ?>">
                                        <label>Введите имя:</label><br>
                                        <input type="text" name="first_name"><br>
                                        <label>Введите фамилию:</label><br>
                                        <input type="text" name="last_name"><br>
                                        <input type="submit" value="Добавить">
                                </form>
                        </fieldset>
                </div>
        <?php } else { ?>
                        <h2>Таблица</h2>
                        <table>
                                <tr>
                                        <th>id</th>
                                        <th>Имя</th>
                                        <th>Фамилия</th>
                                </tr>
                                <? foreach(select_list() as $row){ ?>
                                        <tr>
                                                <td><? echo $row['id'] ?></td>
                                                <td><? echo $row['first_name'] ?></td>
                                                <td><? echo $row['last_name'] ?></td>
                                                <td><button>Редактировать</button></td>
                                                <td><button data-del="<? echo $row['id'] ?>">Удалить</button></td>
                                        </tr>
                                <? } ?>
                        </table>
                        <p><a href="index.php?page=new">Добавить запись</a></p>
        <? } ?>
        </body>
</html>