Excel File Upload to Database Format (csv) PHP

index.php (frontend-file)

<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta http-equiv="X-UA-Compatible" content="IE=edge">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <title>Document</title>

</head>

<body>

    <form method="POST" action="process.php" enctype="multipart/form-data">

        Choose File :<input type="file" name="userfile" required><br><br>

        <input type="submit" name="usersave" value="submit">

    </form>

    </body>

</html>


backend file

<?php
include "conn.php";

//testing sucessfully done

//echo "<pre>";
//print_r($_FILES);
//echo "</pre>";

if (isset($_POST['usersave'])) 
{   
    $upload_file = $_FILES['userfile']['tmp_name'];
    $handle = fopen($upload_file,"r");

    $i = 0;

    while (($myfile = fgetcsv($handle,1000,","))!==false) 
    {   

        $name = $myfile[0];
        $age = $myfile[1];  
        $phone = $myfile[2];
        $query = "INSERT INTO exceltable(dbname,dbage,dbphone) VALUES ('$name','$age','$phone')";
        $query_1 = mysqli_query($conn,$query);
        $i++;
    }
}
?>

(Excel File) 


uploading to 

(Database)


    

     

Comments

Post a Comment

Popular posts from this blog

Search Dropdown - jQuery

Image
<select name="vehicle_no" id="vehicle_no" class="form-control select" >   <option value="" >Select Vehicle</option>      <?php //echo $vchVehicleNumber;exit;?>           @foreach($vehiclesData as $data)              <option {{(isset($vchVehicleNumber) && $vchVehicleNumber == $data['vehicleno'])?'selected':''}} value="{{ $data['vehicleno'] }}" >{{ $data['vehicleno'] }}</option>              @endforeach </select> // jQuery:- you have to add CDN of select2 jquery $("#vehicle_no").select2({   minimumResultsForSearch: Infinity }); $('#vehicle_no').select2({    minimumInputLength: 0  });
Read more

C.R.U.D Oparetion in (PHP Code)

C.R.U.D Oparetion   index.php <?php include "conn.php"; if (isset($_POST["usersubmit"]))  {     $vrname = $_POST["username"];     $vremployee = $_POST["useremployee"];     $vrsalary = $_POST["usersalary"];     $vrgender = $_POST["gender"];     //testing sucessfully complete     // echo $vrname;     // echo $vremployee;     // echo $vrsalary;     // echo $vrgender;     // exit();     $inserting = "INSERT INTO dbemployeelist(dbname, dbemployee, dbsalary, dbgender) VALUES('$vrname', '$vremployee', '$vrsalary', '$vrgender')";     $connecting = mysqli_query($conn,$inserting); } ?> <!DOCTYPE html> <html lang="en"> <head>     <title>Document</title>     <style>         form{             text-align:center;             padding:2...
Read more

Ajax Crud Oparetion (Only Insert Code "create") | PHP | Jquery | Ajax | CODE

Image
 index.php(Frontend & ajax) <!DOCTYPE html> <html lang="en"> <head>     <meta charset="UTF-8">     <meta http-equiv="X-UA-Compatible" content="IE=edge">     <meta name="viewport" content="width=device-width, initial-scale=1.0">     <title>Document</title> </head> <body>     <form id="aj">     Name :<input type="text" name="u_name">     Mobile :<input type="text" name="u_mob">     <button type="button" onclick="user_submit();">SEND</button >     <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>     <script>         function user_submit()          {             var send = new FormData(aj);             // console.log(send);   ...
Read more