File manager - Edit - /home/filmpbuk/public_html/header.php.2020.12.17.tar
Back
home/filmpbuk/public_html/header.php.2020.12.17 0000644 00000017551 15055603020 0014606 0 ustar 00 <?php header( 'content-type: text/html; charset=utf-8' ); // 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 --> <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> </ul> <button type="button" class="btn navbar-right " onclick="toggle_div(this,'searchplus');" >Recherche Avancé <i class="fab fa-searchengin fa-2x" title="recherche avancé"></i></button> <div id="searchplus" class="searchplus" style="display:none"> <form class="navbar-form navbar-right" role="search" method="post"> <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 class="search-header" > <form class="" role="search" method="post" action="index.php"> <div class="form-group"> <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> <input type="text" class="form-control" placeholder="<?php echo($navbar_search) ?>" name="search_query2"> </div> </form> </div> </div>
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.4 |
proxy
|
phpinfo
|
Settings