Advertisement
Guest User

table

a guest
Oct 19th, 2012
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.97 KB | None | 0 0
  1. <style>
  2. br {margin-bottom:-10px;}
  3. </style>
  4.  
  5. <form action="cerca2.php" method="post">
  6. <b>Nome</b>&nbsp;<input type="text" name="Nome">&nbsp;&nbsp;
  7. <b>Numero&nbsp;</b><input type="text" name="Numero">&nbsp;&nbsp;
  8. <b>city&nbsp;</b><input type="text" name="city">&nbsp;&nbsp;
  9. <input type="Submit">
  10. </form>
  11.  
  12. <style>
  13. tr:nth-of-type(odd) { background-color: AZURE; }
  14. tr:nth-of-type(even) { background-color: CYAN; }
  15. </style>
  16. <style>
  17. tr:hover{background-color:DEEPSKYBLUE;}
  18. </style>
  19.  
  20. <script type="text/javascript" src="ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
  21. <script type="text/javascript" src="http://tablesorter.com/__jquery.tablesorter.min.js"></script>
  22. <script type="text/javascript">
  23. $(document).ready(function(){ $("table").tablesorter(); });
  24. </script>
  25.  
  26.  
  27. <?php
  28.  
  29. echo "<table border='1' style='border-collapse: collapse;border-color: silver;'>";
  30. echo "<tr style='font-weight: bold;'>";
  31. echo "<td width='auto' bgcolor=”#7FFFD4″>&nbsp;<i>ID<i/></td>";
  32. echo "<td width='auto' >&nbsp;<i>Nome<i/></td>";
  33. echo "<td width='auto' ></td>";
  34. echo "<td ></td>";
  35. echo "</tr>";
  36.  
  37. define('DB_NAME', 'forms1');
  38. define('DB_USER', 'root');
  39. define('DB_PASSWORD', '');
  40. define('DB_HOST', 'localhost');
  41.  
  42. $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
  43. if (!$link) {
  44. die('Could not connect: ' . mysql_error());
  45. }
  46.  
  47. $db_selected = mysql_select_db(DB_NAME, $link);
  48.  
  49. if (!$db_selected) {
  50. die('Can\'t use ' . DB_NAME . ': ' . mysql_error());
  51. }
  52.  
  53. $Nome = str_replace(' ', '%', $_POST['Nome']);
  54. $Numero = str_replace(' ', '%', $_POST['Numero']);
  55. $city = str_replace(' ', '%', $_POST['city']);
  56.  
  57. $arNome = str_split($Nome);
  58. $arNumero = str_split($Numero);
  59. $arcity = str_split($city);
  60.  
  61. $Nome='';
  62. foreach ($arNome as $value)
  63. {
  64. if ($value=='%') continue;
  65. $Nome.=$value.'%';
  66.  
  67. }
  68.  
  69. $Numero='';
  70. foreach ($arNumero as $value)
  71. {
  72. if ($value=='%') continue;
  73. $Numero.=$value.'%';
  74.  
  75. }
  76.  
  77. $city='';
  78. foreach ($arcity as $value)
  79. {
  80. if ($value=='%') continue;
  81. $city.=$value.'%';
  82.  
  83. }
  84.  
  85. if ($_GET['name_sort'] == 'desc') {
  86. $sql = mysql_query("SELECT * FROM demo WHERE Autore LIKE '%$Nome%' AND Titolo LIKE '%$Numero%' AND cit LIKE '%$city%' ORDER BY Autore DESC") or die(mysql_error());
  87.  
  88. } else {
  89.  
  90. $sql = mysql_query("SELECT * FROM demo WHERE Autore LIKE '%$Nome%' AND Titolo LIKE '%$Numero%' AND cit LIKE '%$city%' ORDER BY Autore ASC") or die(mysql_error());
  91. }
  92.  
  93.  
  94.  
  95. $i = 0; while($row=mysql_fetch_array($sql)){
  96. $i++;
  97. echo "<tr>";
  98. echo "<td width='auto' bgcolor=”#FF0000 &#8243;>" . "&nbsp;". "<b>" . $i . "&nbsp;". "<b/>". "</td>";
  99. echo "<td width='auto'>" . "&nbsp;" . $row[1] . "&nbsp;" . "</td>";
  100. echo "<td width='auto'>". "</td>";
  101. echo "<td width='auto'>" . "&nbsp;". "<i>" . $row[2] . "<i/>". "&nbsp;" . "</td>";
  102. echo "<td width='auto'>" . "&nbsp;". "<i>" . $row[3] . "<i/>". "&nbsp;" . "</td>";
  103. echo "</tr>";
  104.  
  105. }
  106.  
  107. mysql_close();
  108. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement