File manager - Edit - /home/filmpbuk/public_html/header.php.999.tar
Back
home/filmpbuk/public_html/header.php.999 0000644 00000024324 15055600007 0014104 0 ustar 00 <?php /* FILMOTECH Website INDEX page (c) 2013-2015 by Pascal PLUCHON http://www.filmotech.fr */ // Site parameters require_once("include/params.inc.php"); require_once("include/config.inc.php"); require_once("include/functions.php"); require_once("include/fpagination.php"); require_once("include/fpagisearch.php"); // Get configuration $cfg = new CONFIG(); // Connection to database try { if ( $cfg->DB_TYPE == 'sqlite' ) { $db = new PDO('sqlite:'.$cfg->DB_NAME.'.sqlite3'); } else { $db = new PDO('mysql:host='.$cfg->DB_SERVER.';dbname='.$cfg->DB_NAME, $cfg->DB_USER, $cfg->DB_PASSWORD); $db->query("SET NAMES UTF8"); } } catch (Exception $e) { die('Erreur : ' . $e->getMessage()); } // Query parameters $search_fields = array( "TitreVF" , "TitreVO" ,"Acteurs" , "Pays" , "Annee" , "Genre" , "Realisateurs" , "Audio" , "Reference" , "Support" , "Edition", "EntreeType", "EntreeSource", "Synopsis" ); $search_field = "TitreVF"; $search_label = "Titre"; $search_query = ""; // Last update $lastUpdate = '?'; $filename = 'update.txt'; if (file_exists($filename)) { $handle = fopen($filename, "r"); $lastUpdate = fread($handle, filesize($filename)); fclose($handle); } $last_update_label = sprintf($last_update,$lastUpdate); // Preparing database request // Count number of records $query = "SELECT count(*) from " . $cfg->DB_TABLE; $result = $db->query($query); $result_fetch = $result->fetch(); $total_record = $result_fetch[0]; $result->closeCursor(); $page = 1; $offset = 0; $pagination = $paginate; //. ",Annee, Support, FilmVu, PretEnCours, Edition, Pays, EntreeType, EntreeSource, Synopsis FROM " . $cfg if ( (isset($_GET['search_query'])) && ($_GET['search_query']!="") ) { $search_query = stripslashes($_GET['search_query']); $search_field = $_GET['search_field']; $search_label = $field_labels[$search_field]; if (isset($_GET['Page'])) $page = $_GET['Page']; $offset = ($page-1) * $nb_record_per_page; //requete SANS LIMIT . $nb_record_per_page sur la recherche //$select = sprintf( "SELECT ID, TitreVF, %s , FilmVu, PretEnCours, Support, Annee, Edition, EntreeType, EntreeSource, Synopsis FROM %s WHERE %s LIKE '%s' ORDER BY TitreVF , $second_column, $cfg->DB_TABLE , $_GET['search_field'] , '%' . addslashes($search_query) . '%' ); //requete AVEC LIMIT . $nb_record_per_page sur la recherche $select = sprintf( "SELECT ID, TitreVF, %s , FilmVu, TitreVO, Duree, Realisateurs, Acteurs, PretEnCours, Support, Annee, Audio, Edition, EntreeType, EntreeSource, Synopsis FROM %s WHERE %s LIKE '%s' ORDER BY TitreVF LIMIT " . $nb_record_per_page . " OFFSET " . $offset, $second_column, $cfg->DB_TABLE , $_GET['search_field'] , '%' . addslashes($search_query) . '%' ); $select_count = sprintf( "SELECT COUNT(*) FROM %s WHERE %s LIKE '%s' ORDER BY TitreVF", $cfg->DB_TABLE , $_GET['search_field'] , '%' . addslashes($search_query) . '%' ); $pagination = false; // Count number of rows returned $result = $db->query($select_count); $result_fetch = $result->fetch(); $count = $result_fetch[0]; $result->closeCursor(); } else { if (isset($_GET['Page'])) $page = $_GET['Page']; $offset = ($page-1) * $nb_record_per_page; if ($paginate) { // affichage par defaut sur la page index $select = "SELECT ID, TitreVF, " . $second_column . ", Annee, Support, FilmVu, TitreVO, Duree, Realisateurs, Acteurs, PretEnCours, Audio, Edition, Pays, EntreeType, EntreeSource, Synopsis FROM " . $cfg->DB_TABLE . " ORDER BY ID desc LIMIT " . $nb_record_per_page . " OFFSET " . $offset; $select_count = "SELECT COUNT(*) FROM " . $cfg->DB_TABLE . " ORDER BY TitreVF LIMIT " . $nb_record_per_page . " OFFSET " . $offset; $count = 1; } else { $select = "SELECT ID, TitreVF, " . $second_column . ", TitreVO, FilmVu, PretEnCours FROM " . $cfg->DB_TABLE . " ORDER BY TitreVF"; $count = $total_record; // $select_count = "SELECT COUNT(*) FROM " . $cfg->DB_TABLE; } } $response = $db->query($select); if ($pagination) $label_movie_count = sprintf( $movie_count_paginate , $offset+1 , ($offset+$nb_record_per_page)>$total_record ? $total_record : $offset+$nb_record_per_page , $total_record ); else $label_movie_count = sprintf( $movie_count , $count ); ?> <head> <title><?php echo($window_title); ?></title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <link rel="icon" href="favicon.ico"> <!-- FONTAWESOME STYLES --> <link rel="stylesheet" href="fontawesome/css/all.css"> <!-- Bootstrap --> <link href="css/bootstrap.min.css" rel="stylesheet" media="screen"> </head> <!-- Navigation bar --> <div id="header"> <nav class="navbar navbar-default" role="navigation"> <!-- Brand and toggle get grouped for better mobile display --> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse"> <span class="sr-only">Navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> </div> <!-- Collect the nav links, forms, and other content for toggling <i class="fas fa-fast-backward"></i>--> <!--<?php echo $pageinfo; ?>--> <div class="collapse navbar-collapse navbar-ex1-collapse"> <ul class="nav navbar-nav"> <li class=""><a href="index.php"><i class="fas fa-home fa-2x" title="home"></i> </a></li> <?php if ($search_query !='') { echo '<li class=""><a href="javascript:history.back();"><i class="fas fa-chevron-left fa-2x"></i> </a></li>'; } ?> <li class=""><a href="index.php"><i class="fad fa-table fa-2x" title="vue en gallerie"></i> </a></li> <li class=""><a href="index-liste.php"><i class="fad fa-list fa-2x" title="vue en liste"></i> </a></li> <!--<li class=""><a href="nonvu.php"><i class="fa fa-eye fa-2x"></i> <?php echo($navbar_active_nonvu ); ?></a></li> <li class=""><a href="lasttitle.php"><i class="fa fa-file-text-o fa-2x"></i> <?php echo( $navbar_active_last ); ?></a></li>--> </ul> <div id="recherchetitre" class="recherchetitre" > <?php if ($pageinfo=="index") { $action="index.php" ;} ?> <form class="navbar-form navbar-right" role="search" method="GET" action="<?php echo($action) ?>"> <div class="form-group"> <input class="champ_recherche" type="hidden" name="search_field" value="<?php echo($search_field); ?>"> <input type="text" class="form-control" placeholder="<?php echo($navbar_search) ?>" name="search_query"> </div> <button type="submit" class="btn btn-search"><i class="fa fa-search fa"></i></button> </form> </div> <ul class="nav navbar-nav navbar-right"> <li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"><?php echo($navbar_search_by . ' ' . $search_label); ?> <b class="caret"></b></a> <ul class="dropdown-menu"> <?php foreach ($search_fields as $value) { echo( '<li><a tabindex="0" href="#" name="'.$value.'">'.$field_labels[$value].'</a></li>'); } ?> </ul> </li> </ul> </div> </div> <!-- /.navbar-collapse --> </nav></div> <div class="b-header"> <div class="logo-header"> <?php if ($show_title) { //echo( '<div class="jumbotron">' ); echo( '<h1><a href="'.$_SERVER['PHP_SELF'].'"><span class="text-info">'. $title_label .'</span></a></h1>' ); echo( '</div>'); } //else echo( '<a href="'.$_SERVER['index.php'].'"><img class="img-responsive" src="img/top.png" /></a>' ); else echo( '<a href="index.php"><img class="img-responsive" src="img/top.png" /></a>' ); ?> </div> </div> </head> <script>// Fonction Masquer/Afficher une Div function toggle_div(bouton, id) { // On déclare la fonction toggle_div qui prend en param le bouton et un id var div = document.getElementById(id); // On récupère le div ciblé grâce à l'id if(div.style.display=="none") { // Si le div est masqué... div.style.display = "block"; // ... on l'affiche... bouton.innerHTML = "Réduire <i class='far fa-minus-square fa-2x' title='Réduire'></i>";//"Réduire"; // ... et on change le contenu du bouton. } else { // S'il est visible... div.style.display = "none"; // ... on le masque... bouton.innerHTML = "Recherche Avancé <i class='fab fa-searchengin fa-2x' title='recherche avancé'></i>"; // ... et on change le contenu du bouton. } } </script> <script type="text/javascript"> var i = 0; var searchplus = document.getElementById("searchplus"); // var recherchetitre = document.getElementById("recherchetitre"); function switchdiv(){ if (i == 1){ searchplus.style.visibility ="hidden"; // recherchetitre.style.visibility ="visible"; document.getElementById("boutonsearch").innerHTML = "<i class='fas fa-cogs fa' title='recherche avancée'></i>"; }//Recherche Avancé fab fa-searchengin fa-2x else{ searchplus.style.visibility ="visible"; // recherchetitre.style.visibility ="visible"; document.getElementById("boutonsearch").innerHTML = "<i class='far fa-times-circle fa' title='Fermer la recherche avancée'></i>"; }//Réduire far fa-minus-square fa-1_6xRéduire i ++; i = i%2 console.log(i) } </script> <script type="text/javascript"> var i = 0; var searchplusplus = document.getElementById("searchplusplus"); var recherchetitretitre = document.getElementById("recherchetitretitre"); function inverse(){ if (i == 1){ searchplusplus.style.visibility ="hidden"; recherchetitretitre.style.visibility ="visible"; document.getElementById("boutonsearch").innerHTML = "<i class='fas fa-cogs fa' title='recherche avancée'></i>"; }//Recherche Avancé fab fa-searchengin fa-2x else{ searchplusplus.style.visibility ="visible"; recherchetitretitre.style.visibility ="hidden"; document.getElementById("boutonsearch").innerHTML = "<i class='far fa-times-circle fa' title='Fermer la recherche avancée'></i>"; }//Réduire far fa-minus-square fa-1_6xRéduire i ++; i = i%2 console.log(i) } </script>
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.4 |
proxy
|
phpinfo
|
Settings