Building a Social Network in PHP & MySQL From Scratch
4.6 (115 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.
808 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Building a Social Network in PHP & MySQL From Scratch to your Wishlist.

Add to Wishlist

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.6 (115 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.
808 students enrolled
Created by Abdul Wali
Last updated 9/2015
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 14 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
Requirements
  • Internet Connection
  • An Internet Browser (ex: Chrome)
  • XAMPP & Notepad++
  • Basic Understanding of HTML & CSS
  • Basic Understanding of PHP & JavaScript
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




Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 78 Lectures Collapse All 78 Lectures 14:13:47
+
Introduction & Web Development Environment for Social Network
3 Lectures 11:53

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!

Preview 01:38

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.

Preview 06:16

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.

Preview 03:59
+
Creating the Social Network Website Layout
5 Lectures 58:24

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.

Creating the Index Page
06:03

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.

Website Layout - Creating the Header
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.

Website Layout - Creating the Content Area
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.

Website Layout - Styling the Sign Up Form
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.

Website Layout - Creating the Footer
09:20
+
Storing User Information in Database
8 Lectures 01:25: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.

Creating the Database & Tables
08:46

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.

MySQLi Connection - Creating Other Pages
08:58

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.

Inserting Users into Database (1)
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.

Inserting Users into Database (2)
15:35

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.

Securing the User Registration Form
10:34

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.

Creating the SESSION for the Users
11:19

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

Creating the Dynamic Template
04:35

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.

Creating the Login System for Users
08:58
+
Creating the User Timeline
12 Lectures 02:14:53

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.

Creating the Main Timeline
18:30

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.

Adding the Search Box to Timeline Header
05:38

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.

Creating the User Timeline
14:43

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.

Styling the User Timeline
14:12

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.

Creating the Main Timeline Form
12:14

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

Styling the Form for Posting
11:59

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.

Inserting User Posts into Timeline
11:19

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.

Displaying the User Posts on Timeline (1)
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.

Displaying the User Posts on Timeline (2)
05:46

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

Styling the Posting Area
11:34

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.

Creating Logout for Users
08:50

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

User Redirection
04:50
+
Inserting & Displaying Comments
6 Lectures 01:01:29

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

Creating the Single Post Page
14:12

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

Inserting the Comments into Table (1)
06:22

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

Inserting the Comments into Table (2)
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.

Displaying the Comments on the Page
08:32

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

Styling the Comments Section
12:15

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

Fixing the Comments
11:36
+
Social Network Important Features
3 Lectures 41:41

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.

Creating Members Page
11:54

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

Topic Based Posts
11:43

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.

Creating the Custom Search Engine
18:04
+
User Profile & User Posts
9 Lectures 01:44:12

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.

Editing User Profile (1)
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.

Editing User Profile (2)
10:24

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

Updating the User Profile
17:49

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

Displaying User Posts
10:52

Deleting User Posts
11:54

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.

Editing User Posts
12:53

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

Updating User Posts
08:15

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.

Creating the User Profile Page (1)
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.

Creating the User Profile Page (2)
09:09
+
Receiving & Sending Messages
12 Lectures 02:14:28

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

Creating Messages Page
08:38

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.

Inserting Messages into Table
10:14

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

Creating Table for Storing Messages
04:16

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.

Showing Messages in User Inbox
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.

Showing Messages in User Inbox
17:33

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.

Styling the Messages Section
11:56

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.

Displaying Single Message
11:29

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

Reply to Messages
10:58

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.

No Reply & Some Fixes
08:14

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.

Sent Items & Inbox Messages
13:26

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

Counting Messages & Update Messages
19:14

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.

Important: Taking an Overview
05:25
+
Admin Panel for Social Network
13 Lectures 02:33:35

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.

Admin Panel - Overview
04:32

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.

Admin Panel - Creating the Layout
11: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.

Admin Panel - Creating the Sidebar
13:24

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.

Admin Panel - View Users
09:27

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.

Admin Panel - View Users
13:47

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.

Admin Panel - Delete Users
17:54

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.

Admin Panel - Editing & Updating Users
17:30

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.

Admin Panel - View Posts
15:58

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.

Admin Panel - Editing and Deleting Posts
18:33

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.

Admin Panel - Tasks for You!
02:26

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.

Admin Panel - Login System
13:56

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.

Admin Panel - Login System
08:34

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.

Admin Panel - Logout System
06:10
+
Uploading to Online Server & Email Verification
7 Lectures 01:04:26

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.

Uploading the Social Network to Online Server (1)
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.

Uploading the Social Network to Online Server (2)
03:29

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

Recommended Web Hosting
1 page

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.

Email Verification Part (1)
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.

Email Verification Part (2)
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.

Email Verification Part (3)
14:05

Learn and find some special bonues in this lecture.

Quick: Win-Win Bonus For You!
2 pages
About the Instructor
Abdul Wali
4.3 Average rating
3,703 Reviews
70,043 Students
27 Courses
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.