Secret Social Network Project Development

Jinkedin is a secret social network helping members to enhance their networks and find jobs all around the world. Membership is accepted only by reference. Each member can invite others by generating a unique code associated to an email.

The system is build around a centralized Linux server with MySQL database. This allows to control all the members of this secret network. We have built the front-end with HTML, CSS and JavaScript technologies and the back-end with PHP and AJAX.

The database architecture is described below with reverse engineering. There are 26 tables, 38 stored procedure and 6 functions provided in the database.

With Jinkedin, you can search and apply to specific jobs all around the world.

You can easily create jobs via the "Job Submission Form". You will need to upload details such as company name, job type, job title, job category, job location etc. Note that only recruiters working for the company can submit job posts. A proof is asked before submission.

Employers can manage jobs or manage candidates, this action set includes sending messages or decline candidates, download resumes and edit job post details.

Membership code generation requires only the email of the new member. An invitation will be sent via email, and the invited person should register with the code.

An algorithm working server-side (mySQL) is searching for similar jobs for the given Job ID.

SELECT JP.Id as jobPostId, JP.companyName, JP.jobTitle, JT.name as jobTypeName, CT.name as cityName, CTT.name as countryName FROM jobPosts AS JP LEFT JOIN categories AS C ON C.Id = JP.categoryId LEFT JOIN cities AS CT ON CT.Id = JP.cityId LEFT JOIN countries AS CTT ON CTT.Id = CT.countryId LEFT JOIN jobTypes AS JT ON JT.Id = JP.jobTypeId WHERE C.Id = categoryId AND JP.isActive = 1 AND JP.isApproved = 1 AND NOT JP.Id = jobPostId LIMIT 2;