exam 2
How do you extract data from your Program3.php Front End
$Telephone = $_POST['Telephone'];
What is the purpose of the controller3.php page, as done in program 3
To process the input of the program3.php front end
Write the code to connect and have full access to your mySql
mysql -h ocelot.aul.fiu.edu -u username -p
Write the code to save a record containing the following fields: Email as the primary key not accepting empty fields of length 20 and 1 textarea input field called one
"INSERT INTO customers ( Email, one ) VALUES( '$Email', '$one' )";
How to find a record as we've done in program 3
"SELECT * FROM customers where Telephone = '$Telephone'";
How to modify a record as done in program 3
"UPDATE customers SET Email = '$Email', LastName = '$LastName' WHERE Telephone = '$Telephone'";
Write the code to modify a record
"UPDATE customers SET one = '$one', three = '$three' WHERE Email = '$Email'"
How to clear a record as we've done in program 3
$Telephone = ""; $found = "";
Write the code to connect to a database called WebDB using PHP
$db_selected = mysqli_select_db( $connection, "WebDB" );
How to save a record as we've done in program 3
$sql="INSERT INTO customers (Telephone, Email ) VALUES ('$Telephone', '$Email' )";
What is the purpose of the code in controller3.php
To Receive all information from the calling pages and process such data
What's mysqli_connect for?
To connect a MySQL sever
Which is an example of a single commented line of code in mySql
/*this is a test*/
Write the code to modify a record
"UPDATE customers SET one = '$one', three = '$three' WHERE Email = '$Email'";
Create a sql table with two fields, Primary key and NOT NULL? "
"CREATE TABLE ".$tableName."( Telephone VARCHAR(10) NOT NULL, PRIMARY KEY(Telephone), Email VARCHAR(10) )";
Write the code to create a mySql table with a NOT NULL primary key, any names are ok
"CREATE TABLE ".$tableName."( Email VARCHAR(20) NOT NULL, PRIMARY KEY(Email) )";
How to delete a record as we've done in program 3
"DELETE FROM customers WHERE Telephone='$Telephone'";
Write the code from delete.php program, as done in program 3
"DELETE FROM customers WHERE Telephone='$Telephone'";
Which of the following clears the Front End data as done in Program3
<input name="clear" type="submit" value"Clear">
Write the code for a dropdown input as done in program 2
<select name="Age" style="width: 100%;" size="1";> <option value="Under_200">Under 200</option>
How do you display left justified input fields on Program 3
<td style="width: 5%; text-align: left;">Telephone </td>
How do you display right justified input fields on Program 3
<td style="width: 5%; text-align: right;">Telephone </td>
What is the internal CSS3 code
CSS3 code located in the head section
What's mysqli_select_db for?
To select database
How were we required to display the Front End labels and data from Program3.php on Controller3.php
echo Telephone $Telephone."";
Find out which submit button was pressed, as done in Controller2.php
if( $_POST['anyButtonName']) { echo 'You pressed the anyButtonName'; } if( $_POST['anyButtonName']) { echo 'You pressed the anyButtonName'; }
What is the command in the tag to send hidden data
method= "post"
Create one input text field named telephone as we've done in program 3
wdwd
Which is an example of a single commented line of code in CSS3
/*this is a test*/