Php & Mysql

Front 1

What are PHP Arrays?

Back 1

An array in PHP is actually an ordered map. A map is a type that associates values to keys.

Front 2

What are some of the things that PHP files may contain?

Back 2

HTML, Text, and Script

Front 3

What is a Variable Scope?

Back 3

The term "scope" refers to the places within a script where a particular variable is visible.

Front 4

What does count() do?

Back 4

Count all elements in an array, or something in an object.

Front 5

What is an example of a count() array?

Back 5

<?php
$food = array('fruits' => array('orange', 'banana', 'apple'),
'veggie' => array('carrot', 'collard', 'pea'));

// recursive count
echo count($food, COUNT_RECURSIVE); // output 8

// normal count
echo count($food); // output 2

?>

Front 6

What does the sort() array do?

Back 6

This function sorts an array. Elements will be arranged from lowest to highest when this function has completed.

Front 7

What is an example of a sort() array?

Back 7

fruits[0] = apple
fruits[1] = banana
fruits[2] = lemon
fruits[3] = orange

Front 8

What does the asort() do?

Back 8

Sort an array and maintain index association.

Front 9

What is an example of a asort() array?

Back 9

<?php
$fruits = array("d" => "lemon", "a" => "orange", "b" => "banana", "c" => "apple");
asort($fruits);
foreach ($fruits as $key => $val) {
echo "$key = $val\n";
}
?>

Front 10

This is an example of what?

bool asort ( array &$array [, int $sort_flags = SORT_REGULAR ] )

Back 10

asort() array

Front 11

What does rsort() do?

Back 11

Sort an array in reverse order.

Front 12

What is this doing?

bool rsort ( array &$array [, int $sort_flags = SORT_REGULAR ] )

Back 12

This function sorts the array from highest to lowest.

Front 13

This is an example of what?

<?php
$fruits = array("lemon", "orange", "banana", "apple");
rsort($fruits);
foreach ($fruits as $key => $val) {
echo "$key = $val\n";
}
?>

Back 13

rsort() array

Front 14

What is the difference between asort() and rsort()?

Back 14

asort() maintains an index association where as rsort() sorts the arrays in reverse order.

Front 15

What does a PHP Loop do?

Back 15

It tells the PHP how many times to execute a block of code.

Front 16

How do you write a PHP Loop?

Back 16

for (init counter; test counter; increment counter)
{
code to be executed;
}

foreach ($array as $value)
{
code to be executed;
}

Front 17

What is an example of a Loop?

Back 17

<?php
for( $x=0; $x<=10; $x++;)
{
echo "The number is: $x <br>";
}
?>

Front 18

What is an example of a foreach Loop?

Back 18

<?php
$colors = array("red","green","blue","yellow");
foreach ($colors as $value)
{
echo "$value <br>";
}
?>

Front 19

What does trim() do?

Back 19

Removes whitespace or other characters from the left side of a string.

Front 20

What does addslashes() do?

Back 20

Returns a string with backslashes in front of predefined characters.

Front 21

What does explode() do?

Back 21

Breaks a string into an array.

Front 22

What does implode() do?

Back 22

Returns a string from the elements of an array.

Front 23

What is an alias of implode()?

Back 23

join()

Front 24

What does substr() do?

Back 24

Returns a part of a string.

Front 25

What are some other arrays related to substr()?

Back 25

substr_compare() : Compares two strings from a specified start position

substr_count() : Counts how many times a substring appears in a string

substr_replace() : Replaces a part of the string with another string

Front 26

What does strlen() do?

Back 26

Returns the length of a string.

Front 27

What does strpos() do?

Back 27

Returns the position of the first occurrence of a string inside another string.

Front 28

How do you specify a string?

Back 28

Using single quotes ' '

Front 29

What is the difference between require() and include()?

Back 29

Require will produce a fatal error (E_COMPILE_ERROR) and stop the script.

Include will only produce a warning (E_WARNING) and the script will continue

Front 30

When would you use require()?

Back 30

If you want to protect your code security, then use the require key to stop the flow pages.

Front 31

When would you use include()?

Back 31

When you want the pages to continue running with errors and all.

Front 32

Where do you find parameters in PHP?

Back 32

Parameters are specified after the function name, inside the parentheses.

Front 33

What is this an example of and why?

<?php
function ourFunction($x)
{
echo $x . ".<br />";
}

$y = “black”;
echo "My car color is ";
ourFunction("white");

echo "My car color is ";
ourFunction ("$y");
?>

Back 33

It is a parameter and it can be verified after the functions call about the cars.

Front 34

