- Edited
I'm not long writing this, I'm questioning if this is the best way to do it
<?php
class AddShop{
public function __construct()
{
$db = $db = new Database;
$db->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_WARNING);
$this->db = $db;
}
public function address($lat, $lon, $shopName, $streetName, $streetNumber, $town, $region, $country, $postcode, $business, $phone)
{
$this->db->beginTransaction();
$insert = $this->db->prepare('INSERT INTO shopAddress (lat, lon, businessName, street, streetNumber, town, region, country, postcode, business, phone)
VALUES (:lat,:lon, :shopName, :streetName, :streetNumber, :town, :region, :country, :postcode, :business, :phone)');
$insert->execute(array(
':lat' => $lat,
':lon' => $lon,
':shopName' => $shopName,
':streetNumber' => $streetNumber,
':country' => $country,
':streetName' => $streetName,
':town' => $town,
':postcode' => $postcode,
':region' => $region,
':business' => $business,
':phone' => $phone,
));
$this->db->commit();
}
}
calling it
$newShop = new AddShop();
$newShop->address($lat, $lon, $shopName, $streetName, $streetNumber, $town, $region, $country, $postcode, $business, $phone);