<div class="container"> <div class="row"> <div class="tableHeading"> <p class="nomargin alignCenter"><?php echo isset($_GET['id']) ? 'Update' : 'Add'; ?> Supplier</p> </div> <?php $supplier = new supplier(); $ID = isset($_GET['id']) ? $_GET['id'] : NULL; if (isset($_POST['add_supplier'])) { // Update old record if (isset($ID)) { $results = $supplier->update_supplier($_POST, $ID); } else { // Insert new $results = $supplier->add_supplier($_POST); } if ($results) { echo '<div class="alert alert-success" role="alert"> Add Supplier Sucessfully </div>'; } else { echo '<div class="alert alert-danger" role="alert"> Error </div>'; } } if (isset($ID)) { $supplier_result = $supplier->get_supplier($ID); } ?>
$supplier_id = $_POST['id']; //make a connection to the database server $connection = $supplier->dbconnect(); $supplier->dbselect(); if (isset($_POST['addsupplier']) && !$_POST['id'] && !$_POST['mode']) { //add supplier information to the database $add = $supplier->addSupplier($companyname, $contactperson, $address1, $address2, $phone1, $phone2, $cell1, $cell2, $email, $fax, $banker, $bankdetail, $accountno, $creditlimit, $creditperiod); if ($add == true) { $message = "Supplier {$companyname} is Saved in the Database!"; } else { echo 'check your query'; } } else { if (isset($_POST['addsupplier']) && $supplier_id && !$_POST['mode']) { //here is where updation goes $edit = $supplier->update_supplier($supplier_id, $companyname, $contactperson, $address1, $address2, $phone1, $phone2, $cell1, $cell2, $email, $fax, $banker, $bankdetail, $accountno, $creditlimit, $creditperiod); if ($edit == true) { $message = "Supplier {$companyname} `s informations modified succesful"; } else { echo "Check query"; } } else { if (isset($_POST['addsupplier']) && $supplier_id && $_POST['mode']) { $delete = $supplier->detete_supplier($supplier_id); if ($delete) { $message = "Supplier {$companyname} deleted from the Database!"; } else { echo $delete; } } }