A Social Network using PHP and MySQL Description The goal of this project is to learn server-side web programming using PHP and a relational database system (MySQL). More specifically, you will

create a simple social network where users can declare other users as friends. This project must be done individually. No copying is permitted. Note: We will use a system for detecting software plagiarism, called MossLinks to an external site.. which is an automatic system for determining the similarity of programs. That is, your program will be compared with the programs of the other students in class as well as with the programs submitted in previous years. This program will find similarities even if you rename variables, move code, change code structure, etc. Note that, if you use a Search Engine to find similar programs on the web, we will find these programs too. So don't do it because you will get caught and you will get an F in the course (this is cheating). Don't look for code to use for your project on the web or from other students (current or past). Don't use ChatGPT or any other Al program to generate code. Just do your project alone using the help given in this project description and from your instructor and GTA only. Platform You will develop this project on your PC/laptop using XAMPP and you will test it using using your Chrome/Chromium-based web browser. Project Requirements Start the Apache Web Server and the Database server on your PC using the XAMPP manager console. Run phpMyAdminLinks to an external site. on your browser and create a new database with name Social Network by clicking on New. After you create it, select this database (under the name Social Network), go to the SQL tab, and cut and paste the following SQL code and push Go:/nCreate 10 users in the table users using phpMyAdmin. You need to write two PHP scrips login.php and social network.php. The login.php script generates a form that has two text windows for username and password and a button "Login". The social network.php script prints three sections and a "Logout" button. The first section prints the username, fullname, and email of the current user (the user currently logged-in). The second section "Friends" lists the friends of the current user. The third section "Others" lists all the other users who are not friends (non-friends) of the current user. For each friend or non-friend you display username, fullname, and email. Each friend has a button "Remove" to remove her from the friends and add her to the non- friends. Each non-friend has a button "Add" to add her to the friends and remove her from the non-friends. From the login script, if the user enters a wrong username/password and pushes "Login", it should go to the login script again. If the user enters a correct username/password and pushes "Login", it should go to the network script. From the network script, if the user pushes "Logout", it should logout and go to the login script. The network script must always make sure that only authorized users (users who have logged-in properly) can use this script (you need to use a session to check this). Hints: Each Add/Remove button must have an action that submits the form to social network.php with a different query string. You may use a form buttonLinks to an external site, with type="submit" and formaction="social_network.php?add-smith" to add smith as a friend and formaction="social_network.php?remove-smith" to remove smith from friends. Use md5Links to an external site. to encode passwords in PHP. You will need to use the PDO extensionLinks to an external site. of PHP to work with databases. Here is sample PHP code that uses PDO: Sdbh new PDO("mysql: host-127.0.0.1:3306; dbname-Social Network", "root", array(PDO::ATTR_ERRMODE PDO::ERRMODE EXCEPTION)); Sdbh->beginTransaction(); Sdbh->exec('delete from users where username="smith""); Sdbh->exec('insert into users values("smith", or diecprint_r(Sdbh->errorInfo(), true)); Sdbh->comit(); $stat Sdbh->prepare('select from users'); Sstet-execute(); md5("wypass")","John Seith","seithecse.uta.edu")")