Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <head>
- <body background=pattern1.gif>
- <style type="text/css">
- a:link {text-decoration: none; color: brown;}
- a:visited {text-decoration: none; color: green;}
- a:hover {color: red;}
- </style>
- <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>
- <link rel="stylesheet" href="style.css" type="text/css" id="" media="print, projection, screen" />
- <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
- <script type="text/javascript">
- $(function() {
- $(".spoiler-label").click(function() {
- $(this).parent().find(".spoiler-content").toggle();
- });
- });
- </script>
- <script type="text/javascript" src="jquery-latest.js"></script>
- <script type="text/javascript" src="jquery.tablesorter.js"></script>
- <script type="text/javascript">
- $(function() {
- $("table").tablesorter({debug: true});
- });
- </script>
- </head>
- <form action="risultati0.php" method="POST">
- <b>Titolo</b> <input type="text" name="Titolo">
- <b>Proprietà </b><input type="text" name="Proprietà">
- <input type="Submit">
- </form>
- <?php
- echo "<table id='rowspan' cellspacing='0' class='tablesorter'>";
- echo "<thead><tr>";
- echo "<th> <i>ID<i/></th>";
- echo "<th> <i>Titolo<i/></th>";
- echo "<th>Proprietà</th>";
- echo "<th >Download</th>";
- echo "</tr></thead>";
- define('DB_NAME', 'ost_scores_gamerip');
- 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());
- }
- mysql_query('SET CHARACTER SET utf8');
- $Titolo = str_replace(' ', '%', $_POST['Titolo']);
- $Proprietà = str_replace(' ', '%', $_POST['Proprietà']);
- $arTitolo = str_split($Titolo);
- $arProprietà = str_split($Proprietà);
- $Titolo='';
- foreach ($arTitolo as $value)
- {
- if ($value=='%') continue;
- $Titolo.=$value.'%';
- }
- $Proprietà='';
- foreach ($arProprietà as $value)
- {
- if ($value=='%') continue;
- $Proprietà.=$value.'%';
- }
- $sql = mysql_query("SELECT * FROM microsoft WHERE Titolo LIKE '%$Titolo%' AND Proprietà LIKE '%$Proprietà%' UNION SELECT * FROM pc WHERE Titolo LIKE '%$Titolo%' AND Proprietà LIKE '%$Proprietà%' ORDER BY Titolo") or die(mysql_error());
- $i = 0; while($row=mysql_fetch_array($sql)){
- $i++;
- echo "<tr>";
- $row['3']=stripslashes($row['3']);
- $row['3']=str_replace('<br />',"newline",$row['3']);
- $row['3']=htmlentities($row['3']);
- $ary=explode('newline',$row['3']);
- $str="";
- foreach($ary as $str2){
- $str.="<a href=\"$str2\">$str2</a><br/>";
- }
- $row['3']=$str;
- echo "<td width='auto' bgcolor=”#FF0000 ″>" . " ". "<b>" . $i . " ". "<b/>". "</td>";
- echo "<td width='auto'>" . " " . $row[1] . " " . "</td>";
- echo "<td width='auto'>". $row[2] . "</td>";
- echo "<td> <a href=\"".$row[3]."\">".$row[3]."</a> </td>";
- echo '<td><span class="spoiler-label">'.$row[1].'</span><div class="spoiler-content" style="display: none"><br><a href='.$row[3].'>'.$row[3].'<a/></div><td>';
- echo "</tr>";
- }
- mysql_close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement