ricerca

[okan22]

ragazzi devo fare una pagina di una ricerca ma piu si va avanti piu mi incasino

l problema e' che i campi da trovare sono 6

di cui 4 tipo check box o radio button e 2 test..

ma x ogni cosa devo fare la sua condizione di isset cioe' se e' settato fai questa query xe' con s4ei campi di ricerca vengono tantissime condizioni..
(fino a ora ne ho gia 8)
nn so se mi son spiegato bene cmq chi avesse suggerimenti che mi aiuti x favore..

[punkrazio]

forse postando un po di codice
magari incominciando con la parte dove hai creato gia le 8 condizioni
per vedere se si puo fare qualkosa in maniera più dinamica per non scrivere tutte le combinazioni per i controlli

sarebbero 2^6 controlli giusto??

ciauzz

[okan22]

grazie x la risp
il problema e' che sto codice e' x un modulo di drupal quindi leggermente diverso cmq e' diviso in 2 pagine una nella quale c'e' il menu di selezione e l'altra dove si faranno i controlli:
($outupt in pratica scrive..)


<?php

if(isset($_POST['tipo'])==true){
$tipo =$_POST['tipo'];

$result1 = db_query ("select {node}.title,{node}.nid FROM COM_DOC INNER JOIN {node} ON com_doc.aree={node}.nid WHERE com_doc.type='$tipo'");
while ($links = db_fetch_object($result1)) {
$output .="[*]";
$output .=l(("$links->title"),$uid="node/$links->nid");
$output .="";
}
/*
--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------

*/
}else if(isset($_POST['area'])==true){
$area =$_POST['area'];
$result2 = db_query ("select {node}.title,{node}.nid FROM COM_DOC INNER JOIN {node} ON com_doc.aree={node}.nid WHERE {node}.type='$area'");

while ($links = db_fetch_object($result2)) {
$output .="[*]";
$output .=l(("$links->title"),$uid="node/$links->nid");
$output .="";
}
/*
--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------
*/
}else if(isset($_POST['freetag'])==true){
$freetag =$_POST['freetag'];


$result5=db_query ("select name from {term_data} INNER JOIN {term_node} ON {term_data}.tid={term_node}.tid where NAME LIKE '%$freetag%'");


while ($links = db_fetch_object($result5)) {
$output .="$links->name";
$output .="
";

}
/*
--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------
*/
}else if(isset($_POST['tematica'])==true){
$tematica =$_POST['tematica'];
$output .="$tematica";


$result6=db_query ("select vid,tid,name from {term_data} where NAME like '%$tematica%'");


$output .="RISULTATI SUI tematiche";



while ($links=db_fetch_object($result6)){
$output .="$links->name";
$output .="
";

}

/*
--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------
*/
}else if(isset($_POST['utente'])==true){
$utente =$_POST['utente'];
/*
$output .="";$output .="
select o_node.title,o_node.nid FROM COM_DOC INNER JOIN o_node ON com_doc.aree=o_node.nid WHERE o_node.'".uid."'='$uid'";
*/
$result3 = db_query ("select uid,name,mail FROM {users} WHERE ".'uid'."=$utente");
while ($links = db_fetch_object($result3)) {
$output .="[*]";
$output .=l(("$links->name"),$uid="user/$links->uid");
$output .="$links->mail";
$output .="";
}
$result4 = db_query ("select {node}.title,{node}.nid FROM COM_DOC INNER JOIN {node} ON com_doc.aree={node}.nid WHERE {node}.".'uid'."=$utente");

while ($links = db_fetch_object($result4)) {
$output .="[*]";
$output .=l(("$links->title"),$uid="node/$links->nid");
$output .="";
}

/*
--------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------

*/
}else if((isset($_POST["area"])==true)&&(isset($_POST["tipo"])==true)){
$area =$_POST['area'];
$tipo =$_POST['tipo'];
$output .=$tipo;
$output .=$area;

$result6 = db_query ("select {node}.title,{node}.nid FROM COM_DOC INNER JOIN {node} ON com_doc.aree={node}.nid WHERE {node}.type='$area' AND com_doc.type='$tipo'");
while ($links = db_fetch_object($result6)) {
$output .="[*]";
$output .=l(("$links->title"),$uid="node/$links->nid");
$output .="";
}
/*
--------------------------------------------------------
*/
}else if((isset($_POST["area"])==true)&&(isset($_POST["utente"])==true)){
$area =$_POST['area'];
$utente =$_POST['utente'];
//$output .=$utente;
$output .=$area;

$result7 = db_query ("select {node}.title,{node}.nid FROM COM_DOC INNER JOIN {node} ON com_doc.aree={node}.nid WHERE {node}.type='$area' AND {node}.".'uid'."='$utente' GROUP BY {node}.title");
while ($links = db_fetch_object($result7)) {
$output .="[*]";
$output .=l(("$links->title"),$uid="node/$links->nid");
$output .=$utente;
$output .="";
}
/*
--------------------------------------------------------
*/
}else if((isset($_POST["tipo"])==true)&&(isset($_POST["utente"])==true)){
$utente =$_POST['utente'];
$tipo =$_POST['tipo'];
$output .=$tipo;
$output .=$utente;

$result8 = db_query ("select {node}.title,{node}.nid FROM COM_DOC INNER JOIN {node} ON com_doc.aree={node}.nid WHERE {node}.".'uid'."='$utente' AND com_doc.type='$tipo'");
while ($links = db_fetch_object($result8)) {
$output .="[*]";
$output .=l(("$links->title"),$uid="node/$links->nid");
$output .="";
}

}

?>