コード例 #1
0
function saveEditSupplier($handler, $supplierId, $vendor, $name, $tel, $fax, $info, $dumptime, $line1, $line2, $city, $state, $zip, $box)
{
    $supplier = getBasicSupplierInfo($handler, $supplierId);
    $tel = cleanPhoneNumber(mysql_real_escape_string($tel));
    $fax = cleanPhoneNumber(mysql_real_escape_string($fax));
    $addressId = editAddress($handler, $supplier['addressId'], $line1, $line2, $city, $state, $zip, $box);
    $supplierQuery = "UPDATE supplier SET\n\t\tsupplierName = '{$name}',\n\t\tvendorId = '{$vendor}',\n\t\tsupplierTel = '{$tel}',\n\t\tsupplierFax = '{$fax}',\n\t\tsupplierInfo = '{$info}',\n\t\tsupplierDumptime = '{$dumptime}'\n\tWHERE supplierId = '{$supplierId}'";
    mysql_query($supplierQuery, $handler);
    return $supplierId;
}
コード例 #2
0
ファイル: edit_address.php プロジェクト: njassim/SOHO_REPRO
<?php
include './admin/config.php';
include './admin/db_connection.php';
$id = $_GET['id'];
$_SESSION['job'] = $_REQUEST['jobref'];
$_SESSION['qty'] = $_REQUEST['quantity'];
$user_id = $_SESSION['sohorepro_userid'];
$id_user = $_SESSION['sohorepro_companyid'];
$company_id = company_id($user_id);
$editAddress = editAddress($id);
$user_manager    = CheckManager($user_id);
$state_all = StateAll();
if ($_REQUEST['edit_address'] == '1') {    
    extract($_POST);    
    $sql = "UPDATE sohorepro_address
			SET     comp_id         = '". $company_id ."',
                                company_name    = '". $comp ."',
                                address_1       = '". $add1 ."',                        
                                address_2       = '". $add2 . "',  
                                address_3       = '". $add3 . "',  
                                city            = '". $city ."',
                                state           = '". $state."',   
				zip             = '". $zip ."',
                                zip_ext         = '" . $zipext."',
                                phone           = '". $phone ."',
                                extension       = '". $ext ."',
                                attention_to    = '". $attention."' WHERE id = '".$id."' ";
    $sql_result = mysql_query($sql);        
    if(($user_manager == '1') && ($editAddress[0]['type'] == '1'))
    {
  ?>