API tools faq
paste
Advertisement
Guest User

ricerca.php

a guest
Jun 25th, 2018
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.33 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. include("connect.php");
  3. require_once("top.php");
  4.  
  5. $welcome_name=$_SESSION['welcome_name'];
  6.  
  7. $query = "SELECT DISTINCT InseritoDa FROM cliente WHERE InseritoDa<>'".$welcome_name."' ORDER BY InseritoDa";
  8. $result = $connessione->query($query);
  9. while($row = $result->fetch_assoc()){
  10. $array_opzioni[] = $row["InseritoDa"];
  11. }
  12. $query2 = "SELECT DISTINCT Zona1 FROM richiestaimm NATURAL JOIN cliente WHERE Zona1!='' AND Disattivato='NO' ORDER BY Zona1";
  13. $result2 = $connessione->query($query2);
  14. while($row2 = $result2->fetch_assoc()){
  15. $array_opzioni2[] = $row2["Zona1"];
  16. }
  17.  
  18.  
  19. $query3 = "SELECT DISTINCT Citta FROM immobile WHERE Citta!='' AND Disattivato='NO' ORDER BY Citta";
  20. $result3 = $connessione->query($query3);
  21. while($row3 = $result3->fetch_assoc()){
  22. $array_opzioni3[] = $row3["Citta"];
  23. }
  24.  
  25. ?>
  26. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//IT" "http://www.w3.org/TR/html4/frameset.dtd">
  27. <div class="row">
  28. <div class="col-md-11">
  29.  
  30. <center>
  31. <FONT color=#CC0000><B>Ricerca tutti i clienti inserendo:</font><FONT color=#369E45><B> %</font>
  32. <table border="1" bordercolor="red" bgcolor="#369E45" cellspacing="0" cellpadding="0">
  33. <form action="after_search.php" method="post">
  34. <tr><td>
  35. <table border="0" bgcolor="FFFFFF" cellspacing="0" cellpadding="3,5">
  36. <tr><td width="60" bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Cliente</font></b></td>
  37. <td width="164" bgcolor="#369E45"><input type="text" name="stringa"></td>
  38. <tr><td width="60" bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Telefono</font></b></td>
  39. <td width="164" bgcolor="#369E45"><input type="text" name="Telefono" size="8"></td>
  40. <tr><td bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Tipologia</font></b></td>
  41. <td bgcolor="#369E45"><select name="tipoCasa" size="1">
  42. <option selected>--------------------------------</option>
  43. <option value=Appartamento>Appartamento
  44. <option value=Attico>Attico
  45. <option value=Box>Box
  46. <option value=Capannone>Capannone
  47. <option value=Mansarda>Mansarda
  48. <option value="<? echo "Locale Commerciale"; ?>">Locale Commerciale
  49. <option value=Rudere>Rudere
  50. <option value="<? echo "Soluzione Indipendente"; ?>">Sol. Indipendente
  51. <option value="<? echo "Soluzione Semi-Indipendente"; ?>">Sol.Semi-Indipendente
  52. <option value=Sottotetto>Sottotetto
  53. <option value="<? echo "Studio/Ufficio"; ?>">Studio/Ufficio
  54. <option value=Terreno>Terreno
  55. <option value=Villa>Villa
  56. <option value=%>Tutte
  57. </select> </font></td>
  58. <tr><td bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Vani</font></b></td>
  59. <td bgcolor="#369E45"><select name="Vani" size="1">
  60. <option selected>---</option>
  61. <option value=1>1
  62. <option value=2>2
  63. <option value=3>3
  64. <option value=4>4
  65. <option value=5>5
  66. <option value=6>6
  67. <option value=7>7
  68. </select></td>
  69. <tr><td bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Offerta</font></b></td>
  70. <td bgcolor="#369E45"><select name="Offerta" size="1">
  71. <option selected>-------------</option>
  72. <option value=Acquisto>Acquisto
  73. <option value=Vendita>Vendita
  74. <option value=Affitto>Affitto
  75. <option value=Permuta>Permuta
  76. </select></td>
  77. <tr><td bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Prezzo</font></b></td>
  78. <td bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Da</font></b> <input name="prezzoDA" type="text" size="5">
  79. <b><font face="arial" size="2" color="#FFFFFF">A</font></b>
  80. <input name="prezzoA" type="text" size="5"></td>
  81. <tr><td bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Zona</font></b></td>
  82. <td width="164" bgcolor="#369E45"><input type="text" name="Zona"></td>
  83.  
  84. <tr><td bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Agenzia</font></b></td>
  85. <td bgcolor="#369E45"><?
  86. if($welcome_name=="Venafro" OR $welcome_name=="Terzigno" OR $welcome_name=="Atripalda" OR $welcome_name=="Isernia"
  87. OR $welcome_name=="SanGiorgio" OR $welcome_name=="Portici")
  88. {
  89. ?> <select name="agenzia">
  90. <option selected><? echo "$welcome_name"; ?></option>
  91. </SELECT></td>
  92. <? } else {
  93. ?>
  94. <select name="agenzia">
  95. <option value="Tutte">Tutte
  96. <?php
  97.  
  98. for ($i=0; $i < count($array_opzioni); $i++)
  99. {
  100. if(!isset($opzione) && $i == 0)
  101. {
  102. echo "<OPTION SELECTED VALUE=\"". $array_opzioni[$i] . "\">". $array_opzioni[$i] ."</OPTION>\n";
  103. ?><option selected><? echo "$welcome_name"; ?></option><?
  104. }
  105. elseif($opzione == $array_opzioni[$i])
  106. {
  107. echo "<OPTION SELECTED VALUE=\"". $array_opzioni[$i] . "\">". $array_opzioni[$i] ."</OPTION>\n";
  108. }
  109. else
  110. {
  111. echo "<OPTION VALUE=\"". $array_opzioni[$i] . "\">". $array_opzioni[$i] ."</OPTION>\n";
  112. }
  113. }
  114. ?>
  115. </SELECT></td><? } ?>
  116. <tr><td width="60" bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Disattivati</font></b></td>
  117. <td width="164" bgcolor="#369E45"><input name="Disattivati" type="checkbox" value="SI"></td>
  118. <tr><td width="60" bgcolor="#369E45"><b><font face="arial" size="2" color="#FFFFFF">Giorni</font></b></td>
  119. <td width="164" bgcolor="#369E45"><select name="Giorni" size="1">
  120. <option selected>---</option>
  121. <option value=1>1
  122. <option value=2>2
  123. <option value=3>3
  124. <option value=4>4
  125. <option value=5>5
  126. <option value=6>6
  127. <option value=7>7
  128. <option value=8>8
  129. <option value=9>9
  130. <option value=10>10
  131. <option value=11>11
  132. <option value=12>12
  133. <option value=13>13
  134. <option value=14>14
  135. <option value=15>15
  136. <option value=16>16
  137. <option value=17>17
  138. <option value=18>18
  139. <option value=19>19
  140. <option value=20>20
  141. <option value=21>21
  142. <option value=22>22
  143. <option value=23>23
  144. <option value=24>24
  145. <option value=25>25
  146. <option value=26>26
  147. <option value=27>27
  148. <option value=28>28
  149. <option value=29>29
  150. <option value=30>30
  151. </select></td></td>
  152. <tr><td bgcolor="#369E45">
  153. <input name="criterio" type="hidden" value="esatta">
  154. </td>
  155. <td bgcolor="#369E45">
  156. <input name="ordine" type="hidden" value="crescente">
  157. </td>
  158. </tr>
  159. <tr><td colspan="2" align="center" bgcolor="#369E45">
  160. <input type="submit" value="Cerca">&nbsp;&nbsp;<input type="reset" value="Annulla">
  161. </td></tr></table>
  162. </td></tr></table>
  163. </center>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!