I have a batch of CSV files that I download several times a day and would like to have them turned into MySQL tables. The first line of the CSV is headings and there could be as many as a couple hundred headings and 20,000 lines.
I would like the script to read the headings then decide what type of data is under each heading (varchar, int, dec, text…) and build the sql statement to create the table.
A PHP function would be great. Something that simply takes the name of the CSV file and the name I want the MySQL table to have. I'm thinking this is a quick and easy project. I have included a sample of a CSV. Again, there are several and each have different headings. The script needs to build the sql based on the headings in each CSV, but I can write the code that walks through the different files. I just need the function to do the work.
Questions? Please feel free to ask.
Thanks.
Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Clients find us better than the so called best. We believe that Customer Satisfaction and Trust will always be our Key for success. Sri Technocrat provides the best breed of designing and application solutions to small and medium sized businesses around the world. A strong Dedicated Executive Team consists of leaders from Indian Institute of Technology (IIT) and various industries and backgrounds aimed at helping execute the plan.
With Regards Sri Technocrat.
Dear Sir,
we are able to complete this work with its innovative ideas and excellent customer service. we will make some different to your expectation.
we are available via Skype, phone and e-mail and are always open for discussion of progress, issues, functionality changes etc I'll be glad to continue our discussion and hope to talk to you soon. wating for your prompt reply.
Thanks
Naimish Makwana
Creativeitech
Hi sir , My name is Luigi Widmore and i'm an expert web developer.
My areas are HTML/CSS PHP/MYSQL Design/Photoshop.
I can deliver this project in 3 days or less.
Please check PM for details , you may be impressed.
Thank you
Hi there,
Our preferred technology : PHP/Mysql, javascript, AJAX
Charges: At least 40% in advance
Ready to start asap.
Let me know if you have any questions.
Thanks,
prasy