query ricerca

[GLORIA71]

salve, ho creato un form per la ricerca dati in db , ma come è la query per ricercare tali dati?? il form contiene i campi marca, modello, prezzo , se si vuole ricerca i dati in base al campo marca??grazie

[Habanero]

http://database.html.it/guide/lezion...e-il-database/

[GLORIA71]

thank you.ora vado a provare.ciao

[GLORIA71]

ho creato il form e la connesione al db poi pero' facendo la ricerca di un termine specifico esempio (bmw) mi appare la lista completa delle autovetture non quella scelta?? che cosa ho sbagliato ???
ecco il codice:
<form method="post" action="tabelle.php" name="cercauto" style="margin:0px;margin-top:3px;">
<table width="100%" border="0" cellpadding='0' cellspacing='1' bgcolor="#FFFFCC"><tr><td class="testob11"><table width="100%" border="0" cellpadding='0' cellspacing='1' bgcolor="#FFFFCC">
<tr>
<td class="testob11">Marca</td>
<td><select name="marca" size="1" class="testo11">
<option value="%" >Tutte le Marche</option>
<option value="alfa romeo">alfa romeo</option>
<option value="BMW-ALPINA">BMW-ALPINA</option>
<option value="ASIA MOTORS">ASIA MOTORS</option>
<option value="ASTON MARTIN">ASTON MARTIN</option>
<option value="AUDI">AUDI</option>
<option value="BMW">BMW</option>
<option value="BUICK">BUICK</option>
<option value="CADILLAC">CADILLAC</option>
<option value="chevrolet">chevrolet</option>
<option value="CHRYSLER" >CHRYSLER</option>
<option value="CITROEN" >CITROEN</option>
<option value="DAEWOO" >DAEWOO</option>
<option value="DAIHATSU" >DAIHATSU</option>
<option value="DE TOMASO">DE TOMASO</option>
<option value="DODGE" >DODGE</option>
<option value="FERRARI">FERRARI</option>
<option value="fiat">fiat</option>
<option value="ford">ford</option>
<option value="GMC" >GMC</option>
<option value="LIGIER">LIGIER</option>
<option value="HONDA" >HONDA</option>
<option value="HUMMER">HUMMER</option>
<option value="HYUNDAI">HYUNDAI</option>
<option value="INFINITI">INFINITI</option>
<option value="ISUZU" >ISUZU</option>
<option value="JAGUAR" >JAGUAR</option>
<option value="JEEP" >JEEP</option>
<option value="KIA" >KIA</option>
<option value="LADA">LADA</option>
<option value="LAMBORGHINI">LAMBORGHINI</option>
<option value="lancia">lancia</option>
<option value="LAND ROVER">LAND ROVER</option>
<option value="LEXUS" >LEXUS</option>
<option value="LOTUS" >LOTUS</option>
<option value="MARCOS" >MARCOS</option>
<option value="MASERATI">MASERATI</option>
<option value="MAZDA" >MAZDA</option>
<option value="mercedes">merceds</option>
<option value="MG" >MG</option>
<option value="MINI" >MINI</option>
<option value="MITSUBISHI">MITSUBISHI</option>
<option value="MORGAN" >MORGAN</option>
<option value="NISSAN" >NISSAN</option>
<option value="OPEL" >OPEL</option>
<option value="pegeout">pegeout</option>
<option value="PIAGGIO">PIAGGIO</option>
<option value="PORSCHE">PORSCHE</option>
<option value="RENAULT">RENAULT</option>
<option value="ROLLS ROYCE">ROLLS ROYCE</option>
<option value="ROVER">ROVER</option>
<option value="SAAB">SAAB</option>
<option value="SEAT">SEAT</option>
<option value="SKODA">SKODA</option>
<option value="SMART">SMART</option>
<option value="SUBARU">SUBARU</option>
<option value="SUZUKI">SUZUKI</option>
<option value="TATA" >TATA</option>
<option value="TOYOTA">TOYOTA</option>
<option value="wolswagen">volswagen</option>
<option value="VOLVO" >VOLVO</option>
<option value="ALTRO" >ALTRO</option>
<option value="MOTO" >MOTO</option>
</select></td>
</tr>
<tr>
<td class="testob11">Modello</td>
<td>
<select name="modello" id="modello">
<option value="%">Tutti</option>
<option value="ka">ka</option>
<option value="stilo">stilo</option>
<option value="croma">croma</option>
<option value="musa">musa</option>
<option value="y">y</option>
<option value="yaris">yaris</option>
<option value="golf">golf</option>
<option value="matiz">matiz</option>
<option value="classe a">classe a</option>
<option value="307">307</option>
<option value="147">147</option>
<option value="focus">focus</option>
<option value="fiesta">fiesta</option>
<option value="seicento">seicento</option>
<option value="panda">panda</option>
<option value="grande punto">grande punto</option>
<option value="cmax">cmax</option>
</select></td>
</tr>
<tr>
<td class="testob11">Alimentazione</td>
<td class="testo11"><input type="checkbox" id="ali_tutte" name="alimentazione" value="%" checked />
Tutte
<input type="checkbox" id="ali_benzina" name="alimentazione" value="benzina%" />
Benzina
<input type="checkbox" id="ali_disel" name="alimentazione" value="disel%" />
Diesel
<input type="checkbox" id="ali_gpl" name="alimentazione" value="gpl%" />
Gpl
<!-- <select name="alimentazione" id="alimentazione">
<option value="%">tutti</option>
<option value="benzina">benzina</option>
<option value="disel">disel</option>
<option value="gpl/metano">gpl/metano</option>
</select>--> </td>
</tr>
<tr>
<td class="testob11">Prezzo (€)</td>
<td class="testo11"><select name="prezzo_inizio" class="testo11" id="prezzo_inizio" style="width:100px;">
<option value="0">Da</option>
<option value="500">€ 500</option>
<option value="2500">€ 2.500</option>
<option value="5000">€ 5.000</option>
<option value="8000">€ 8.000</option>
<option value="10000">€ 10.000</option>
<option value="15000">€ 15.000</option>
<option value="20000">€ 20.000</option>
<option value="30000">€ 30.000</option>
<option value="50000">€ 50.000</option>
<option value="75000">€ 75.000</option>
<option value="100000">€ 100.000</option>
<option value="100000sup">> € 100.000</option>
</select>

