top of page

SQL

PHP website linked with SQL database
 

I made a website using PHP to link to a database i created in mySQL, in the website there is the possibility to add information to certain tables (first block). Use a link to move a certain row from one table to another.

Display the contents of a table.

Delete certain rows from a table.

Find things in the database based on a keyword in a dropdown (find all food with a certain magic level, the dropdown containing all different magic levels that exist in the database.)
All these operations were created with parametrisation to stop SQL-injections.

image.png

.NET C# website linked with SQL database
 

This was basically the same website as described above but it was created using .NET C# and MVC, so all code was divided into the proper category and linked together to adhere to the MVC architecture.

bottom of page