header("Location: /staff/?id=notFound"); exit; } $sqltext = "SELECT * FROM contacts,address WHERE contacts.addsid=address.addsid AND contactsid=?"; // print "<br>$sqltext"; $q = $db->select($sqltext, array($_GET['id']), 'i'); $r = $q[0]; $addsid = $r->addsid; if (isset($_GET['remove']) && $_GET['remove'] == "y" && isset($_GET['id']) && is_numeric($_GET['id'])) { db_delete("contacts", $_GET['id'], 'contactsid'); header("Location: /contacts/"); exit; } if (isset($_GET['go']) && $_GET['go'] == "y") { // Add to Address table $addsid = db_updateAddress($_POST, $addsid); $contactsUpdate = new Contacts(); // Update DB $contactsUpdate->setContactsid($_GET['id']); $contactsUpdate->setFname($_POST['fname']); $contactsUpdate->setSname($_POST['sname']); $contactsUpdate->setCo_name($_POST['co_name']); $contactsUpdate->setRole($_POST['role']); $contactsUpdate->setCustid($_POST['custid']); $contactsUpdate->setSuppid($_POST['suppid']); $contactsUpdate->setNotes($_POST['notes']); $contactsUpdate->updateDB(); header("Location: /contacts/?Updated=" . $result['id']); exit; } $pagetitle = "Edit contact";
$pagetitle = 'Company Details'; $navtitle = 'Home'; $keywords = ''; $description = ''; $addsid = 100; $fields = array('co_name', 'co_no', 'vat_no', 'colour', 'athenaemail', 'athenaemailpw', 'emailsmtpsrv'); foreach ($fields as $field) { if (!isset($_POST[$field])) { $_POST[$field] = ''; } } // Check if we have Form Data to process if (isset($_GET['go']) && $_GET['go'] == "y") { $logContent = ''; // Update Address table $addsid = db_updateAddress($_POST, 100); # Update DB $ownerUpdate = new Owner(); $ownerUpdate->setOwnerid(100); $ownerUpdate->setCo_name($_POST['co_name']); $ownerUpdate->setVat_no($_POST['vat_no']); $ownerUpdate->setCo_no($_POST['co_no']); $ownerUpdate->setAthenaemail($_POST['athenaemail']); $ownerUpdate->setAthenaemailpw($_POST['athenaemailpw']); $ownerUpdate->setEmailsmtpsrv($_POST['emailsmtpsrv']); $res = $ownerUpdate->updateDB(); header("Location: index.php?updateOwner=" . $res); exit; } // Define elements for the HTML Header include $pagetitle = "Edit Your Company Details";