<select name="prezzo_fine" class="testo11" id="prezzo_fine" style="width:100px;">
<option value="9999999">a</option>
<option value="500">€ 500</option>
<option value="2500">€ 2.500</option>
<option value="5000">€ 5.000</option>
<option value="8000">€ 8.000</option>
<option value="10000">€ 10.000</option>
<option value="15000">€ 15.000</option>
<option value="20000">€ 20.000</option>
<option value="30000">€ 30.000</option>
<option value="50000">€ 50.000</option>
<option value="75000">€ 75.000</option>
<option value="100000">€ 100.000</option>
<option value="100000sup">> € 100.000</option>
</select> </td>
</tr>
<tr>
<td class="testob11">Anno</td>
<td class="testo11"><select name="anno_inizio" class="testo11" id="anno_inizio" style="width:100px;">
<option value="0">Da</option>
<option value="2011">2011</option>
<option value="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1985">1985</option>
<option value="1980">1980</option>
<option value="1975">1975</option>
<option value="1970">1970</option>
<option value="1965">1965</option>
<option value="1960">1960</option>
<option value="1955">1955</option>
<option value="1950">1950</option>
<option value="1945">1945</option>
<option value="1940">1940</option>
<option value="1935">1935</option>
<option value="1930">1930</option>
<option value="1925">1925</option>
<option value="1920">1920</option>
<option value="1915">1915</option>
<option value="1910">1910</option>
</select>

<select name="anno_fine" class="testo11" id="anno_fine" style="width:100px;">
<option value="9999">a</option>
<option value="2011">2011</option>
<option value="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1985">1985</option>
<option value="1980">1980</option>
<option value="1975">1975</option>
<option value="1970">1970</option>
<option value="1965">1965</option>
<option value="1960">1960</option>
<option value="1955">1955</option>
<option value="1950">1950</option>
<option value="1945">1945</option>
<option value="1940">1940</option>
<option value="1935">1935</option>
<option value="1930">1930</option>
<option value="1925">1925</option>
<option value="1920">1920</option>
<option value="1915">1915</option>
<option value="1910">1910</option>
</select>

