Drew's Blog

For Module 11, the focus was on understanding the requirements for our final project, which combines everything we’ve learned throughout the course. The goal is to design and create a website that promotes and supports a local charity or volunteer organization. The project includes two main parts: the public front-end , which focuses on layout, visuals, and user experience, and the administrative back-end , which handles the functionality, things like data collection and connecting to a MySQL database through PHP. At this stage, the professor asked us to review the project instructions and post any questions we might have. Many students mentioned the broken example link and asked about domain setup and the level of complexity expected for both the front-end and back-end. Personally, I don’t have any major questions, as the requirements seem pretty clear. I plan to continue using my existing InfinityFree domain and simply create a new section or page dedicated to the final project. Tha...

Link to my site:   http://drew-williams.infinityfree.me/Module10.html For this module, I connected my PHP code to my MySQL database on InfinityFree and used a basic HTML form to insert new records. The goal was to take data submitted from the form and insert it into the table I created in Module 9. I built a simple form that collects a user’s first and last name and sends it to a file called insert.php . Inside that file, I used PHP’s MySQLi extension to connect to the database. Once connected, I used a basic SQL statement to insert the form data into the users table. After uploading the files to my InfinityFree htdocs directory, I was able to submit data from the form and see the new record appear instantly inside phpMyAdmin. The easiest part was creating the form itself, the HTML side is always straightforward. The trickier part was confirming the exact credentials from InfinityFree (server name, username, password, and database name) since each one needs to match exactly. Once...