Laravel Seeder Generator KISS

generator.php

<?php
/*
 * Your settings here
 */

define('DB_DSN', 'mysql:host=localhost;dbname=mydb;charset=UTF8');
define('DB_USER', 'myuser');
define('DB_PASS', 'mypass');
define('DB_TABLE', 'mytable');
define('DB_OPTIONS', [
    PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',
]);

require('helper.php');

/*
 * Script starts here
 */

try {
    $db = new PDO(DB_DSN, DB_USER, DB_PASS, DB_OPTIONS);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}

catch (PDOException $e) {
    exit('PDO: ' . $e->getMessage());
}

$sth = $db->prepare(sprintf('SELECT * FROM %s', DB_TABLE));
$sth->execute();

foreach($sth->fetchAll() as $row) {
    // Modify this to your own needs
    $slug  = str_slug($row['title']);
    $title = addslashes($row['title']);

    echo '[' . PHP_EOL;
    echo "\t'id'   => {$row['id']}," . PHP_EOL;
    echo "\t'name' => '{$title}'," . PHP_EOL;
    echo "\t'slug' => '{$slug}'," . PHP_EOL;
    echo '],' . PHP_EOL . PHP_EOL;
}

helper.php

<?php
// Copy contents from https://github.com/rappasoft/laravel-helpers or include your own

$ php generator.php > seeds

/**
 * Run the database seeds.
 *
 * @return void
 */
public function run()
{
    DB::table('import-table')->insert([
        // generator contents
    ]);
}