<?php


$servername = "127.0.0.1:3306";
$username = "root";
$password = "mysql";
$dbname = "DemoDB";

header('Content-type: application/json');
header('Access-Control-Allow-Origin: *');
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
// username and password sent from Form
    $officialname = isset($_POST['name']) ? $_POST['name'] : '';
    $contact_no = isset($_POST['contact_no']) ? $_POST['contact_no'] : '';
    $designation = isset($_POST['designation']) ? $_POST['designation'] : '';
    $branch = isset($_POST['testbranch']) ? $_POST['branch'] : '';
    $level0 = isset($_POST['test0']) ? $_POST['level0'] : '';
    $level1 = isset($_POST['test1']) ? $_POST['level1'] : '';
    $level2 = isset($_POST['test2']) ? $_POST['level2'] : '';
    $level3 = isset($_POST['test3']) ? $_POST['level3'] : '';
    $sevarthID = isset($_POST['regID']) ? $_POST['sevarthID'] : '';
    $email = isset($_POST['email']) ? $_POST['email'] : '';
    $password = isset($_POST['password']) ? $_POST['password'] : '';
    $cd = isset($_POST['created_date']) ? $_POST['created_date'] : '';
    $ud = isset($_POST['updated_date']) ? $_POST['updated_date'] : '';

    if ($officialname != '' && $contact_no != '' && $designation != '' && $testbranch != '' && $test0 != '' && $test1 != '' && $test2 != '' && $test3 != '' && $regID != '' && $email != '' && $password != '') {
        $enrypt_pass = md5($password);

        $sql = "SELECT id, contact_no FROM `registration` WHERE `contact_no` = '".$contact_no."'";


        $registrationArray = array();

        $result = $conn->query($sql);

        if ($result->num_rows > 0) {
            // output data of each row
            //echo 'test';
            while ($row = $result->fetch_assoc()) {
//                array_push($registrationArray, [
//                    'status' => false,
//                    'contact_no' => $row['contact_no'],
//                    'messege' => "This mobile no already registerd"
//                ]);
                $registrationArray['status'] = false;
                $registrationArray['contact_no'] = $row['contact_no'];
                $registrationArray['messege'] = 'This mobile no already registerd';

                $someJSON = json_encode($registrationArray);
                echo $someJSON;

            }
        } else {

            $sql = "INSERT INTO `registration` (name,contact_no,designation,testbranch,test0,test1,test2,test3,regID,email,password,created_date,updated_date) VALUES ('".$name."','".$contact_no."','".$designation."','".$testbranch."','".$test0."','".$test1."','".$test2."','".$test3."','".$regID."','".$email."','".$enrypt_pass."','".$cd."','".$ud."')";
            //echo $sql;die;
            try{
                if ($conn->query($sql) === TRUE) {
//                    array_push($registrationArray, [
//                        'status' => TRUE,
//                        'result' => "user register successfully"
//                    ]);
                    $registrationArray['status'] = true;

                $registrationArray['messege'] = 'user register successfully';
                    $printJSON = json_encode($registrationArray);
                    echo $printJSON;
                } else {
                    echo "Error: " . $sql . "<br>" . $conn->error;

                    array_push($registrationArray, [
                        'status' => false,
                        'result' => "user register failed"
                    ]);
                    $printJSON = json_encode($registrationArray);
                    echo $printJSON;
                }
            } catch (Exception $e){
                echo 'error-'.$e->getMessage();

            }

        }
        $conn->close();
    }else{
         $message['messege'] = 'something went wrong, please try again.';
    $printJSON = json_encode($message);
    echo $printJSON;
    }


} else {
   $message['messege'] = 'something went wrong, please try again.';
    $printJSON = json_encode($message);
    echo $printJSON;
}
?>