En cours

simple project to get data from text files into mysql database

i have some datafiles that are in this format:

$

what is the capital of usa?

$

washington

$

which is the biggest planet?

$

jupiter

$

Each file may contain thousands of question answer pairs.

I need a SIMPLE php script that can take these files and do the following

(when provided with mysql database information). FIRST CREATE A TABLE WITH THE FOLLOWING FIELDS:

subject , chapter, question, answer, boolean1, boolean2

(table creation is a one time process)

1) check name of file. Each file will have two parts, for example anatomy_arm. The first part of the name is the name of the subject, the second part of the name is the name of the chapter.

2) input the data in the file into the mysql database in this manner:

a) field 1: subject : use the first part of the name of the file

b) field 2: chapter: use the second part of the name of the file

c) field 3: question: use the first line of data in the file

d) field 4: answer: use the next line of data in the file that appears after the next '$'

A 'review data' screen, where user gets to pick subject and chapter, and question-answer pairs start loading, one by one, navigate with next/ previous buttons. DELETE button to delete a row when a nonsensical question-answer pair is spotted. EDIT button to edit contents of a row. This is a very simple project and is for internal use only, not for customers. no design needed, just functionality. Budget $40. YOU MUST KNOW WHAT YOU ARE DOING, i dont have time for learners / beginners / time wasters/anyone who wants a year to do this.

BUDGET $40 MAXIMUM, NO MORE THREE DIGIT BIDS FROM INDIA PLEASE

I WILL NOT READ OR RESPOND TO ANY BIDS ABOVE $40

Compétences : MySQL, PHP

Voir plus : restore mysql database files frm, data mysql database simple android example, need simple java project mysql database, data transfer text files mysql database, simple iphone app mysql database data, java simple project mysql database, saves data radio buttons mysql database, mysql database fill blank project, mysql database files myi, implement mysql database online bookstore project, search data fields mysql database, text mysql database migration, xml files mysql database, mysql database hold text files, simple php mysql database

Concernant l'employeur :
( 62 commentaires ) trivandrum, India

N° du projet : #12731346

Décerné à :

kingsnigdho

Hi, I'm a PHP Web developer. After reading your job description, I think the job is best suited to me. Recently I have worked on a project which was an E-commerce website. Here's the GitHub link to the project if yo Plus

35 $ USD en 2 jours
(2 Commentaires)
1.6

30 freelance ont fait une offre moyenne de 146 $ pour ce travail

gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sour Plus

226 $ USD en 8 jours
(421 Commentaires)
8.1
moonwebtech

Hi, We are a skilled development team and we are working in web development form last five years so we can complete your task inefficient time and cost please feel free to contact us Thanks moonwebtech

233 $ USD en 3 jours
(87 Commentaires)
6.5
210 $ USD en 3 jours
(52 Commentaires)
5.8
155 $ USD en 3 jours
(36 Commentaires)
5.8
rishab6565

Dear Employer, I've thoroughly gone through your requirement. I can handle this job efficiently. I specialize in using Core PHP with customized CMS using LAMP. I can work on Shopify, magento, opencart, LARAVAL. Plus

45 $ USD en 3 jours
(26 Commentaires)
5.7
websolutionseo

Dear Client, I reviewed your requirements for the simple project to get data from text files into mysql database. I am very experienced with bootstrap/php websites and developed many websites with 100% client's fee Plus

225 $ USD en 7 jours
(74 Commentaires)
5.7
webplanetsoft

well sir our company has lots of experienced developer, designer experts and they can do this project easily. we can talk about the money later on and can start the project rite now. we want a long term relation with o Plus

250 $ USD en 10 jours
(45 Commentaires)
5.7
Dckumawat

Dear Client, We are expertise in php, core php, CMS, HTML5, CSS3, bootstrap, WordPress, PSD to HTML, Angular JS, Node JS photoshop, OPencart, Codeignitor, Laravel and many other technologies. Please have a look a Plus

100 $ USD en 3 jours
(38 Commentaires)
4.9
hamidejaz024

Hello Hope you are good sir. I'm a web developer and i have 4+ year experience in this field. i did work on various project include charity base system, jobs portal and ecommerce systems. i'm sure i can full fill yo Plus

155 $ USD en 3 jours
(18 Commentaires)
4.2
200 $ USD en 3 jours
(9 Commentaires)
4.2
alif8

Hi, Task to implement- DESIGN & DEVELOP WEBSITE We have designed and developed several websites (WORDPRESS, HTML, PHP, MAGENTO, SHOPIFY, ETC) and have 3+ years of experience in this field. We have plenty of web de Plus

155 $ USD en 3 jours
(31 Commentaires)
4.5
MiniBigTech

Hello. Hoping you to be in the best shape of health, -We can assure you that we have all the skills and expertise that you require. We are ready to perform the tasks mentioned. Please provide us complete detail s Plus

200 $ USD en 3 jours
(15 Commentaires)
3.7
vbizsolutionss

Hi, I consider our firm eligible for your project requirements as we have well past experiences and knowledge to do such projects successfully. Ready start from today. Our company is perfect for your project posi Plus

100 $ USD en 3 jours
(6 Commentaires)
3.8
hossaincse2

Hello/ Hello Sir, I have read your job description and understand your requirements. I have proper experience about many lartavel,web design, html, CSS, ajax,Bootstrap,html5,CSS3, landing Page design, wordpress, Lar Plus

111 $ USD en 3 jours
(17 Commentaires)
3.5
shanymathew

Dear Sir, i can do this please message to me we can discuss in chat. happy to work for you reply to me

30 $ USD en 1 jour
(9 Commentaires)
2.9
palak17

We are having an experience of 5 years and also provide surety of quality [url removed, login to view] are also having the team with innovative & creative ideas and good experienced in Google Analytic s and Internet Marketing and Web and G Plus

88 $ USD en 3 jours
(12 Commentaires)
2.8
Hassan1859

Hello there, I had a chance to go through your complete job description. And we think this is the best project matching with our skills. I would like to have a verbal conversation with you to walk through your web dev Plus

200 $ USD en 3 jours
(1 Commentaire)
2.4
greenusys

>Sir i saw your requirements and i can assure you we can deliver your project on time. >We are new on freelancer but we have already worked on many projects as individuals. >Now we have established a company and Plus

40 $ USD en 3 jours
(4 Commentaires)
2.1
Shazog

I have more than 5 years experience in PHP programming and well versed in open-sources / Framework like Codeigniter , OpenCart, Wordpress and other Web solutions . My strengths are web development, PHP, ajax, CSS, HTML Plus

155 $ USD en 3 jours
(2 Commentaires)
2.4
priyadarshysaura

Greetings, I've expertise in web development along with depth knowledge of SQL, servers. I will easily input the required fields to database by select function for required tables as I have already done similar t Plus

70 $ USD en 3 jours
(2 Commentaires)
1.8