merterciyescagan/uni-parser

The package parses CSV, JSON, XLSX, or XML files and generates CREATE TABLE and INSERT INTO SQL statements.

Maintainers

Details

github.com/erciyescagan/uni-parser

Source

Issues

Installs: 10

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 1

Forks: 0

Open Issues: 0

v1.0.3 2025-02-28 16:41 UTC

Requires

Requires (Dev)

MIT cddca8a002574796a9e6a85a920657a6e6edded4

  • erciyescagan <erciyescagan.woop@gmail.com>

This package is auto-updated.

Last update: 2025-04-28 17:03:52 UTC

README

UniParser is a PHP package that simplifies database integration by automatically parsing CSV, JSON, XLSX, and XML files and generating CREATE TABLE and INSERT INTO SQL statements.

Features

  • Multi-Format Support: Easily parse CSV, JSON, XLSX, and XML files.
  • Automatic SQL Generation: Generate SQL queries for table creation and data insertion.
  • Flexible Usage: Retrieve data as an array or generate SQL strings for MySQL integration.
  • Secure & Fast: Designed with security in mind and optimized for performance.

Installation

You can install UniParser via Composer:

composer require merterciyescagan/uniparser
require 'vendor/autoload.php';

use Merterciyescagan\UniParser\File;

// Replace 'path/to/your/file.csv' with the actual path to your data file.
$file = new File('path/to/your/file.csv');

// Parse the file to get data as an array
$data = $file->read();

// Generate a CREATE TABLE SQL statement
$sqlCreate = $file->generateTableString();
echo $sqlCreate;

// Generate an INSERT INTO SQL statement for the parsed data
$sqlInsert = $file->generateBatchImportString($data);
echo $sqlInsert;

Contributing

Contributions are welcome! If you have ideas, improvements, or bug fixes, feel free to open an issue or submit a pull request.

License

UniParser is open-sourced software licensed under the MIT License.