1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| $limite = $_GET['limite'];
if (!isset($limite)) $limite = 0;
if (isset($_GET['titre'])) $_POST['titre']=$_GET['titre'];
if (isset($_GET['type'])) $_POST['type']=$_GET['type'];
if (isset($_GET['value'])) $_POST['value']=$_GET['value'];
if (isset($_GET['order'])) $_POST['order']=$_GET['order'];
if (!$_POST['order']) $_POST['order']=$_POST['type'];
if (isset($_GET['desc'])) $_POST['desc']=$_GET['desc'];
if ($_GET['fl']) $var_sql = $_POST['type']." like '".$_GET['fl']."%' and ";
function desc($POSTtype,$POSTdesc,$type){
if($POSTtype == $type) {
if($POSTdesc == 'desc') return '';
elseif($POSTdesc != 'desc') return 'desc';
}
}
// on fait les liens
$lien_titre = "index.php?action=104&fl=".$_GET['fl']."&type=".$_POST[type]."&value=".$_POST[value]."&order=titre&desc=".desc($_POST[order],$_POST[desc],'titre');
$lien_artiste = "index.php?action=104&fl=".$_GET['fl']."&type=".$_POST[type]."&value=".$_POST[value]."&order=artiste&desc=".desc($_POST[order],$_POST[desc],'artiste');
$lien_style = "index.php?action=104&fl=".$_GET['fl']."&type=".$_POST[type]."&value=".$_POST[value]."&order=style&desc=".desc($_POST[order],$_POST[desc],'style');
$lien_type = "index.php?action=104&fl=".$_GET['fl']."&type=".$_POST[type]."&value=".$_POST[value]."&order=type&desc=".desc($_POST[order],$_POST[desc],'type');
$arrow[$_POST['order']] ="<img src=\"images/ordre".$_POST['desc'].".png\" />";
$mess = new req();
$mess->connect($host_bdd,$login_bdd,$mdp_bdd,$database_bdd);
$mess->query_lim("tablatures WHERE $var_sql ".$_POST['type']." like '%".$_POST['value']."%' order by ".$_POST['order']." ".$_POST['desc'],$limite,20);
echo "<table width='500px'><tr><td><a href=\"$lien_titre\">".$arrow['titre']."Titre</a></td><td><a href=\"$lien_artiste\">".$arrow['artiste']."Artiste</a></td><td><a href=\"$lien_style\">".$arrow['style']."Style</a></td><td><a href=\"$lien_type\">".$arrow['type']."Type</a></td></tr>";
while( $result = $mess->fetch_array() ){
echo "<tr><td><a href=\"index.php?action=100&id=".$result['id']."\">".$result['titre']."</a></td><td><a href=\"index.php?action=104&type=artiste&value=".$result['artiste']."\">".$result['artiste']."</a></td><td><a href=\"index.php?action=104&type=style&value=".$result['style']."\">".$result['style']."</a></td><td><a href=\"index.php?action=104&type=type&value=".$result['type']."\">".$result['type']."</a></td></tr>";
$result_min=1;
}
echo '</tr></table>';
if (!$result_min) echo"Pas de résultat";
echo "<br>";
$mess->liens("index.php?action=104&&type=$type&&value=$value&&"); |
Partager