conjoinedly

Back Back Up Advanced Editor

<?php  session_start();
include("../../config/config.php");
include("../validateuserlogin.php");

$company_name	=   secureSuperGlobalPOST($_REQUEST[SESS_MASTER.'company_name']);
$footer_change	=   secureSuperGlobalPOST($_REQUEST[SESS_MASTER.'footer_change']);
$copyright	    =   secureSuperGlobalPOST($_REQUEST[SESS_MASTER.'copyright']);
$datecreated=date("Y-m-d H:i:s");

try{
echo $rows_found_settings;
  	if($rows_found_settings>0){

$olgaquerys="UPDATE website_setting SET datecreated='$datecreated' ";

if(!empty($company_name)){
            $olgaquerys=$olgaquerys." ,company='$company_name'";

}
		     if(!empty($footer_change)){

$olgaquerys=$olgaquerys." ,footer='$footer_change'";
		   }
		   if(!empty($copyright)){

$olgaquerys=$olgaquerys." ,copyright='$copyright'";
		   }
		$stmts = $conn->prepare($olgaquerys);
		if($stmts->execute()){

header("location:../dashboard.php");

}
		}else{
			 $olgaquerys="INSERT INTO website_setting SET datecreated='$datecreated' ";

if(!empty($company_name)){
            $olgaquerys=$olgaquerys." company='$company_name'";

}
		     if(!empty($footer_change)){

$olgaquerys=$olgaquerys." ,footer='$footer_change'";
		   }
		   if(!empty($copyright)){

$olgaquerys=$olgaquerys." ,copyright='$copyright'";
		   }
		$stmts = $conn->prepare($olgaquerys);
		if($stmts->execute()){

header("location:../dashboard.php");

}

}
 
 
   }
         
        // show error
        catch(PDOException $exception){
            die('ERROR: ' . $exception->getMessage());
        }