composer create-project laravel/laravel exportImport file 

Step 2 : Install Laravel Excel

composer require maatwebsite/excel 

Steps 3 : Publish the Config File

php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider"

This creates a config/excel.php file.

Step 4 : Export Data

php artisan make:export UsersExport --model=User

Define UsersExport.php

namespace App\Exports;

use App\Models\User;
use Maatwebsite\Excel\Concerns\FromCollection;

class UsersExport implements FromCollection
{
    public function collection()
    {
        return User::all();
    }
}

Add Route and Controller :

Route (web.php):

Route::get('/export-users', [UserController::class, 'export']);

Controller Method:

use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;

public function export()
{
    return Excel::download(new UsersExport, 'users.xlsx');
}

Import Data :

Create an Import Class :

php artisan make:import UsersImport --model=User

Define UsersImport.php

namespace App\Imports;

use App\Models\User;
use Maatwebsite\Excel\Concerns\ToModel;

class UsersImport implements ToModel
{
    public function model(array $row)
    {
        return new User([
            'name' => $row[0],
            'email' => $row[1],
            'password' => bcrypt($row[2]),
        ]);
    }
}

Upload & Import File from Controller :

Route (web.php):

Route::post('/import-users', [UserController::class, 'import']);

Controller Method:

use App\Imports\UsersImport;
use Maatwebsite\Excel\Facades\Excel;

public function import(Request $request)
{
    $request->validate([
        'file' => 'required|mimes:xlsx,csv',
    ]);

    Excel::import(new UsersImport, $request->file('file'));

    return redirect()->back()->with('success', 'Users imported successfully.');
}

Blade Form for Import :

<form action="{{ url('/import-users') }}" method="POST" enctype="multipart/form-data">
    @csrf
    <input type="file" name="file" required>
    <button type="submit">Import Users</button>
</form>

I wanted to do lots of thing but not able to do ,may ne I am confused or way of doing thing is not right .

Wants to start my own IT software company in mumbai but so much confusion and lack of understanding ,confused….

I know what things will be

Practice….Practice…. Practice..

U wanted to learn many things at same time but forget very a

composer create-project laravel/laravel:^8.0 demoProject

Step 2 : Create database and connect with database in .env file

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=blog 
DB_USERNAME=root
DB_PASSWORD=

here DB_DATABASE name is blog and DB_USERNAME is root and DB_PASSWORD is empty .

Step 3 : Create controller in laravel with resource .

php artisan make:cotroller UserController --resource 

step 4 : Create route in laravel which is you have to create in route folder and there api.php

use App\Http\Controllers\UserController;


Route::apiResources([UserController::class]);

Step 5 : Create Model in laravel .

php artisan make:model User

Step 6 : write code for api in laravel

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;

class HomeController extends Controller
{
    
    public function index()
    {
       $user = DB::table('user')->get();
       return $user;       
    }

    public function create()
    {
        //
    }

    public function store(Request $request)
    {
        $users  = DB::table('user')->insert(
            [
            "user_name" => $request->user_name, 
             "user_password" => $request->user_password,
             "user_email" => $request->user_email,
             "user_profile" => $request->user_profile
           ]);

           if($users){
            return response()->json(['result' => 'Data inserted Successfully' ]);
           }else{
            return response()->json(['result' => 'Data not inserted...' ]);
           }
    }

    public function show($id)
    {
        //
    }
  
    public function edit($id)
    {
        //
    }
  
    public function update(Request $request)
    {

        $id = $request->id;

        $users = DB::table('user')->where('id',$id)->update([
            "user_name" => $request->user_name, 
            "user_password" => $request->user_password,
            "user_email" => $request->user_email,
            "user_profile" => $request->user_profile,
       ]);

        if($users){
            return response()->json(['result' => 'Data updated Successfully' ]);
        }else{
            return response()->json(['result' => 'Data not updated...' ]);
        }
        
    }

  
    public function destroy($id)
    {
        
    }
}

if content useful for you follow my instgram elonifycoder

Q.1 :write a program “HELLO WORLD ” in javascript ?

<html>
<head>
    <title>javascript example </title>
    <script>
    //here 3 way we can print "hello world"
           alert("Hello World");
           console.log("Hello world ");
           document.write("Hello world")

    </script>
