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.
27 freelance font une offre moyenne de $135 pour ce travail
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
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 Plus
Hey there, i have checked your csv file, i will surely do this job for you with perfection, Lets get it done. Looking forward, Thanks
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 o Plus
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 impresse Plus
Hello, I've already created similar scrpt and so I can make it within max 2 days after you accept my bid. Regards, Tamas
Hello, Since I am expert of PHP and mysql I can fulfill your requirement. I am ready to start the project. Regards, Sadhan.
Hello Im a PHP expert let me do this work for you. It can be done in 24 hours. And you will be happy with the result.