Class Checkpoint

Series · 13 parts · 10:21:59

Making Parkwood Vale

This series shows how parkwoodvale.co.uk was built, step by step. It is a transactional website for a library, where visitors browse, reserve and return books, made as an exemplar for WJEC GCE Digital Technology. It starts with installing the software and designing the database, then builds the pages, accounts, email, search, an admin area and the loans system. Each part builds on the one before, so watch them in order. Software used: Adobe Dreamweaver, Adobe XD, UwAmp, HeidiSQL, PHP, MySQL, Bootstrap, JavaScript and PHPMailer.
Start from Part 1
  1. 1 8:18 Part 1 Install the software for the build: Dreamweaver, UwAmp and HeidiSQL, all run from a memory stick.
  2. 2 19:57 Part 2 Design the database with an ERD, then build the users, loans, copies and books tables in HeidiSQL.
  3. 3 32:17 Part 3 Set up the Dreamweaver site, learn the PHP basics and connect to the database with mysqli.
  4. 4 28:51 Part 4 Wireframe the site in Adobe XD or Figma, then prepare the images as WebP with XnConvert.
  5. 5 1:14:29 Part 5 Add Bootstrap, split the page into a shared header and footer, and build the home and facilities pages.
  6. 6 24:05 Part 6 Build the home page image slideshow in JavaScript, and hide .php from addresses with .htaccess.
  7. 7 23:40 Part 7a Build the sign in, register and forgot password forms in HTML and Bootstrap.
  8. 8 1:01:46 Part 7b Make sign in and register work: PHP sessions, checks, hashed passwords and a protected account page.
  9. 9 1:08:17 Part 8 Send email from PHP with PHPMailer and Gmail, then build the full forgot password reset.
  10. 10 1:06:16 Part 9 Build the profile page: show and update the user's details and upload a profile picture.
  11. 11 1:00:28 Part 10 Add live book search: results appear under the search box as you type, using Ajax.
  12. 12 1:36:18 Part 11 Add books from the Google Books API through a new admin area, with covers saved to the site.
  13. 13 57:17 Part 12 Finish the library: reserve and return books, with emails and a loans page.