web exam 2

Ace your homework & exams now with Quizwiz!

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 to save a record containing the following fields: Email as the primary key not accepting empty fields and of length 20. 1 textarea input field called one

"INSERT INTO customers (Email, one ) VALUES ( '$Email', '$one' )";

Write in sequence the following commands: delete a table, display all your databases names, connect to your mysql

drop tablename; show database; mysql -h ocelot.aul.fiu.edu -u username -p

Using the shell language: Write the code to create two checkboxes input box as done in program 3

: <a href="http://fiu.edu"> <img src="theGraph.png" /> </a>

Using a hyperlink named page 3, call the program located at includes/page3.html

<a href="includes/page3.html">page 3</a>

Write a html program that will have the two main parts in html, as learned in this class

<html> <head> </head> <body> </body> </html>

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 CSS3 learned in this class, to display two (2) horizontal options/links page1 and page2

<nav> <ul> <li> <a href="page1">page1</a> <a href="page2">page2</a> </li> </ul> </nav>

What does the cellspacing attribute do

It specifies the space between cells

What is the purpose of the controller2.php page, as done in program 2

To process the input of the program2.php front end

Write the code to connect and have full access to your mySQL

mysql -h ocelot.aul.fiu,edu -u username -p

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


Related study sets

Speech Comm Chp 16-17 Study Guide

View Set

Pharmacology 306: Test 1 Kahoot Questions

View Set

Fundamental Information Security Chapter 11: Malicious Code and Activity

View Set

CHAPTER 9- TEACHING AND COUNSELING

View Set

Course Point - Chapter 13: Outcome Identification & Planning

View Set

Exam: 02.02 Comptez! (Deuxième partie) Quiz

View Set