Using mySQL with PHP for the Web
Level 5, 20 Credits.
- Not Presently Available.
Get the latest updates on our courses
Please use our subscription page to register your interest, and we will keep you updated on all relevant information and news about subjects you have chosen.
This course covers the fundamentals of designing and building a relational database for the web using MySQL, and the interface between the mySQL server and the PHP scripting engine. Students will learn to design and build database tables and use them to produce dynamic website applications. This course assumes knowledge of the topics covered in the PHP scripting for the Web module. The basic syntax of SQL, as is applicable to mySQL, is taught on the course. See the Computing page on www.cardiff.ac.uk/learn for details.
Who is this course for?
This course is ideal for the student who already has some knowledge of the PHP programming language.
Learning and Teaching
This module includes a mix of traditional lectures and laboratory sessions. Each meeting starts with a lecture and finishes with a laboratory session.
Coursework and Assessment
To award credits we need to have evidence of the knowledge and skills you have gained or improved. Some of this has to be in a form that can be shown to external examiners so that we can be absolutely sure that standards are met across all courses and subjects.
During the course, you will be given assignments to be submitted to the course tutor. At the end of the course, there will be a class test.
The most important element of assessment is that it should enhance your learning. Our methods are designed to increase your confidence and we try very hard to devise ways of assessing you that are enjoyable and suitable for adults with busy lives.
- Structure of mySQL and its PHP API and relationship to the PHP scripting engine and web server
- Introduction to relational databases and normalisation and basic database design
- The PHP/mySQL interface
- Basic constructs and syntax of SQL
- Advanced features of SQL such as joining tables
- mySQL database creation and management
Du Bois, Paul, MySQL, New Riders ISBN: 0735709211, 1999
Library and Computing Facilities
As a student on this course you are entitled to join and use the University library and computing facilities. You can find out more about these facilities on our website www.cardiff.ac.uk/learn under Student Information, or by ringing the Centre on
(029) 2087 0000.
Accessibility of Courses
Our aim is access for all. We aim to provide a confidential advice and support service for any student with a long term medical condition, disability or specific learning difficulty. We are able to offer one-to-one advice about disability, pre-enrolment visits, liaison with tutors and co-ordinating lecturers, material in alternative formats, arrangements for accessible courses, assessment arrangements, loan equipment and Dyslexia screening. Please contact the Centre on (029) 2087 0000 for an information leaflet.
A range of further information can be found on our web site www.cardiff.ac.uk/learn or in Choices. This includes the times and dates of courses and an explanation of accreditation and credit levels.