Community Information Systems 
Winter Quarter Refresher


What is a relational database?  What is its core thing? 


What is a relational database management system? 


What does "SQL" stand for?

How is SQL used?

What are MySQL's datatypes?


What are the rows in a table used  for?             What about the columns?


What SQL command would you use to put information in MySQL (make up an example) 


What SQL command would you use to retrieve information in MySQL (make up an example)


What's the difference between mysql and MySQL?


What is the basic model that underlies relational databases?


How does a web page transfer user supplied information to a program?


What are the two ways that we've studied for interacting with MySQL?


Assume a database of U. S. presidents.  Explain would this do...

SELECT last_name, first_name FROM  president WHERE death IS NULL. 


1)  What tags do we use to start and end a section of PHP code or a PHP
program?



2)  Circle the valid variable names below:

        $_MyVariableName#1      $MyVariableName2        $_____1______

        $1stVariable            $$NewVariable           $My Variable

    What is a variable?



3)  Fill in the results of the echo statements below:

        $MyMonth = "November";
        $MyBDay = 'My birthday is: $MyMonth';
        echo "$MyBDay\n";

        $YourMonth = "September";
        $YourBDay = "Your birthday is: $YourMonth";
        echo "$YourBDay\n";

4)  What do you call the items in 3 that are surrounded by either single     or double quotes?


5)  Fill in the symbols or strings used for the following operators:

    assignment operator  ______         multiplication operator  ______

    equals operator  _____      string concatenation operator    ______

    not equal operator  _____           AND logical operator _____

    error suppression  _____            execution operator  _____

6)  What are three types of conditional statements?


    Three types of iteration statements?



7)  What is an array?



    What is the difference between a numerically indexed array and an associative array?



    What are three functions to sort arrays?



    For that matter, what is a function?


8)  Given the following snippet of HTML code:

<form action="processform.php" method="post">
<input type="text" name="puppies" size="3">
</form>

What variable in the 'processform.php' program would contain the value of the 'puppies' field - if the register_globals PHP configuration directive is 'OFF'?


9)  What does the following code do?  There is a PHP function that can accomplish this in one line - what is it?


<?php

$variable1 = "This is a string";
$variable2 = "string";
$variable3 = "number";

$result = what($variable1, $variable2, $variable3);
print "$result\n";

function what ($string1, $string2, $string3)
{
        $strings = explode(" ",$string1);
        for ($i = 0; $i < count($strings); $i++)
        {
                if ($strings[$i] == $string2)
                {
                        $strings[$i] = $string3;
                }
        }
        return implode(" ",$strings);
}
?>

10)  Here's a challenge - figure out what the following does - without running it:


<?php $a=array("Lbzjoftt","Inqbujfodf",
"Hvcsjt"); $b= "Lbssz Wbmm"; $b =
`echo "$b" | tr b-z a-z`; $c = " Tif "
. count($a)." hsfbu wj" .
"suvft pg b qsphsbnnfs" . ":\n";
$c =`echo "$c" | tr b-y a-z`;
print "\n\n$c "; for ($i=0;$i<count($a);
$i++){$a[$i]=`echo "$a[$i]"|tr b-y a-z`;
if($a[$i]==end($a)){ print"and ".
rtrim($a[$i])."."; }else{ print
rtrim($a[$i]).", "; } }print
"\n\t\t--$b\n\n";