<?
date_default_timezone_set('America/New_York'); // CDT
$noregistro=$_GET["noreg"];
if (isset($_GET["apareil"])) {
    // El valor GET "apareil" existe
    $where = $_GET["apareil"];
} else {
    // El valor GET "apareil" no existe
    $where = 0;
}
$hoy=date("Y-m-d H:i:s");
require '/var/www/vhosts/jadore-montreal.com/secure_config/conexion.php';
$sql = $db->prepare('SELECT * FROM anunciosh WHERE registro = :Fecha');
$sql->execute(array(':Fecha' => $noregistro));
$result = $sql->fetchAll();
foreach ($result as $Rs) {
	$adonde=$Rs["link"];
}
$sqla = $db->prepare("INSERT INTO clicksh (registro, fecha, app) VALUES (:Reg, :Fechaa, :APP)");
$sqla->bindParam(':Reg', $noregistro);
$sqla->bindParam(':Fechaa', $hoy);
$sqla->bindParam(':APP', $where);
$sqla->execute();
header("location: $adonde");
?>