#

PHP Keyword/ phrase

Explanation

Example

Chapter 8

i.e.

<?php … ?>

The PhP tags allow for code within the tags to be interpreted and executed, while any PHP code outside the tags will not work

<?php

     echo ”Hello World!”

?>

1

#              AND

/* … */

2

$

3

define(name,value)

4

echo

5

include        AND

include_once

6

require        AND

require_once

7

if…else AND if…elseif

8

switch…case

9

while          AND

do…while

10

for

11

function

Chapter 9

12

array()

• Simple
• Associative
• Multidimensional

13

foreach

Chapter 10

14

class {}

15

$this à property

16

private

17

extends

#

SQL Keyword/ phrase

Explanation

Example

i.e.

AS

The SQL keyword AS is used when creating a column alias to rename column headings.  The alias follows immediately after the original column name and before the new column name.

SELECT ID AS "Student ID",

Status AS "Class Status"

FROM student_table;

18

CREATE TABLE

19

ALTER TABLE

20

MODIFY/ CHANGE

21

INSERT

22

UPDATE

23

DELETE

24

DROP TABLE

25

SELECT…WHERE

26

ORDER BY

27

COUNT()

28

SUM()/ AVG ()

29

MIN()/ MAX()

30

GROUP BY          AND

GROUP BY…HAVING