Section 1
Preview this deck
Write the code from find.php
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (73)
Section 1
(50 cards)
Write the code from find.php
<html> <body> <?php $sql="SELECT * FROM ".$tableName." where PKey='$PKey'"; if ($result=mysqli_query($connection,$sql)) { $rowCount=mysqli_num_rows($result); while( $row = mysqli_fetch_array( $result ) ) { $PKey = $row['PKey']; $LastName = $row['LastName']; } ?> </body> </html>
What language was used to display the login time and running time in program 4?
Javascript
What does this jsp code do?
<html> //open html <head> //open head <meta charset='utf-8'> //set character encoding to utf-8 <title>Initialized JSP</title> //set the title </head> //close head <body> //open body <form> //open simple form <p> //start paragraph This is a simple HTML page that has a form in it. <p> //start paragraph The hobby was received as: <strong>${param.hobby}</strong> //grab input from input named 'hobby' and bold it <p> //start paragraph Hobby: <input type='text' name='hobby' value='${param.hobby}'> //make a text field named 'hobby' that accepts and displays the string entered <input type='submit' name='confirmButton' value='Confirm'> //make a button named 'confirmButton' that will submit the value in 'hobby' </form> //close form </body> //close body </html> //close html
What is the purpose of the form tag?
To send all data in the current page, HIDDEN, to the page assigned to the action command
Write the code for two input fields that will display back data.
<input type="text" name="FirstName" value="<?php echo $FirstName >"> <input type="text" name="LastName" value="<?php echo $LastName ?>">
Write the code for loginTime
function loginTime() { var today = new Date(); var temp = "logged in at: " + today; document.write(temp); }
What does this xml code do?
<servlet> //starting a servlet <servlet-name> //open servlet name FirstController //name of program </servlet-name> //close servelt name <servlet-class> //starts servlet class ch2.servletController.Controller //class location on second storage </servlet-class> //closes servlet class </servlet> //ending of servlet <servlet-mapping> //start servlet mapping <servlet-name> //open servlet name FirstController //program name </servlet-name> //closes servlet name <url-pattern> //start url-pattern /ch2/servletController/Controller //what is the url-pattern </url-pattern> //closes url-mapping </servlet-mapping> //close servlet mapping
Write the code for a text area that will display back data.
<textarea name="area" rows="2" cols="22"><?php echo $area ?></textarea>
Write the code that will obtain hours, minutes, and seconds in currentTime
function currentTime() { var today = new Date(); var hour = today.getHours(); var min = today.getMinutes(); var sec = today.getSeconds(); }
Write the code for a placeholder
<input type="text" placeholder="First Name" name="FirstName" value="">
Write the code to extract and display data from a field named FirstName, keeping it hidden
$FirstName = $_POST['FirstName']; echo "First Name: ".$FirstName;
Write the code for tooltip in the body
<div class="tooltip"> Telephone <span class="tooltip">Enter telephone number</span> </div>
Write the code for about.php
<ul> <li> <a class="anyClassName">anyTopicName<br></a> any message can go here <li> <a class="anyClassName">anyTopicName<br></a> any message can go here </ul>
Write the code for help.php with one topic and description
var myWindow = window.open("", "Help", "width=400, height=600, scrollbars=yes, resizeable=yes, left=200, top=35"); myWindow.document.write("<font size=8><b>Save<br></b></font>"); myWindow.document.write("<font size=5> <p>Press this to save all the data entered in the fields, you must have at least a username entered.<br> </p> </font>");
What does cellspacing do in HTML
Cellspacing allows us to create spaces between the Adjacent cells
Create a table with one row, two columns, and in the center of the screen with a green frame/border size 1
<table align="center" borderColor="green" borderSize="1"> <tr> <td></td> <td></td> </tr> </table>
What language is used to create servlet?
Java
Write the opening and closing of a form that calls controller5.php, passing all data "hidden"
<form method="POST" action="controller5.php"> </form>
Create a menu with css3 to display two horizontal options
<nav> <ul><a href="page1.html">page1</a></ul> <ul><a href="page2.html">page2</a></ul> </nav>
Write the code from clear.php
<html> <body> <?php $PKey = ""; $LastName = ""; $FirstName = ""; $Email = ""; $Comments = ""; $DropDown = ""; ?> </body> </html>
write the code to create 2 radio buttons that display back data
<input type="radio" <?php if($Bottle=="Water") echo "checked";?> name="Bottle" value="Water"> <input type="radio" <?php if($Bottle=="Soda") echo "checked";?> name="Bottle" value="Soda">
Write the code to create a submit button
<input type="submit" name="Find" value="Find">
Write the code from delete.php
$sql="DELETE FROM customers WHERE Telephone='$Telephone'"; if ( ( strlen(trim($found)) > 0 ) && ($found == $Telephone) ) { if (mysqli_query($connection, $sql)) { //echo "Record deleted successfully found = {".$found."}"; $found=""; //this clear the flag for record found to be able to modify } else { $message = "Error deleting record: " mysqli_error($connection); } }
Write the code to connect to mysql from php
$connection = mysqli_connect("host" ,"username", "password", "dbName");
Assuming you are in your index file, create a hyperlink that goes to page1.html
<a href="includes/page1.html">Link</a>
Write the code to create a clear button to clear the screen
<input type="reset" name ="ClearScreen" value="ClearScreen">
Display "Welcome" using ariel font, size 3, blue text
<font face="Ariel" size="3" color="blue">Welcome</font>
Create a menu using css3 to display two vertical options
<nav> <ul> <li><a href="page1.html">page1</a></li> <li><a href="page2.html">page2</a></li> </ul> </nav>
Create a new table called contacts with fields: Telephone as a primary key First name Last name Email
$sql = "CREATE TABLE contacts ( Telephone VARCHAR(20) NOTNULL, PrimaryKey (Telephone), FirstName VARCHAR(20), LastName VARCHAR(20), Email VARCHAR(20) )"; mysqli_query($connection, $sql);
What will this code do: chmod ../../folder/* 755
Give an error, improperly formatted. It should be: chmod 755 ../../../*
Where to servlets usually execute?
The Server
Write the code from save.php
<html> <body> <?php $PrimaryKey=trim($PrimaryKey); if(strlen($PrimaryKey)>0) { $sql = "INSERT INTO ".$tableName." VALUES ( '$PrimaryKey', '$FirstName', '$LastName', '$Email', '$Comments' )"; $found = $PrimaryKey; } ?> </body> </html>
What is the command that shows information on the text input section of the front-end.
place holder
What is the MVC in web design?
MVC is the Model View Controller, used to develop user interfaces
Write the code to determine what button is pressed.
if($_POST['Button1']) { echo "You pressed button 1."; } else if($_POST['Button2']) { echo "You pressed button 2."; }
Write the code for a dropdown menu that will display back data, using at least two choices
<select name="DropDown" size="1"> <option <?php if ($DropDown=="Choice1") echo selected?>>Choice1</option> <option <?php if ($DropDown=="Choice2") echo selected?>>Choice2</option>
write the terminal command to connect to your database
mysql -h ocelot.aul.fiu.edu -u username -p password
Using a Unix/Linux server to place your website, a) What is the name of the folder where you must place your website's home page b) After placing all pages what do we need to do if we get error 404 or Access Denied or Forbidden c) Do you need to have your images in the same folder as you home page
a)public_html b) you have to give the right permissions to the files through chmod 755 C) no
Where does jsp usually execute?
Local Machine
What will this code do: chmod 755 ../../*.?ab *.dat
Look back two directories and give all ._ab and .dat files 755 permissions.
What does cellpadding do in HTML
Cellpading allows us to create padding around the cell content
what does WINSCP do?
Allows upload and download files from/to source to destination
Which are the main commands to find a record in a table named customers, from inside a webpage
$sql="SELECT * FROM customers order by Telephone ASC";
In which OS can we use winSCP to connect to a server
Windows
Write an html program with the two main parts of html
<html> <head></head> <body></body> </html>
What language is similar to JSP?
HTML
Write the contact_me_controller.php code
<?php
if(isset($_POST['submit']))
{
$to = "email";
$subject = "From..";
$name_field = $_POST['UserName'];
$email_field = $_POST['UserEmail'];
$body = " From: $name_field
eMail:$email_field
Tel: $UserTel
Fax: $UserFax
Option:
";
mail($to, $subject, $body);
?>
What is the difference between paragraphs and breaks
<p> are used to display text, and <br> and used to display a new line
What if the name of the process/function/method that displays information about a field name when you hoover over it
tooltip
Write the code to connect to a database called WebDB as done in all Controllers.php
$db_selected = mysqli_select_db( $connection, "WebDB" );
Section 2
(23 cards)