chapter 1 Flashcards
clients use
web browsers to request web pages from web server
Lan
connects computers that are near each other
http sends a request to
the webserver that includes name of requested file
a static webpage is a
page that is the same each time it is retrieved
a dynamic webpage is generated by a
server side program or script
HTTP request that lead to php scripts are
processed by PHP interpreter
HTML is
the language that defines the structure and contents of a webpage
==
equal
!=
not equal
<=
less than or equal
===
identical
!==
not identical
&&, ! and || are all
logical operators
php provides six data types including
integer, double,boolean and string
to concatenate two strings you use
. the concatenation operator
to get data from a form theat has been submitted you use
either $_GET or $_POST
if statements provide
the logic of an application
while loop excutes a
block of code as long as the condition is TRUE
you can use what to check if values exist
filter_input()
a relational database
consists of tables in rows and columns
the tables in a relational database are related through
foreign keys
each colmun in a database is defined with a
data type
the SELECT statement in sql
returns data from two or more tables
an inner join
returns a set of that includes data only
GRANT
grants permission to user
an outer join returns
rows from one table in the join even
left outer join
returns data from for all rows in the first table only if the data for matching rows are included
an exception is an
object that contains information about an error
to code an object in a class you code the
new keyword and the name of the class and set of parentheses
to get an array for all rows in a result set you can
call the fetch () method of the PDOstatement
an array can store
one or more elements
you code arguments required by the method by
seperating multiple arguments with commas
when coding relaitive URLs you can begin the URL with a
single . (dot)
to set parameter values and excute an sql statement you use
bindValue and execute() methods
to loop through elements in an array you can use
a foreeach statement to define a foreach loop
to handle exceptions you use
try/catch statement
the MVC model view controller is commonly used to
structure web apps that have processing requirements.
the model consists of the
php files that work with the data
the view consists of
of the HTML
the controller consists of the
PHP files that get request