Break

Hi, this is what I did during the break of PFD, continuing on the project, I installed XAMPP which is a integrated suite of Apache, MySQL (MariaDB), and PHP on board, which I used to develop the API for the project. Ideally, I would love to set up nginx, PHP and ASP.NET core on the cloud instance. Allowing for the use of forwarding traffic and all, to the different aspects, API and admin panel.

Firstly, me and my team met up, and converted the completed Microsoft SQL Server database into a MySQL database, and helping them install the ADO.NET connector for MySQL on their NuGet in the ASP.NET Project. After that, I went onto develop the PHP API, where basically the connection PHP file is in another directory which is not /var/www/html, to avoid credential leakage. Next is using some code samples online to make it easier to talk to the MySQL database, and using Prepared Statements (to avoid SQL Injection). Next, is to do some exception handling to try and kill the server (so that malicious users) cannot break in so easily, via errors and such. Ensure that they are sending proper JSON, and having correct fields, only after that, it will push to the MySQL database, Ideally, I would want some Authentication via JWT (Json Web Tokens), and use of Transactions in Database (to not conflict with the Admin side). And only push when it is safe. This will be done after the break (as well as HTTPS with certificates). For the retrieving of data, it will also use POST, which the Pi will send the ID's to the respectively endpoints, either retrieving a number ID, or a JSON for Python to parse into a Dictionary.