Module #10

 


 

website link - tericiar.infinityfree.me/module4.php

In this module, I learned how to connect PHP to a MySQL database and insert data from an HTML form into a database table. At first, it seemed a little tricky because you have to make sure your PHP script can actually “talk” to the database, but once I got the hang of it, it started making sense.

We started by creating a table in MySQL using phpMyAdmin. I set up columns for first name, last name, and email so that when someone fills out the form, their information has a place to go. Then, I created a simple HTML form where users can type in their information. The form uses the POST method to send the data, which is important because it keeps the information secure and organized.

The really interesting part was writing the PHP script to handle the form data. I used the $_POST superglobal to grab the data from the form and then used an SQL INSERT statement to put it into my MySQL table. I also learned that connecting to the database requires the correct server name, username, password, and database name. One mistake in those details can cause the connection to fail, so you have to be careful.

By the end of the module, I was able to submit the form and see the new records appear in my database. It felt really satisfying to see it all working together because it’s a real example of how websites store and manage information. Overall, this module gave me a much better understanding of how PHP and MySQL work together to create dynamic web applications, and I’m excited to use this skill in future projects.


Comments

Post a Comment

Popular posts from this blog

My Website Wireframe & Design Process

Image
For my website wireframe, I used Canva to create a simple, clean layout that focuses on clarity and user-friendly navigation. The wireframe is structured into three main sections: header/logo , main content , and footer . Header / Logo: At the very top, I included a header box for my website name. This is the first thing visitors see, so I wanted it to clearly establish the brand. I also placed navigation links directly below the header to make it easy for users to move between different parts of the site. Main Content: The main content area contains three boxes. The first box is a welcome message , where I introduce myself and give visitors a friendly, approachable introduction to the site. The second box is a contact form link , providing users with a clear way to reach out to me. The third box is for a gallery display or additional content, giving visitors more interactive or visual elements to explore. The vertical arrangement makes it easy for users to scroll and digest the inf...
Read more

Module 4 Assignment

Image
Module 4 Assignment 1. JavaScript If Else Condition For this assignment, I created my own customized if-else condition using JavaScript. The goal was to display a message based on how many hours someone studied. This script checks the value of studyHours and displays a different message depending on whether the condition is true or false. I chose this example because it felt relatable and easy to understand, and it helped me see how if-else statements can be used to make decisions in a program. My First Website   Reflection: Creating the if-else condition was easier than I expected once I understood the logic behind it. The easiest part was deciding what condition to check and writing the messages that would display on the page. The harder part was making sure the syntax was correct, especially remembering where the curly braces go and how the if-else structure is supposed to be written. 2. The original code had an issue with the if-else statement structure. The problem was that t...
Read more

Module #9 Assignment

Image
  Creating My First MySQL Table For this assignment, I created my first MySQL table using InfinityFree and phpMyAdmin. The process had three main steps: creating the database, designing the table, and inserting data. Step 1: Create a New Database I started by logging into InfinityFree and opening cPanel. I clicked “Create New MySQL Database”, gave it a name, and saved it. This step was pretty easy since the interface guided me through it. The only slightly confusing part was understanding that the database is just a container for the tables I’ll create. Step 2: Design the Table Next, I opened phpMyAdmin and selected my database. I created a new table called MyFirstTable with three columns: FirstName, LastName, and Age. I chose VARCHAR for the name columns and INT for age. This step was a bit tricky because I had to decide which data type to use for each column, but once I understood INT vs VARCHAR, it made sense. Step 3: Insert Data Finally, I clicked the Insert tab in phpM...
Read more