<?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;