Building a Social Network in PHP & MySQL From Scratch

Learn how to create a basic and beautiful social networking website & discussion forum in PHP & MySQLi from scratch.
4.0 (99 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
733 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 78
  • Length 14 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

Learn how to create a basic, but beautiful Social Networking Website and Discussion Forum using simple PHP and MySQLi web development techniques.

Build Social Networking Website Yourself in PHP!

Social Networking websites are communities where you can share something with the world and people can interact with you. After taking this course, you can create the same thing yourself using simple PHP and MySQLi from scratch. Users can comment, can message and can view other members on this social network.

The Content & Overview

With over 75 lectures and 15 hours of content, this course is designed to help you in creating a very basic but powerful social networking website from scratch, You are learning from an instructor who is web developer himself. You should know the basics of PHP & MySQLi before joining this course, because we'll straight start working on the project instead of explaining the basic syntax of PHP. We'll first create the web development environment on our local computer and after that we'll start working on the project step by step. At the end of the course, you'll be able to create a beautiful social networking website yourself.

Below are some of the main features of this social network:

  • Sign Up & Sign In Systems
  • User Timeline & User Postings
  • User Profile and Members Area
  • Commenting & Replies
  • Sending & Receiving Messages
  • Admin Panel




What are the requirements?

  • Internet Connection
  • An Internet Browser (ex: Chrome)
  • XAMPP & Notepad++
  • Basic Understanding of HTML & CSS
  • Basic Understanding of PHP & JavaScript

What am I going to get from this course?

  • Build a Beautiful Social Networking Website & Discussion Forum in PHP & MySQLi
  • Strengthen Your Skills by Creating an Advanced Project in PHP from Scratch
  • Take Your PHP & MySQLi Web Development Career to the Next Level

What is the target audience?

  • This course is for those who want to learn how to create a beautiful social networking website along with social discussion forum in PHP & MySQLi from scratch

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction & Web Development Environment for Social Network
01:38

Introduction: we'll take a look at the overview of the course, what's included in this course and for this course is suitable. Watch the introduction please!

06:16

In this lecture, we'll create the web development environment for creating this social network in PHP and MySQLi, so in order to create the environment you'll need to install XAMPP software on your local computer, and we'll also download and install Notepad++ which is a text editor for writing codes.

03:59

in this lecture, we'll create the project folders for this social media network in PHP, after watching this lecture, you should create all the necessary folders inside "htdocs" folder existing in the XAMPP directory.

Section 2: Creating the Social Network Website Layout
06:03

In this lecture, we'll create the main index page for this social network which will be the default page, and we'll add all the layout sections to this index page. This is to practically start working on this project.

18:27

In this lecture, we'll create the header for the main layout of this social network in PHP & MySQLi, so after this you should be able to create the header using CSS3 and HTML5.

12:27

In this lecture, we'll create the header for the main layout of this social network in PHP & MySQLi, so after this you should be able to create the header using CSS3 and HTML5.

12:07

In this lecture, we'll create the header for the main layout of this social network in PHP & MySQLi, so after this you should be able to create the header using CSS3 and HTML5.

09:20

In this lecture, we'll create the header for the main layout of this social network in PHP & MySQLi, so after this you should be able to create the header using CSS3 and HTML5.

Section 3: Storing User Information in Database
08:46

In this lecture, we'll create the header for the main layout of this social network in PHP & MySQLi, so after this you should be able to create the header using CSS3 and HTML5.

08:58

In this lecture, we'll establish a connection to the database so we can insert the user details into the table for users. And furthermore, we'll create other pages such as functions.php, home.php, connection.php etc. We'll start the back-end work from this lecture after completing the layout of this social network.

17:01

In this lecture, you'll learn to insert the users to the table inside database, we'll use a PHP script to insert the users into the database, the next lecture is the continuation of this lecture.

15:35

In this lecture, you'll learn to insert the users to the table inside database, we'll use a PHP script to insert the users into the database.

10:34

During this lecture, you'll learn how to secure the registration form with some PHP functions to prevent it from being injected by hackers, this is just a basic security measure for securing forms which are sending data to the mysql database.

11:19

In order to identify different users who log-in to their account in this social network, we've to create SESSIONS in PHP, and you'll learn that during this lecture, creating sessions will make it easier for us to expire and start the time of the users.

04:35

In this lecture, You'll learn creating the dynmaic template in PHP which will make this social network more faster and easy to understand.

08:58

In this lecture, you'll learn creating the login system for the users who already have registered their account on this social network using the user registeration form.

Section 4: Creating the User Timeline
18:30

in this lecture, you'll learn to create the main timeline for the users when they are logged in same as Facebook, the users can see their details, can post discussions, can view other users and also can comment on the posts already published by other users.

05:38

in this lecture, you'll learn to add the search box into the navagation bar of the social network home page after the user logs in to their account.

14:43

in this lecture, we'll create the user timeline where we'll display the user information in the sidebar, and this will be the important area for all the registered users, this will be visiable when users log in to their account.

14:12

in this lecture, we'll style of the main timeline for the users, we'll use CSS3 simple properties to design the main timeline a little bit to make it beautiful.

12:14

in this lecture, you'll learn to create the form for main timeline of this social network where users can post something to share with other members in the main area when they log in to their account.

11:59

in this lecture, you'll learn styling the posting area with simple CSS properties.

11:19

in this lecture, You'll learn to insert the user posts into the table inside mysql database, we'll just insert the posts with the user_id and topic_id so we can identify the posts later when we want to display them to the respective users in their account.

15:18

in this lecture, we'll display the posts on the timeline which we already inserted to the table in database, the different users can post any discussion in this forum or social network, and we'll display all the posts on the home page of this timeline during this lecture.

05:46

in this lecture, we'll display the posts on the timeline which we already inserted to the table in database, the different users can post any discussion in this forum or social network, and we'll display all the posts on the home page of this timeline during this lecture.

11:34

in this lecture, you'll learn to style the posting area a little bit so that it can look beautiful.

08:50

in this lecture, you'll learn to create the logout script in PHP and MySQLi for the users who login to their account, so they can click the LOGOUT link to go out from their account.

04:50

in this lecture, You'll learn to redirect users to another page when there is no SESSION set.

Section 5: Inserting & Displaying Comments
14:12

in this lecture, You'll learn creating single page for posts which users can view individually and can post comments on those posts.

06:22

in this lecture, You'll learn inserting the comments into table which are posted by different users on different posts.

08:32

in this lecture, You'll learn inserting the comments into table which are posted by different users on different posts.

08:32

in this lecture, you'll learn how to display the comments on the website with the respective post where the comments were posted by the users.

12:15

in this lecture, you'll learn to style the commenting section on the website so that looks beautiful.

11:36

in this lecture, We'll fix some issues related to the comments.

Section 6: Social Network Important Features
11:54

in this lecture, we'll learn to create the member pages in PHP and MySQLi, where we'll actually display all the registered members on this social network.

11:43

in this lecture, we'll learn to fetch topic based posts upon the user clicks the links in the menu.

18:04

in this lecture, you'll learn to create the custom search engine for this social network in PHP and MySQLi, this search engine will work on the website when the users will search for something i.e topics, users etc.

Section 7: User Profile & User Posts
16:00

in this lecture, we'll learn to edit the user profile in PHP and MySQLi, the user can edit and update their details and profile picture.

10:24

in this lecture, we'll learn to edit the user profile in PHP and MySQLi, the user can edit and update their details and profile picture.

17:49

in this lecture, we'll learn to update the user profile using PHP, so that user can update their profile easily.

10:52

in this lecture, we'll learn about displaying the user specific posts in the timeline when a user clicks to check their posts.

Deleting User Posts
11:54
12:53

in this lecture, you'll learn to edit the user posts, we'll do this using PHP and MySQLi, each user will be able to edit their posts after we create this script.

08:15

in this lecture, you'll learn to update the user posts in PHP and MySQLi, this is very important for this social networking website.

06:56

in this lecture, you'll learn to create the user profile page where we'll display user details along with a button for sending message to other users.

09:09

in this lecture, you'll learn to create the user profile page where we'll display user details along with a button for sending message to other users.

Section 8: Receiving & Sending Messages
08:38

in this lecture, we'll create the message page for sending message to any user who is registered on this social network.

10:14

in this lecture, we'll create a script to insert messages into the table which we created in previous lecture, we'll store the user messages into table.

04:16

in this lecture, we'll learn to create a table in MySQL database for storing user messages.

13:05

in this lecture, we'll learn about displaying the messages in the user profile, we'll discuss about how we can show the inbox messages in the user account so he/she can view the message and can reply to that.

17:33

in this lecture, we'll learn about displaying the messages in the user profile, we'll discuss about how we can show the inbox messages in the user account so he/she can view the message and can reply to that.

11:56

in this lecture, we'll style up the messaging section in the user profile, we'll make it a little bit beautiful using CSS3, so after that we'll move forward to another section.

11:29

In this lecture, we'll learn to display the single message when clicked by the user, actually in the inbox, we can display the single message content separately if the user wants to see and reply to that.

10:58

in this lecture, we'll learn about creating the reply function for the message which is received by a user in their inbox.

08:14

in this lecture, we'll fix some small issues related to the messaging system and also we'll discuss about no_reply column in the table.

13:26

in this lecture, we'll learn about sent items and inbox items, we'll create two separate sections for inbox and sent items, so that use can easily manage their messaging system.

19:14

in this lecture, we'll learn about counting messages and updating messages using PHP & MySQLi.

05:25

Hi, please watch this important lecture to understand what we've covered so far in this great social networking website and discussion forum. And don't forget to watch this lecture till the end.

Section 9: Admin Panel for Social Network
04:32

Onwards, in this whole section, we'll discuss all about creating the Admin Panel for this social networking website. So in the first lecture, we'll discuss about the whole structure of the Admin Panel that we're just going to create from this lecture.

11:24

In the part of the Admin Panel, we'll have to create the layout first, and we'll learn step by step how to create a beautiful but simple layout for the main page of this Admin Panel. From this admin panel, we'll be able to manage the whole social networking website.

13:24

In the admin panel for this social networking website, we'll create the sidebar of the Admin Panel of this project. In the sidebar, we'll add some links which we'll use later to fetch data from the MySQL database. The project is going very smooth so far, and we'll be able to finish it very soon with some more features including email verification system.

09:27

In this part of the course, we'll display the register users from the table in the Admin Panel, and we'll add some basic options such as deleting user and updating user in this lecture.

13:47

This will be the contintuation of the previous lecture in which we'll display the registered users in the Admin Panel and again we'll be able to delete or update any user we want as Adminminstrator of this social network.

17:54

Admin Panel:

We are now going to delete the users in the Admin Panel, and this is something really great when it comes to GUI (General User Interface), we can just click the delete link and the user will be deleted from the database, we'll create a small PHP script for this task during this lecture.

17:30

In the Admin Panel:

We'll learn editing and updating the users straight from the Admin Panel using General User Interface, in this lecture, we'll create the PHP & MySQL script for editing and updating the users which we want from the Admin Panel.

15:58

Admin Panel:

In this lecture, we'll learn to view the posts in the Admin Panel which we are repeating same as viewing users, but you can easily learn both in this lecture inside Admin Panel.

18:33

Admin Panel:

Now let's Edit and Delete the posts together in this single lecture, we'll be able to do some cool stuff in this lecture, but in fact, we are repeating the previous lectures, so you guys now need to do something yourself in the next lecture. See you soon.

02:26

In this important lecture, I'll assign you some simple tasks which you can do easily after learning a lot of logic's in this course, so just complete the tasks and let me know in the discussion forum.

13:56

I've created the login system for the Admin Panel of this social networking website, in this login system, we've used PHP and MySQLi, and you'll learn how to create a secure login system for Admin of this whole system.

08:34

Admin Panel:

I've created the login system for the Admin Panel of this social networking website, in this login system, we've used PHP and MySQLi, and you'll learn how to create a secure login system for Admin of this whole system.

06:10

Admin Panel Logout:

Now after we completed the login system for this whole Admin Panel, we'll create logout system as well because that's also necessary for a system that has a login system. So we'll do it all in this lecture.

Section 10: Uploading to Online Server & Email Verification
19:46

After completing the social networking website & discussion forum project on Local Host, now it's time to upload it to online server and test it in real time, so in that regard, we'll upload the whole project to online server for testing. And we'll set up all the necessary configurations for running this website on the web.

03:29

After completing the social networking website & discussion forum project on Local Host, now it's time to upload it to online server and test it in real time, so in that regard, we'll upload the whole project to online server for testing. And we'll set up all the necessary configurations for running this website on the web.

1 page

Learn about the best hosting which you can use for your website, I've included the best hosting companies.

14:30

in this important part of the course, I'll be teaching email verification which is a crucial system in websites such as social media network, we'll go through detailed instructions for creating the script which will ask the users to verify their email address. This whole section will be divided into three lectures.

12:36

in this important part of the course, I'll be teaching email verification which is a crucial system in websites such as social media network, we'll go through detailed instructions for creating the script which will ask the users to verify their email address. This whole section will be divided into three lectures.

14:05

in this important part of the course, I'll be teaching email verification which is a crucial system in websites such as social media network, we'll go through detailed instructions for creating the script which will ask the users to verify their email address. This whole section will be divided into three lectures.

2 pages

Learn and find some special bonues in this lecture.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Abdul Wali, SEO Marketer & Top Udemy Instructor

Abdul has successfully ranked hundreds of keywords in Google without any backlinking strategy. He is in the SEO and online marketing industry since 2009. Apart from SEO and marketing, he loves web development. WordPress is the core platform which Abdul has been using for creating top notch websites over the years. 

Abdul has established several successful startups such as OnlineTuting (An elearning system), OnlineUstaad (The largest hub of Urdu courses), Wali Solutions (Provides A to Z web solutions).

He is one of the top Udemy Instructors with 45,000+ students and 1900+ reviews. He engages with students on Udemy in real time and answers questions within minutes. If you have any question in mind then don't hesitate to ask Abdul via private message. 

Ready to start learning?
Take This Course