.html + databases Flashcards
(20 cards)
Checkbox Code
<Input type=”checkbox” Id=”vehicle1” name=”vehicle1” value=”Bike”>
Bike
(remove asterisks)
Radio Button Code
<input type=”radio” name=”accept” value=”y” >
Yes
<Input type=”radio” name=”accept” value=”n” >
No
(remove asterisks)
Form Code
<form>
<p>
<label>first name:</label>
<input></input>
</p>
<input></input>
</form>
How to Style a Link
a:link {background-color: #107210; color: #800000;
border-width: thick;
border-style: outset;}
a:visited {background-color: #107210;
color: #800000;
border-width: thick; border-style: outset;}
a:hover {color:#FF6633;}
a:active {color: #FF6633;
border-width: thick;
border-style: inset;}
Using Hyperlink Targets
_self - Opens the document in the same window/tab as it was clicked
_blank - Opens the document in a new window or tab
_parent - Opens the document in the parent frame
_top - Opens the document in the full body of the window
What are two forms of validation on webpages, and give an example?
Manual - Proofreading
Electronic - Form validation
What is Validation?
Checking that user data input is appropriate
* Timely
* Within Range
* Existence
* Type
*Checking that original information is appropriate
Name at least 6 things that make a website successful
Accessibility
Site load-time is reasonable
Adequate text-to-background contrast
Font size/spacing is easy to read
Flash & add-ons are used sparingly
Images have appropriate ALT tags
Site has custom not-found/404 page
Identity
Company logo is prominently placed
Tagline makes company’s purpose clear
Home-page is digestible in 5 seconds
Clear path to company information
Clear path to contact information
Navigation
Main navigation is easily identifiable
Navigation labels are clear & concise
Number of buttons/links is reasonable
Company logo is linked to home-page
Links are consistent & easy to identify
Site search is easy to access
Content
Major headings are clear & descriptive
Critical content is above the “fold”
Styles & colors are consistent
Emphasis (bold, etc.) is used sparingly
VS
Ads & pop-ups are unobtrusive
Main copy is concise & explanatory
URLS are meaningful & user-friendly
HTML page titles are explanatory
How to write a select query
use schema;
select fldnames (or * for all) from tblname where fldname = ‘textvalue’ and/or fldname=numvalue
How to update a query
update database.tablename set fieldname1=’textvalue’, fieldname2=number where fieldname3=number
How to insert a query
insert into database.tablename (fieldname1, fieldname2) values (‘textvalue1’, numbervalue2)
Give 2 formats which can be used on a webpage
.html and .php
What is the purpose of creating a site in Dreamweaver?
It provides a way to organize and manage all of your web documents, upload your site to a web server, track and maintain your links, and manage and share files.
What is normalizing?
Storing of data in the smallest data pieces (within reason) in order to search more efficiently, effectively. Eg. consistent units, avoiding duplication, consistent lettering/spelling
How to store data values from a form?
<?php
$tempstore=$_POST[‘formfieldname’]
?>
What is PHP code?
It is a programming language that allows webpages to be dynamic and interactive, rather than static. It is processed on the webserver rather than the computer itself. They must be saved within the WAMP server.
Dropdown Box Format
<select>
<option>Monday</option>
<option>Tuesday</option>
<option>Wednesday</option>
</select>
3 Design Tools
Sitemap, Storyboard, Layout Design, Data Dictionary
Foreach Syntax
<?php
$array1 = array(1,2,3,4,5);
foreach($array1 as $value)
echo “$value<br></br>”;
}
?>
IF Syntax
Used for an ‘existence’ check
<?php
if(condition){
code to execute if conditions. met;
}
?>
