Exam2 review Website management and Construction
Which is an example of a commented line of code in HTML
<!-- this is a test -->
What is the Reset Button?
Is used to clear or reset the values all the form elements to their default or initial state <input type="reset" value= "Reset">
How to login to Mysql
mysql -u fall23_msanc445 -p
Connect to Mysql
$connection = mysqli_connect("ocelot.aul.fiu.edu","fall23_msanc445","6207084","fall23_msanc445");
Which is an example of a commented line of code in PHP
/*this is a test*/
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 is the name of the folder to place all your programs and folders for your website, used in this class.
public_html
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 the Putty program do, as learned in this class.
Allows you to have full remote control of your FIU server, as a user
Input Fields diffrent types and how to name it and its values
1. Text input: <input type = "text"> 2. CheckBox: <input type= "checkbox"> 3. Radio Buttons <input type="radio"> 4. Textarea: <textarea> </textarea> 5. Drop Down: <Select name = "Amount" style = widrh <option value="1" >1 </option> <option value="2" >2 </option> </Select>
How is HTML divided and in how many sections
1.Document Type Declaration (<!DOCTYPE html>) 2.HTML Element (<html>): 3.Head Section (<head>): 4.Title (<title>): 5. Body Section (<body>): 6.Lists (<ul>, <ol>, <li>) 7.Tables (<table>, <tr>, <td>, <th>): 8.Forms (<form>):
Brake comands... When and how they are used?
<br> tag is an empty tag (meaning it doesn't have a closing tag) that forces a line break in the content.
Name the three main opening tags of the dropdown menu used in program 2
<li> <ul> <nav>
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>
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>
What is the purpose of the code in Controller2.php
To Receive all information from the calling pages and process such data
Is WINSCP same as FileZilla
both are FTP clients(File Transfer Protocol) Winscp is designed to work with Wine and Linux
Chmod 755 (Change mode)
gives access and permisiones
What is $_POST? (PhP
is like a storage box where the server collects information that a user submits throught a form data
What is the command in the <form> tag to send hidden data
method="post"
How to pull data from the front end
HTLM cant do it so the use of javascript can
Write the code for a textarea input box as done in program
<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>
How to do Titles
<title>tomeyAcontactMe</title>
Creating a Table in mysql
$sql = "CREATE TABLE ".$tableName."( Telephone VARCHAR(20) NOT NULL, PRIMARY KEY(Telephone ), Email VARCHAR(20), LastName VARCHAR(20), FirstName VARCHAR(20), Address VARCHAR(20), City VARCHAR(20), State VARCHAR(20), Country VARCHAR(20), Zip VARCHAR(20), comments VARCHAR(200), Pets VARCHAR(7), coffee VARCHAR(5), IT VARCHAR(2), CS VARCHAR(2), Robotics VARCHAR(8), Cyber VARCHAR(5) )";
Difference between Radios and Checkboxes
1. Radio Buttons: are sed when you want the user to make a single selection from a set of options 2. CheckBoxes: allow users to make multiple selections from a set of options
Commands to Modify,Save, Delete using mysql
1. Modify:$found = $_POST['found']; if ( ( strlen(trim($found)) > 0 ) && ($found == $Telephone) ) { $query = "UPDATE customers 2. Save: $Telephone=trim($Telephone); if(strlen($Telephone)>0) { $sql="INSERT INTO customers 3. Delete:
Multiple Languages .. How to do comments in Single and Multiple Lines
1. Single Line Coments: In html: <!-- This is a comment --> In CSS. /* This is a comment */ In JavaScript: // This is a comment 2. Multiple Lines Comment In CSS and Javacript: /*This is a comment */
How to write the code for inserting Images...
<center> <a href="https://www.aquariumcoop.com/blogs/aquarium/angelfish-care-guide"> <img src="../images/angelfish.jpeg" alt="FIU School of Computing & Information Sciences" width="250" height="250" border=4 /> </a> <a href="https://www.ratemyfishtank.com/blog/everything-you-need-to-know-about-freshwater-angelfish"> <img src="../images/angelfish2.jpeg" alt="FIU School of Computing & Information Sciences" width="250" height="250" border=4 /> </a> </center>
How to code Horizontal and vertically centered...
<center> <br><br> <font size= "3" face="" color=red> we are </font> <p> <font size="8" face="" color=red> Hey </font> </p> <font size= "7" face="" color=red> we are </font> <p> <font size="10" face="" color=red> Hey </font> </p> </center>
nside 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">
Centered Name
<header> <center><font size="11" face="Arial" color= red> Moises Sanchez</font></center> </header>
Which of the following clears the Front End data as done in Program2
<input name="clear" type="reset" value"ClearScreen">
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 two radio buttons as done in program 2.
<input type="radio" name="Coffee" value="American" > American <input type="radio" name="Coffee" value="Instant"> Instant
What does Filezilla do?
Changes the access.. transfer files from the computer to ocelot server and back
The purpose of the Controller3
Conecting to mysql to input the information to the given place in the table while follwing its guidelines
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 what Operating systems does FilleZilla work in?
Main ones: 1. Windows 2.Linux 3. MacOs
In which operating system(s) does FILEZILLA work, as learned in this class.
Most current Operating Systems.
In What operating system does FileZilla
Most current operating Systems
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 <form> tag, as done in program 2
To sent data to a program being called by it, after creating all fields in it
Another Name for Tables
Two Dimensional Arrays
In which operating system(s) does PUTTY work, as learned in this class.
Various current Operating Systems.
What is the Submit Button
When clicked the submit button the form is sent to the server, and the servercan then process to from data < input type = "Submit" name="Submit" value= Submit>
In which operating system(s) does WINSCP work, as learned in this class.
Windows
How were we required to display the Front End labels and data from Program2.php on Controller2.php
echo Telephone $Telephone."<br>";
PHP if Statements and in Java / call dunction in Javascript
if ($condition) { // Code to be executed if the condition is true echo "Condition is true"; } else { // Code to be executed if the condition is false echo "Condition is false"; } ?>
Find out which submit button was pressed, as done in Controller2.php 1.if( 'anyButtonName' ) { echo 'You pressed the anyButtonName'; } 2.if( echo 'anyButtonName' ) { echo 'You pressed the anyButtonName'; } 3.if( $_post'anyButtonName' ) { echo 'You pressed the $anyButtonName'; } 4. if( $_POST['anyButtonName']) { echo 'You pressed the anyButtonName'; }
if( $_POST['anyButtonName']) { echo 'You pressed the anyButtonName'; }
What is the purpose of the "TextArea"
is used to create multiline text input field allowing users to input larger amounts of text The(rows) and (Col) attributes determine the initial size of the textarea
In Ubuntu, what will this code do: ../../../chmod * 755
it will give us an error
