Advertisement
Bozman2024

deliveryAddresses.php

Jul 2nd, 2024
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.72 KB | None | 0 0
  1. <?php
  2.  
  3. function saveDeliveryAddressForUser(int $userId, string $recipient, string $city, string $zipCode, string $street, string $streetNumber): int
  4. {
  5.     $sql = "INSERT INTO delivery_adresses
  6.  SET user_id = :userId,
  7.  recipient = :recipient,
  8.  city = :city,
  9.  street = :street,
  10.  streetNumber = :streetNumber,
  11.  zipCode = :zipCode
  12.  ";
  13.  
  14.     $statement = getDB()->prepare($sql);
  15.     if (false === $statement) {
  16.         return 0;
  17.     }
  18.  
  19.     $statement->execute([
  20.         ':userId' => $userId,
  21.         ':recipient' => $recipient,
  22.         ':city' => $city,
  23.         ':street' => $street,
  24.         ':streetNumber' => $streetNumber,
  25.         ':zipCode' => $zipCode
  26.     ]);
  27.  
  28.     return (int)getDB()->lastInsertId();
  29. }
  30.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement