MubinSayed

<?php 
// this script would save csv file to this specified directory
// APPPATH is location of application folder in Codeigniter
$file = fopen(APPPATH . '/../upload/'.'tesaasasat.csv', 'wb');
 
// set the column headers
fputcsv($file, array('Column 1', 'Column 2', 'Column 3', 'Column 4', 'Column 5'));
 
// Sample data. This can be fetched from mysql too
$data = array(

MubinSayed

<?php
// routes/console.php

// quickly create an user via the command line
Artisan::command('user:create', function () {
    $name = $this->ask('Name?');
    $email = $this->ask('Email?');
    $pwd = $this->ask('Password?');
    // $pwd = $this->secret('Password?'); // or use secret() to hide the password being inputted
    \DB::table('users')->insert([

MubinSayed

{
    "states": [
        {
            "id": "1",
            "type": "Union Territory",
            "capital": "Mayabunder",
            "code": "AN",
            "name": "Andaman and Nicobar Islands",
            "districts": [
                {

MubinSayed

<?php

// -- Only one caveat : The results must be ordered so that an item's parent will be processed first.

// -- Simulate a DB result
$results = array();
$results[] = array('id' => 'a', 'parent' => '',  'name' => 'Johnny');
$results[] = array('id' => 'b', 'parent' => 'a', 'name' => 'Bobby');
$results[] = array('id' => 'c', 'parent' => 'b', 'name' => 'Marky');
$results[] = array('id' => 'd', 'parent' => 'a', 'name' => 'Ricky');