use Raw2Sql\Raw2Sql; $rawData = "John, Doe, 35, New York" . PHP_EOL . "Jane, Smith, 28, Chicago"; // raw data in plaintext format $sql = Raw2Sql::createTable('users', ['first_name', 'last_name', 'age', 'city'], ',', "\r\n"); // create table SQL statement $sql .= Raw2Sql::insertData('users', $rawData, ',', "\r\n"); // insert data SQL statement echo $sql;
use Raw2Sql\Raw2Sql; $csvFile = 'users.csv'; // path of the CSV file $sql = Raw2Sql::createTableFromCsv($csvFile, 'users'); // create table SQL statement $sql .= Raw2Sql::insertDataFromCsv($csvFile, 'users'); // insert data SQL statement echo $sql;In this example, we use the `createTableFromCsv()` method to generate an SQL statement to create a `users` table from the CSV file with the same name. Then, we use the `insertDataFromCsv()` method to generate SQL statements to insert the CSV data into the `users` table.