My phpMyAdmin experience

So PHP(Hypertext Preprocessor) is an open source scripting language that executes scripts on the server and is best suited for web development. I managed to get a taste of PHP when I got my hands on phpMyAdmin, which is a free software tool written in PHP which is meant to handle the administration of MySQL over the web, and to me it was pretty much similar to pgAdmin. In order to get started with phpMyAdmin, I had to download and install Xampp which became my web server. With Xampp running, I was then able to create my database (fgs) which had a 'healthsites' table that I inserted data into using the code for every healthsite with its own inputs (e.g. INSERT INTO healthsites (id_, h_name, pop_served, vaccines_allocated) VALUES ('1','Mahube Valley Pharmacy', '10451', '0');)

). This database was meant to store all weighted vaccine distributions across Mamelodi’s healthsites when a user enters the number of vaccines bought from the vaccine supplier, by using PHP code.

I got to make the Mamelodi Vaccine Calculator which unfortunately did not calculate the values properly, and was later told SQL could have been written in order to calculate values. When I got stuck, my teammate Nic was able to get the PHP code and database running using pgAdmin which was deemed the way to go since the localhost was on the web, and not only on our computers which would have made it difficult for our work to be accessed by important and interested parties. Below is my PHP product I was able to come up with and the code can be obtained from our GitHub account https://github.com/geo-classroom/group-project-frontline-gis-solutions: