Import new Students into Database

Student Records should be in an xml file which has been created by the Excel Save As function

Please call this file students.xml and copy into the php code directory

Field headings should be:

Values and SQL statements will be displayed for approval

Loading data: students.xml

RegnoSurnameForenameProgrammeUsername
21401457Adams HenryComputer Scienceha287INSERT INTO user (forename, surname, username, user_level) VALUES ('Henry','Adams','ha287', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21401457','Computer Science', '1')
21504119Agacy ChayComputer Science (IP)ca335INSERT INTO user (forename, surname, username, user_level) VALUES ('Chay','Agacy','ca335', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21504119','Computer Science (IP)', '1')
21605773Ahmed Sh Khalaf Ahmed Alasfoor Sara MComputing for Bus and Mgmtsma36INSERT INTO user (forename, surname, username, user_level) VALUES ('Sara M','Ahmed Sh Khalaf Ahmed Alasfoor','sma36', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21605773','Computing for Bus and Mgmt', '1')
21304498Akinsowon Jeremiah Akintunde MojibayoComputing for Bus and Mgmtjaa38INSERT INTO user (forename, surname, username, user_level) VALUES ('Jeremiah Akintunde Mojibayo','Akinsowon','jaa38', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21304498','Computing for Bus and Mgmt', '1')
21404403Al Gassab NadeemComputer Sciencena342INSERT INTO user (forename, surname, username, user_level) VALUES ('Nadeem','Al Gassab','na342', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21404403','Computer Science', '1')
21501850Alajlan Maryam MSComputer Sciencema746INSERT INTO user (forename, surname, username, user_level) VALUES ('Maryam MS','Alajlan','ma746', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21501850','Computer Science', '1')
21404457Albertelli James PComputing for Digital Mediajpa25INSERT INTO user (forename, surname, username, user_level) VALUES ('James P','Albertelli','jpa25', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21404457','Computing for Digital Media', '1')
21404322Aligullu AlsenComp Sci and AIaa895INSERT INTO user (forename, surname, username, user_level) VALUES ('Alsen','Aligullu','aa895', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21404322','Comp Sci and AI', '1')
21401458Allen LiamComputer Sciencela283INSERT INTO user (forename, surname, username, user_level) VALUES ('Liam','Allen','la283', '2')INSERT INTO student (registration_number, programme, project_status) VALUES ('21401458','Computer Science', '1')

Do the fields and the SQL look okay?