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 = editAddressServices($id);

$user_manager    = CheckManager($user_id);

$state_all = StateAll();

if ($_REQUEST['edit_address'] == '1') {    

    extract($_POST);    

    $sql = "UPDATE sohorepro_address_service

			SET     comp_id         = '". $company_id ."',
<?php
include "./admin/config.php";
$_SESSION['job'] = $_REQUEST['jobref'];
$_SESSION['qty'] = $_REQUEST['quantity'];
$user_id = $_SESSION['sohorepro_userid'];
$company_id = company_id($user_id);
$state_all = StateAll();
if ($_REQUEST['new_address'] == '1') {    
    extract($_POST);    
    $sql = "INSERT INTO sohorepro_address_service
			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."' ";
    $sql_result = mysql_query($sql);
    if ($sql_result) {
        $result = "success";
    } else {
        $result = "failure";
    }
}
?>
Exemple #3
0
function company_count()
{
    return Query::table(Base::table('posts'))->where('company', '=', company_id())->where('status', '=', 'published')->count();
}
<?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 = editAddressServices($id);
$user_manager    = CheckManager($user_id);
$state_all = StateAll();
if ($_REQUEST['edit_address'] == '1') {    
    extract($_POST);    
    $sql = "UPDATE sohorepro_address_service
			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'))
    {