Hola
este es el codigo buscar.php
Código PHP:
<?php session_start();
include ("conectar.php");
$link = conectar();
if (isset ($_POST["idPersona"])){
$idPersona= $_POST["idPersona"];
$_SESSION["idPersona"] = $idPersona;
}
$_SESSION["id"]=$idPersona;
?>
html ...
<body>
if ($_POST['tipo']==fecha){
if (($tmp1=$_POST['idHito'])&&($tmp2=$_POST['fecha1'])&&($tmp4=$_POST['idHito1'])&&($tmp3=$_POST['fecha2'])&&($table1=$_POST['table1']) &&($table2=$_POST['table2'])){
$SQL="SELECT AB.cod_sitio,AB.nombre, $table1.fecha
FROM $table1, AB
WHERE $table1.fecha
BETWEEN '".$tmp2."'
AND '".$tmp3."'
AND ab.idab = $table1.idab
AND $table1.idhito = '".$tmp1."'
UNION (
SELECT AB.cod_sitio,AB.nombre, $table2.fecha
FROM $table2, AB
WHERE ab.idab = $table2.idab
AND $table2.idhito = '".$tmp4."');";
$result=mysql_query($SQL,$link);
} elseif (($tmp1=$_POST['idHito'])&&($tmp2=$_POST['fecha1'])&&($tmp4=$_POST['idHito1'])&&($table1=$_POST['table1']) &&($table2=$_POST['table2'])){
$SQL="SELECT AB.cod_sitio,AB.nombre, $table1.fecha
FROM $table1, AB
WHERE $table1.fecha>='".$tmp2."'
AND ab.idab = $table1.idab
AND $table1.idhito = '".$tmp1."'
UNION (
SELECT AB.cod_sitio,AB.nombre, $table2.fecha
FROM $table2, AB
WHERE ab.idab = $table2.idab
AND $table2.idhito = '".$tmp4."');";
$result=mysql_query($SQL,$link);
} elseif (($tmp1=$_POST['idHito'])&&($tmp3=$_POST['fecha2'])&&($tmp4=$_POST['idHito1'])&&($table1=$_POST['table1']) &&($table2=$_POST['table2'])){
$SQL="SELECT AB.cod_sitio,AB.nombre, $table1.fecha
FROM $table1, AB
WHERE $table1.fecha<='".$tmp3."'
AND ab.idab = $table1.idab
AND $table1.idhito = '".$tmp1."'
UNION (
SELECT AB.cod_sitio,AB.nombre, $table2.fecha
FROM $table2, AB
WHERE ab.idab = $table2.idab
AND $table2.idhito = '".$tmp4."');";
$result=mysql_query($SQL,$link);
}else echo "no exite informacion!";
while ($row=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#82cafa"><?echo $row['cod_sitio']?></td>
<td bgcolor="#82cafa"><?echo $row['nombre']?></td>
<? }?>
</tr>
<?
} else {
if (($tmp1=$_POST['idHito'])&&($tmp2=$_POST['fecha1'])&&($tmp4=$_POST['idHito1'])&&($tmp3=$_POST['fecha2'])&&($table1=$_POST['table1']) &&($table2=$_POST['table2'])){
$SQL="SELECT AB.cod_sitio,AB.nombre, $table1.fecha
FROM $table1, AB
WHERE $table1.fecha_ingreso
BETWEEN '".$tmp2."%'
AND '".$tmp3."%'
AND ab.idab = $table1.idab
AND $table1.idhito = '".$tmp1."'
UNION (
SELECT AB.cod_sitio,AB.nombre, $table2.fecha
FROM $table2, AB
WHERE ab.idab = $table2.idab
AND $table2.idhito = '".$tmp4."');";
$result=mysql_query($SQL,$link);
} elseif (($tmp1=$_POST['idHito'])&&($tmp2=$_POST['fecha1'])&&($tmp4=$_POST['idHito1'])&&($table1=$_POST['table1']) &&($table2=$_POST['table2'])){
$SQL="SELECT AB.cod_sitio,AB.nombre, $table1.fecha
FROM $table1, AB
WHERE $table1.fecha_ingreso LIKE '".$tmp2."%'
AND ab.idab = $table1.idab
AND $table1.idhito = '".$tmp1."'
UNION (
SELECT AB.cod_sitio,AB.nombre, $table2.fecha
FROM $table2, AB
WHERE ab.idab = $table2.idab
AND $table2.idhito = '".$tmp4."');";
$result=mysql_query($SQL,$link);
} elseif (($tmp1=$_POST['idHito'])&&($tmp3=$_POST['fecha2'])&&($tmp4=$_POST['idHito1'])&&($table1=$_POST['table1']) &&($table2=$_POST['table2'])){
$SQL="SELECT AB.cod_sitio,AB.nombre, $table1.fecha
FROM $table1, AB
WHERE $table1.fecha_ingreso LIKE '".$tmp3."%'
AND ab.idab = $table1.idab
AND $table1.idhito = '".$tmp1."'
UNION (
SELECT AB.cod_sitio,AB.nombre, $table2.fecha_ingreso
FROM $table2, AB
WHERE ab.idab = $table2.idab
AND $table2.idhito = '".$tmp4."');";
$result=mysql_query($SQL,$link);
}
while ($row=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#82cafa"><?echo $row['cod_sitio']?></td>
<td bgcolor="#82cafa"><?echo $row['nombre']?></td>
<td bgcolor="#82cafa"><?echo $row['fecha']?></td>
</tr>
<? }
}?>
saludos