1/28
Looks like no tags are added yet.
Class
A template for objects; begins with the class keyword followed by a valid class name and curly braces enclosing properties and methods.
Object
An instance of a class created using the new keyword, sharing the class's properties and methods while holding distinct values.
Properties
Variables defined within a class.
Methods
Functions defined within a class.
$this keyword
Refers to the current object and is only available inside class methods.
new keyword
Used to create an instance/object of a class.
Form
A document section containing interactive controls for collecting user input, created using the
action attribute
Specifies the URL that processes the form submission.
method attribute
Specifies the HTTP method (such as POST or GET) used for submitting the form.
POST method
An HTTP form submission method where sent data is invisible to others.
GET method
An HTTP form submission method where sent data is visible to everyone in the URL.
MySQL
A server-based database system commonly used on the web that supports standard SQL and is developed by Oracle Corporation.
Database Connection
A communication pipeline between a database management system (DBMS) and an application program.
mysqli_connect()
A PHP function used to open a connection to a MySQL database server using hostname, username, password, and optional database name.
mysqli_close()
A PHP function used to manually close an open MySQL database connection before the script ends.
CREATE DATABASE statement
An SQL statement used in MySQL to create a new database (requires admin privileges).
CREATE TABLE statement
An SQL statement used to create a new database table consisting of columns and rows.
NOT NULL attribute
A column attribute ensuring that each row must contain a value and null values are not allowed.
DEFAULT VALUE attribute
A column attribute that sets a default value when no other value is passed.
UNSIGNED attribute
A column attribute for number types that limits stored data to positive numbers and zero.
AUTO_INCREMENT attribute
A column attribute that automatically increases the field's value by 1 each time a new record is added.
PRIMARY KEY attribute
A column attribute used to uniquely identify each row in a table.
SELECT statement
An SQL statement used to retrieve data from one or more database tables.
mysqli_num_rows()
A PHP function that checks the number of rows returned by a query result.
mysqli_fetch_assoc()
A PHP function that fetches a result row as an associative array.
INSERT INTO statement
An SQL statement used to add new records to a MySQL table.
DELETE statement
An SQL statement used to remove existing records from a table, typically filtered with a WHERE clause.
WHERE clause
An SQL clause used to specify which exact record or records should be affected by a DELETE or UPDATE statement.
UPDATE statement
An SQL statement used to modify existing records in a MySQL table.