In Progress

Enable me to import csv data into MySQL database phpMyAdmin

I have an appointment booking website, which runs from a MySQL database, I can add events one at a time in the admin section of the booking system, but I'd like to add events in bulk. To do this I would need to add new records to a table in the MySQL database.

I have a CSV file with the new dates and I would like to import this csv into the database through phpMyAdmin but I don't know how to do this.

I will add new dates every few months, so I will need to be given instructions of how to this - I don't mind using phpMyAdmin myself, but I would require instructions/commands from you.

Attached is a screenshot of the table from the MySQL database that needs records importing into it and also attached is a csv file that I have made with the new events.

If there is a better way to do this, rather than using a csv then please let me know - the only fields that will ever change are 'id', 'eventDate' and 'entryFee'.

Skills: Javascript, MySQL, PHP

See more: phpmyadmin mysql import csv, phpmyadmin import csv, mysql import csv, phpmyadmin enable csv import, mysql table csv, id me, please let know, import mysql, import database, enable, data importing, CSV, csv php, csv data, appointment booking, mysql database import, import data php website, database javascript, php table csv, import csv data mysql, mysql import csv data, table csv, system data file, screenshot using php, javascript mysql table

About the Employer:
( 21 reviews ) Swadlincote, United Kingdom

Project ID: #1297313

Awarded to:

sureshdevi

I can create a script to import CSV events in bulk into your MySQL database. Thanks, Suresh

£30 GBP in 1 day
(549 Reviews)
7.3

14 freelancers are bidding on average £39 for this job

netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

£20 GBP in 0 days
(77 Reviews)
6.6
k1ng440

Professional Web Developer is ready get started right now. More information in Private Message.

£60 GBP in 2 days
(94 Reviews)
6.5
freeworks

hi,i saw your project description. I will do that on time. I will do custom design and coding for you. Please check my profile and portfolio.thanks

£40 GBP in 0 days
(84 Reviews)
6.4
randdythea

hi sir, please check pmb. thanks ^_^

£20 GBP in 1 day
(69 Reviews)
5.4
hiukim

Hi, could you check pm please?

£30 GBP in 2 days
(39 Reviews)
5.4
mukesh06ni

i can do this ... check you PMB....

£30 GBP in 0 days
(10 Reviews)
3.3
rfuentescruz

Hi. Please check your inbox for my message

£30 GBP in 0 days
(5 Reviews)
3.3
effecter

please check PMB

£20 GBP in 1 day
(1 Review)
1.6
gslogic

Respected sir I can do this for you. Please check your message box for details Thanks

£30 GBP in 1 day
(0 Reviews)
1.6
indsoftexpert

Hello, I can guide you how to insert data from csv. Also if you need I can make a program to insert data dynamically from csv to phpmyadmin. no phpmyadmin interface is required.

£120 GBP in 2 days
(0 Reviews)
0.0
stephenpnewal1

I m doing that. Please find file and link I am gonna send you.

£60 GBP in 1 day
(0 Reviews)
0.0
danishevsky

I'm going to develop PHP script with simple interface, that you can use anytime you want your database to be updated.

£20 GBP in 1 day
(0 Reviews)
0.0
contact2haseeb

I m ready to do this. By creating store procedure which you execute on mySQL DB.

£30 GBP in 1 day
(0 Reviews)
0.0