How to Upload CSV file in phpMyAdmin of cPanel ?
How to upload CSV file in PHP, my admin? steps : - 1) open excel file. 2) save as UnicodeText(.txt) format 3) open .txt file and change delimiter ( )tab to any you want. ->we use ||. Like, pipe(||),comma(,,),etc. "Note which delimiter you apply that can't be the value of the any field." 4) the first column is a name of the columns 5)in server phpmyadmin open import tab. File to import: 6)browse that .csv file -> Character set of the file:utf-16 ->Skip this number of queries (for SQL) starting from the first one:1(if u have first columns as a field name) otherwise 0. Format: 7) CSV ->select if u want to update same data ->Columns separated with: value which u set as delemeter.(in our case ||) ->Columns enclosed with:" ->Columns escaped with:" ->Lines terminated with:auto Column names: id,sub_category_name,sub_category_details,catId,typeId(our field names)