السلام عليكم
اخواني اريد ان ابحث في اكتر من input سوف اوضح لكم
انا عندي قاعة بينات اهي
-- phpMyAdmin SQL Dump -- version 3.4.5 -- http://www.phpmyadmin.net -- -- Client: localhost -- Généré le : Mer 22 Février 2012 à 22:54 -- Version du serveur: 5.5.16 -- Version de PHP: 5.3.8 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Base de données: `allabout_db` -- -- -------------------------------------------------------- -- -- Structure de la table `saison` -- CREATE TABLE IF NOT EXISTS `saison` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(200) NOT NULL, `idpro` int(11) NOT NULL, `debut` varchar(100) NOT NULL, `fin` varchar(100) NOT NULL, `dis` text NOT NULL, `nom` text NOT NULL, `chamber` text NOT NULL, `pseudo` text NOT NULL, `email` varchar(250) NOT NULL, `pass` text NOT NULL, `nom_fr` text NOT NULL, `nom_en` text NOT NULL, `ville` varchar(255) NOT NULL, `adresse` text NOT NULL, `tel` varchar(255) NOT NULL, `fax` varchar(255) NOT NULL, `gsm` varchar(255) NOT NULL, `web` text NOT NULL, `logo` text NOT NULL, `dateins` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=140 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
اريد ان ابحت داخل saison في الخداول التالية
debut = تاريخ البداية
fin = تاريخ انهاية
nom = الاسم
chamber = عدد الغرف
ville = المدينة
ولقد عملت صفحت للبحت
<form id="form1" name="form1" method="post" action="test2.php">
<table width="150" border="0" class="tb">
<tr>
<td colspan="3" class="tb"> </td>
</tr>
<tr>
<td width="75"> <p>Arrivée le : </p></td>
<td width="53"> </td>
<td width="109"> Départ le : </td>
</tr>
<tr>
<td><label>
<input name="debut" type="text" id="select3" size="5" />
</label></td>
<td> </td>
<td><input name="fin" type="text" id="select3" size="5" /></td>
</tr>
<tr>
<td>Ville</td>
<td colspan="2"><label>
<select name="ville" id="ville">
<option value=""></option>
<option value="Agadir">Agadir</option>
<option value="Casablanca">Casablanca</option>
<option value="El Jadida">El Jadida</option>
<option value="Essaouira">Essaouira</option>
<option value="Fes">Fes</option>
<option value="Laayoune">Laayoune</option>
<option value="Marrakech">Marrakech</option>
<option value="Meknes">Meknes</option>
<option value="Ouarzazate">Ouarzazate</option>
<option value="Rabat">Rabat</option>
<option value="Safi">Safi</option>
<option value="Smara">Smara</option>
<option value="Tanger">Tanger</option>
<option value="Tetouan">Tetouan</option>
</select>
</label></td>
</tr>
<tr>
<td colspan="3"><table width="174" border="0" class="b">
<tr>
<td> Chambres </td>
<td> Adultes </td>
<td> Enfants </td>
</tr>
<tr>
<td><select name="chamber" id="chamber">
<option value=""></option>
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
</select></td>
<td><select name="select3" id="select4">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
</select></td>
<td><select name="select3" id="select5">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
</select></td>
</tr>
</table></td>
</tr>
<tr>
<td>Classification</td>
<td><span style="padding-left:5px">
<select name="nom" id="nom">
<option value=""></option>
<option value="Appartement">Appartement</option>
<option value="Auberge">Auberge</option>
<option value="Gite">Gite</option>
<option value="Hotel">Hotel</option>
<option value="Kasbah">Kasbah</option>
<option value="Palais">Palais</option>
<option value="Riad">Riad</option>
<option value="Villa">Villa</option>
</select>
</span></td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
<p>
<label>
<input type="submit" name="Submit" value="Envoyer" />
</label>
</p>
</form>وفي صفجت
test2.php
عملت ايضا كود اهو
<?php
$host="localhost";
$user="root";
$pass="root";
$db="test";
mysql_connect($host,$user,$pass);
mysql_select_db($db);
$cherch=$_POST['debut'];
$cherch2=$_POST['fin'];
$cherch3=$_POST['ville'];
$cherch4=$_POST['chamber'];
$cherch5=$_POST['nom'];
$sql="(select * from saison where debut LIKE '%$cherch' OR fin LIKE '%$cherch2' OR ville LIKE '%$cherch3' OR chamber LIKE '%$cherch4' OR nom LIKE '%$cherch5')";
$query=mysql_query($sql);
while($row=mysql_fetch_array($query)){
echo "<br>ville:".$row['ville']."<br>";
echo "<br>chamber:".$row['chamber']."<br>";
echo "<br>chamber:".$row['nom']."<br>";
echo "<br>type:".$row['nom']."<br>";
echo "<br>debut:".$row['debut']."<br>";
echo "<br>dfin:".$row['fin']."<br>";
}
?>لكن للاسف لم يعمل المرجو مساعدتي وشكرا لكم