Use of cookies!
|
|
|
[email protected]
free support**
Move around the city and don't miss a thing!
Date
[email protected]
free support**
Live the city to the fullest
Visit Montreal's most iconic sights!
0
Cemeteries
10
Clinical
28
CLSC
include("conexion.php");
$hoy=date("Y-m-d H:i:s");
$main=date("Y-m-d");
$cont=0;
$i = 0;
while ($i < 1) {
$sql = $db->prepare('SELECT * FROM anunciosh WHERE fechaf > :Fecha AND turno = 0 ORDER BY RAND() LIMIT 0,1');
$sql->execute(array(':Fecha' => $main));
$result = $sql->fetchAll();
$numero = count($result);
if ($numero < 1){
$sqlid = "UPDATE anunciosh SET turno=0 WHERE 1";
$esid = $db->prepare($sqlid);
$esid->execute();
}else{
$i++;
foreach ($result as $Rs) {
$matrizclick[$cont]=$Rs["registro"];
$matrizimg[$cont]=$Rs["imagen"].$lang.".jpg";
$cont++;
$numid=$Rs["registro"];
$sqla = $db->prepare("INSERT INTO impresionesh (registro, fecha, pagina ) VALUES (:Reg, :Fechaa, :Paginaa)");
$sqla->bindParam(':Reg', $numid);
$sqla->bindParam(':Fechaa', $hoy);
$sqla->bindParam(':Paginaa', $pags);
$sqla->execute();
$sqlid = "UPDATE anunciosh SET reloj=reloj+1, turno=1 WHERE registro = :Aupd";
$esid = $db->prepare($sqlid);
$esid->execute(array(':Aupd' => $numid));
}
}
}
?>
0
Exchange
0
Fast food
0
Gas stations
0
Mall
60
Mall
include("conexion.php");
$hoy=date("Y-m-d H:i:s");
$main=date("Y-m-d");
$cont=0;
$i = 0;
while ($i < 1) {
$sql = $db->prepare('SELECT * FROM anunciosh WHERE fechaf > :Fecha AND turno = 0 ORDER BY RAND() LIMIT 0,1');
$sql->execute(array(':Fecha' => $main));
$result = $sql->fetchAll();
$numero = count($result);
if ($numero < 1){
$sqlid = "UPDATE anunciosh SET turno=0 WHERE 1";
$esid = $db->prepare($sqlid);
$esid->execute();
}else{
$i++;
foreach ($result as $Rs) {
$matrizclick[$cont]=$Rs["registro"];
$matrizimg[$cont]=$Rs["imagen"].$lang.".jpg";
$cont++;
$numid=$Rs["registro"];
$sqla = $db->prepare("INSERT INTO impresionesh (registro, fecha, pagina ) VALUES (:Reg, :Fechaa, :Paginaa)");
$sqla->bindParam(':Reg', $numid);
$sqla->bindParam(':Fechaa', $hoy);
$sqla->bindParam(':Paginaa', $pags);
$sqla->execute();
$sqlid = "UPDATE anunciosh SET reloj=reloj+1, turno=1 WHERE registro = :Aupd";
$esid = $db->prepare($sqlid);
$esid->execute(array(':Aupd' => $numid));
}
}
}
?>
0
Mechanical workshop
0
Motels
67
Museum
0
Parking
894
Parks
0
Pharmacies
22
Pub
108
Public art
include("conexion.php");
$hoy=date("Y-m-d H:i:s");
$main=date("Y-m-d");
$cont=0;
$i = 0;
while ($i < 1) {
$sql = $db->prepare('SELECT * FROM anunciosh WHERE fechaf > :Fecha AND turno = 0 ORDER BY RAND() LIMIT 0,1');
$sql->execute(array(':Fecha' => $main));
$result = $sql->fetchAll();
$numero = count($result);
if ($numero < 1){
$sqlid = "UPDATE anunciosh SET turno=0 WHERE 1";
$esid = $db->prepare($sqlid);
$esid->execute();
}else{
$i++;
foreach ($result as $Rs) {
$matrizclick[$cont]=$Rs["registro"];
$matrizimg[$cont]=$Rs["imagen"].$lang.".jpg";
$cont++;
$numid=$Rs["registro"];
$sqla = $db->prepare("INSERT INTO impresionesh (registro, fecha, pagina ) VALUES (:Reg, :Fechaa, :Paginaa)");
$sqla->bindParam(':Reg', $numid);
$sqla->bindParam(':Fechaa', $hoy);
$sqla->bindParam(':Paginaa', $pags);
$sqla->execute();
$sqlid = "UPDATE anunciosh SET reloj=reloj+1, turno=1 WHERE registro = :Aupd";
$esid = $db->prepare($sqlid);
$esid->execute(array(':Aupd' => $numid));
}
}
}
?>
include("conexion.php");
$hoy=date("Y-m-d H:i:s");
$main=date("Y-m-d");
$cont=0;
$i = 0;
while ($i < 1) {
$sql = $db->prepare('SELECT * FROM anunciosh WHERE fechaf > :Fecha AND turno = 0 ORDER BY RAND() LIMIT 0,1');
$sql->execute(array(':Fecha' => $main));
$result = $sql->fetchAll();
$numero = count($result);
if ($numero < 1){
$sqlid = "UPDATE anunciosh SET turno=0 WHERE 1";
$esid = $db->prepare($sqlid);
$esid->execute();
}else{
$i++;
foreach ($result as $Rs) {
$matrizclick[$cont]=$Rs["registro"];
$matrizimg[$cont]=$Rs["imagen"].$lang.".jpg";
$cont++;
$numid=$Rs["registro"];
$sqla = $db->prepare("INSERT INTO impresionesh (registro, fecha, pagina ) VALUES (:Reg, :Fechaa, :Paginaa)");
$sqla->bindParam(':Reg', $numid);
$sqla->bindParam(':Fechaa', $hoy);
$sqla->bindParam(':Paginaa', $pags);
$sqla->execute();
$sqlid = "UPDATE anunciosh SET reloj=reloj+1, turno=1 WHERE registro = :Aupd";
$esid = $db->prepare($sqlid);
$esid->execute(array(':Aupd' => $numid));
}
}
}
?>
[email protected]
free support**
Visits © 2023 J'adore Montréal Developed by Javier Atahualpa Cervantes Macias