advanced search

soniasonia · Aug 20, 2002

I am working on a page where I have to search over three tables. The seach form has the posibility of select:
location: the whole country, state,capital (radio button)
Search by: department, tel, address, manager (dropdown list)
Text: (textbox).
I am having problems with the code. I would like to know where I can get a good example code of this kind. I have alreday looked for it but I coundnt find anything like tthat. I you like I could send you what I made.
Sorry for my English. Any help will be really appreciated.

Sonia.

daca · Aug 20, 2002

Please send your code in order to help you... I don`t know what is your problem... Someone who has never served other is someone that has never lived...

Bastien · Aug 20, 2002

$sql="select * from mytable where"
//assume country=1, state=2, capitol=3
//assume if country is picked, all records are searched
//therefore no need to alter $sql to limit the search
if ($localradiobuttonvalue=2){
$sql=$sql." state = '$state'";
}elseif ($localradiobutton=3){
//$searchby = the dropdown list
//$text = entry in text box...note that tel numbers must
//be stored as text to by picked up
$sql=$sql." and $searchby = '$text'";
}
$result = mysql_query($sql,$conn) or die ("Database not available&quot

;

//code to show the results...

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken

soniasonia · Aug 20, 2002

I send you the code:
CONSULTA2.PHP
<HTML>
<HEAD>
<TITLE> Subsistema de Areas </TITLE>
</HEAD>
<BODY>
<H1> Subsistema de Consultas</H1>
<FORM ACTION="listaconsulta.php" METHOD=POST>
<p align="left">Locación:          
Capital<input type="radio" " value="capital"checked name="locacion">    
Interior <input type="radio" value="interior" name="locacion">     
Todo  <input type="radio" value="todos" name="locaion"></p>

<p align="left">Búsqueda por:    <select size="1" name="busquedapor">
<option selected>Area</option>
<option>Agente</option>
<option>Edificio</option>
<option>Telefono</option>
</select></p>

<p align="left">Ingresar el texto: <input type="text" name="searchtext" size="20"></p>

<p align="left"><input type="submit" value="Buscar" >
<input type="reset" value="Restablecer" > </p>
</FORM>

<P ALIGN=CENTER><A HREF="admin.html">Regreso al Inicio</A></P>
</BODY>
</HTML>

LISTACONSULTA.PHP
<HTML>
<HEAD>
<TITLE> Subsistema de Areas </TITLE>
</HEAD>
<BODY>
<H1>Subsistema de Consulta</H1>
<P><A HREF="consulta2.php">Nueva Consulta</A></P>
<?php

$dbcnx = @mysql_connect("localhost", "root", "password&quot

;
mysql_select_db("miprueba&quot

;

// The basic SELECT statement
$select = "SELECT DISTINCT arid, eid";
$from = " FROM todos";
$where = " WHERE arid > 0 OR eid > 0 ";

if (locacion == 'todos') {
$from .= ",edificios";
$where .= " AND id=eid";
}

if (locacion == 'capital') {
$from .= ",edificios";
$where .= " AND id=eid AND sede='capital'";
}

if (locacion == 'interior') {
$from .= ",edificios";
$where .= " AND id=eid AND sede <> 'capital'";
}

if (busquedapor == 'Area') {
$from .= ", areas";
if (searchtext != "&quot

{
$where .= " AND id=arid AND descripcion LIKE '%searchtext%'";
} else {
$where .= " AND id=arid";
}

if (busquedapor == 'Agente') {
$from .= ", agentes";
if (searchtext != "&quot

{
$where .= " AND id=aid AND nombre LIKE '%searchtext%' OR apellido LIKE '%searchtext%";
} else {
$where .= " AND id=aid";
}

if (busquedapor == 'Telefono') {
$from .= ", areas";
if (searchtext != "&quot

{
$where .= " AND id=arid AND tel1 LIKE '%searchtext%' OR tel2 LIKE '%searchtext%' OR tel3 LIKE '%searchtext%' OR tel4 LIKE '%searchtext%'";
} else {
$where .= " AND id=arid";
}

if (busquedapor == 'Edificio') {
$from .= ", edificios";
if (searchtext != "&quot

{ // Some search text was specified
$where .= " AND id=eid AND domicilio LIKE '%searchtext%'";
} else {
$where .= " AND id=eid";
}
?>

<TABLE BORDER=1>
<TR><TH>Area</TH></TR>

<?php
$areas = mysql_query($select . $from . $where);
if (!areas) {
echo("</TABLE>&quot

;
echo("<P>Error al traer Areas desde la DB !<BR>".
"Error: " . mysql_error());
exit();
}

while ($area = mysql_fetch_array($areas)) {
echo("<TR>\n&quot

;
$id = $area["id"];
$descripcion = $area["descripcion"];

}
?>

</TABLE>
</BODY>
</HTML>

db: MIPRUEBA
tables:
AGENTES
ID
NOMBRE
APELLIDO
DNI
PROFESION
SEXO
EMAIL
AREAS
ID
DESCRIPCION
TEL1
TEL2
TEL3
TEL4
AID
EDIFICIOS
ID
DOMICILIO
SEDE
TODOS
ARID
EID

Hope you can help me.

daca · Aug 21, 2002

Pues yo veo algunos errores de variables mal escritas...checa bien tu código o cuál es tu problema??? que es lo que hace mal???

faltan algunos $...y además cuando le indicas que los valores se tomaron de la forma con algo como $HTTP_POST_VARS
o $GLOBALS

//Variables tomadas de la forma
$nom = $GLOBALS["nombre"];
$log = $GLOBALS["login"];
$pas = $GLOBALS["passwd"];

por ejemplo...
Someone who has never served other is someone that has never lived...

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

advanced search

soniasonia

Technical User

daca

Programmer

Bastien

Programmer

soniasonia

Technical User

daca

Programmer

Similar threads

Part and Inventory Search

Sponsor