PHP and MySQL

PHP (Hypertext Preprocessor)

An open-source scripting language used to create dynamic web pages and can be embedded in HTML.

MySQL

An open-source relational database management system used to store and manage data.

echo

A PHP statement used to output text to the browser.

mysqli

A PHP extension used to connect and interact with a MySQL database.

Connection (Database)

The process of linking PHP to a MySQL database using credentials.

$conn

A variable commonly used to store the database connection object.

connect_error

A property used to check if there is an error in the database connection.

die()

A PHP function that stops script execution and displays a message.

SQL (Structured Query Language)

A language used to communicate with and manage databases.

CRUD Operations

Basic database operations: Create, Read, Update, and Delete

INSERT

An SQL command used to add new records into a table.

SELECT

An SQL command used to retrieve data from a database.

query()

A method used to execute SQL statements in MySQL using PHP.

TRUE

A boolean value indicating a successful operation.

$sql

A variable used to store an SQL query statement.

num_rows

A property used to check the number of rows returned by a query.

fetch_assoc()

A method used to fetch a result row as an associative array.

$row

A variable used to store a single row of data from the database.

while loop (PHP)

A loop used to repeatedly execute code while a condition is true.

Form Handling

The process of collecting and processing user input using PHP.

Validation

Ensuring that user input is correct and complete.

Sanitization

Cleaning user input to prevent security risks.

Session

A way to store user data across multiple pages.

SQL Injection

A security vulnerability where malicious SQL code is inserted into queries.

XSS (Cross-Site Scripting)

A security vulnerability where malicious scripts are injected into web pages.

Prepared Statements

A secure way of executing SQL queries to prevent SQL injection.

File Uploads

The process of sending files from a user to the server using PHP.