PHP Classes

PHP Convert Array to JSON, CSV or XML: Generate files in JSON, CSV and XML from arrays

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2024-01-11 (7 months ago) RSS 2.0 feedNot yet rated by the usersTotal: 108 All time: 9,668 This week: 55Up
Version License PHP version Categories
php_escrever_csv_xml 1.0.0GNU General Publi...5PHP 5, Files and Folders, Conversion, D...
Description 

Author

Marcelo Telles

This package can generate JSON, CSV, and XML files from arrays.

It provides an example script that defines an array with two dimensions with data to be converted.

The script uses PHP functions and classes to convert the data to CSV, JSON, and XML and stores the converted data in files.

Picture of Marcelo Telles
  Performance   Level  
Name: Marcelo Telles <contact>
Classes: 5 packages by
Country: Brazil Brazil

Level 1 Star

 Innovation award
Innovation award
Nominee: 2x

Example

<?php
//CSV
//fonte: https://www.php.net/manual/pt_BR/function.fputcsv.php
//criando o conjunto de valores a ser gravado
$lista = array (
    array('Nome', 'Telefone', 'Endereço'),
    array('Pessoa1', '456', 'Rua XXX'),
    array('Pessoa2', '789', 'Rua yyy')
);
//definindo o nome do arquivo e abrindo o mesmo para escrita (write)
$fp = fopen("contatos.csv", 'w');
//percorrendo o conjunto de valores e gravando no arquivo
foreach ($lista as $linha) {
    fputcsv($fp, $linha,";");
}
//fechando o arquivo
fclose($fp);

//XML
//fonte
//https://pt.stackoverflow.com/questions/99967/como-gerar-um-arquivo-xml-%C3%A0-partir-de-um-formul%C3%A1rio-em-php
//definindo a versao do encoding xml
$dom = new DOMDocument("1.0", "UTF-8");
//retirando os espacos em branco
$dom->preserveWhiteSpace = false;
//gerarando o codigo
$dom->formatOutput = true;
//criando o nó principal (root)
$root = $dom->createElement("agenda");

$lin=0;
foreach ($lista as $linha) {
    if ($lin>0){
        //nó filho (contato)
        $contato = $dom->createElement("contato");
        //setanto nomes e atributos dos elementos xml (nós)
        $nome = $dom->createElement($lista[0][0], $linha[0]);
        $telefone = $dom->createElement($lista[0][1], $linha[1]);
        $endereco = $dom->createElement($lista[0][2], $linha[2]);
        //adiciona os nós (informacaoes do contato) em contato
        $contato->appendChild($nome);
        $contato->appendChild($telefone);
        $contato->appendChild($endereco);
        $root->appendChild($contato);
        //adiciona o nó contato em (root) agenda
        $dom->appendChild($root);
    }
    $lin++;
}
// salvando o arquivo
$dom->save("contatos.xml");

//JSON
//https://blog-en.openalfa.com/how-to-read-and-write-json-files-in-php
//https://stackoverflow.com/questions/3281354/create-json-object-the-correct-way
//criando o array que vai conter os dados dos contatos
$json = array();
$lin=0;
foreach ($lista as $linha) {
    if ($lin==0){
        $key = $linha;
    }else{
        $json[] = array_combine($key, $linha);
    }
    $lin++;
}
//criando o conjunto de contatos
$contatos = array ('conato' => $json);
//alocando os contatos no array agenda
$agenda = array('agenda' => $contatos);
//definido o arquivo resultante
$fh = fopen("contatos.json", 'w');
//salvando o arquivo
fwrite($fh, json_encode($agenda,JSON_UNESCAPED_UNICODE));
//fechando o arquivo
fclose($fh);

//conversão online
//http://www.utilities-online.info/xmltojson
//validação online JSON
//https://jsonlint.com/

?>

Details

php_escrever_csv_xml_json

Criação de arquivos CSV, XML e JSON Este é um exemplo básico, para testar, basta colocar o gerar.php no root e abrir no navegador. Ao abrir no navegador serão criados 3 arquivos na mesma pasta do gerar.php. O conteúdo dos 3 arquivos é o conteudo do array criado no PHP


  Files folder image Files (2)  
File Role Description
Accessible without login Plain text file gerar.php Example Example script
Accessible without login Plain text file README.md Doc. Documentation

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadphp_escrever_csv_xml-2024-01-11.zip 1KB
Downloadphp_escrever_csv_xml-2024-01-11.tar.gz 1KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:108
This week:0
All time:9,668
This week:55Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.