|
|
| Home | Observatorio | Equipamiento | Astrofotos | Supernovas | Otros Sitios |
Fotos por fecha
Execute($consulta);
if ($result2 === false) die("No pudo generar seleccion de opciones ".$campo);
echo "";
while (!$result2->EOF) {
echo "";
$result2->MoveNext();
}
$result2->Close();
}
function SendMyEcho($orden)
{
// echo "hola".$PHP_SELF."?ord1=".urlencode($orden).
//"&n1=".urlencode($n1)."&n2=".urlencode($n2)."&messier=".urlencode($messier)."&ngc=".urlencode($ngc).
//"&lugar=".urlencode($lugar)."&ciudad=".urlencode($ciudad)."&pais=".urlencode($pais).
//"&marca=".urlencode($marca)."&modelo=".urlencode($modelo).
//"&tipomedia=".urlencode($tipomedia)."&marcamedia=".urlencode($marcamedia)."&modelomedia=".urlencode($modelomedia)."&f=".urlencode($f);
}
$db = NewADOConnection($BD_Base);
$db->Connect($BD_Servidor, $BD_Usuario, $BD_Clave, $BD_Nombre);
$querystr = "SELECT fotos.exposicion,
fotos.id,
fotos.f,
fotos.fecha,
fotos.foto,
fotos.fotoch,
otrosobjetos.nombre as n1,
catalog.nombre as n2,
fotoautor.nombre,
telescopio.marca,
telescopio.modelo,
fotomedia.tipomedia,
fotomedia.marcamedia,
fotomedia.modelomedia,
lugar.lugar,
lugar.ciudad,
lugar.pais,
fotos.id,
catalog.ngc,
catalog.messier
FROM fotos
LEFT JOIN catalog ON (catalog.id = fotos.idcatalog)
INNER JOIN fotomedia ON (fotos.idmedio = fotomedia.id)
INNER JOIN telescopio ON (fotos.idtelescopio = telescopio.id)
LEFT JOIN otrosobjetos ON (fotos.idotros = otrosobjetos.id)
INNER JOIN lugar ON (fotos.idlugar = lugar.id)
INNER JOIN fotoautor ON (fotos.idautor = fotoautor.id) ";
// $querystr .= " WHERE ( ".$qry." )";
$n1 = urldecode($n1);
$n2 = urldecode($n2);
$messier = urldecode($messier);
$ngc = urldecode($ngc);
$lugar = urldecode($lugar);
$ciudad = urldecode($ciudad);
$pais = urldecode($pais);
$marca = urldecode($marca);
$modelo = urldecode($modelo);
$tipomedia = urldecode($tipomedia);
$marcamedia = urldecode($marcamedia);
$modelomedia = urldecode($modelomedia);
$f = urldecode($f);
$fecha = urldecode($fecha);
if (($n1 != "") || ($n2 != "") || ($messier != "") || ($ngc != "") || ($lugar != "") || ($ciudad != "") || ($pais != "") || ($marca != "") || ($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != "") || ($fecha != ""))
$querystr .= "WHERE ";
if ($n1 != "") {
$querystr .= "otrosobjetos.nombre like \"".$n1."\"";
if (($n2 != "") || ($messier != "") || ($ngc != "") || ($lugar != "") || ($ciudad != "") || ($pais != "") || ($marca != "") || ($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($n2 != "") {
$querystr .= "catalog.nombre like \"".$n2."\"";
if (($messier != "") || ($ngc != "") || ($lugar != "") || ($ciudad != "") || ($pais != "") || ($marca != "") || ($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($messier != "") {
$querystr .= "messier = ".$messier;
if (($ngc != "") || ($lugar != "") || ($ciudad != "") || ($pais != "") || ($marca != "") || ($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($ngc != "") {
$querystr .= "ngc = ".$ngc;
if (($lugar != "") || ($ciudad != "") || ($pais != "") || ($marca != "") || ($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($lugar != "") {
$querystr .= "lugar.lugar like \"".$lugar."\"";
if (($ciudad != "") || ($pais != "") || ($marca != "") || ($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($ciudad != "") {
$querystr .= "lugar.ciudad like \"".$ciudad."\"";
if (($pais != "") || ($marca != "") || ($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($pais != "") {
$querystr .= "lugar.pais like \"".$pais."\"";
if (($marca != "") || ($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($marca != "") {
$querystr .= "telescopio.marca like \"".$marca."\"";
if (($modelo != "") || ($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($modelo != "") {
$querystr .= "telescopio.modelo like \"".$modelo."\"";
if (($tipomedia != "") || ($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($tipomedia != "") {
$querystr .= "fotomedia.tipomedia like \"".$tipomedia."\"";
if (($marcamedia != "") || ($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($marcamedia != "") {
$querystr .= "fotomedia.marcamedia like \"".$marcamedia."\"";
if (($modelomedia != "") || ($f != ""))
$querystr .= "AND ";
}
if ($modelomedia != "") {
$querystr .= "fotomedia.modelomedia like \"".$modelomedia."\"";
if (($fecha != ""))
$querystr .= "AND ";
}
if ($fecha != "") {
$querystr .= "fotos.fecha like \"".$fecha."\"";
if (($f != ""))
$querystr .= "AND ";
}
if ($f != "")
$querystr .= "fotos.f like \"".$f."\"";
if (!empty($ord1)) {
$querystr .= " order by ".$ord1; }
else {
$querystr .= " ORDER BY fotos.fecha DESC, fotos.id DESC"; }
// if (($ord1 == "lugar") || ($ord1 == "ciudad"))
// $querystr .= " desc";
// echo $querystr."
|
|||||||||||||||||||||||||||||||||||||||||||||
Consultas: Domingo Verrascina