Backend developer: Recruitment tasks

Please complete the tasks and send the link to the repository with access (preferred Github) to the address joinpandas@pandagroup.co.

01.
Task 1.

In this task you should create a simple news management system. Details of individual functionalities are provided below.

  1. Please create a registration system that will save the following user data in the database:
    • first_name
    • last_name
    • email
    • gender (boys or girls)
    • is_active
    • password
    • created_at
    • updated_at
  2. Please add a login system. The necessary fields for logging in:
    • email
    • password
  3. Please add a news management system that should contain actions:
    • adding
    • edit
    • deleting
  4. The news table in the database should contain:
    • name
    • description
    • is_active
    • created_at
    • updated_at
    • author_id (user_id)
  5. News management should be available after logging in.
  6. Please use the MySQL database.

Notes to the task:

Technologies to be used: PHP, MySQL, CSS, HTML, JavaScript

It’s best to create the whole code in “basic” PHP. As a last resort you can use any PHP framework.

02.
Task 2.

Please create a mechanism to import a .csv file

  1. The .csv file should be generated at: https://mockaroo.com/.
  2. Then, please display the number of people from individual countries on the chart.
  3. All data should be saved in the database.
  4. The library for the chart can be any (open source).

Notes to the task:

Technologies to be used: PHP, Mysql, CSS, HTML, JavaScript

Of course, you can use frameworks and libraries.

Please complete the tasks and send the link to the repository with access (preferred Github) to the address joinpandas@pandagroup.co.