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="?name1">Имя</th></a>
        <th><a href="?surn">Фамилия</th></a>
        <th><a href="?phone1">Номер телефона</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['name1']) && !isset($_GET['surn']) && !isset($_GET['phone1'])) {
        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>";
    }
} elseif (isset($_GET['id']) && $_GET['id'] == 0) {
    $countid = 0;
    $countid ++;
     $order = $_GET['id'] == 'ASC' ? 'DESC' : 'ASC';
        $query = "SELECT * FROM `users` WHERE `check` = 1  ORDER BY `id` " .$order;
$result0 = mysqli_query($mysqlConnection,$query);
   while ($row = mysqli_fetch_array($result0)) {
    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>";
}
}
/*elseif (isset($_GET['id']) && $_GET['id'] != 0){
    $order = "DESC";
    $query = "SELECT * FROM `users` WHERE `check` = 1  ORDER BY `id`" .$order;
$result0 = mysqli_query($mysqlConnection,$query);
   while ($row = mysqli_fetch_array($result0)) {
    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>";
}
   }*/  elseif (isset($_GET['name1']) && $_GET['name1'] == 0){
    $order = 'ASC';
            $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `first_name` " .$order;
$result0 = mysqli_query($mysqlConnection,$query);
   while ($row = mysqli_fetch_array($result0)) {
    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>";

   }
} elseif (isset($_GET['surn']) && $_GET['surn'] == 0) {
    $order = 'ASC';
            $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `surname` " .$order;
$result0 = mysqli_query($mysqlConnection,$query);
   while ($row = mysqli_fetch_array($result0)) {
    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>";
    }
} elseif (isset($_GET['phone1'])&& $_GET['phone1'] == 0) {
     $order = 'ASC';
            $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `phone_number` " .$order;
$result0 = mysqli_query($mysqlConnection,$query);
   while ($row = mysqli_fetch_array($result0)) {
    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>";
    }
} elseif (isset($_GET['surn']) && $order == 'ASC') {
    $order = 'DESC';
              $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `surname` " .$order;
$result0 = mysqli_query($mysqlConnection,$query);
   while ($row = mysqli_fetch_array($result0)) {
    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>";
    }
}
/*else if (isset($_GET['name1'])) {
    $order = $_GET['id'] == 'ASC' ? 'ASC' : 'DESC';
}{
$order = 'DESC';
        $query = "SELECT * FROM `users` WHERE `check` = 1 ORDER BY `id` " .$order;
$result0 = mysqli_query($mysqlConnection,$query);
   while ($row = mysqli_fetch_array($result0)) {
    echo
     "<table class='tab2' border='2'  bgcolor='red' width='15%'>
    <tr  style='color: chartreuse'>
    <tr>
    <td>", $row[0], "</td>
    <td>", $row[1], "</td>
    <td >", $row[2], "</td>
    <td>", $row[3], "</td>
    </table>";

}
    }*/
   /* $sort = isset($_GET['surn']) ? $_GET['surn'] : 'desc';
    $order = "ORDER BY $sort";*/
/*$key = isset($_GET['key']) ? $_GET['key'] : 'number';*/

/*  if(isset($_GET['id'])) {
    $qr_result = mysql_query("SELECT * from `users` ORDER BY `id` ASC limit 1");
}
        elseif(isset($_GET['name1'])) {
            $qr_result = mysql_query("SELECT * from `users` ORDER BY `first_name` DESC");}
        elseif(isset($_GET['surn'])) {
            $qr_result = mysql_query("SELECT * from `users` ORDER BY `surname` DESC");
        }
        elseif(isset($_GET['phone1'])) {
            $qr_result = mysql_query("SELECT * from `users` ORDER BY `phone_number` DESC");
        } */
        /*while($data = mysqli_fetch_array($result0))
        {
          echo "<table class='tab2' border='3'  bgcolor='#ff7f50' width='15%'>
    <tr  style='color: chartreuse'>
             <tr>
             <td>$data[0]</td>
             <td>$data[1]</td>
             <td>$data[2]</td>
             <td>$data[3]</td>
            </tr>
            </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>