Jul 25

How do I import CSV file into a MySQL table? (Laravel — Source code available)

Take it Easy! GitHub - lokeshrangani/importCsv: Read csv file and import in database Read csv file and import in database. Contribute to lokeshrangani/importCsv development by creating an account on…github.com Postman collection is there you can directly import and boom.. I’m assuming that you have basic understanding of Laravel! :) Let’s break the problem: first of all we need to create table according to csv columns.

Laravel

1 min read

How do I import CSV file into a MySQL table? (Laravel — Source code available)

Take it Easy!

GitHub - lokeshrangani/importCsv: Read csv file and import in databaseRead csv file and import in database. Contribute to lokeshrangani/importCsv development by creating an account on…
github.com

Postman collection is there you can directly import and boom..

I’m assuming that you have basic understanding of Laravel! :)

Let’s break the problem:

first of all we need to create table according to csv columns.
after that we can insert by reading csv file.

To Create table : /api/create-table*

Look At : https://github.com/lokeshrangani/importCsv/blob/master/app/Http/Controllers/TableController.php#L11

To Import run : /api/import*

It will upload csv file to public/uploads

Result :

Feel free to ask question.

You can find request : https://github.com/lokeshrangani/importCsv/blob/master/Import%20csv.postman_collection.json

Jul 20

Mini-Max Sum (JavaScript)

Take it Easy! — Find Sum of all possible pair where i != j and put into sum_array find min and max element of sum_array which is eventually out answer Please See code below: function miniMaxSum(arr) { var min=0,max=0,sum_array=[]; for (var i = 0; i < arr.length; i++) { var sum = 0; for (var j = 0; j < arr.length; j++) { if ( i != j ) { sum += arr[j]; } } sum_array[i] = sum; } min = sum_array[1],max=sum_array[1]; for (var i = 0; i < sum_array.length; i++) { if(sum_array[i] > max) { max = sum_array[i]; } if(sum_array[i] < max && sum_array[i] < min) { min = sum_array[i]; } } process.stdout.write(min + “ “ +max); }

Hackerrank Solution

1 min read

Mini-Max Sum (JavaScript)

Take it Easy!

Find Sum of all possible pair where i != j and put into sum_array
find min and max element of sum_array which is eventually out answer
Please See code below:

function miniMaxSum(arr) {
var min=0,max=0,sum_array=[];
for (var i = 0; i < arr.length; i++) {
var sum = 0;
for (var j = 0; j < arr.length; j++) {
if ( i != j ) {
sum += arr[j];
}
}
sum_array[i] = sum;
}

min = sum_array[1],max=sum_array[1];
for (var i = 0; i < sum_array.length; i++) {
if(sum_array[i] > max) {
max = sum_array[i];
}
if(sum_array[i] < max && sum_array[i] < min) {
min = sum_array[i];
}
}

process.stdout.write(min + “ “ +max);
}

Jun 30

How to Build an Authentication API with JWT Token in Node.js

Take it Easy! Authentication Vs Authorization Authentication : Who a user is. Authorization : Verifying what user have access to. Why JWT ? In short, JWTs are used as a secure way to authenticate users and share information. Assuming that you’ve created node project. Install other dependency. npm install mongoose…

Nodejs

1 min read