Build a Social Media Web App
This course is an introduction to working with dynamic websites backed by a mySQL database.
In this course you will learn the PHP language and learn to create and manage database tables.
This course is for new developers who have little or no programming and database experience.
Example Curriculum
First Section - Setup
Available in
days
days
after you enroll
- Introduction to PHP and mySQL (4:25)
- Activity 1 Part A How to install MAMP web server and Eclipse for PHP (12:58)
- Hello World with PHP (6:11)
- Create an Input Form with HTML and PHP Part 1 (14:23)
- Create an Input Form with HTML and PHP CSS improvements Part 2 (4:21)
- Create an Input Form with HTML and PHP insert data into a mySQL database Part 3 (6:14)
- Create an Input Form with HTML and PHP Part 4 (13:16)
- Move a mySQL database from one server to another using export and import (7:15)
- Mysql Workbench create foreign key relationships and join tables (38:34)
- Mobile App Development vs Web Development Career (10:21)
Section 2 - First SQL queries
Available in
days
days
after you enroll
Section 3 Recipe Blog
Available in
days
days
after you enroll
- Recipe Database Application in PHP and mySQL Part 1 Introduction (6:26)
- Recipe Database Application in PHP and mySQL Part 2 Starting Code (4:50)
- Recipe Database Application in PHP and mySQL Part 3 Session Variables (8:45)
- Recipe Database Application in PHP and mySQL Part 4 add a record to the database (9:05)
- Recipe Database Application in PHP and mySQL Part 5 Search for a Record (7:47)
- Recipe Database Application in PHP and mySQL Part 6 Edit Delete Items (10:21)
- Recipe Database Application in PHP and mySQL Part 7 Admin Edit and Delete Posts (1:47)
- Recipe Database Application in PHP and mySQL Part 8 Admin Functions (9:48)
- Recipe Database Application in PHP and mySQL Part 9 Edit Form (11:23)
- Recipe Database Application in PHP and mySQL Part 10 Process Edits or Updates (7:52)
- Recipe Database Application in PHP and mySQL Part 11 CSS for input forms (2:47)
- Recipe Database Application in PHP and mySQL Part 12 Add Comments (13:55)
- Recipe Database Application in PHP and mySQL Part 13 Add Comments to mySQL table (7:16)
- Recipe Database Application in PHP and mySQL Part 14 SQL Joins to include user name on comments (3:00)
- Recipe Database Application in PHP and mySQL Part 15 SQL Join to show user name on comments (12:25)
- Recipe Database Application in PHP and mySQL Part 16 User Administration Create Edit and Delete (2:09)
- Recipe Database Application in PHP and mySQL Part 17 User Admin (11:11)
- Recipe Database Application in PHP and mySQL Part 18 Organize a php project (10:19)
- Recipe Database Application in PHP and mySQL Part 19 SQL Injection Attacks (7:09)
- Recipe Database Application in PHP and mySQL Part 20 Comments Administration (11:11)
- Recipe Database Application in PHP and mySQL Part 21 CSS for Comments Admin (4:11)
- Recipe Database Application in PHP and mySQL Part 23 Edit and Delete buttons (3:08)
Subscribe to All Courses
including this one
Check your inbox to confirm your subscription