{"@attributes":{"version":"2.0"},"channel":{"title":"DEV Community: John Samuel Obinna","description":"The latest articles on DEV Community by John Samuel Obinna (@johnsamuelob).","link":"https:\/\/dev.to\/johnsamuelob","image":{"url":"https:\/\/media2.dev.to\/dynamic\/image\/width=90,height=90,fit=cover,gravity=auto,format=auto\/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F19967%2F6adae334-3e74-491a-acd7-afa2abd8d23b.jpg","title":"DEV Community: John Samuel Obinna","link":"https:\/\/dev.to\/johnsamuelob"},"language":"en","item":[{"title":"How to Export Database Records to Excel using PHP(Laravel)","pubDate":"Wed, 07 Jul 2021 12:20:58 +0000","link":"https:\/\/dev.to\/johnsamuelob\/how-to-export-database-records-to-excel-using-php-laravel-1g30","guid":"https:\/\/dev.to\/johnsamuelob\/how-to-export-database-records-to-excel-using-php-laravel-1g30","description":"

Have you encountered a challenge where you need to export records from the database to excel using Laravel?<\/p>\n\n

We will be using Maatwebsite<\/a> Laravel package <\/p>\n\n

\n \n \n Installation\n<\/h2>\n\n

First require the Maatwebsite laravel package in your composer.json<\/code>
\n<\/p>\n\n

\n
composer require maatwebsite\/excel\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
The Maatwebsite\\Excel\\ExcelServiceProvider<\/code> is registered by default. But you can manually register the ServiceProvider in your config\/app.php<\/code>
\n<\/p>\n\n
\n
'providers' => [\n    \/*\n     * Service Providers...\n     *\/\n    Maatwebsite\\Excel\\ExcelServiceProvider::class,\n]\n\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
The Excel Facade is discovered and registered by default. But you can add it manually to your config\/app.php<\/code>
\n<\/p>\n\n
\n
'aliases' => [\n    ....\n    'Excel' => Maatwebsite\\Excel\\Facades\\Excel::class,\n]\n\n\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
Publish config by running the vendor command<\/p>\n\n
php artisan vendor:publish --provider=\"Maatwebsite\\Excel\\ExcelServiceProvider\" --tag=config<\/code><\/p>\n\n
This will create a new config file named config\/excel.php.<\/code> and your setup is completed.<\/p>\n\n
\n  \n  \n  Exporting\n<\/h2>\n\n
On our already seeded database, we will be exporting those records to an excel file.Checkout how to seed in laravel<\/a> First we create a controller using:
\n<\/p>\n\n
\n
 php artisan make:controller ExportToExcelController\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
then we create an export class in the app\\Export<\/code> using the:
\n<\/p>\n\n
\n
php artisan make:export UsersExport --model=User\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
the UsersExport<\/code> is the Export class while the flag --model=User<\/code> is referencing the model class in use.<\/p>\n\n
The result of the command php artisan make:export UsersExport --model=User<\/code>:
\n<\/p>\n\n
\n
\n<?php\n\nnamespace App\\Exports;\n\nuse App\\Models\\User;\nuse Maatwebsite\\Excel\\Concerns\\FromCollection;\n\nclass UsersExport implements FromCollection\n{\n    public function collection()\n    {\n        return User::all();\n    }\n}\n\n\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
Head over to your ExportToExcelController<\/code> you can export records
\n<\/p>\n\n
\n
\n<?php\n\nnamespace App\\Http\\Controllers;\n\nuse App\\Exports\\UsersExport;\nuse Maatwebsite\\Excel\\Facades\\Excel;\n\nclass ExportToExcelController extends Controller \n{\n    public function ExportRecords() \n    {\n        return Excel::download(new UsersExport, 'users.xlsx');\n    }\n}\n\n\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
Ooh one more thing, add a route to be able to access ExportRecords:
\n<\/p>\n\n
\n
Route::get('data\/export\/', 'ExportToExcelController@ExportRecords');\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
Thats IT!<\/strong> \ud83d\ude0e<\/p>\n\n","category":["laravel","php"]},{"title":"When should I call myself a software Engineer","pubDate":"Sat, 06 Apr 2019 08:06:39 +0000","link":"https:\/\/dev.to\/johnsamuelob\/when-should-i-call-myself-a-software-engineer-4cei","guid":"https:\/\/dev.to\/johnsamuelob\/when-should-i-call-myself-a-software-engineer-4cei","description":{},"category":"discuss"},{"title":"Asynchronous JavaScript for Newbies","pubDate":"Thu, 26 Apr 2018 09:57:17 +0000","link":"https:\/\/dev.to\/johnsamuelob\/asynchronous-javascript-for-newbies-k61","guid":"https:\/\/dev.to\/johnsamuelob\/asynchronous-javascript-for-newbies-k61","description":"
When writing JavaScript we frequently deal with Asynchronous  code which can be confusing for us as newbies. Before we jump into Asynchronous JavaScript lets talk a little about Synchronous Code.<\/p>\n\n
\n  \n  \n  What is Synchronous Code?\n<\/h2>\n\n
Synchronous Code runs on a single thread. 1 Action is completed before moving to the  next.
\n<\/p>\n\n
\n
 thread<\/span> -<\/span>\n          |<\/span>\n          V<\/span>    \n          Start<\/span>|<\/span>Line1<\/span><---------<\/span>A<\/span>--------->|<\/span>Finish<\/span>\n          Start<\/span>|<\/span>Line2<\/span><---------<\/span>B<\/span>--------->|<\/span>Finish<\/span>\n          Start<\/span>|<\/span>Line3<\/span><---------<\/span>C<\/span>--------->|<\/span>Finish<\/span>\n\n\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
\n  \n  \n  Asynchronous Code\n<\/h2>\n\n
Unlike Synchronous code, asynchronous code runs now and finishes later.
\nFrom the illustration below, as you can see, the fn2 line was not finished but was completed after fn6 has been executed.
\n<\/p>\n\n
\n
 thread<\/span> -<\/span>                                                Separate<\/span> thread<\/span> outside<\/span> you<\/span> code<\/span>.<\/span>\n          |<\/span>                                             \/<\/span>\n<\/span>          V<\/span>                                            \/<\/span>\n          Start<\/span>|<\/span>fn1<\/span><--------<\/span>A<\/span>---------->|<\/span>Finish<\/span>       \/<\/span>\n          Start<\/span>|<\/span>fn2<\/span><--------<\/span>B<\/span>-----------|-------------|<\/span>\n          Start<\/span>|<\/span>fn3<\/span><--------<\/span>C<\/span>---------->|<\/span>Finish<\/span>       |<\/span>\n          Start<\/span>|<\/span>fn4<\/span><--------<\/span>D<\/span>---------->|<\/span>Finish<\/span>       V<\/span> \n          Start<\/span>|<\/span>fn5<\/span><--------<\/span>E<\/span>---------->|<\/span>Finish<\/span>       |<\/span> \n          Start<\/span>|<\/span>fn6<\/span><--------<\/span>F<\/span>---------->|<\/span>Finish<\/span>       V<\/span>  \n      Callback<\/span> |<\/span>fn2<\/span><--------<\/span>B<\/span>---------->|<------------|<\/span>                                               \n\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
Note that JavaScript is single-threaded, only to code you write but Requests made from your code are handed over to a separate thread. Let's say an Api call for example. Hold it, i know what you are thinking; What's a 'Callback'? Don't worry next we're going to discuss 'Callback'.<\/p>\n\n
\n  \n  \n  What is a Callback?\n<\/h2>\n\n
A callback is a function passed into another function as an argument, which is then invoked inside the out function to complete some kind of action.
\n<\/p>\n\n
\n
\nfunction<\/span> Callback<\/span>(){<\/span>\n alert<\/span>(<\/span>\"<\/span>You called Me<\/span>\"<\/span>);<\/span>\n}<\/span>\n\nsetTimeout<\/span>(<\/span>callback<\/span>,<\/span>300<\/span>);<\/span>\n\n\/\/ You called Me<\/span>\n\n\n<\/code><\/pre>\n\n<\/div>\n\n\n\n
This is a Synchronous callback, next we're going to talk about <\/p>\n\n
\n  \n  \n  -Asynchronous callback.\n<\/h5>\n\n
\n  \n  \n  -Callback Hell.\n<\/h5>\n\n
\n  \n  \n  -Ajax Requests.\n<\/h5>\n\n
\n  \n  \n  -Promises.\n<\/h5>\n\n
\n  \n  \n  -Generators.\n<\/h5>\n\n","category":["asynchronouscode","javascript","codenewbie","juniordevs"]},{"title":"What you need to know as a junior Developer.","pubDate":"Tue, 24 Apr 2018 11:48:12 +0000","link":"https:\/\/dev.to\/adroitcoder\/what-you-need-to-know-as-a-junior-developer-3an4","guid":"https:\/\/dev.to\/adroitcoder\/what-you-need-to-know-as-a-junior-developer-3an4","description":"
\"code\"<\/a><\/p>\n\n
Also Posted at codementor<\/a><\/em><\/p>\n\n
Every newbie wants to build something cool but the urge to get it done quickly  sometimes lead to skipping procedures which can lead to  holes.
\nAm going to keep it short and simple, below are 5 key points to do and avoid as a newbie developer.<\/p>\n\n
\n  \n  \n  1. Accept you are a Junior Developer.\n<\/h2>\n\n
Accepting to be a junior developer puts you on a track of procedures, which actually lead to proper learning and consistency.<\/p>\n\n
\n  \n  \n  2.Understand, don\u2019t imitate.\n<\/h2>\n\n
Imitating is an enemy of creativity and innovation. Sometime we feel the need to imitate someone but understanding should be place first.<\/p>\n\n
\n  \n  \n  3.Give yourself time to Master.\n<\/h2>\n\n
The brain is just a house with bricks laid on bricks; Giving yourself time to grow is an essential skill to attach to development skill. Remember it\u2019s not a race.<\/p>\n\n
\n  \n  \n  4.Don\u2019t follow Social media trends.\n<\/h2>\n\n
Not everyone will agree with me on this but getting rid of this behavior was one of the best things that has happened to me. I know we all want to join the team of those cool developers using one trending language or frameworks, but lack of proper understanding of the foundation will lead to bad or poor usage of those tools. Just give yourself time to understand the basics first.<\/p>\n\n
\n  \n  \n  5.Never Stop!\n<\/h2>\n\n
No one  was born with code brain or some magic powers. Every guru and serious developer out there got to the top with constant practices and learning. Coding is not difficult, but your patient and passion for it will be tested. <\/p>\n\n","category":["juniordeveloper","code","newbie"]},{"title":"Includes() vs indexOf() in JavaScript ","pubDate":"Mon, 04 Sep 2017 06:40:28 +0000","link":"https:\/\/dev.to\/adroitcoder\/includes-vs-indexof-in-javascript","guid":"https:\/\/dev.to\/adroitcoder\/includes-vs-indexof-in-javascript","description":"\n\n
ES2016 Specifications included the\u00c2  includes()<\/code> method\u00c2  for\u00c2  Array data structure.\u00c2 The includes()<\/code> method check if an array includes a certain element, returning true<\/code> or false<\/code> as appropriate.
\nBut in ES5 we are used to performing operations like this with indexOf()<\/code> method.<\/p>\n\n
Using includes()<\/code> method.<\/p>\n\n\n\n
const<\/span> array<\/span> =<\/span> [<\/span>1<\/span>,<\/span>2<\/span>,<\/span>3<\/span>,<\/span>4<\/span>,<\/span>5<\/span>,<\/span>6<\/span>];<\/span>\n\nif<\/span>(<\/span>array<\/span>.<\/span>includes<\/span>(<\/span>4<\/span>)<\/span> ){<\/span>\nconsole<\/span>.<\/span>log<\/span>(<\/span>\"true 4 was found in the array\"<\/span>)<\/span>\/\/ true 4 was found in the array<\/span>\n}<\/span> \n<\/code><\/pre><\/div>\n\n\n\n
Let's perform the same operation with indexOf()<\/code> method.<\/p>\n\n\n\n
const<\/span> array<\/span> =<\/span> [<\/span>1<\/span>,<\/span>2<\/span>,<\/span>3<\/span>,<\/span>4<\/span>,<\/span>5<\/span>,<\/span>6<\/span>];<\/span>\n\nif<\/span>(<\/span>array<\/span>.<\/span>indexOf<\/span>(<\/span>4<\/span>)<\/span> ><\/span> -<\/span>1<\/span> ){<\/span>\nconsole<\/span>.<\/span>log<\/span>(<\/span>\"true 4 was found in the array\"<\/span>)<\/span>\/\/ true 4 was found in the array<\/span>\n}<\/span>\n<\/code><\/pre><\/div>\n\n\n\n
Using includes()<\/code> method to check for NaN<\/code> <\/p>\n\n\n\n
\u00c2<\/span> const<\/span>\u00c2<\/span>  array<\/span> =<\/span> [<\/span>NaN<\/span>];<\/span>\n\nif<\/span> (<\/span>array<\/span>.<\/span>includes<\/span>(<\/span>NaN<\/span>)){<\/span>\nconsole<\/span>.<\/span>log<\/span>(<\/span>\"true. NAN was found in the array\"<\/span>);<\/span>\/\/ true. NAN was found in the array<\/span>\n}<\/span>\n<\/code><\/pre><\/div>\n\n\n\n
This is where things begin to fall apart with indexOf()<\/code> method.<\/p>\n\n\n\n
const<\/span>  array<\/span> =<\/span> [<\/span>NaN<\/span>];<\/span>\nif<\/span> (<\/span>array<\/span>.<\/span>indexOf<\/span>(<\/span>NaN<\/span>)<\/span> ==<\/span> -<\/span>1<\/span>){<\/span>\n    console<\/span>.<\/span>log<\/span>(<\/span>\"NaN not found in the array\"<\/span>);<\/span>\/\/NaN not found in the array<\/span>\n}<\/span>\n\n<\/code><\/pre><\/div>\n\n\n\n
Checking for undefined<\/code> with the includes()<\/code> method.<\/p>\n\n\n\n
const<\/span> array<\/span> =<\/span> [,<\/span> ,<\/span> ,<\/span> ,];<\/span>\n\nif<\/span>(<\/span>array<\/span>.<\/span>includes<\/span>(<\/span>undefined<\/span>)){<\/span>\nconsole<\/span>.<\/span>log<\/span>(<\/span>\"true array elements are undefined\"<\/span>);<\/span>\/\/ true array elements are undefined<\/span>\n}<\/span> \n<\/code><\/pre><\/div>\n\n\n\n
Let's see how indexOf()<\/code> method will handle this operation.<\/p>\n\n\n\n
const<\/span> array<\/span> =<\/span> [,<\/span> ,<\/span> ,<\/span> ,];<\/span>\n\nif<\/span>(<\/span>!<\/span>array<\/span>.<\/span>indexOf<\/span>(<\/span>undefined<\/span>)<\/span> ==<\/span> -<\/span>1<\/span> ){<\/span>\nconsole<\/span>.<\/span>log<\/span>(<\/span>\"true. array elements are undefined\"<\/span>);<\/span>\n}<\/span>else<\/span> {<\/span>\nconsole<\/span>.<\/span>log<\/span>(<\/span>\"Sorry can't find undefined\"<\/span>);<\/span>\/\/ Sorry can't find undefined<\/span>\n}<\/span>\n<\/code><\/pre><\/div>\n\n\n\n
The includes()<\/code> method\u00c2  does not distinguish between -0 and +0<\/p>\n\n\n\n
const<\/span> a<\/span> =<\/span> [<\/span>-<\/span>0<\/span>].<\/span>includes<\/span>(<\/span>+<\/span>0<\/span>);<\/span>\nconsole<\/span>.<\/span>log<\/span>(<\/span>a<\/span>);<\/span>\/\/true<\/span>\n<\/code><\/pre><\/div>\n\n\n\n
Typed Arrays will also have a method includes()<\/code><\/p>\n\n\n\n
let<\/span> array<\/span> =<\/span> Uint8Array<\/span>.<\/span>of<\/span>(<\/span>2<\/span>,<\/span>6<\/span>,<\/span>4<\/span>);<\/span>\nconsole<\/span>.<\/span>log<\/span>(<\/span>array<\/span>.<\/span>includes<\/span>(<\/span>4<\/span>));<\/span>\/\/true<\/span>\n<\/code><\/pre><\/div>\n\n\n\n
\n  \n  \n  Summary\n<\/h3>\n\n