MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

The Ultimate Web Development Course

Course Summary

Learn ALL the major web development technologies in one working project: HTML, CSS, MySQL, PHP, jQuery and AJAX


  • +

    Course Syllabus

    • Course Introduction
      • Introduction
      • Working Files, eBook and Bookmarks
    • Komodo Text Editor
      • Introducing Komodo Edit
      • Download Komodo Edit
      • Configure Komodo Edit
    • Local Webserver Installation
      • Introducing XAMPP
      • Download and Install XAMPP
      • Change Server Timezone
      • XAMPP Tools and phpMyAdmin
    • Bare Bones HTML5
      • Introducing HTML5
      • Bare bones HTML - Movies List Page
      • Bare Bones HTML - Single Movie Page
      • Bare Bones HTML - Admin Page
      • Test your HTML
    • Styling with CSS
      • Introduction to Styling with CSS
      • CSS Reset
      • Styling with Classes and IDs
      • Applying Classes to index.html
      • Box Layout
      • HTML-shiv for IE8
      • Styling the header and top navigation
      • Styling the favourites and movie list panel
      • Styling the footer
      • Styling the single movie page
      • Styling the admin pages
      • Creating background images with a CSS sprite
      • Cross-browser compatibility check
      • Validate HTML
      • Test your CSS
    • Essential PHP
      • Introduction to PHP
      • Combining PHP and HTML to display strings, variables, and HTML tags
      • Echoing quote marks - String delimiters
      • PHP Conditions
      • Switch ... case
      • PHP Loops
      • PHP Includes
      • Arrays
      • Passing variables in the URL
      • Passing variables without their appearing in the URL
      • Guarding against missing variables
      • Functions and variable scope
      • Passing data to functions with parameters
      • Test your PHP
    • MySQL in phpMyAdmin
      • What is a Database
      • Create a database, add tables
      • Insert data
      • Import data
      • Select records
      • Update existing database records
      • Select favourites
      • Delete records, empty and delete tables and database
    • MySQL in PHP
      • Initialise and connect to a database with mysqli
      • Select all records from a database
      • Select matching records using WHERE ... AND
      • SQL injection demonstrated
      • Combating SQL injection with mysqli real_escape_string
      • Combating SQL injection with prepared statements
      • Add data through PHP interface
      • Delete data through PHP interface
    • From static HTML to dynamic PHP
      • Introduction to Section 9 - PHP
      • Efficient, reusable code with PHP includes
      • One index file for single movie and movies list
      • One admin file for users and movies admin
      • Initialise and connect to the favourite movies database
      • Displaying dynamic data - the list of users
      • Convert users list to function
      • Set include paths in parent files
      • User navigation - test if valid user set
      • Set parameters for show users function
      • Parameterised show users function
      • Catching missing and invalid user_id
      • ASSIGNMENT: Write the favourite movies display function
      • The favourite movies display function
      • ASSIGNMENT: Write the non-favourites display function
      • The non-favourite movies display
      • Insert personal greeting on movie list page
      • The single movie display
      • Catching missing and invalid user input - movie_id
      • Catching empty movie-goers table
      • ASSIGNMENT - Catching empty movies table
      • Catching empty movies table
      • Data-dependent title for favourites list
      • Data-dependent welcome in movie list display
      • Data-dependent link on single movie page
      • ASSIGNMENT – Putting dynamic data into the movie admin table
      • Dynamic data in movies admin table
      • Dynamic data in users admin table
      • Check again for cross-browser compatibility
      • Validate HTML
      • Format HTML source
    • Essential jQuery and AJAX
      • Introduction to jQuery
      • Install Firebug
      • Basic jQuery syntax
      • The $(this) selector
      • Add/remove class and the dynamic event handler 'on'
      • Retrieving and using HTML attributes
      • One-way drag-and-drop effect using jQuery UI
      • AJAX - Update database in the background with no page refresh
      • ASSIGNMENT - The drag-to-delete AJAX call and PHP script
      • The drag-to-delete AJAX call and PHP script
    • jQuery effects and AJAX interaction
      • Adapt JQuery for project
      • Toggle background image on mouseover
      • The click-to-add interface
      • The drag-to-remove interface
      • Load generic thumbnail image in case of missing image
      • ASSIGNMENT - The add/remove interface for the single movie page
      • Add-remove interface for single movie page
      • ASSIGNMENT - Data-dependent headings - Modify PHP
      • Data-dependent headings - Modify PHP
      • ASSIGNMENT- Data-dependent headings - jQuery
      • Data-dependent headings - jQuery version
      • Visual enhancements and AJAX loader icon
      • ASSIGNMENT: Visibility of admin and movie-goer menus
      • Control visibility of admin menus
      • ASSIGNMENT - Conditional loading of Javascript files
      • Conditional loading of Javascript files
      • Movie-goer deletion interface - preliminaries
      • ASSIGNMENT - Movie-goer deletion interface
      • Movie-goer deletion interface
      • The movie deletion interface
      • Add new user interface (1)
      • Add new user interface (2)
      • Delete newly inserted database records
      • Escape HTML output in jQuery
      • Add new movie interface
      • Update user interface - firstname
      • ASSIGNMENT - Full update user interface
      • Full update user interface
      • Update movie interface
      • Catch browsers with Javascript disabled
    • Online version and security considerations
      • Security considerations - directory browsing
      • Prevent directory browsing with .htaccess
      • PHP redirect out of directories
      • Accessing AJAX files through AJAX call only
      • Uploading the project to a webhost
      • Moving the database connection file out of web directory
    • Course conclusion and ... what comes next
      • Course conclusion and ... what comes next


Course Fee:
USD 49

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Open Source , Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top