intermediate web programming pre final

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/28

encourage image

There's no tags or description

Looks like no tags are added yet.

29 Terms

1
New cards

Class

A template for objects; begins with the class keyword followed by a valid class name and curly braces enclosing properties and methods.

2
New cards

Object

An instance of a class created using the new keyword, sharing the class's properties and methods while holding distinct values.

3
New cards

Properties

Variables defined within a class.

4
New cards

Methods

Functions defined within a class.

5
New cards

$this keyword

Refers to the current object and is only available inside class methods.

6
New cards

new keyword

Used to create an instance/object of a class.

7
New cards

Form

A document section containing interactive controls for collecting user input, created using the

element.

8
New cards

action attribute

Specifies the URL that processes the form submission.

9
New cards

method attribute

Specifies the HTTP method (such as POST or GET) used for submitting the form.

10
New cards

POST method

An HTTP form submission method where sent data is invisible to others.

11
New cards

GET method

An HTTP form submission method where sent data is visible to everyone in the URL.

12
New cards

MySQL

A server-based database system commonly used on the web that supports standard SQL and is developed by Oracle Corporation.

13
New cards

Database Connection

A communication pipeline between a database management system (DBMS) and an application program.

14
New cards

mysqli_connect()

A PHP function used to open a connection to a MySQL database server using hostname, username, password, and optional database name.

15
New cards

mysqli_close()

A PHP function used to manually close an open MySQL database connection before the script ends.

16
New cards

CREATE DATABASE statement

An SQL statement used in MySQL to create a new database (requires admin privileges).

17
New cards

CREATE TABLE statement

An SQL statement used to create a new database table consisting of columns and rows.

18
New cards

NOT NULL attribute

A column attribute ensuring that each row must contain a value and null values are not allowed.

19
New cards

DEFAULT VALUE attribute

A column attribute that sets a default value when no other value is passed.

20
New cards

UNSIGNED attribute

A column attribute for number types that limits stored data to positive numbers and zero.

21
New cards

AUTO_INCREMENT attribute

A column attribute that automatically increases the field's value by 1 each time a new record is added.

22
New cards

PRIMARY KEY attribute

A column attribute used to uniquely identify each row in a table.

23
New cards

SELECT statement

An SQL statement used to retrieve data from one or more database tables.

24
New cards

mysqli_num_rows()

A PHP function that checks the number of rows returned by a query result.

25
New cards

mysqli_fetch_assoc()

A PHP function that fetches a result row as an associative array.

26
New cards

INSERT INTO statement

An SQL statement used to add new records to a MySQL table.

27
New cards

DELETE statement

An SQL statement used to remove existing records from a table, typically filtered with a WHERE clause.

28
New cards

WHERE clause

An SQL clause used to specify which exact record or records should be affected by a DELETE or UPDATE statement.

29
New cards

UPDATE statement

An SQL statement used to modify existing records in a MySQL table.