<?php 

include('../admin/inc/conn.php');
    date_default_timezone_set("Asia/Kolkata");
    $referred_by=$_POST['referred_by'];
    $name=$_POST['name'];
    $phone=$_POST['phone'];
    $exisiting=$_POST['exisiting'];
    $client_name=$_POST['client_name'];
    $client_email=$_POST['client_email'];
    $client_phone=$_POST['client_phone'];
    $client_name=$_POST['client_name'];
    $client_shop_name=str_replace("'", "\'", $_POST['client_shop_name']);
    $client_shop_address=str_replace("'", "\'", $_POST['client_shop_address']);
    $date=date('d-m-Y H:i:s');
        $location = '../admin/uploads/referral/';
        $blog_image = $_FILES['img']['name'];
        $tmp_name = $_FILES['img']['tmp_name'];
        $upload_dir = $location.$blog_image;
        if(move_uploaded_file($tmp_name, $upload_dir))
        { }
            $sql = "INSERT INTO `referral_programme` (`referred_by`, `name`, `phone`, `exisiting`, `client_name`, `client_email`, `client_phone`, `client_shop_name`, `client_shop_address`, `image`, `date`) VALUES ('$referred_by', '$name', '$phone', '$exisiting', '$client_name', '$client_email', '$client_phone', '$client_shop_name', '$client_shop_address', '$blog_image', '$date');";
            if (mysqli_query($con, $sql)) {
                echo json_encode(array("statusCode"=>200));
            } 
            else {
                echo json_encode(array("statusCode"=>201));
            }
        
    mysqli_close($con);
	

?>