Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <style>
- br {margin-bottom:-10px;}
- </style>
- <form action="cerca2.php" method="post">
- <b>Nome</b> <input type="text" name="Nome">
- <b>Numero </b><input type="text" name="Numero">
- <b>city </b><input type="text" name="city">
- <input type="Submit">
- </form>
- <style>
- tr:nth-of-type(odd) { background-color: AZURE; }
- tr:nth-of-type(even) { background-color: CYAN; }
- </style>
- <style>
- tr:hover{background-color:DEEPSKYBLUE;}
- </style>
- <script type="text/javascript" src="ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
- <script type="text/javascript" src="http://tablesorter.com/__jquery.tablesorter.min.js"></script>
- <script type="text/javascript">
- $(document).ready(function(){ $("table").tablesorter(); });
- </script>
- <?php
- echo "<table border='1' style='border-collapse: collapse;border-color: silver;'>";
- echo "<tr style='font-weight: bold;'>";
- echo "<td width='auto' bgcolor=”#7FFFD4″> <i>ID<i/></td>";
- echo "<td width='auto' > <i>Nome<i/></td>";
- echo "<td width='auto' ></td>";
- echo "<td ></td>";
- echo "</tr>";
- define('DB_NAME', 'forms1');
- define('DB_USER', 'root');
- define('DB_PASSWORD', '');
- define('DB_HOST', 'localhost');
- $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
- if (!$link) {
- die('Could not connect: ' . mysql_error());
- }
- $db_selected = mysql_select_db(DB_NAME, $link);
- if (!$db_selected) {
- die('Can\'t use ' . DB_NAME . ': ' . mysql_error());
- }
- $Nome = str_replace(' ', '%', $_POST['Nome']);
- $Numero = str_replace(' ', '%', $_POST['Numero']);
- $city = str_replace(' ', '%', $_POST['city']);
- $arNome = str_split($Nome);
- $arNumero = str_split($Numero);
- $arcity = str_split($city);
- $Nome='';
- foreach ($arNome as $value)
- {
- if ($value=='%') continue;
- $Nome.=$value.'%';
- }
- $Numero='';
- foreach ($arNumero as $value)
- {
- if ($value=='%') continue;
- $Numero.=$value.'%';
- }
- $city='';
- foreach ($arcity as $value)
- {
- if ($value=='%') continue;
- $city.=$value.'%';
- }
- if ($_GET['name_sort'] == 'desc') {
- $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());
- } else {
- $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());
- }
- $i = 0; while($row=mysql_fetch_array($sql)){
- $i++;
- echo "<tr>";
- echo "<td width='auto' bgcolor=”#FF0000 ″>" . " ". "<b>" . $i . " ". "<b/>". "</td>";
- echo "<td width='auto'>" . " " . $row[1] . " " . "</td>";
- echo "<td width='auto'>". "</td>";
- echo "<td width='auto'>" . " ". "<i>" . $row[2] . "<i/>". " " . "</td>";
- echo "<td width='auto'>" . " ". "<i>" . $row[3] . "<i/>". " " . "</td>";
- echo "</tr>";
- }
- mysql_close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement