5546 sujets
Sémantique web et HTML
mais nonavec fgetcsv j y arrive mais pas avec gets pour un txt
existe t il l equivalent de ca mais qui fonctionne sur un txt parceque le separateur espace de fonctionne pas en l occurence
$fichier = 'fichier.csv';
//Lecture du fichier CSV
if (($handle = fopen($fichier, "rb")) !== FALSE) {
// recuperation des lignes dans un array
while (($ligne = fgetcsv($handle, 1024, ";")) !== FALSE) {
$lignes[] = $ligne;
}
// affichage
foreach ($lignes as $data) {
echo '<a>'.$data[0].' - '.$data[3].'</a>'."\n";
}
fclose($handle);
}
existe t il l equivalent de ca mais qui fonctionne sur un txt parceque le separateur espace de fonctionne pas en l occurence
$fichier = 'fichier.csv';
//Lecture du fichier CSV
if (($handle = fopen($fichier, "rb")) !== FALSE) {
// recuperation des lignes dans un array
while (($ligne = fgetcsv($handle, 1024, ";")) !== FALSE) {
$lignes[] = $ligne;
}
// affichage
foreach ($lignes as $data) {
echo '<a>'.$data[0].' - '.$data[3].'</a>'."\n";
}
fclose($handle);
}
Et l'eau,
ci dessous 2 class qui devrait t'aider.
Comment ça fonctionne ? (les méthodes set_separator, set_escape, set_enclosure sont optionnels puisque je mets des valeurs par défaut au constructeur)
fichier source :
Modifié par niuxe (24 Jan 2020 - 02:44)
ci dessous 2 class qui devrait t'aider.
<?php
class CSVReader{
const OPEN_FILE_MODE = "r";
// Must be greater than the longest line (in characters) to be found in the CSV file (allowing for trailing line-end characters). Otherwise the line is split in chunks of length characters, unless the split would occur inside an enclosure.
const LENGTH = 0;
//path to csv file
private $file = null;
// ressource csv file
private $ressource = null;
// The optional delimiter parameter sets the field delimiter (one character only).
private $separator = null;
// The optional enclosure parameter sets the field enclosure character (one character only).
private $enclosure = null;
// The optional escape parameter sets the escape character (at most one character). An empty string ("") disables the proprietary escape mechanism.
private $escape = null;
//index
private $first_record = null;
//données sous forme de tableau associatif
private $data = null;
private static $instance = null;
private function __construct($separator, $enclosure, $escape){
if(!is_string($separator)) throw new Exception(sprintf('the separator (%s%s) must be string', __CLASS__, __METHOD__));
if(!is_string($enclosure)) throw new Exception(sprintf('the enclosure (%s%s) must be string', __CLASS__, __METHOD__));
if(!is_string($escape)) throw new Exception(sprintf('the escape (%s%s) must be string', __CLASS__, __METHOD__));
$this->separator = $separator;
$this->enclosure = $enclosure;
$this->escape = $escape;
}
public static function initialize($separator = ",", $enclosure = '"', $escape = "\\"){
if(is_null(self::$instance)) {
self::$instance = new CSVReader($separator, $enclosure, $escape);
}
return self::$instance;
}
public function set_file($value, $first_record = 0, $offset = null){
// if(!file_exists($value) || trim(strtolower(@end(explode('.', $value)))) !== 'csv')
// throw new Exception(sprintf("can't access or the value (%s) must be a csv file", $value));
if(!is_integer($first_record))
throw new Exception(sprintf("first record (%s) must be an integer", $first_record));
if(!is_integer($offset) && !is_null($offset))
throw new Exception(sprintf("offset (%s) must be an integer", $offset));
$this->file = $value;
$this->get_data($first_record, $offset);
return $this;
}
public function set_separator($value){
if(!is_string($value))
throw new Exception(sprintf('this attribute (%s) must be string (%s)', 'separator', $value));
$this->separator = $value;
return $this;
}
public function set_enclosure($value){
if(!is_string($value))
throw new Exception(sprintf('this attribute (%s) must be string (%s)', 'enclosure', $value));
$this->enclosure = $value;
return $this;
}
public function set_escape($value){
if(!is_string($value))
throw new Exception(sprintf('this attribute (%s) must be string (%s)', 'escape', $value));
$this->escape = $value;
return $this;
}
public function __get($attribute){
switch ($attribute) {
case 'fields':
case 'data':
return $this->$attribute;
default:
throw new Exception(sprintf("this attribute (%s) doesn't exist or you can't access it", $attribute));
break;
}
}
private function get_data($first_record, $offset){
$raw_data = $this->get_raw_data();
if(empty($raw_data)){
throw new Exception(sprintf("can't get data from file %s", $this->file));
}
$fields = array_shift($raw_data);
$this->set_fields($fields);
$slugifyFields = $this->slugify($this->fields);
$data = [];
for($index = 0, $len = count($raw_data); $index < $len; $index++){
if($row = @array_combine($slugifyFields, $raw_data[$index])){
$data[] = json_decode (json_encode($row), false);
}else{
throw new Exception(sprintf("integrity of row is not correct : %s", $index));
}
}
if(!fclose($this->ressource)){
throw new Exception(sprintf("can't close the file %s", $this->file));
}
$this->data = array_slice($data, $first_record, !is_null($offset)? $offset : count($data));
return $this;
}
private function get_raw_data(){
$records = [];
if(!($this->ressource = fopen($this->file,self::OPEN_FILE_MODE))){
throw new Exception(sprintf("can't open file %s", $this->file));
}
while($row = fgetcsv($this->ressource,self::LENGTH,$this->separator, $this->enclosure, $this->escape)){
$records[] = $row;
}
return $records;
}
private function set_fields($array){
$this->fields = $array;
}
private function slugify($array){
return array_map(function($item){
return strtolower(Utilities::slug($item));
}, $array);
}
}
<?php
class Utilities {
/**
* Returns a string with all spaces converted to underscores (by default), accented
* characters converted to non-accented characters, and non word characters removed.
*
* @param string $string the string you want to slug
* @param string $replacement will replace keys in map
* @return string
*/
public static function slug($string, $replacement = '_') {
$oldLocale = setlocale(LC_ALL, '0');
setlocale(LC_ALL, 'en_US.UTF-8');
$clean = iconv('UTF-8', 'ASCII//TRANSLIT', $string);
$clean = preg_replace("/[^a-zA-Z0-9\/_|+ -]/", '', $clean);
$clean = strtolower($clean);
$clean = preg_replace("/[\/_|+ -]+/", $replacement, $clean);
$clean = trim($clean, $replacement);
setlocale(LC_ALL, $oldLocale);
return $clean;
}
public static function array_map_recursive($callback, $array) {
foreach ($array as $key => $value) {
if (is_array($array[$key])) {
$array[$key] = Utilities::array_map_recursive($callback, $array[$key]);
}else {
$array[$key] = call_user_func($callback, $array[$key]);
}
}
return $array;
}
}
Comment ça fonctionne ? (les méthodes set_separator, set_escape, set_enclosure sont optionnels puisque je mets des valeurs par défaut au constructeur)
fichier source :
"prénom";"nom";"âge"
"Denise";"Michu";18
"Gontrand";"Michu";22
$csv_reader = CSVReader::initialize(); //Singleton
$path_source = "./source.csv";
$table = $csv_reader->set_separator(";")->set_file($path_source); //lire la signature de cette méthode
echo '<pre>';
print_r($table->fields);
echo '</pre>';
echo '<pre>';
print_r($table->data);
echo '</pre>';
Modifié par niuxe (24 Jan 2020 - 02:44)