prepare($sql);
$stmt->bind_param('i',$inputRelacion);
$stmt->execute();
if(!empty($_POST['array_chk']))
{
foreach($_POST['array_chk'] as $key)
{
$value = htmlspecialchars(mysqli_real_escape_string($con,$key));
$sql = "SELECT * FROM CONTACTOS_ORGANIZACIONES WHERE CONTACTO = ? AND ORGANIZACION = ?";
$stmt = $con->prepare($sql);
$stmt->bind_param('ii',$inputRelacion,$value);
$stmt->execute();
$res = $stmt->get_result();
if($res->num_rows == 0)
{
$sql = "INSERT INTO CONTACTOS_ORGANIZACIONES(CONTACTO,ORGANIZACION) VALUES(?,?)";
$stmt = $con->prepare($sql);
$stmt->bind_param('ii',$inputRelacion,$value);
$stmt->execute();
echo '
' . $relaciones_asignadas_lg . '
';
}
else
{
$_SESSION['agenda_m56'] = 98;
echo "";
}
}
}
else
{
echo '
' . $campos_actualizados_lg . '
';
}
?>