<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
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);
$query = "SELECT * FROM `users`";
$rs = mysqli_query($mysqlConnection , $query );
?>
<form class="datalogin" action="login.php" method="post" id="datalogin">
<fieldset>
    <legend>Все данные</legend>
<?php
while ($row = mysqli_fetch_assoc($rs)) {
    echo
    "<table class='tab2' border='2'  bgcolor='#ff7f50' width='15%'>
    <tr  style='color: chartreuse'>
    <tr>
    <td>", $row['first_name'], "</td>
    <td>", $row['surname'], "</td>
    <td >", $row['phone_number'], "</td>"
    ?>
    <input type="checkbox" name="checkthis[]" value="<?php echo $nm; ?>"> Yes <br>
    <?php
    "</tr>

    </table>";
}
?>
<input type="submit" name="senddata">
</fieldset>
</form>
<?php

if ($mysqlConnection->connect_error) die ($mysqlConnection->connect_error);

if (isset($_POST['name']) && isset($_POST['surname']) && isset($_POST['pn'])){
    if ((!empty($_POST['name']) && !empty($_POST['surname']) && !empty($_POST['pn']))) {
        $nm = $_POST['name'];
        $sn = $_POST['surname'];
        $pn = $_POST['pn'];
        $checkvalidationname = preg_match('/^[A-Z\d]+$/i', $nm);
        $checkvalidatonsurname = preg_match('/^[A-Z\d]+$/i', $sn);
        $checkvalidationphone_number = preg_match('/^\+380\d{2}\d{2}\d{3}\d{2}$/', $pn);
        $checkvalidation = $checkvalidationname && $checkvalidatonsurname && $checkvalidationphone_number;
        if ($checkvalidation === true) {
            $result = mysqli_query($mysqlConnection, "INSERT INTO `users` (`first_name`, `surname`, `phone_number`) VALUES ('$nm', '$sn', '$pn');");
            echo "New record created successfully";
        } else {
            echo "create record failed";
        }
    } else {
        echo "Your fileds is empty or you need to fill all fields";

    }

}
    mysqli_close($mysqlConnection);