Module 10: Inserting Data into MySQL with PHP


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 the connection worked, everything else ran smoothly.

This assignment tied everything together, building the table in Module 9 and now connecting to it from PHP. It’s a small step toward dynamic web applications, where front-end forms actually feed data into a live database.

Comments

Post a Comment

Popular posts from this blog

Module 8: PHP Forms and GET vs POST

Link to my site:  http://drew-williams.infinityfree.me/Module8.html For this module, I created an HTML form that collects a user’s first name, last name, and email address. When the form is submitted, it sends the data to a PHP file on the server, which then displays the submitted information back on the page. I used the POST method for this form because it’s more secure and better suited for sending user input that shouldn’t be visible in the URL. I also reviewed the difference between $_GET and $_POST in PHP: $_GET sends data through the URL. You’ll see the variables appear in the query string, like  ?fname=Drew&lname=Williams . It’s fine for search queries or simple data you don’t mind being visible. $_POST sends the data in the body of the HTTP request, so it doesn’t appear in the URL. This makes it better for things like login forms or sensitive data. In my project, the PHP handler uses  $_POST  to grab each value, the...
Read more

Module 2: Introduction to HTML, CSS, and FTP

Here’s the link to my website:  https://drew-williams.infinityfree.me/index.html For this assignment, I created my very first homepage for the course using HTML and CSS and uploaded it to InfinityFree using FTP. At first, figuring out the FTP process felt a little tricky, But I had used it in the past for another course so it was really just a matter of seeing how much I could remember. Using VS Code to write my HTML and CSS was straightforward. I enjoyed giving the site a bit more style so it looked more like a real webpage, with a header, navigation links, and a footer. Creating the Module3.html page and adding a simple JavaScript script to display some text, was pretty simple. Overall, the hardest part was just making sure my files transferred correctly with FileZilla, but once I saw the site live, it felt really rewarding. Now I feel more confident about uploading changes and expanding the site in future modules.
Read more

Working with Datetime and Timedelta in Python

This week’s assignment focused on using the datetime and timedelta modules in Python. I practiced working with time-based objects, performing calculations, and combining date/time data with custom functions. Code Procedure: Simulated reading transaction data and displayed the item/cost with the current time using datetime.now() Used timedelta to subtract 60 seconds and add 2 years (730 days) to the current time. Created a timedelta object representing 100 days, 10 hours, and 13 minutes and printed the result. Wrote a function that takes 2 arguments (feet and inches) and prints them along with the current datetime. These exercises helped me better understand how Python handles time-based data and how to apply that to real-world scenarios. Code: from datetime import datetime, timedelta # 1. Display current time with item & cost sample_data = "2025-06-29\t11:23:00\tPublix\tMilk\t3.25\tCredit" data = sample_data.strip().split("\t") if len(data) == 6: ...
Read more