I was wondering if anyone could either guide me or know where can I find out how to create a "submit form" of some sort to upload CSV. file to a primitive online application.
Basically it is a little proyect I am doing to learn Html, Css, Js and Php. I wanted to be able to load user info into the application and I was told that a good way was using .CSV (which I didn´t even know it existed).
I have no idea how would to make a browse button to find the root of the file and even less how to validate it. For what I could find this is the code I need to add in SQL(Wamp server in my case):
-- Seteamos el formato de fecha para que funcione correctamente este fichero
SET DATEFORMAT YMD;
GO
-- This is to import I assume.
BULK
INSERT CSVUsers
FROM 'D:\users.CSV'
WITH
(
-- This is to set the separations I think.
FIELDTERMINATOR = ',',
--s is to separate the registry I deduct
ROWTERMINATOR = '\n'
);
GO
I don´t know if I am missing something here besides the obvious upload thing.So frustrating...
Thanks a lot in advance. Best Wishes
