Sveiki, esu cia naujokas, taciau noreciau paprasyti jusu pagalbos..
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
//-----------
if(! get_magic_quotes_gpc() )
{
$Marke = addslashes ($_POST['Marke']);
$Modelis = addslashes ($_POST['Modelis']);
$Metai = addslashes ($_POST['Metai']);
}
else
{
$Marke = addslashes ($_POST['Marke']);
$Modelis = addslashes ($_POST['Modelis']);
$Metai = addslashes ($_POST['Metai']);
}
//------------
mysql_select_db('auto');
$result = mysql_query("SELECT * FROM mas_paieska
WHERE (Marke='$Marke') AND (Modelis='$Modelis') AND (Metai='$Metai')");
echo "<table border='1'>
<tr>
<th>Marke</th>
<th>Modelis</th>
<th>Metai</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['Marke'] . "</td>";
echo "<td>" . $row['Modelis'] . "</td>";
echo "<td>" . $row['Metai'] . "</td>";
echo "</tr>";
}
echo "</table>";
echo "Fetched data successfully\n";
mysql_close($conn);
}
else
{
?>
<form method="post" action="<?php $_PHP_SELF ?>">
<table width="600" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="250">Iveskite Marke</td>
<td>
<input name="Marke" type="text" id="Marke" size="20">
</td>
</tr>
<tr>
<td width="250">Iveskite modeli</td>
<td>
<input name="Modelis" type="text" id="Modelis" size="20">
</td>
</tr>
<tr>
<td width="250">Iveskite metus</td>
<td>
<input name="Metai" type="text" id="Metai" size="20">
</td>
</tr>
<tr>
<td width="250"> </td>
<td> </td>
</tr>
<tr>
<td width="250"> </td>
<td>
<input name="add" type="submit" id="add" value="Rasti">
</td>
</tr>
</table>
</form>
<?php
}
?>
man neveikia butent boldintas sakinys, nes man ismeta ne tai ko noriu..
PAVYZDYS:
jeigu vartotojas iveda i paieska AUDI ir 2008 metus, tai butu gerai kad ismestu visus AUDI 2008 metu modelius, kaip A5 A4 A3 A1 Q7 A8 ir t.t.
o man cia nesigauna WHERE nurodyti salygos.. :( pagelbekit zmones.. labai prasau.. :)