Course description
Web Programming Using PHP/MySQL Part 1
Start building dynamic web solutions and apps using PHP with MySQL with this practical 10-week course.
The short course broadly comprises the fundamentals of programming with PHP, relational database design and operations with MySQL, and web solutions using PHP and MySQL.
Upcoming start dates
Suitability - Who should attend?
If you are already familiar with HTML, this course will enable you to build more powerful web solutions. You will advance to dynamic, database-enabled, website/intranet programming and applications using the open-source PHP scripting language and MySQL database.
Eligibility:
Prior knowledge: Successful completion of Building Websites with HTML5 and CSS3 or good understanding of HTML and how web pages work.
English requirements:
Applicants must be proficient in written and spoken English.
Outcome / Qualification etc.
You will be awarded an official City, University of London certificate if you attend over 70 per cent of the classes. The course is not formally accredited.
By the end of this course, you'll be able to:
- Understand the basics of programming in PHP
- Write and debug procedural PHP scripts
- Understand fundamental relational database concepts
- Design a relational database suitable for a blog
- Code a simple content management system
- Understand the importance of web application security
Training Course Content
- PHP, MySQL, LAMP: what they are and what they do. Static vs dynamic pages. Client-side vs server-side scripting. Obtaining PHP and MySQL software. Resources and tools e.g. manuals, books, websites, and development environments. Using XAMPP as a development environment.
- Basics of programming with PHP - variables, constants, data types, operators, expressions, control structures & decision making, functions, type-casting, program flow. Documenting your code. Simple templating with PHP. Organising your application. Finding and fixing bugs in your code. HTTP client-server communication: HTTP headers, server response codes.
- MySQL: What is SQL. Relational databases vs spreadsheets. MySQL in the terminal. Relational database design. MySQL's data types. CRUD operations: create, read, update and delete data. Primary, foreign and unique keys. Getting results from more than one table: joins. One-to-one, one-to-many, many-to-many relationships. Column and table aliases. Changing table structure. Table types. Aggregate queries.
- PHP, MySQL and Apache admin: php.ini, my.ini & httpd.conf. Understanding PHP errors.
- PHP and MySQL on the web: Connecting to MySQL using PHP. Querying the database and using the results. Dynamic templating. Single and multi-article templates. PHP's superglobals. Accepting user input through the URL and forms. Forms: validation and giving user feedback. Database CRUD operations through a web front end. Defensive programming. Security considerations. Working as a web developer. What to learn next.
Course delivery details
This practical course takes place over ten weekly evenings.
Request info
City, University of London
City, University of London is a special place. With skill and dedication, we have been using education, research and enterprise to transform the lives of our students, our community and the world for a hundred years. We are proud of...