File manager - Edit - /home/filmpbuk/public_html/header_detail.php.2020.12.17
Back
<?php // Query parameters //$search_fields = array( "TitreVF" , "TitreVO" , "Genre" , "Acteurs" , "Realisateurs" , "Commentaires" , "Bonus" , "Reference" ); $search_fields = array( "TitreVF" , "TitreVO" , "Acteurs" , "Pays" , "Annee" , "Genre" , "Realisateurs" , "Reference" , "Support" , "Edition", "EntreeType", "EntreeSource", "Synopsis" ); $search_field = "TitreVF"; $search_field2 = "TitreVF"; $search_label = "Titre"; $search_label2 = "Titre"; $search_query = ""; $search_query2 = ""; // 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(); $TitreVF = 'TitreVF'; $page = 1; $offset = 0; $pagination = $paginate; // Recherche sur les champs titreVO, titreVF if ( (isset($_POST['search_query'])) && ($_POST['search_query']!="") ) { $search_query = stripslashes($_POST['search_query']); $search_field = $_POST['search_field']; $search_label = $field_labels[$search_field]; $select = sprintf( "SELECT ID, TitreVF, %s , Annee, Support, Edition, FilmVu, PretEnCours, EntreeType, EntreeSource, Synopsis FROM %s WHERE %s LIKE '%s' OR %s LIKE '%s' ORDER BY TitreVF", $second_column, $cfg->DB_TABLE , $_POST['search_field'] , '%' . addslashes($search_query) . '%' ,'TitreVO', '%' . addslashes($search_query) . '%'); //,'Acteurs', '%' . addslashes($search_query) . '%' OR %s LIKE '%s' $select_count = sprintf( "SELECT COUNT(*) FROM %s WHERE %s LIKE '%s' OR %s LIKE '%s' ORDER BY TitreVF", $cfg->DB_TABLE , $_POST['search_field'] , '%' . addslashes($search_query) . '%' ,'TitreVO', '%' . addslashes($search_query) . '%'); //,'Acteurs', '%' . addslashes($search_query) . '%' OR %s LIKE '%s' $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) { $select = "SELECT ID, TitreVF, " . $second_column . ",Annee, Support, FilmVu, PretEnCours, 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 . ", FilmVu, Annee, Support, PretEnCours, Edition, Pay, EntreeType, EntreeSource, Synopsiss FROM " . $cfg->DB_TABLE . " ORDER BY TitreVF"; $count = $total_record; } } $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 ); // Recherche sur les champs titreVO, titreVF, acteurs formulaire dans le header if ( (isset($_POST['search_query2'])) && ($_POST['search_query2']!="") ) { $search_query2 = stripslashes($_POST['search_query2']); $search_field2 = $_POST['search_field2']; $search_label2 = $field_labels[$search_field2]; $select = sprintf( "SELECT ID, TitreVF, %s , Annee, Support, Edition, FilmVu, PretEnCours, EntreeType, EntreeSource, Synopsis FROM %s WHERE %s LIKE '%s' OR %s LIKE '%s' OR %s LIKE '%s' ORDER BY TitreVF", $second_column, $cfg->DB_TABLE , $_POST['search_field2'] , '%' . addslashes($search_query2) . '%' ,'TitreVO', '%' . addslashes($search_query2) . '%','Acteurs', '%' . addslashes($search_query2) . '%'); $select_count = sprintf( "SELECT COUNT(*) FROM %s WHERE %s LIKE '%s' OR %s LIKE '%s' OR %s LIKE '%s' ORDER BY TitreVF", $cfg->DB_TABLE , $_POST['search_field2'] , '%' . addslashes($search_query2) . '%' ,'TitreVO', '%' . addslashes($search_query2) . '%','Acteurs', '%' . addslashes($search_query2) . '%'); $pagination = false; // Count number of rows returned $result = $db->query($select_count); $result_fetch = $result->fetch(); $count = $result_fetch[0]; $result->closeCursor(); } $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 ); ?> <!-- FONTAWESOME STYLES --> <link rel="stylesheet" href="fontawesome/css/all.css"> <!-- Bootstrap --> <link href="css/bootstrap.min.css" rel="stylesheet" media="screen"> <link rel="icon" href="favicon.ico"> <!-- Navigation bar --> <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>--> <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"></i> <?php echo( $navbar_active_title ); ?></a></li> <li class=""><a href="javascript:history.back();"><i class="fas fa-chevron-left fa-2x"></i> <?php echo( $navbar_detail_back ); ?></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> <button type="button" id="boutonsearch" class="btn navbar-right " onclick="inverse()" >Recherche Avancé <i class="fab fa-searchengin fa-2x" title="recherche avancé"></i></button> <!--onclick="toggle_div(this,'searchplus');"--> <div id="searchplus" class="searchplus" style="visibility:hidden"> <form class="navbar-form navbar-right" role="search" method="post" action="index.php" style="padding: 0;"> <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" style="right: 45px;position: relative;"><i class="fa fa-search fa-2x"></i></button><!--<?php echo($navbar_go) ?>--> </form> <ul class="nav navbar-nav navbar-right"> <li class=""> <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 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 id="recherchetitre" class="search-header" style="visibility:visible" > <!--style="position: relative;top: -50px;left: 251px;height: 34px;"--> <form class="" role="search" method="post" action="index.php"> <div class="form-group"> <!--style="float: right; top: -50px; margin-left: 15px;"--> <input class="champ_recherche" type="hidden" name="search_field2" value="<?php echo($search_field2); ?>"> <button type="submit" class="btn btnsearchheader" ><i class="fas fa-search fa-2x"></i></button><!-- style="right: -12px;position: absolute;bottom: -3px;" <?php echo($navbar_go) ?>--> <input type="text" class="form-control" placeholder="<?php echo($navbar_search) ?>" name="search_query2"> </div> </form> </div> </div> <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 inverse(){ if (i == 1){ searchplus.style.visibility ="hidden"; recherchetitre.style.visibility ="visible"; document.getElementById("boutonsearch").innerHTML = "Recherche Avancé <i class='fab fa-searchengin fa-2x' title='recherche avancé'></i>"; } else{ searchplus.style.visibility ="visible"; recherchetitre.style.visibility ="hidden"; document.getElementById("boutonsearch").innerHTML = "Réduire <i class='far fa-minus-square fa-2x' title='Réduire'></i>"; } i ++; i = i%2 console.log(i) } </script>
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.4 |
proxy
|
phpinfo
|
Settings