PAL Session 13

1
PAL Session 13

• Session Overview
• Searching the web
• PHP preparation - mySQL

2
Searching the web

• Based on search tips by

3
Searching the web

• Use the following operators to help narrow down
  search results
• Placing a key phrase in speech marks will
  search that specific phrase
• before a keyword will always include it in the
  search. Multiple keywords with will make sure
  the resulting pages will include ALL the keywords
• will search for synonyms of that keyword
• OR will search for either of two keywords

4
Searching the web

• There are other operators you can use in your
  searches
• keyword sitehttp//www only searches in that
  site
• safesearchkeyword excludes adult content
• linkhttp//www finds pages that links to the
  specified website
• infohttp//www finds information about that
  website
• relatedhttp//www finds websites related to the
  specified website
• See http//www.google.com/help/operators.html for
  more operators

5
Find this fact

• Who wrote the famous song Happy birthday to
  you?
• Mildred J. Hill and Dr. Patty Smith Hill
• Source http//www.ibiblio.org/team/fun/birthday/

6
Find this fact

• When was Diet Coke invented?
• 1982
• Source http//funnyfact.com/sillyfacts.shtml

7
Find this fact

• What is the longest recorded flight of a chicken?
• 13 seconds
• Source http//funnyfact.com/sillyfacts.shtml

8
Find this fact

• Where is it is illegal to tie a giraffe to a
  telephone pole or street lamp?
• Atlanta, Georgia, USA
• Source http//www.schnr-specimen-shells.com/Wierd
  .html

9
Find this fact

• How long can a cockroach live if it loses its
  head?
• 9 days (and thats because it starves to death!)
• Source http//www.cool-teens.com/forum/archive/t-
  10704

10
Find this fact

• How much pizza (in acres) do Americans eat per
  day?
• 18 acres
• Source http//expage.com/devilishweirdfacts

11
Connect to mySQL

• mySQL is a database in which you can create,
  modify and delete tables and data
• Connecting to mySQL
• Open Exceed Start ? All Programs ? Network
  Clients ? Exceed ? Exceed and log in as normal
• Open up the Terminal window
• Type ssh shares you will see a new prompt
• Type in mysql h shares -u username -p
• Type in your (original) password
• Test
• Type SHOW DATABASES
• You should see a list of available databases,
  which should be named as your username
• Type USE ltusernamegt