Untitled


<html>
<head>
    <meta charset="utf-8">
    <title>My Form</title>
</head>
<body>
<table class="tab2" border="1">
    <tbody id="body">
    <tr>
        <th><a href="?id">№</th></a>
        <th><a href="?name">Имя</th></a>
        <th><a href="?surn">Фамилия</th></a>
        <th><a href="?phone">Номер телефона</th></a>
    </tr>
    <?php
const HOST_NAME = '127.0.0.1';
const DB_NAME = 'address_book';
const LOGIN_DB = 'basart';
const PASSWORD_DB = "megusta";
const PORT = 3306;
$mysqlConnection = new mysqli(HOST_NAME, LOGIN_DB, PASSWORD_DB, DB_NAME, PORT);
function addcheck ($mysqlConnection){
    $query1 = "SELECT * FROM `users` WHERE `check`= 1";
    $result = mysqli_query($mysqlConnection,$query1 );
     if ($ew1 =  mysqli_fetch_all($result)) {
        return $ew1;
    }
}
addcheck($mysqlConnection);
if(!isset($_GET['id']) && !isset($_GET['name']) && !isset($_GET['surn']) && !isset($_GET['phone'])) {
    echo "1";
        foreach (addcheck($mysqlConnection) as $key => $value) {
         echo
    "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
    <tr  style='color: chartreuse'>
    <tr>
    <td>", $value[0], "</td>
    <td>", $value[1], "</td>
    <td >", $value[2], "</td>
    <td>", $value[3], "</td>
    </table>";
    }
}
        if(isset($_GET['id'])) {
        echo "2";
        $desc = 0;
        $desc=$desc +1;
        $qr_result = mysqli_query($mysqlConnection,"SELECT * FROM `users` WHERE `check` = 1 ORDER BY `id` ASC");
         var_dump($desc);
        }if ($desc%2!=1){
            $qr_result = mysqli_query($mysqlConnection,"SELECT * FROM `users` WHERE `check` = 1 ORDER BY `id` DESC");
         }
        if(isset($_GET['name'])) {
            echo "3";
            $qr_result = mysqli_query($mysqlConnection,"SELECT * FROM `users` WHERE `check` = 1 ORDER BY `first_name` ASC");
        }
        if(isset($_GET['surn'])) {
            echo "4";
            $qr_result = mysqli_query($mysqlConnection,"SELECT * FROM `users` WHERE `check` = 1 ORDER BY `surname` ASC");
        }
        if(isset($_GET['phone'])) {
            echo "5";
            $qr_result = mysqli_query($mysqlConnection,"SELECT * FROM `users` WHERE `check` = 1 ORDER BY `phone_number` ASC");
        }
    while ($row = mysqli_fetch_array($qr_result)){
               echo
    "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
    <tr  style='color: chartreuse'>
    <tr>
    <td>", $row[0], "</td>
    <td>", $row[1], "</td>
    <td >", $row[2], "</td>
    <td>", $row[3], "</td>
    </table>";
}
    ?>

    </tr>
    </tbody>
</table>
<input type="button" value="Добавить" id="btnTrigger"/>
<input type="button" value="Удалить всё" id="deleteAllRows"/>
<form class="form" action="form.php" method="post" id="form">
    <p>My form</p>
    <fieldset>
        <legend>Запись данных</legend>
        <p><label for="name">Имя <em>*</em></label><input  type="text" id="name" name="name"></p>
        <p><label for="surname">Фамилия<em>*</em></label><input  type="text" id="surname"
                                                                name="surname"></p>
        <p><label for="phonenumber">Номер телефона<em>*</em></label><input  type="text" id="pn"
                                                                           name="pn"></p>
        <input type="submit" value="Добавить"  id="btnAdd"/>

    </fieldset>
<!--<script src="ajax.js" charset="utf-8"></script>-->
</body>