Social Networking Site in PHP/MySQLi with Full Source Code


Project: Social Networking Site in PHP/MySQLi with Full Source Code

The Social Networking Site is a web based project that is developed using PHP, CSS, JavaScript and MySQL for the database. It is a very simple project that even beginners in programming would find it very interesting. This Social Networking Site is a user friendly projects that different user can easily use all of its features.

About The Social Networking Site in PHP/MySQLi

The Social Networking Site project is just like the popular social networks like Facebook, Twitter and Instagram using PHP and MySQL. In this Social Networking Site it includes features such as Login/sign up, Post Status, Photos, comments, Maintain user bio and User Timeline. Just like the usual, before you could explore a social network site, you need to sign up first by filling up all the required information. Once you are done signing up, you can now have the account to access the Social Networking Site. In there, you will be able to post any status that you like, upload your photos and you can also write comments on the comment box. You can also maintain your biography and view the timeline. It’s just like your favorite Facebook that you will surely love to explore.

These are the following features of Social Networking Site in PHP/MySQLi

  • Registers User
    • In the section you can register your basic information
  • Login User
    • In this section you can login your email and password
  • Home Page
    • In this section you can view all the status that are posted by your friends
  • Update Profile
    • In this section you can edit you personal information
  • Change Picture
    • In this section you can change you profile picture
  • Posting Status
    • In this section you can post your status
  • Comment in the Status
    • In this section you can write comment on the status of your friends
  • Remove Status
    • In this section you can remove the status that you posted

How to setup the Social Networking Site in PHP/MySQLi

  1. Download the zip file.
  2. Download and install XAMPP
  3. Run the XAMPP control panel and start MySQL and Apache
  4. Go to C:\xampp\htdocs and extract the downloaded zip file (social) inside the folder
  5. Open the browser and go to http://localhost/phpmyadmin/ to create the database
  6. Click the new to create a database.
  7. Name the database sourcecodester_biobook.
  8. Click import to import the sql file.
  9. Click choose file and select the file that can be found inside the social folder
  10. Click go.

How to run the Social Networking Site in PHP/MySQLi

Open the browser and go to http://localhost/social/

Accessing janobe’s accounts

Username: [email protected]
Password: admin

This Social Networking Site in PHP/MySQLi with Full Source Code is for educational purposes only. You can download it as a reference and expand your knowledge in making a system. You can freely modify it, according to your desire.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Submitted byTony Mo (not verified)on Tue, 12/29/2020 - 19:43

Its not working good
Submitted byBale (not verified)on Thu, 03/25/2021 - 18:17

I got this message below, how to i rectify it? Warning: mysqli_connect(): (HY000/1049): Unknown database 'sourcecodester_biobook' in C:\xampp\htdocs\social\includes\database.php on line 2 Fatal error: Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, bool given in C:\xampp\htdocs\social\signin_form.php:10 Stack trace: #0 C:\xampp\htdocs\social\signin_form.php(10): mysqli_query(false, 'SELECT * FROM u...') #1 {main} thrown in C:\xampp\htdocs\social\signin_form.php on line 10
Submitted byjean camargo (not verified)on Tue, 05/03/2022 - 07:24

this is because a lot of the functions for SQL was removed from PHP 7 if you have any problems email me [email protected]
Submitted bysoson (not verified)on Mon, 07/18/2022 - 10:40

Fatal error: Uncaught TypeError: Unsupported operand types: int - string in C:\xampp\htdocs\social\home.php:5 Stack trace: #0 C:\xampp\htdocs\social\home.php(216): time_stamp('') #1 {main} thrown in C:\xampp\htdocs\social\home.php on line 5...this errotr shows in the homepage how do i fix it
Submitted byShraddha dodiya (not verified)on Sun, 07/31/2022 - 19:53

i can not set my image as main home page background ....please tell how can i do it
Submitted byoper (not verified)on Sat, 10/22/2022 - 08:43

Access denied for the credentials given above the article

Add new comment