En cours

Convert XML and insert to a mySQL table

I need a function where I can upload an XML document and then inserts the information into a table.

As an example

<exam>

<question1>

<question>What planet do you live on?</question>

<answer1>Earth</answer1>

<opt1>Mars</opt1>

<opt2>Earth</opt2>

<opt3>Jupiter</opt3>

<opt4>Saturn</opt4>

</question1>

<question2>

<question>Which countries are in Europe?</question>

<answer1>France</answer1>

<answer2>Ireland</answer2>

<opt1>France</opt1>

<opt2>Ireland</opt2>

<opt3>Australia</opt3>

<opt4>Japan</opt4>

</question2>

<question3>

<question>What colour is Santa's outfit?</question>

<answer1>None</answer1>

<opt1>Black</opt1>

<opt2>Blue</opt2>

<opt3>None</opt3>

</question3>

</exam>

I will need a textfield where this can be typed into and uploads into a sql table.

================

ID = Auto Increment

Name = Exam Name

Author = Reads the username from my already existing script

Date = Date of Upload

Time = Time of Upload

================

I am opened to your advice and experience to determine what the rest of the table should look like in order to capture the information.

The form will need validation checking so it will need to be a valid XML in my schema, I am also opened to advice and experience to change the xml attributes.

Compétences : HTML, PHP, SQL, Design de site internet

En voir plus : insert check query table mysql, convert table mysql xmldevlopp net, create table mysql insert xls file, select insert statement table mysql, convertir xml table mysql, show insert delete table mysql script, xml parse etmek mysql insert php, insert fields table mysql, convert xml table mysql, conver xml sql table mysql

Concernant l'employeur :
( 14 commentaires ) Newtownabbey, United Kingdom

Nº du projet : #8780167

6 freelances font une offre moyenne de 56 £ pour ce travail

Meagan26

Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. I have been working in the field of web Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(272 Commentaires)
7.4
IevgenBaziak

G'Day. I have a feeling you are on a somewhat wrong direction. In case you need to query the stored data, you need a proper MySQL tables to be designed. I can help you with that, just keep in mind - the bid is not f Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(14 Commentaires)
6.8
leomedina01

Hi sir, My name is Leonardo Medina, and I'm from Brazil. I have lots of experience in PHP. I'm an experienced Web Developer working since 1996 in this field, with: * 7+ years experience in PHP, ASP, HTML, CSS Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(151 Commentaires)
6.8
mayanksm7

Ready to start:) I m expert in this. I have +5years experience and i m working on weekend too. Following are my recently completed project: Wordpress [login to view URL] [login to view URL] http: Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(193 Commentaires)
6.6
WaheedGondal1

Dear Sir, Hope you are doing well, I have read your job description, I am willing to work on your task. I have already done similar job and win 5 star rating with wonderful review. - I ll complete all of Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(18 Commentaires)
5.5
paulhutchnz

Hi, I have been doing web development for the last 7 years. Is your server running a MySQL Database? Thanks, Paul

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(68 Commentaires)
5.1