CGS4854: Website Construction and Management: Exam 1/2
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
How did you send your email in program 3
mail($to, $subject, $body);
What is the command in the <form> tag to send hidden data
method="post"
Write the code to connect and have full access to your mySql
mysql -h ocelot.aul.fiu.edu -u username -p
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
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*/
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) )";
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 modify a record
"UPDATE customers SET one ='$one', three = '$three' WHERE Email = '$Email'";
How do you extract data from you Program2.php Front End
$Telephone = $_POST['Telephone'];
What is inline CSS3 code
*should be correct* CSS3 code located in the body section overriding internal CSS3 code
----- EXAM 1 -----
----- START HERE -----
----- EXAM 2 -----
----- START HERE -----
Which is an example of a commented line of code in PHP
/*this is a test*/
Which is an example of commented line of code in CSS3
/*this is a test*/
Which is an example of a single commented line of code in PHP
//this is a test
Which is an example of a commented line of code in HTML5
<!-- this is a test -->
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
<nav> <ul> <li> <a href="page1">page1</a> <a href="page2">page2</a> </li> </ul> </nav>
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>
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>
How do you display right justified input fields on Program 3?
<td style="width: 5%; text-align: right;">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. Example 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: <center><a href="includes/page1.html">page 1 <a href="includes/page2.html">page 2</a></center>
Displays page 1 page 2 horizontally centered
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
What is the location of the index.html file, as learned in this class.
In the first level of the public_html folder.
in Ubuntu, 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 are proportional fonts
They use varying widths to display each of its letters and symbols
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 DOCTYPE html, as learned in this class.
To inform the browers 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 contact_me program in program 3
To send data to the Contact_me_Controller.php
What is the purpose of the <form> tag, ad done in program 2
To sent 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.
IN Linux, what will this code do: ../../../chmod * 755
it will give us an error
In terminal, how do you connect to a database named webDB
connect webDB;
In terminal, how do you delete a table
drop tablename;
How were we required to display the Front End labels and data from Program2.php con 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
Which command tell us that we are using HTML5
<!DOCTYPE html>
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>
Assume that you are at the directory/folder were the index.html file is located. Using a hyperlink name page 3, call the program located at includes/page3.html
<a href="includes/page3.html">page3</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.
<form method="post" action="includes/page3">
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 as done in Program2
<input name="clear" type="reset" value"ClearScreen">
Which of the following clears the Front End data as done in Program3
<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
Write the code to create a checkbox input box as done in program 3
<input type="checkbox" name="CS"
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 is internal CSS3 code
CSS3 code located in the head section