<?php 
ob_start();
session_start();
$pageTitle  = 'contact';
include 'init.php';
?>
<?php 
if (isset($_POST['Add_cons']) OR isset($_POST['add_mail_posts']) ) { 

    $ip = "";

    if (!empty($_SERVER["HTTP_CLIENT_IP"]))
    {
        // Check for IP address from shared Internet
        $ip = $_SERVER["HTTP_CLIENT_IP"];
    }
    elseif (!empty($_SERVER["HTTP_X_FORWARDED_FOR"]))
    {
        // Check for the proxy user
        $ip = $_SERVER["HTTP_X_FORWARDED_FOR"];
    }
    else
    {
        $ip = $_SERVER["REMOTE_ADDR"];
    }

    if (isset($_POST['Add_cons'])){
        $checkip     = $conn->prepare("SELECT ipcons FROM consultation WHERE ipcons = ? AND adddatecons between  date_sub(now(),INTERVAL 1 WEEK) and now() ");
        $checkip->execute(array($ip));
        $check1 = $checkip->rowcount();
        if ($check1 == 1) {
           
            header('Location:ret.php?b');
            exit;

        }else{
            
    $name             = filter_var($_POST['cons_nme'], FILTER_SANITIZE_STRING);
    $email            = filter_var($_POST['cons_email'], FILTER_SANITIZE_STRING);
    $phone            = filter_var($_POST['cons_phone'], FILTER_SANITIZE_STRING);
    $exp              = filter_var($_POST['cons_exp'], FILTER_SANITIZE_STRING);
    $coty             = filter_var($_POST['constype'], FILTER_SANITIZE_NUMBER_INT);
       
    $stmt = $conn->prepare("INSERT INTO 
    consultation(namecons, phonecons, emailcons, expcons, typecons, ipcons, adddatecons)
    VALUES (:znam, :zpho, :zema, :zexp, :zcot, :zipp, now() ) ");

    $stmt->execute(array(
        'znam'     => $name,
        'zpho'     => $phone,
        'zema'     => $email,
        'zexp'     => $exp,
        'zcot'     => $coty,
        'zipp'     => $ip

    ));

    header('location:ret.php?a');
  
    exit();

}
}
if (isset($_POST['add_mail_posts'])){


    $nltemail             = filter_var($_POST['cus_mail_post'], FILTER_SANITIZE_STRING);

    $checkip     = $conn->prepare("SELECT mailnewsip FROM mailnewsletter WHERE mailnewsip = ?");
    $checkip->execute(array($ip));
    $check1 = $checkip->rowcount();

    $checkemail     = $conn->prepare("SELECT mailnewsemail FROM mailnewsletter WHERE mailnewsemail = ?");
    $checkemail->execute(array($nltemail));
    $check2 = $checkemail->rowcount();

    if ($check1 > 2) {
           
        header('Location:ret.php?c');
        exit;

    }elseif ($check2 == 1) {
           
        header('Location:ret.php?d');
        exit;

    }else{

    $stmt22 = $conn->prepare("INSERT INTO 
    mailnewsletter(mailnewsemail, mailnewsip, mailnewsadddate)
    VALUES (:zema, :zipp, now() ) ");

    $stmt22->execute(array(
        'zema'     => $nltemail,
        'zipp'     => $ip

    ));

    header('location:ret.php?e');
  
    exit();

    }

}
 }else{
header('Location:index.php');
exit;}?>
<?php
include $tpl . 'footer_ar.php';
ob_end_flush();
?>