<input type="submit" value="cerca" class="testo11"/> </td>
</tr>
</table> </td>
</tr>
</table>


</form>

<CREATE TABLE modelli (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
marca VARCHAR(15),
modello TEXT,
FULLTEXT (marca, modello)
);
>
<?/* Connecting, selecting database */
$db_link = mysql_connect("localhost", "root", "enzo");
if (!$db_link) {
die("Could not connect: " . mysql_error());
}
mysql_select_db("autovetture") or die("Could not select database");

/* Performing SQL query */


/* Closing connection */
mysql_close($db_link);
$query="select * from modelli where like%='id'"?>

[MVC]

questa query:
$query="select * from modelli where like%='id'"

non ha senso

cosa vuoi ricercare la parola "bmw"?

$query = "SELECT * FROM nometabella WHERE campotabelladeimodelli LIKE %bmw%";

[GLORIA71]

Salve come posso fare a creare un filtro di ricerca con questo form???facendo la ricerca di una marca appaiano tutta la lista completa di quella marca???che mi crea automaticamente la lista delle pagine??? un esempio semplice non c'e' ???non sono molto pratica ???grazie

[satifal]

...
$marca = $_POST['marca'];
...
$query = "SELECT * FROM modelli WHERE marca = '$marca'";
... 

[GLORIA71]

$marca = $_POST['marca'];
$modello = $_POST['modello'];
$prezzo = $_POST['prezzo'];
$anno = $_POST['anno'];
$query = "SELECT * FROM modelli WHERE marca = '$marca'";
$query = "SELECT * FROM modelli WHERE modello = '$modello'";
$query = "SELECT * FROM modelli WHERE prezzo = '$prezzo'";
$query = "SELECT * FROM modelli WHERE anno = '$anno'";
ho inserito questo codice ma il filtro scelto non compare appare
tuutta la lista completa delle marche che altro codice devo inserire??
grazie

[xproj]

satifal ti ha fatto solo un esempio di query con un filtro... la cosa è un po' più complessa... cerca prima di studiare il WHERE nelle select...

[GLORIA71]

ho inserito questa query ma non funziona che cosa ho sbagliato??? grazie
$search = $_GET['search'];
echo "Il testo cercato è: <span style='background-color:#CC0000; color:#FFCC00;'>$search</span>.";
$query = "SELECT * FROM modelli WHERE marca LIKE '%$marca%' OR modello LIKE '%$modello%' or anno like '$anno%' or cc like '$cc%' or prezzo like '$prezzo%' or alimentazione like '$alimentazione%'";

$result = mysql_query($query);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
$row["marca"] = eregi_replace($search, "<span style='background-color:#CC0000; color:#FFCC00;'>$search</span>", $row['marca']);
$row["modello"] = eregi_replace($search, "<span style='background-color:#CC0000; color:#FFCC00;'>$search</span>", $row['modello']);
$row["cc"] = eregi_replace($search, "<span style='background-color:#CC0000; color:#FFCC00;'>$search</span>", $row['cc']);
$row["anno"] = eregi_replace($search, "<span style='background-color:#CC0000; color:#FFCC00;'>$search</span>", $row['anno']);
$row["alimentazione"] = eregi_replace($search, "<span style='background-color:#CC0000; color:#FFCC00;'>$search</span>", $row['alimentazione']);
$row["prezzo"] = eregi_replace($search, "<span style='background-color:#CC0000; color:#FFCC00;'>$search</span>", $row['prezzo']);
$marca= $row["marca"];
$modello= $row["modello"];
$cc= $row["cc"];
$anno= $row["anno"];
$alimentazione= $row["alimentazione"];
$prezzo= $row["prezzo"];


echo $marca;
echo $modello;
echo $cc;
echo $anno;
echo $alimentazione;
echo $prezzo;
?>