Advanced PHP & MySQL Development

I am eager to find a PHP expert who can enrich my platform with the addition of a few new functions in an already working system under PHP 8.2. The system is already made in simple PHP pages, without the use of any frameworks. Essential requirements for potential freelancers include: - Deep understanding of PHP programming and MySQL. - Ideally, applicants should have advanced skills in both PHP and MySQL and can implement intricate functions with minimal bugs. - Examples or references of past work where similar functionalities have been developed. The application must run in our server with PHP 8.2 We can divide the functions in 3 steps: STEP 1) Add new fields in a form for Customer: - text input for the City (in italian language “Città”) - text input for the Postal Code (in italian language “CAP”) - text input for the Province (in italian language “Provincia”) Same fields must be reported in the database and in all the relevant pages: - view customer page, backup db page and restore db page) - Remove a Field "Company" And add a select input type for "Company". The options of the select will taken from a table of the database. The first Option will be a blank Option, and the others will be the name of the companies. So we need to create a page in the backand of admin, where the admin can add or edit a company name. For example, we will add a table with the following rows: - Company ID - Company Name (will be written by the admin) - Company Promo (will be written by the admin) example: Company ID: 0 Company Name: blank Company Promo: blank Company ID: 0 Company Name: APPLE Company Promo: - 20% So a Member will be related to a Company ID. In the customer page: we will see the Company name and the Company Promo —————————————————————————————————————————— STEP 2) TRANSFORM THE SINGLE-COMPANY SYSTEM TO A MULTI-COMPANY SYSTEM The software perfectly works for a single company. To make a multi-company system, we need to change the references on the software, and make them not fixed, but variable depending from witch user logins to the system. Make one simple interface for a Super Administrator. In this page the super administrator can create and edit a new store. Each store can have one administrator and some users. For Example: STORE: GLASS STORE administrator: admin_glass password: 1234 user: user1_glass password: 1234 user: user2_glass password: 1234 Database name: xxxxx_glass Db user: we can choose a name for db user These administrators and users can only enter in the store of GLASS STORE. With the same credentials it is not possible to enter in more stores. In this way, when a user o admin login, the system automatically can recognize what store we have to be connected. We should create a simple interface where, the Super Administrator, after login can create a new store: Create a New Store or Edit an existent store and insert the parameters: - STORE NAME (create and edit) - Users (create, edit and remove) - Admin (create and edit) - State of the Store (ACTIVE OR INACTIVE) Db name: (we need to talk about this, if it is better that the superadmin will write the name or if the system automatically crates a name) Db user name and passw: (we need to talk about this, if it is better that the superadmin will write the name or if the system automatically crates a name) POSSIBILITY TO DELETE A STORE In this case all the data and the correspondant database and db user will be deleted Meaning of State of the STORE: the Super Admin can set a store Active or Inactive If a store is Active, all the users and admin can use the software without problems. If a store is Not Active, at the login, the admin and the users will receive a message: Store not active, please contact the administrator (in italian language: “Negozio non attivo, contattare l’Amministratore”). —————————————————————————————————————————————————————————————— STEP 3) DIGITAL CARDS From the system the Administrator and the Users can click on a button (present in the cusomer page) to send an email to the member. The user will receive an email containing the following informations: - A text that we will decide - A pdf containing the digital card (with Our Logo, name, surname, Company name, Card number, Barcode in code39). ———————————————————————————————————————————————————————————————