<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();
?>