Import CSV File Data into MySQL Table using PHP & Ajax

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น • 43

  • @reinaldoferreira4318
    @reinaldoferreira4318 6 ปีที่แล้ว

    Very useful your video, could you make something like that but for a csv file with two or more sheets? I’m having issues to make a program with that kind of file

  • @kegsnepomosenoii9128
    @kegsnepomosenoii9128 3 ปีที่แล้ว

    any advice for 200,000 rows excel file ?

  • @Mattou2812
    @Mattou2812 7 ปีที่แล้ว

    thank you ever so much for this tutorial that i need to improve my professional data base system. thanks to you i learnt this amazing thing !! you do a great job congratulations

  • @GaneshShinde-es2mp
    @GaneshShinde-es2mp 5 ปีที่แล้ว +1

    If column name is different in csv file database column name so before upload csv file using php how to set validation to column

  • @liitcode8003
    @liitcode8003 5 ปีที่แล้ว +1

    First of all many thanks for this tutorial! you saved my day!
    this code works fine on localhost however when i switch to a remote host
    i get "Notice: Only variables should be passed by reference in C:\xampp\htdocs\test\import.php"
    i modified the code by looking through the comments to
    $tmp = explode(".", $_FILES["employee_file"]["name"]);
    $extension = end($tmp);
    and the moment i do it
    i get "Parse error: syntax error, unexpected 'if' (T_IF)"

  • @1230124
    @1230124 2 ปีที่แล้ว

    Thanks~ this help me a lot :)

  • @tamil0777
    @tamil0777 7 ปีที่แล้ว

    your tutorial always saves my job. thank u so much friend

    • @webslesson
      @webslesson  7 ปีที่แล้ว +1

      It's My pleasure Bharat.

    • @debashishbasu1505
      @debashishbasu1505 3 ปีที่แล้ว

      @@webslesson Only variables should be passed by reference in

  • @1aligenie
    @1aligenie 8 ปีที่แล้ว +2

    $extension = end(explode(".", $_FILES["employee_file"]["name"]));
    Notice: Only variables should be passed by reference in C:\xampp\htdocs\test\import.php on line 7
    Can you help me here? Not sure why your code isn't working for me.

    • @Mattou2812
      @Mattou2812 7 ปีที่แล้ว

      1aligenie did u try to pass in a variable before do the end function ?

    • @fotosvinadelamr5942
      @fotosvinadelamr5942 6 ปีที่แล้ว

      all code working fine with this update. that solve the Notice: Only variables should be passed by reference problem

  • @MarcelRinker
    @MarcelRinker 7 ปีที่แล้ว

    After uploading, everything is in one row in sql aswell as in the page itself. And there are some errors in line 16-20 on the import.php file. How can I fix it? Thank you for your help :)

  • @fawadali5068
    @fawadali5068 7 ปีที่แล้ว

    the same code is not working for me.... when i select the file and click on upload button it give me an error that.... the error place is when i check the extension it tell me you select a wrong extension

  • @hassanfarooq2502
    @hassanfarooq2502 3 ปีที่แล้ว

    Sir please can you make video in codeligniter 4 in which import CSV file and show on webpage and real time validation on csv if error row of csv in web page got red row .. and you can edit red row and then submit on database
    Please sir its humble request

  • @afratrad7214
    @afratrad7214 6 ปีที่แล้ว

    Hello Sir I encounter the same error $extension = end(explode(".", $_FILES["employee_file"]["name"]));
    Notice: Only variables should be passed by reference in C:\xampp\htdocs\test\import.php on line 7
    please your help please

    • @prudhviraj5591
      @prudhviraj5591 5 ปีที่แล้ว

      $tmp = explode(".", $_FILES["employee_file"]["name"]); $extension = end($tmp);

    • @johnlemueldeinla741
      @johnlemueldeinla741 5 ปีที่แล้ว

      @@prudhviraj5591 whre i can place that code? i still have error. or replace only line 7?

  • @suryanshrajdubey
    @suryanshrajdubey 5 ปีที่แล้ว

    It is showing error "Please select file" even though the code is same!

  • @amitdeb2093
    @amitdeb2093 6 ปีที่แล้ว

    How to show the data in Bar Chart?

  • @josephrosales9321
    @josephrosales9321 6 ปีที่แล้ว

    when i click upload, from loading my CSV nothing changes in my mysql database, anyone have a suggestion.

  • @susylawatieabdurahman2614
    @susylawatieabdurahman2614 6 ปีที่แล้ว

    Good sharing

  • @NelsonFilipeCosta23
    @NelsonFilipeCosta23 7 ปีที่แล้ว

    when I press upload, nothing happen... and im sure the csv its working cuz im testing on two scripts

    •  7 ปีที่แล้ว

      becuase the name of import.php change to export.php

    • @NelsonFilipeCosta23
      @NelsonFilipeCosta23 7 ปีที่แล้ว +1

      if that works... i ll child out and see netflix for 1 hour and eat so much

    • @NelsonFilipeCosta23
      @NelsonFilipeCosta23 7 ปีที่แล้ว

      works -,,,-'

    • @mehdilemoufid7256
      @mehdilemoufid7256 6 ปีที่แล้ว

      nothing for me ....

  • @flaviomiranda4464
    @flaviomiranda4464 7 ปีที่แล้ว

    Ao clicar em upload não faz nada

  • @debashishbasu1505
    @debashishbasu1505 3 ปีที่แล้ว

    Only variables should be passed by reference in

  • @lucasgabule
    @lucasgabule 8 ปีที่แล้ว

    Amazing :)

  • @chris.w391
    @chris.w391 6 ปีที่แล้ว +1

    Nice tutorial, but my hears are bleeding.

  • @i.karpowski7059
    @i.karpowski7059 4 ปีที่แล้ว

    The computer voice is horrible! X()

  • @oliverdelafuente8260
    @oliverdelafuente8260 2 ปีที่แล้ว

    useless tutorial