CGS4854- Final Exam Review
How do you extract data from your Program2.php Front End
$Telephone = $_POST['Telephone'];
What does this code do: <center><a href="includes/page1.html">page 1 <a href="includes/page2.html">page 2</a></center>
Displays page 1 page 2 horizontally centered
Write a html program that will have the two main parts in html, as learned in this class
<html> <head> </head> <body> </body> </html>
Which of the following clears the Front End data in Program 2?
<input name="clear" type="reset" value"ClearScreen">
Which of the following clears the front end data as done in Program 3
<input name="clear" type="submit" value"Clear">
Write the code to create two checkboxes input box as done in program 2
<input type="checkbox" name="IT" value="IT" > IT <input type="checkbox" name"CS" value="CS" > CS
Assume that you are at the directory/folder were (where) the index.html file is located. Using a hyperlink named page 3, call the program located at includes/page3.html
<a href="includes/page3.html">page 3</a>
Being inside the includes folder, create a CENTERED horizontal menu using hyperlinks for page4 and page3
<center> <a href="page4.html">page4</a> <a href="page3.html">page3</a> </center>
Display FIU is Great in green color, Ariel font and size 2, as done in program 1
<font color=green size=2 face=Ariel>FIU is Great</font>
Assume that you are in the same folder where the index file is found, create the heading of a form to call page3, located in the includes folder, passing its data, hidding (hiding/hidden?).
<form method="post" action="includes/page3">
Write the code to create two radio buttons as done in program 2.
<input type="radio" name="Coffee" value="American" > American <input type="radio" name="Coffee" value="Instant" > Instant
Create one input text field named telephone as done in program 2
<input type="text" name="telephone" value="">
Name the three main opening tags of the dropdown menu used in program 2
<li> <ul> <nav>
What does the Putty program do, as learned in this class.
Allows you to have full remote control of your FIU server, as a user
Write the code to create a mySQL table with a NOT NULL primary key, and names are ok
CREATE TABLE ".$tableName."(Email VARCHAR(20) NOT NULL, PRIMARY KEY(Email) )";
What is inline CSS3 code
CSS3 code located in the body section overriding internal CSS3 code
What is internal CSS3 code?
CSS3 code located in the head section?
How did you send your email in program 3
mail($to, $subject, $body);
Write the code to connect and have full access to your mySQL
mysql -h ocelot.aul.fiu.edu -u username -p
In terminal, how do you know the names of the databases you have
show databases;
In terminal, how do you find the names of the current tables
show tables from webDB;
In terminal, how do you connect to our class web server
Which is an example of a single commented line of code in mySQL
/*this is a test*/
Which command tells us that we are using HTML5?
<!DOCTYPE html>
Write the code from delete.php program, as done in program 3
"DELETE FROM customers WHERE Telephone='$Telephone'";
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')";
Write the code to connect to a database called WebDB using PHP
$db_selected = mysqli_select_db($connection , "WebDB");
Ignoring the row spacing, create a menu using the html, CSS3 learned in this class, in program 2, to display two (2) horizontal options/links, named page1 and page2.
(different in test- i added spacing) <nav> <ul> <li> <a href="page1">page1</a> <a href="page2">page2</a> </li> </ul> </nav>
Which is an example of a commented line of code in CSS3
/*this is a test*/
Which is an example of a commented line of code in PHP
/*this is a test*/ (/* it won't show the slash and star)
Which is an example of a single commented line of code in PHP
//this is a test
Write the code that will display an image called theGraph.png that when pressed, it will load the web page called fiu.edu
<a href="http://fiu.edu"> <img src="theGraph.png" /> </a>
Which is an example of a commented line of code in HTML 5?
<!-- this is a test -->
Create one table with one row and two columns as done in Program 2
<table> <tr> <td> </td> <td> </td> </tr> </table>
How do you display left justified input fields on Program 2
<td style="width: 5%; text-align: left;">Telephone </td>
Write the code for a textarea input box as done in program 2
<textarea name="SpecialNeeds" rows="5" cols="42"> any data </textarea>
In HTML, create a title with your first name, last name. EX: Joe Smith
<title>Joe Smith</title>
What does the FILEZILLA program do, as learned in this class.
Allows you to Create/Delete/Upload/Download folders/files to/from your FIU server
What does the WINSCP program do? As learned in this class
Allows you to Create/Delete/Upload/Download folders/files to/from your ocelot.aul.fiu.edu FIU server
What does this code do: <a href="includes/page1.html"><center>page 1</center></a> <a href="includes/page2.html"><center>page 2</center></a>
Displays page 1 page 2 vertically centered?
In Linux, what will this code do: ../../../chmod * 755
It will give us an error
In which operating system(s) does FILEZILLA work, as learned in this class
Most current Operating systems
In addition to HTML what other language was used to create our customer table in our website
PHP
What is the difference between paragraphs and breaks, as learned in this class.
Paragraphs terminate a text paragraph and adds an additional line at the end Breaks terminates a text line and moves the cursor to the next line.
What are proportional fonts
They use varying widths to display each of its letters and symbols
What is the purpose of DOCTYPE html, as learned in this class.
To inform the browsers that you are using HTML 5.
What is the purpose of the controller3.php page as done in program 3
To process the input of the program3.php front end
What is the purpose of the code in Controller2.php
To receive all information from the calling pages and process such data
What is the purpose of the code in controller3.php
To receive all information from the calling pages and process such data
What is the purpose of the <form> tag, as done in program 2?
To sent (send) data to a program being called by it, after creating all fields in it
In which operating system(s) does Putty work, as learned in this class
Various current operating systems
In which operating system(s) does WINSCP work, as learned in this class?
Windows
Program 3- mysql commands to know
create database dbName; show databases; use dbName; or connect dbName; drop database dbName; show tables; describe table tableName; drop table tableName;
How were we required to display the Front End labels and data from Program2.php on Controller2.php
echo Telephone $Telephone."<br>";
Write the code that finds out which button was pressed, use two buttons as an example
if ($_POST['Save'] { echo $Save ;} else if ($_POST['Find'] { echo 'Find'); }
Find out which submit button was pressed, as done in Controller2.php
if($_POST['anyButtonName']) { echo 'You pressed the anyButtonName';}
In ocelot.aul.fiu.edu, what is the name of the folder where you place all your programs and folders for your website, as learned in this class
public_html
In this class, what is the name of the folder to place all your programs and folders for your website.
public_html
