"; echo "
"; $conn = pg_pconnect("dbname=sif user=mike"); function displayform($keywords) { GLOBAL $PHP_SELF, $conn, $lang, $tipoid, $label_buscar, $label_todoslosdocumentos, $label_titulo, $label_desc, $label_cont, $label_todo; $querytipo = pg_exec($conn, "SELECT tipoid, tipo_$lang FROM tipos WHERE tipoid>0 AND tipoid != 7 AND tipoid != 8 ORDER BY tipoid"); echo "\n"; } function showpages() { GLOBAL $total, $numresults, $offset, $que, $oldtipoid, $string, $limit, $label_a, $label_de, $label_resultados, $label_page, $PHP_SELF; if (!$limit) { $limit = 10; } if (!$offset) { $offset = 0; } if (($offset + 1 + $limit) > $total) { $endpage = $total; } else { $endpage = $offset + $limit; } $offsetplusone = $offset + 1; $k = 0; $j = 0; echo "".$label_resultados.$offsetplusone.$label_a.$endpage.$label_de.$total."
"; if ($total > $numresults) { $oldoffset = $offset; echo "$label_page: "; while ($j < ($total / $limit)) { $k = $j+1; $offset = $limit*$j; if ($oldoffset == $offset) { $urls = "$k "; } else { $urls = "".$k." "; } if ($k < ($total / $limit)) { echo $urls."- "; } else { echo $urls; } $j++; } $offset = $oldoffset; echo "
\n"; } } function parsedata($keywords) { //$keywords = strip_tags($keywords); $keywords = trim($keywords); $keywords = htmlentities($keywords); $keywords = str_replace(", ", " ", $keywords); $keywords = str_replace(",", " ", $keywords); $keywords = str_replace(" ", "&&&&", $keywords); $word = explode("&&&&", $keywords); return $word; return $keywords; } function vartoarray($keywords) { //$keywords = strip_tags($keywords); $keywords = trim($keywords); $keywords = htmlentities($keywords); $keywords = str_replace(", ", " ", $keywords); $keywords = str_replace(",", " ", $keywords); $word = array($keywords); return $word; return $keywords; } if ($string) { $keywords = str_replace("+", " ", $string); } if (!$keywords) { //display search form echo "$label_header "; echo "$label_header_descripcion"; echo "
$label_reglas_titulo:
"; echo "
$label_ejemplo1
- $label_regla1"; echo "
- $label_regla2"; echo "
- $label_regla6"; echo "
- $label_regla3"; echo "
- $label_regla4"; echo "
- $label_regla5"; echo "
"; echo "$label_ejemplo2"; echo "$label_favorentrar:
"; displayform($keywords); ?>
Búsqueda en el sitio Funredes usando GOOGLE
$label_sqlfootnote"; } if ($keywords) { if (!$limit) { $limit = 10; } $oldtipoid = $tipoid; if (strstr($keywords, "docid")) { $string = str_replace("=", "&&&&", $keywords); $word = explode("&&&&", $string); $docid = $word[1]; //$docid = substr($keywords, 6); $docid = trim($docid); $querystring = "SELECT DISTINCT p.docid, p.titulo_$lang, l.lengua, p.descripcion_$lang, tipo FROM lenguas l, principal p, contenido c WHERE l.lenguaid=p.lengua AND p.docid=c.docid AND p.docid=$docid"; $totalstring = $querystring; } else if ($keywords == "todos") { $word = array($keywords); $string = $keywords; $querystring = "SELECT DISTINCT p.docid, p.titulo_$lang, l.lengua, p.descripcion_$lang, tipo FROM lenguas l, principal p, contenido c WHERE l.lenguaid=p.lengua AND p.docid=c.docid"; if ($tipoid != 0) { $querystring = $querystring." AND p.tipo=$tipoid"; } $totalstring = $querystring; $querystring = $querystring." LIMIT $limit"; if ($offset) { $querystring = $querystring." OFFSET $offset"; } } else { //parse data //$word = vartoarray($keywords); $string = trim($keywords); $string = str_replace(" ", "+", $string); $word = parsedata($keywords); $n = 0; $andor = "OR"; //get search criteria from form if ($que == "todo") { $camposabuscar = "(lower(p.titulo_es) LIKE lower('%$word[$n]%') OR lower(p.titulo_fr) LIKE lower('%$word[$n]%') OR lower(p.titulo_en) LIKE lower('%$word[$n]%')) $andor (lower(p.descripcion_es) LIKE lower('%$word[$n]%') OR lower(p.descripcion_fr) LIKE lower('%$word[$n]%') OR lower(p.descripcion_en) LIKE lower('%$word[$n]%')) $andor (lower(c.contenido) LIKE lower('%$word[$n]%'))"; if (count($word) > 1) { do { $n++; $camposabuscar = $camposabuscar." $andor (lower(p.titulo_es) LIKE lower('%$word[$n]%') OR lower(p.titulo_fr) LIKE lower('%$word[$n]%') OR lower(p.titulo_en) LIKE lower('%$word[$n]%') OR lower(p.descripcion_es) LIKE lower('%$word[$n]%') OR lower(p.descripcion_fr) LIKE lower('%$word[$n]%') OR lower(p.descripcion_en) LIKE lower('%$word[$n]%') OR lower(c.contenido) LIKE lower('%$word[$n]%'))"; } while ($n < count($word) - 1); } $camposabuscar = "(".$camposabuscar.")"; } if ($que == "titulo") { $camposabuscar = "lower(p.titulo_es) LIKE lower('%$word[$n]%') OR lower(p.titulo_fr) LIKE lower('%$word[$n]%') OR lower(p.titulo_en) LIKE lower('%$word[$n]%')"; if (count($word) > 1) { do { $n++; $camposabuscar = $camposabuscar." OR lower(p.titulo_es) LIKE lower('%$word[$n]%') OR lower(p.titulo_fr) LIKE lower('%$word[$n]%') OR lower(p.titulo_en) LIKE lower('%$word[$n]%')"; } while ($n < count($word) - 1); } $camposabuscar = "(".$camposabuscar.")"; } if ($que == "descripcion") { $camposabuscar = "lower(p.descripcion_es) LIKE lower('%$word[$n]%') OR lower(p.descripcion_fr) LIKE lower('%$word[$n]%') OR lower(p.descripcion_en) LIKE lower('%$word[$n]%')"; if (count($word) > 1) { do { $n++; $camposabuscar = $camposabuscar." OR lower(p.descripcion_es) LIKE lower('%$word[$n]%') OR lower(p.descripcion_fr) LIKE lower('%$word[$n]%') OR lower(p.descripcion_en) LIKE lower('%$word[$n]%')"; } while ($n < count($word) - 1); } $camposabuscar = "(".$camposabuscar.")"; } if ($que == "contenido") { $camposabuscar = "lower(c.contenido) LIKE lower('%$word[$n]%')"; if (count($word) > 1) { do { $n++; $camposabuscar = $camposabuscar." OR lower(c.contenido) LIKE lower('%$word[$n]%')"; } while ($n < count($word) - 1); } $camposabuscar = "(".$camposabuscar.")"; } if ($tipoid != "0") { $camposabuscar = $camposabuscar." AND tipo=$tipoid"; } //perform search $querystring = "SELECT DISTINCT p.docid, p.titulo_$lang, l.lengua, p.descripcion_$lang, tipo FROM lenguas l, principal p, contenido c WHERE l.lenguaid=p.lengua AND p.docid=c.docid AND $camposabuscar"; if ($notdocid) { $querystring = $querystring." $notdocid"; } $querystring = $querystring." ORDER BY p.titulo_$lang"; $totalstring = $querystring; $querystring = $querystring." LIMIT $limit"; if ($offset) { $querystring = $querystring." OFFSET $offset"; } } $searchquery = pg_exec($conn, $querystring); $numresults = pg_numrows($searchquery); $gettotal = pg_exec($conn, $totalstring); $total = pg_numrows($gettotal); $row = 0; //diplay search results echo "
| $label_resultsof \"$keywords\" $label_por \"$label_what\": | |
|---|---|
| "; echo ""; showpages(); echo " | |
| ";
do {
$getresults = pg_fetch_row($searchquery, $row);
$tipoid = $getresults[4];
//make bold text
$n = 0;
do {
$getresults[1] = str_replace("$word[$n]", "$word[$n]", $getresults[1]);
$getresults[3] = str_replace("$word[$n]", "$word[$n]", $getresults[3]);
$ucword[$n] = ucfirst($word[$n]);
$getresults[1] = str_replace("$ucword[$n]", "$ucword[$n]", $getresults[1]);
$getresults[3] = str_replace("$ucword[$n]", "$ucword[$n]", $getresults[3]);
$lcword[$n] = strtolower($word[$n]);
$getresults[1] = str_replace("$lcword[$n]", "$lcword[$n]", $getresults[1]);
$getresults[3] = str_replace("$lcword[$n]", "$lcword[$n]", $getresults[3]);
$n++;
} while ($n < count($word));
echo " $getresults[1] \n"; $tipoid = $oldtipoid; showpages(); displayform($keywords); } if ($numresults == 0) { echo " $label_nohay | "; // repost form displayform($keywords); } echo " |
"; } echo ""; include("footer.php3"); ?>