</head>
<body>
      
</body>
</html>

Q.2 JS program to add two Number

Note : here we will see two ways to add two numbers

1. static program

2 . dynamic program

<html>
<head>
    <title>javascript example </title>
    <script>
   
    //static ways to get data 
         let a = 5;
         let b = 6;
         var c = a+b;
       console.log("the sum of "+ a+" and "+b +"is : "+c);

  //Dynamic ways to get data 
       
     let a = prompt("Please Enter first Number");
     let b =prompt("Please enter your second number");
   
     let c = parseInt(a)+parseInt(b);

     console.log("the sum of"+ a +" and "+b+ " is : "+c);


    </script>
</head>
<body>
      
</body>
</html>

Q.3 WAP TO Square root of a number

Hint : Math.sqrt();Q.3 WAP TO Square root of a number

<html>
<head>
    <title>javascript example </title>
    <script>
          let a = 16;
           console.log(Math.sqrt(a)); // output 4

   //GET value from use 
     let a = prompt("Enter your value");
     console.log(parseInt(Math.sqrt(a)); 

    </script>
</head>
<body>
      
</body>
</html>

Q.4 Wap to CALCULATE THE AREA OF NUMBER

hint : there are two type of triangle 1. (base*hright)/2

second one is 3 sides of triangle .

<html>
<head>
    <title>javascript example </title>
    <script>
       let base = prompt("Enter your base value of triangle ");
       let Height = prompt("enter your height of triangle");

     let area = (base*height)/2 
     console.log(area) // output 
 
    </script>
</head>
<body>
      
</body>
</html>

by using herons formula to find area of triangle

<html>
    <head>
     <title></title>
     <script>
          let a = 20;
          let b =30;
          let c =40;
          let s = (a+b+c)/2;
          let temp = s(s-a)*(s-b)*(s-c);
   

         let area = math.sqrt(temp);
         console.log(area);

     </script>
    </head>
    <body></body>

</html>

Q.5 Swap to number using temporary variable and without temporary variable .

hite : 1 . swapping using temporary variable .

2. swapping without using temporary variable .

<html>

<head>
    <title>javascript example </title>
    <script>

    var a = prompt("please enter the a value");
    var b = prompt("please enter the b value ");
    console.log(`there value of a is: ${a} and value of b is ${b}`);

    </script>
</head>
<body>
      
</body>
</html>

without temp variable

suppose a =5 and b =6;

a = a+b= 5+6 =11

b =a-b = 11–6 = 5

a = a-b =11–5 = 6

<html>
<head>
    <title>javascript example </title>
    <script>

    var a = parseInt(prompt("please enter the a value"));
    var b = parseInt(prompt("please enter the b value "));
    console.log(`there value of a is: ${a} and value of b is ${b}`);

    a = a+b ;
    b=a-b ;
     a = a-b ;
     console.log(`after swapping number a is : ${a} and value of b is : ${b}`)

    </script>
</head>
<body>
      
</body>
</html>

Q. 6 Write a programin to kilometer to miles using javascript function

<html>
<head>
    <title>javascript example </title>
    <script>
      function convert(){
           let kms = document.getElemtById("data").value;
           const factor = 0.621371;
           var miles = kms * factor;
  
           document.getElementById('res').innerText = `${miles} miles`;
       }
       

    </script>
</head>
<body>
   <input type="number" name="" step="any" id="data"/>Kms
   <button onclick="convert()">convert</button>Miles

   <h1 id="res"></h1>
      
</body>
</html>

Q .7 Convert celsius to fahrenheit using javascript .

Hint :

fahrehit = celsius *1.8+32;

<html>
<head>
    <title>javascript example </title>
    <script>
      function convert(){
           let a = document.getElementById('data').value;
           let f = (a*1.8)+32;

           document.getElementById('res').innerText = `${c} c = ${f}f`;


       }

    </script>
</head>
<body>
   <input type="" name="" id="data" />
    <br/>
    <button onclick="convert()" >convert</button>
    <h1 id="res"></h1>
      
</body>
</html>

Q.8 write a progarm in js to check the given number is positive , negative or zero .

hint : Math.sign(x);

<html>
<head>
    <title>javascript example </title>
    <script>
      function check(){
           let data = document.getElementById('data').value;
          
           let res = Math.sign(value);
           let value ;
           if(res == 1){}else if(res == -1)
            OR
           IF(data>0){ 
          console.log("positive number "); 
           } else if(data < 0){ 
            console.log("negative value");
           }else if(value == 0 ){
             console.log("it is zero");
           }else{
             console.log("its not a number");
               }
 

           document.getElementById('res').innerText = res;

       }

    </script>
</head>
<body>
   <input type="" name="" id="data" />
    <br/>
    <button onclick="check()" >check</button>
    <h1 id="res"></h1>
      
</body>
</html>

Q .9 Javscropt program to generate a random number using Math.random() function .

<html>
<head>
    <title>javascript example </title>
    <script>
    let a = Math.random();
    console.log("Before Calculation "+x);
    x = x*(10000-1)+1;
    console.log("After calculation " +x);
    console.log("F1oor calculation"+Math.floor(x));

    </script>
</head>
<body>
 
      
</body>
</html>

Q.10 js program to check if number is odd or even .

Note :1. checking using if-else

2. checking using ternary operator

<html>
<head>
    <title>javascript example </title>
    <script>
      // var a=6;
       // if(x%2 == 0){
         //   console.log("even number");
       // }else {
       //  console.log("odd number");
       //}

       var res = x%2 == 0 ? " even ": " odd ";
  
       console.log(res);

    </script>
</head>
<body>
 
      
</body>
</html>

Q.11 js program to check if number is a prime Number or not .

Prime number is complete divisible by itself or 1 .

<html>
<head>
    <title>javascript example </title>
    <script>
      var number = prompt("please enter a number");
       if(number == 1){
          console.log(`${number} is neither prime nor composite number`);
       }else if(number< 1) {
         console.log(`${number} is not a prime number`);
       }else {
           for(var i =2;i<number;i++){
               if(number%i==0){
                    console.log("this is not prime number");
                    break;
                }else {
                   console.log("this is prime number");
                 }
              }
       } 
    </script>
</head>
<body>
      //number
</body>
</html>

Q.12 . JS Program to find largest Number Among 3 Numbers .

Hint : Math.max()

 <html>
<head>
    <title>javascript example </title>
    <script>
       var a = prompt("please enter 1st number");
       var b = prompt("please enter 2nd number");
       var c = prompt("please enter 3nd number");

       var x = Math.max(a,b,c);

      console.log(x);

    or 

     function check(a,b,c) {

        if(a>=b && a>=c){
              console.log(`a is gretest number`);
           }else if(b>=a && b>=c){
              console.log(`b is gretest number`);
           } else {
              console.log(`c is gretest number`);
           }




      }
    </script>
</head>
<body>
   
</body>
</html>

Q. 13 js program to find the factorial od a number

<html>
<head>
    <title>javascript example </title>
    <script>
     var number = prompt("please enter a number");
 
     var fact=1;
    if(number == 0){
      console.log(`the factorial of -ve numbers is not possible `);
    }else if(){

   }else {
       for(var i=1;i<)
    }
           
    </script>
</head>
<body>
      //number
</body>
</html>

composwr create

newDate() | Date object :

the new dat() creates aa date object with the current date and time .

Note: Js ounts months , days ,seconds , milliseconds , hours all from 0 . eg : jan = 0 | Dec =11 ;

thereare 9 ways to create a new date objects : 

new Date() 
new Date( date string )

new Date(year,month )
new Date(year, month,day)
new Date(year,month,day,hours)
new Date(year,month,day,hours,minutes)
new Date(year,month,day,hours,minutes,seconds)
new Date(year,month,day,hours,minutes,seconds,ms)

1.toDateString():

Returns the date portion of a date object .

const event = new date() //date object 

console.log(event.toDateString());

//Mon feb 07 2023 " | <- Return Full Date 

2. getDate() :

Returns the day of the month( 1 to 31 ) of a date .

const event = new Date();  /date object 

console.log(event.getDate());

//6 -> returns only date 

3. getFullYear() :

return the full year (4 digits ) of a date .

const event = new Date();

console.log(event.getFullYear());

//2023 <- Returs only year     

4. getMonth() :

Returns the month (0 to 11 ) of a date .

const event = new Date();

console.log(event.getMonth());
//1 <- (Feb) js counts months from 0 to 11 

5. getDay() :

Return theday of theweek ( 0 to 6 ) of a date.

const event = newDate() // date object 

console.log(event.getDay());

//2  <- day of week ( 0 to 6 ) sun =0 ,mon=1 ....

6. getHours() :

Returns the Hour ( 0 to 23 ) of a date .

const event = new Date(); //date object 
console.log(event.getHours());

//18 

7. getMinutes() :

Return the minuts ( 0 to 59 ) of a date .

const event = new Date() // date object 

console.log(event.geyMinutes());

//55

8.getSecconds():

Return the seconds ( 0 to 59) of a date .

const event = new Date(); 

console.log(event.getSeconds());

//45  <- Returns Seconds ( 0to 59 ) 

9.getMilliseconds();

Return the millisconds ( 0 to 999 ) of a date.

const event = new Date();
console.log(event.getMilliseconds());

//645

10. getTime() :

Return the number of milliseconds since january 1, 1970 00:00:00

const event = new Date(); //date object 

console.log(event.getTime());
//1638383736272<-milliseconds

11. setDate() :

sets the day of the month of a date .

const event = new Date();

console.log(event.setDate(15));

//web Feb 15 202309:84:00 GMT+0530 (India standard Time)

12. setFullYear() :

sets the year of a date , can also set month and day .

const event = new Date();

console.log(event.setFullYear(2020,11,3))

//thu Dec 03 2020 10:00:09 GMT+0530 (  India standard Time )

13. setHours() :

sets the hours of a date , can also set minutes and secons and milliseconds .

const event = new Date();

console.log(event.setHours(22));

//Tue Feb 07 2023 22:07:40 GMT+0530 ( India standard Time) 

14 .setMilliseconds :

sets the milliseconds of a date .

const event = new Date();

console.log(event.setMilleseconds(730));
console.log(event.getMilliseconds())/ //730

15. setMinutes():

sets the minutes of a date , can also be used to set the seconds and milliseconds .

const event = new Date();

console.log( event.setMinutes(55));
//Tue Feb 07 2023 10:45:55

16. setSeconds() :

Sets the seconds of a date object , can also be used to set the milliseconds .

const event = new Date();

console.log(event.setSeconds(55))

//Tye Feb 07 2023 10:45:55  

17. setMonth()

sets the month of a date object , can also be used to set the day of the month .

const event = newDate();
console.log(event.setMonth(4));

//sun May 07 2023 10:44:45 GMT+0530 (India Standard Time )

18.setTime():

sets a date and time by adding or subtracting a specified number of milliseconds to /from mid jan 1 , 1970 .

const event = new Date();

console.log(event.SetTime(133232323232323));

//thu mar 22 2023 13:41:22

1. let and const keywords
2. Arrow functions
3. template literals
4. Destructuring
5. Spread Operator
6. classes
7. promises
8. Async /await
9. Modules
10. Default and rest parameters

Most comman loop in js ,it allows you to loop through an array or perform a set of instructions a specific number of times

for(let i=1;i<=5;i++){
   console.log(i);
}
console.log("done");

2.for in loop :

this loop is used to iterate over the properties of an object

let obj = {
     name: "elonifycoder",
     age: "27",
     place: "india"
};

for(let key in obj) {
    console.log(key + ":" +obj[key]);  //key = name,age,place
}

3. for of loop :

this loop isused to iterate over the values of an iterable object , such as an array or a string .

let array = [10,20,30,40];

for(let a of array) {
   console.log(e +5);
}

4. while loop :

this loop is used to perform a set of instruction while a certain cons=dition is true .

Note : if not added increament i++ it will run as infinite loop

let i =1;
while( i<=5) {
  console.log("Hello " +i);
  i++;
}

5. do while loop :

this loop is similar to the while loop but it excute the instructions at least once , even if the condition is false .

let i =6;
do {
  console.log("Hello " +i);
  i++;
} while (i >100 );     //false