What does pass by reference mean?

Back 34

You can pass a variable by reference to a function so the function can modify the variable.

Front 35

What kind of things can be passed by reference?

Back 35

Variables, i.e. foo($a)

New statements, i.e. foo(new foobar())

References returned from functions, i.e.:

Front 36

When & is used in a pass by it means it is a ...

Back 36

Pass by Reference

Front 37

What does & mean when used in a pass by reference?

Back 37

It means that the original parameter must not be copied to a new variable. The parameter is referred inside the function by the reference

Front 38

What is Returning references?

Back 38

Returning by reference is useful when you want to use a function to find to which variable a reference should be bound.

Front 39

What are a list of superglobals?

Back 39

1/ $GLOBALS
2/ $_SERVER
3/ $_GET
4/ $_POST
5/ $_COOKIE
6/ $_FILES
7/ $_ENV
8/ $_REQUEST
9/ $_SESSION

Front 40

$_SERVER?

Back 40

Array of server environment variables.

Front 41

$_GET?

Back 41

Array of variables passed to the script via the GET method.

Front 42

$_POST

Back 42

Array of variables passed to the script via the POST method.

Front 43

$_COOKIE

Back 43

Array of cookie variables.

Front 44

$_FILES

Back 44

Array of variables related to file uploads.

Front 45

$_ENV

Back 45

Array of environment variables.

Front 46

$_REQUEST?

Back 46

Array of all user input including the contents of input including $_GET, $_POST, and $_COOKIE but not including $_FILES.

Front 47

$_SESSION

Back 47

Array of session variables.

Front 48

What are the 6 PHP Assignment Operators?

Back 48

=
+=
-=
*=
/=
%=

Front 49

What are the 7 PHP Arithmetic Operators?

Back 49

+ Addition
- Subtraction
* Multiplication
/ Division
% Modulus (division remainder)
++ Increment
-- Decrement

Front 50

What are the 6 PHP Comparison Operators?

Back 50

== (equal to)
!= (not equal)
> (greater than)
< (less than)
>= (greater than or equal to)
<= (less than or equal to)

Front 51

What are the 3 PHP Logical Operators?

Back 51

&& and
|| or
! not

Front 52

What is the syntax of an If...Else statement?

Back 52

if (condition)
code to be executed if condition is true;
else
code to be executed if condition is false;

Front 53

What is the syntax of an ElseIf statement?

Back 53

if (condition)
code to be executed if condition is true;
elseif (condition)
code to be executed if condition is true;
else
code to be executed if condition is false;

Front 54

What is the syntax for a basic Numeric Array?

Back 54

$example = array("Var1","Var2","Var3");

Front 55

What is the syntax for assigning the ID values manually in a Numeric Array?

Back 55

$example[0] = "Var1";
$example[1] = "Var2";
$example[2] = "Var3";

Front 56

What is the basic syntax for an Associative Array?

Back 56

$example = array("Var1"=>32, "Var2"=>30, "Var3"=>34);

Front 57

What is an example of a multidimensional array?

Back 57

$families = array
(
"Var1"=>array
(
"Sub1Var1",
"Sub1Var2",
"Sub1Var3"
),
"Var2"=>array
(
"Sub2Var1"
"Sub2Var2"
),
"Var3"=>array
(
"Sub3Var1",
"Sub3Var2",
"Sub3Var2"
)
);

Front 58

What does a multidimensional array include?

Back 58

In a multidimensional array, each element in the main array can also be an array. And each element in the sub-array can be an array, and so on.

Front 59

What does an Associative Array include?

Back 59

In an associative array, each ID key is associated with a value.

Front 60

The PHP $_REQUEST variable can be used to get the result from form data sent with both the ___ and ____ methods.

Back 60

$_GET and $_POST

Front 61

The PHP _________ variable contains the contents of both $_GET, $_POST, and $_COOKIE.

Back 61

$_REQUEST

Front 62

The ______ variable is used to collect values from a form with method="post".

Back 62

$_POST

Front 63

What does a comma operator do? (,)

Back 63

Separates function arguments and lists of items.

Front 64

Who is new -> operators used?

Back 64

Used to instantiate a class and access class members, respectively.

Front 65

A PHP scripting block always starts with _____ and ends with __.

Back 65

<?php

?>

Front 66

What is the syntax of a single-line comment in PHP? What is the syntax for a large comment block?

Back 66

// to make a single-line comment

/* and */ to make a large comment block

Front 67

All variables in PHP start with what symbol?

Back 67

$

Front 68

Variables may contain _______, _______, or ______.

Back 68

strings, numbers, or arrays