Web Programming using PHP/MySQL | Part 1

City University London
In Islington (England)

Price on request

Important information

  • Short course
  • Islington (England)
  • When:

This course will enable those already familiar with HTML to build more powerful web solutions and advance to dynamic, database-enabled, website/intranet programming and applications using the open-source PHP scripting language and MySQL database. The course broadly comprises the fundamentals of programming with PHP, relational database design and operations with MySQL, and web solutions using PHP and MySQL. Course Information Start DateStart TimeDurationCostCourse CodeApply Thursday 6 October 2016 18:30 - 20:30 10 weekly classes £430.00 CS1559 Apply Now Thursday 19 January 2017 18:30 - 20:30 10 weekly classes £430.00 CS1559 Apply Now Thursday 4 May 2017 18:30 - 20:30 10 weekly classes £430.00 CS1559 Apply Now Tutor Info Sonya Smith is a freelance web developer with several years' commercial experience building websites for social media clients and SMEs. She's glad that her former boss made her learn PHP, and enjoys helping students over the first hurdles of learning to program. She has science degrees from Newcastle upon Tyne and Heriott-Watt universities. Eligibility Successful completion of Web Authoring course or good knowledge of HTML and web pages.

Important information

Where and when

Starts Location
Northampton Square, EC1V 0HB , London, England
See map

What you'll learn on the course

Database Design
Web Programming
Database training

Course programme

What will I learn?
  • 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. Dealing with the legacy settings register_globals and magic_quotes. How to handle and log PHP errors.
  • PHP and MySQL on the web: Connecting to MySQL using PHP. Querying the database and using the results. Dynamic templating. Single and multiple article templates. PHP's superglobals. Accepting user input through the URL and forms. Forms: validation and giving user feedback. Dynamic navigation. Building a simple CMS: Database CRUD operations through a web frontend. Defensive programming. Security considerations. Working as a web developer. What to learn next.

By the end of the course, you will 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

Additional information

Teaching and Assessment

Class time consists of theory supported by live coding, problem solving exercises and discussion in class. The students are provided with extensive notes and code packages. Online quizzes are available on Moodle to be completed at the student's leisure. Homework exercises are available, for which individual feedback will be given if submitted. Email support is given outside of classroom time.