CPSC 431, Database and Applications, PHP, MySQL, Midterm

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

nl2br

Inserts HTML line breaks before all newlines in a string

implode

Join array elements with a string

what is str_replace?

This function returns a string or an array with the replaced values.

Are variables case sensitive?

True

Can there be more than 1 column in a primary key?

True

What is first step when querying a db from the web?

Validate user input

Is PHP case sensitive?

Variable names are case-sensitive but function names are not case sensitive

What is the function to create an array?

array()

what is ksort?

ascending order, according to key $list=array("key1"=>"value1");

what is asort?

ascending order, according to value$list=array("key1"=>"value1");

sort function sorts in what order?

ascending order, sort($list)

==

compare values

===

compares values and type

rsort functions sorts what order?

descending order, rsort($list)

What is @ used for? Use foo

error supression @foo

What can a PHP function contain

letters, digits, underscores

Is the default pass by value or pass by reference?

pass by value

What is the default access modifier?

public

What is the difference between require and include?

require generates an error if the file doesn't exist and include just warns if the file doesn't exists.

What are the sort functions?

sort, rsort, asort, ksort

sort

sorts an array

strtr, Hilla Warld -> Hello World

strtr("Hilla Warld", "ia", "eo");

Which quotation allows for string interpolation?

"

What is a try catch for?

For handling exceptions

chop

Alias of rtrim()

What is an update anomaly?

An update anomaly is a data inconsistency that results from data redundancy and a partial update.

Are functions case sensitive?

False

substr_compare

Compares two strings from a specified start position

CIA

Confidentiality, Integrity, Availability

htmlentities

Convert all applicable characters to HTML entities

htmlspecialchars

Convert special characters to HTML entities

strtoupper

Converts a string to uppercase letters

What does DSN stand for?

Data Source Name

preg_replace

Perform a regular expression search and replace

substr

Returns a part of a string

sort order flags

SORT_REGULAR - compare items normally SORT_NUMERIC - compare items numerically SORT_STRING - compare items as strings SORT_LOCALE_STRING - compare items as strings, based on the current locale. SORT_NATURAL - compare items as strings using "natural ordering" SORT_FLAG_CASE - can be combined (bitwise OR) with SORT_STRING or SORT_NATURAL to sort strings case-insensitively

What is wrong with this? select col1 from foo where $searchType = '$searchterm'

SQL injection attack

auto_prepend_file

Specifies the name of a file that is automatically parsed after the main file. The file is included as if it was called with the require function.

explode

Split a string by a string

datatypes

String Integer Float Boolean Array Object Resource Callable

strip_tags

Strip HTML and PHP tags from a string


संबंधित स्टडी सेट्स

The People/Dates/Events for AP World

View Set

3.08 Unit Test : Algebraic Sense

View Set

Principle of Management Unit 2 Test

View Set

Early Documents that Influenced the Constitution

View Set