PHP supplier::update_supplier Examples

Example #1

File: add_supplier.php Project: TheHanif/POS-Faizan

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

Example #2

File: add_supplier.php Project: patmark/care2x-tz

$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;
            }
        }
    }