 |
Procedure
|
|
prepping for the exercise
- download starter files, move to
upload folder
- new site "e4-rocky"
making the CSS style sheet
- open "appearance.html"
- examine file structure
- add new CSS style (define in new style sheet file)
- redefine <p>: 11/20 trebushet bold
- redefine <a>: decoration none, color=blue
- new style (class) ".head": 16/20 trebushet bold
- new style (CSS selector) "a:hover": underline
- new style (class) ".date": font color=orange
setting up the server
- edit site "e4-rocky"
- remote and testing server ("jsmith" doesn't exist
yet):
host: ftp.electric-pictures.com
dir: public_html/jsmith
login: gds215student
pw: _______________
testing server URL prefix:
http://gds215student.electric-pictures.com/jsmith/
- duplicate "appearance.html", rename "appearance.php",
open
- window > databases: + connection (this is site specific)
name: ep
mysql server: 127.0.0.1
user: paulananda2
pw: _______________
database: electric-pictures_com_-_db
- upload files including "Connections" folder (for testing)
creating a database table using phpMyAdmin
- browse to:
http://65.61.219.1/MyAdmin/indexsite.php
user: paulananda2
pw: _______________
- use database "electric-pictures_com_-_db"
- create new table "jsmith" (5 fields):
ID, tinyint
visible, tinyint
date, int
date_print, text
text, longtext
- make ID primary
- edit ID: auto_increment
- insert one row for testing
inserting fields in "appearance.php"
- window > bindings: + record set (query)
(this is file specific)
connection: ep
table: jsmith
filter: "visible" = form variable (1)
sort: date (ascending)
- replace date with field "date_print"
replace text with field "text"
- click "live data" view to test
- select date and text
- window > server behaviors: + repeat region (all records)
- add new dates with phpMyAdmin
- save, upload (cmd+shift+U), preview (F12)
- make links to your
work from your projects page
- browse to your "live" projects
page with a browser
- test on a PC
|
