exam 2

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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 &nbsp; </td>

How do you display right justified input fields on Program 3

<td style="width: 5%; text-align: right;">Telephone &nbsp; </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*/


Set pelajaran terkait

WH 20-1 Spain Builds an American Empire

View Set

SLS-1261 M6A3 Quiz | Chapters 11, 12 and 13

View Set

Unit 2 Information Systems Management C724 WGU

View Set

AGEC 330 all post test questions

View Set

Demography: The Study of Population

View Set