Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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";
- }
- ?>
Add Comment
Please, Sign In to add comment