File manager

File manager - Edit - /home/filmpbuk/public_html/header.php.123

Back
<?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 ); ?> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <!-- 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"> <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" > <!--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>

| ver. 1.4 | Github | . | PHP 7.3.33 | Generation time: 0.4 | proxy | phpinfo | Settings