The ‘Build a Social Network from Scratch: JavaScript PHP + MySQL’ course will teach you how to create your own social network site just like Facebook. In this course, you’ll learn JavaScript, PHP and MySQL by building the ultimate social network website from scratch.
By the end of this course, you will learn to program proficiently in PHP, HTML and CSS. The course is usually available for INR 2,599 on Udemy but you can click on the link and get the ‘Build a Social Network from Scratch: JavaScript PHP + MySQL’ for INR 499.
Who all can opt for this course?
- No prior knowledge of any programming language is required.
- Although it is not mandatory, Knowledge of PHP and MySQL would be beneficial.
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 17 Hours |
| Rating | 4.7/5 |
| Student Enrollment | 13,502 students |
| Instructor | Reece Kenney https://www.linkedin.com/in/reecekenney |
| Topics Covered | MySQL, PHP, Javascript |
| Course Level | Beginner |
| Total Student Reviews | 2,844 |
Learning Outcomes
- Build a comprehensive social networking website with features like newsfeeds, profiles, a friend system, a chat system, trending postings, and much more.
- Programming skills in HTML, CSS, and PHP.
- Use an object-oriented approach when programming.
- Understand how to use MySQL databases with ease on your website.
- Learn how to register domain names and launch your new website.
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | Welcome! Info and Setup (28 minutes) | Intro (same as course landing page video) |
| Installing Xampp – Mac / Linux | ||
| Installing Xampp – Windows | ||
| Installing a text editor | ||
| Creating the index page | ||
| Creating our database | ||
| Connecting to our database with PHP | ||
| 2. | Register / Sign Up Form (01 hour 06 minutes) | Let’s create the register form! |
| Getting values from the form | ||
| Checking that the Emails Match | ||
| Creating the Users Table | ||
| Checking that the Email Hasn’t Already Been Used | ||
| Validating Remaining Values | ||
| Storing Values in Session Variables | ||
| Storing the Error Messages | ||
| Displaying the Error Messages to the User | ||
| Generating a Unique Username | ||
| Giving the User a Random Profile Picture | ||
| Inserting the Values into our Database | ||
| Finishing touches – Finally! | ||
| 3. | Login Form (26 minutes) | Improving efficiency – Only 2 extra lines of code! |
| Creating the login form | ||
| Writing the Login Handler | ||
| Handling Login Errors | ||
| Reopening a Closed Account | ||
| 4. | Styling the Register/Login Page (45 minutes) | Setup and Introduction to CSS |
| Adding our Page Background Image | ||
| White Panel Background | ||
| Panel Header | ||
| Using Custom Fonts | ||
| Styling the Input Boxes | ||
| Showing and Hiding the Register/Login Forms | ||
| Register Page Finishing Touch | ||
| 5. | Building the Foundation of Our Site (32 minutes) | Header Page and Redirecting Users not Logged in |
| Adding Twitter Bootstrap | ||
| Creating the Blue Top Bar | ||
| Making a Simple Site Logo | ||
| Navigation Bar Icons | ||
| 6. | Starting the Index Page (01 hour 13 minutes) | Creating the Main User Details Column Structure |
| Styling the User Details Panel | ||
| Adding Data to the User Details Panel | ||
| Creating the Newsfeed Column – Part 1 | ||
| Creating the Newsfeed Column – Part 2 | ||
| The HTAccess File | ||
| Creating our Newsfeed Database Tables | ||
| Object Oriented Programming – The User Class | ||
| Posting Status Updates – Part 1 | ||
| Posting Status Updates – Part 2 | ||
| Allowing line breaks in our posts | ||
| Stop the form resubmitting on refresh | ||
| The Forgotten Logout Button | ||
| 7. | Newsfeed – Getting Posts (01 hour 05 minutes) | Loading Posts – Part 1 |
| Loading Posts – Part 2 Checking if Account is Closed | ||
| Loading Posts – Part 3 Getting the Timestamp | ||
| Loading Posts – Part 4 Output to Newsfeed | ||
| Styling the Posts | ||
| Infinite Scrolling (Auto Load Posts) – Part 1 | ||
| Infinite Scrolling (Auto Load Posts) – Part 2 | ||
| Infinite Scrolling (Auto Load Posts) – Part 3 | ||
| Infinite Scrolling (Auto Load Posts) – Part 4 | ||
| Our Infinite Scrolling System – Explained! | ||
| 8. | Newsfeed – Extra Features (01 hour 33 minutes) | ‘isFriend’ function – Is user ‘A’ friends with user ‘B’ |
| Only Showing Posts from Friends | ||
| Posting Comments – Part 1 | ||
| Posting Comments – Part 2 | ||
| Displaying the Comment Section – (Posting our First Comment) | ||
| Loading comments – Part 1 | ||
| Loading comments – Part 2 | ||
| Styling the Comments – Part 1 | ||
| Styling the Comments – Part 2 | ||
| Bug fix – “Cannot modify header information…” | ||
| Displaying Number of Comments for Each Post | ||
| When Link is Clicked, Don’t Show Comments | ||
| Like Button – Part 1 | ||
| Like Button – Part 2 | ||
| Like Button Handler | ||
| Unlike Button Handler (Undoing a Like) | ||
| Like Button Styling | ||
| 9. | Profile Page (02 hours 07 minutes) | Creating the Left Profile Bar |
| Styling the Left Profile Bar | ||
| Add Friend Buttons – Part 1 | ||
| Add Friend Buttons – Part 2 | ||
| Friend Button Styling | ||
| Remove Friend Functionality | ||
| Add Friend Functionality | ||
| Creating the Friend Requests Page | ||
| Accepting and Ignoring Friend Requests | ||
| Styling the Friend Request Buttons | ||
| Showing the Popup Post Form | ||
| Creating our Main JavaScript File | ||
| Submit Post Ajax Form | ||
| Adding the Delete Post Button | ||
| Delete Button Functionality and Styling | ||
| Profile Page Newsfeed | ||
| Profile Page Newsfeed – Finishing Touches | ||
| Mutual Friends Calculation | ||
| Displaying the Mutual Friends Count | ||
| Uploading Profile Pictures | ||
| Fix: Jcrop JS File Spelling | ||
| 10. | Messaging System (02 hours 02 minutes) | Making a Start on the Messages Page |
| Retrieving the Most Recently Interacted with User | ||
| Creating the Messages Table | ||
| Messages Page Heading | ||
| Message Form Setup | ||
| Sending Messages | ||
| Retrieving the Messages – Part 1 | ||
| Retrieving the Messages – Part 2 | ||
| Styling the Message Form | ||
| Styling the Messages | ||
| Automatically Scrolling to Most Recent Message | ||
| Getting the Conversation List | ||
| Getting the Latest Message from Each Conversation | ||
| Getting the Conversations List – Finishing Off | ||
| Styling the Conversations List | ||
| New Message – Part 1 | ||
| New Message – Part 2 | ||
| New Message – Part 3 | ||
| Styling the New Message Page | ||
| Profile Page Messages – Setting up the Tabs | ||
| Profile Page Messages – Adding our Message System | ||
| Profile Page Messages – Sending the Messages | ||
| 11. | Dropdown Message Box (From Navigation Menu) (01 hour 01 minutes) | Setting up our HTML |
| Writing our JavaScript Function | ||
| Creating our Ajax File | ||
| Retrieving the Data for our Dropdown Window | ||
| Configuring the Return String | ||
| Dropdown Message Box Styling | ||
| Infinite Scrolling – Part 1 | ||
| Infinite Scrolling – Part 2 | ||
| Adding the Message Badge to the Navigation Bar | ||
| Notification Badge Styling | ||
| 12. | Notifications (01 hour 16 minutes) | Creating the Notifications Table |
| Creating the Notifications Class | ||
| Adding the Notification Badge to the Navigation Bar | ||
| Insert Notifications Function | ||
| Profile Post Notifications | ||
| Liked Post Notifications | ||
| Comment on Post Notifications | ||
| Sending a Notification to all Commenters | ||
| Inserting Notifications – Bug Fixes | ||
| Notifications Dropdown – Part 1 | ||
| Notifications Dropdown – Part 2 | ||
| Styling the Notifications Dropdown | ||
| Notifications Dropdown – Bug Fix | ||
| Creating the Page to View a Single Post | ||
| Writing the Function to get a Single Post | ||
| Setting Notifications to ‘Opened’ | ||
| Friend Requests Notification Badge | ||
| 13. | Live Search (56 minutes) | Search Form Setup |
| Search Form Styling | ||
| Search Form JavaScript | ||
| Get Live Search Users Function | ||
| Creating our Live Search Ajax Page | ||
| Deciding which Query to use | ||
| Configuring the Return String | ||
| Debugging… | ||
| Styling the Search Form Dropdown Results | ||
| Hiding the Live Search Results when Clicking Away | ||
| 14. | Search Results Page (36 minutes) | Making a Start to our Search Results Page |
| Showing the Number of Results Found | ||
| Displaying the Friend Button next to each Result | ||
| Configuring the Return String | ||
| Styling the Search Results | ||
| Adding Functionality to the Friend Buttons | ||
| 15. | Account Settings Page (46 minutes) | Linking to the Upload Profile Picture Page |
| Creating the User Details Forms | ||
| Adding Functionality to the Update Details Form | ||
| Debugging the Update Details Form | ||
| Adding Functionality to the Update Password Form | ||
| Creating the Close Account Form | ||
| Close Account Functionality | ||
| Styling the Settings Page | ||
| 16. | Extra Features (29 minutes) | Posting YouTube Videos from a URL |
| Embedded YouTube Link Bug Fix | ||
| Calculating Trending Words – Preparing the Post | ||
| Calculating Trending Words – Analysing the Post | ||
| Outputting the Trending Words | ||
| 17. | Conclusion – You Made It! (05 minutes) | Thank you for Watching! |
| Basic Information on Web Hosting | ||
| 18. | Requested Features (19 minutes) | Uploading Images to the Newsfeed |
| Uploading Images to the Newsfeed – Part 2 | ||
| Bug fix: Fixing profile posting |
Resources Required
- A laptop or a desktop
- A programming text editor
Featured Review
Nanofritek (5/5) : This is one of the best if not the best web development course. It contains everything you need to be a good web developer. I like the Object-Oriented approach of handling functionalities. One of the greatest courses on Udemy
Pros
- Federico Garzia (5/5) : Great course! it’s not like a zero to hero course, if you want to get the best of it, some basics html/js/php are recommended.
- Saem Samarnmit (5/5) : And I believe that the creator of this course also follows the best practice principals and also correct some of these practices along the course.
- Don Tharindra Yohan Bamunuarachchi Pathirana (4/5) : He is producing his best effort to provide knowledge to students.
- Brian Smith (5/5) : This is one of the best courses that I have had at Udemy.
Cons
- Abhik Shrestha (1/5) : Everything matches, sometimes you confuse me with the assigning of the variables I don’t whats wrong.
- Siddharth (1/5) : It is difficult to understand what the presenter is speaking because of his speed and accent 2.
- Ilham Soran (1/5) : If you want to be a pro software developer this is not the place, it only teaches you the bad way of writing code.
- William Lewis (1/5) : I asked a question on the forum he was not able to answer it after 4 replies, in the end someone else answered it….
About the Author
The instructor of this course is Reece Kenney who is a Software Engineer at Microsoft. With 4.7 Instructor Rating and 8,795 Reviews on Udemy, Reece Kenney offers 9 Courses and has taught 32,093 Students so far.
- Reece Kenney has a lot of expertise creating products that are used every day by millions of people. He also have the good fortune of working with some of the world’s top-notch software engineers.
- With the intention of improving people’s lives, Reece Kenney is on Udemy to share his expertise with as many people as he can.
Comparison Table
| Parameters | Build a Social Network from Scratch: JavaScript PHP + MySQL | Make a Google search engine clone: JavaScript PHP and MySQL | PHP OOP: Object Oriented Programming for beginners + Project |
|---|---|---|---|
| Offers | INR 499 ( | INR 455 ( | INR 455 ( |
| Duration | 17 hours | 6 hours | 18.5 hours |
| Rating | 4.7/5 | 4.7/5 | 4.6/5 |
| Student Enrollments | 13,502 | 3,433 | 24,498 |
| Instructors | Reece Kenney | Reece Kenney | Edwin Diaz |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this