<?php
require_once '../model/address.php';
require_once '../model/link_company_delivery_address.php';
//Création et ajout de l'adresse dans la base de données
if ($_GET) {
$naddress = new address();
foreach ($_GET as $key => $value) {
if ($key != "id_company") {
$nattr = "set" . ucfirst($key);
$naddress->{$nattr}($value);
}
}
$naddress->addToDatabase();
$id_address = $naddress->getId();
$id_company = $_GET["id_company"];
$nlcda = new link_company_delivery_address();
$nlcda->setId_company($id_company);
$nlcda->setId_address($id_address);
$nlcda->addToDatabase();
}
<?php
require_once '../model/link_company_delivery_address.php';
require_once '../model/address.php';
require_once '../model/database.php';
$id_DA = $_GET["idDA"];
$id_c = $_GET["idC"];
$pdo = database::getInstance();
$pdo = $pdo->PDOInstance;
$stmt = $pdo->prepare('SELECT id FROM link_company_delivery_address WHERE id_company = :idc and id_address = :ida');
$stmt->bindParam(':idc', $id_c);
$stmt->bindParam(':ida', $id_DA);
$stmt->execute();
$result = $stmt->fetch();
$idLDA = $result['id'];
$lda = new link_company_delivery_address($idLDA);
$address = new address($lda->getId_address());
?>
<h2>Set this Address to Database</h2>
<form method="get" action="../controller/setLinkDA.php">
<input type="hidden" name="idA" value="<?php
echo $address->getId();
?>
">
<input type="hidden" name="idC" value="<?php
echo $id_c;
?>
">
<div class="form-group">
<label for="line">Line</label>
<?php
require_once '../model/link_company_delivery_address.php';
require_once '../model/database.php';
$id_a = $_GET["idA"];
$id_c = $_GET["idC"];
$pdo = database::getInstance();
$pdo = $pdo->PDOInstance;
$stmt = $pdo->prepare('SELECT id FROM link_company_delivery_address WHERE id_company = :idc and id_address = :ida');
$stmt->bindParam(':idc', $id_c);
$stmt->bindParam(':ida', $id_a);
$stmt->execute();
$result = $stmt->fetch();
$idLDA = $result['id'];
$lda = new link_company_delivery_address($idLDA);
$lda->eraseOfDatabase();
header('location:../controller/viewCompany.php?id=' . $id_c);
exit;
