web exam 2
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