<?php
include('../helpers/init.php');
if(isset($_POST['addClient']))
{
    $city = $_POST['citynem'];
    $client = $_POST['name'];
    $name = str_replace("'","",$_POST['name']);
	$name = str_replace('"','\"',$name);
	$slug = slug($name);
    $error = "";
    $sql = "insert into clients(name,city,slug) values('$client','$city','$slug')";
		if(query($sql)){
			header('Location:../pages/add_client.php?&result=success');
		}else{
			$error = error();
			header('Location:../pages/add_client.php?&result=failer');
		}
	
}

//-----------------------Add Client Edns Here ---------------



if(isset($_GET['action']) && $_GET['action']=="delClient")
{
	$id=$_GET['id'];
    $clients = getWhere("client_images","client_id",$id);
	if(num_rows($clients)){
		$error = " Cannot be deleted because ".num_rows($clients)." Gallery Images are added with this Client.";
		header("Location:../pages/add_client.php?result=failer&message=".$error);
	}
    else
    {
		$sql = "delete from clients where id=$id";
		if(query($sql))
        {
			header("Location:../pages/add_client.php?result=dsuccess");
		}
            else{
			$error =  error();
			header("Location:../pages/add_client.php?result=failer&message=".$error);
		  }
    }

}

//------------- Delete Category Ends Here-------------------


if(isset($_POST['updateClient'])){
	$id = $_POST['id'];
    $cont = $_POST['content'];   
    $seot = $_POST['seo_title'];    
    $seod = $_POST['seo_description'];
    
	 	$sql = "update clients set content='$cont', seo_title='$seot', seo_description='$seod' where id='$id'";
		if(query($sql)){
			header('Location:../pages/manage_client.php?id='.$id.'&result=success');
		}else{
			$error =  error();
			header('Location:../pages/manage_client.php?id='.$id.'&result=failer');
		}
	/*end of */
	}




?>