<?php

    // Get the userimage and save it with a unique id
    $sFileExtension = pathinfo($_FILES['fileUserImage']['name'], PATHINFO_EXTENSION);
    $sFolder = 'img_webshop/';
    $sFileName = 'userimage-'.uniqid().'.'.$sFileExtension;
    $sSaveFileTo = $sFolder.$sFileName;
    move_uploaded_file( $_FILES['fileUserImage']['tmp_name'], $sSaveFileTo);

    try {

                // connect to the database
                require 'connect.php';
                // create a query
                $sUserName = $_POST['txtEmailorPhoneNumber'];
                $sFirstName = $_POST['txtFirstName'];
                $sLastName = $_POST['txtLastName'];
                $sPassword = $_POST['txtPassword'];
                $sImage = $sFolder.$sFileName;
                $query1 = $conn->prepare("INSERT INTO users ( userName, firstName, lastName, password, image ) VALUES ( :userName, :firstName, :lastName, :password, :image )");
                $query1->bindParam( ':userName' , $sUserName );
                $query1->bindParam( ':firstName' , $sFirstName );
                $query1->bindParam( ':lastName' , $sLastName );
                $query1->bindParam( ':password' , $sPassword );
                $query1->bindParam( ':image' , $sImage );
                // run the query
                $aResult = $query1->execute();
                $query2 = $conn->prepare("SELECT COUNT ( userRole ) as total FROM userRoles");
                $bResult = $query2->execute();
                if ($bResult === 0 ) {
                    $sUserRole = 'admin';
                }
                else {
                    $sUserRole = 'user';
                }
                $query3 = $conn->prepare("INSERT INTO userRoles ( userRole ) VALUES ( :userRole )");
                $query3->bindParam( ':userRole' , $sUserRole );
                $cResult = $query3->execute();
                $sjResponse = $cResult ? '{"status":"ok"}' : '{"status":"error"}';
                // $lastId = $query->lastInsertId();
                // $result = json_encode( $query->fetch(PDO::FETCH_ASSOC) );

                echo $sjResponse;


            } catch (Exception $e) {

                echo "ERROR";

            }

    ?>