save-zap-contact zappanell.php

/*BY: ASK JARVIS + DANTE TESTA */

<?php

//CARGA DOS DADOS PARA FUNÇÃO
$name   ='TURBOLINO VALMERTIL';
$phone  ="5522982085512";
$tag    ="1";
$user   ="1";

//CHAMADA DE FUNÇÃO
insere_contato($name,$phone,$tag,$user);



function insere_contato($name,$phone,$tag,$user){
    
$caracteres_sem_acento = array(
    'Š'=>'S', 'š'=>'s', 'Ð'=>'Dj','Ž'=>'Z', 'ž'=>'z', 'À'=>'A', 'Á'=>'A', 'Â'=>'A', 'Ã'=>'A', 'Ä'=>'A',
    'Å'=>'A', 'Æ'=>'A', 'Ç'=>'C', 'È'=>'E', 'É'=>'E', 'Ê'=>'E', 'Ë'=>'E', 'Ì'=>'I', 'Í'=>'I', 'Î'=>'I',
    'Ï'=>'I', 'Ñ'=>'N', 'Ń'=>'N', 'Ò'=>'O', 'Ó'=>'O', 'Ô'=>'O', 'Õ'=>'O', 'Ö'=>'O', 'Ø'=>'O', 'Ù'=>'U', 'Ú'=>'U',
    'Û'=>'U', 'Ü'=>'U', 'Ý'=>'Y', 'Þ'=>'B', 'ß'=>'Ss','à'=>'a', 'á'=>'a', 'â'=>'a', 'ã'=>'a', 'ä'=>'a',
    'å'=>'a', 'æ'=>'a', 'ç'=>'c', 'è'=>'e', 'é'=>'e', 'ê'=>'e', 'ë'=>'e', 'ì'=>'i', 'í'=>'i', 'î'=>'i',
    'ï'=>'i', 'ð'=>'o', 'ñ'=>'n', 'ń'=>'n', 'ò'=>'o', 'ó'=>'o', 'ô'=>'o', 'õ'=>'o', 'ö'=>'o', 'ø'=>'o', 'ù'=>'u',
    'ú'=>'u', 'û'=>'u', 'ü'=>'u', 'ý'=>'y', 'ý'=>'y', 'þ'=>'b', 'ÿ'=>'y', 'ƒ'=>'f',
    'ă'=>'a', 'î'=>'i', 'â'=>'a', 'ș'=>'s', 'ț'=>'t', 'Ă'=>'A', 'Î'=>'I', 'Â'=>'A', 'Ș'=>'S', 'Ț'=>'T',
);
$name = strtr($name, $caracteres_sem_acento);    
    
$pdo = new PDO('mysql:host=localhost;dbname=BANCO','USER','SENHA');

$sql = "SELECT * FROM contacts WHERE number = :number AND tag_id = :tag";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':number', $phone, PDO::PARAM_STR);
$stmt->bindParam(':tag', $tag, PDO::PARAM_INT);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);

if($row['number'] != $phone && $row['tag_id'] != $tag){

$sql = "INSERT INTO contacts (user_id, tag_id, name, number, created_at, updated_at) VALUES (:user_id, :tag_id, :name, :number, :created_at, :updated_at)";

$stmt = $pdo->prepare($sql);

$stmt->execute([
    'user_id' => $user,
    'tag_id' => $tag,
    'name' => $name,
    'number' => $phone,
    'created_at' => date('Y-m-d H:i:s'),
    'updated_at' => date('Y-m-d H:i:s')
]);
  }
}

?>