Step 1 – Create Table
- phpmyadmin – http://www.imagearts.ryerson.ca/jpascoe/myadmin/
- select your database
- select table to work on – if it exists
- if not -create it:
- will lilst all tables that database already contains
- at bottom of list – option to create new table
- can modify inClass2 or start from scratch
- table name – describes contents
- number of fields: (may not know exactly, but should have fairly good idea) – figure out what info you need before you get to this point
- can add and remove at will, but be careful when removing
- Dublin Core – 15 fields
- click go – it will show you big table
- first one/field – put in primary key – My Table_ID – always INT (integer) – name by convention is your table with ID at the end . Type is always INT. No need to enter values, except under:
- Extra – auto_increment.
- column immediately to the right, click the button, makes the row primary key (called primary)
- primary key – field in a record that guarantees its unique, has to be unique.
- if the object has accession number and it is guaranteed as unique, then it can be used as primary key.
- CHAR – fixed length, VARChar – variable length up to a maximum
- 2nd Field: Author – make sure you set the length to a length that you know the authors name will stay within (max 255 – char), space is a character, if over limit, it will cut off the name.100
- Make it text if you can’t guarantee the text is below 255 – take more processing power, min. amount will be too big. Only use if your sure it will be over 255. VARCHAR and char are tiny and fast data types.
- Null: not null means that field has to have a value, has to have data entered (database will reject it saying you haven’t filled in the form correctly). Null means its ok to not fill this field in. mySQL ignores this.
- Title: text
- Date: can be vague or accurate. if data is the type that you will have accurate dates – all digital images have creation date, photographs may not. Date data type constrains you – but it will allow for calculations to be done with it.
- If you can’t guarantee that dates will be in right format, then you need to use text based (VARCHAR, CHAR) – but searches where you’re actually calculating becomes trickier.
- Only have 3 or 4 options to enter date – why you use vocabularies and authorities
- Or you could just have a year field – use INT
- Date: VARCHAR 30 characters
- intYear: INT – duplicating data but allow for calculations – allows for searches in the year/dates
- Naming the fields – rules apply
- Medium – VARCHAR – 30 – predefined listing for names (authority) – make it the maximum length of those canonical names (make up list and then count the longest)
- Users will not see these field names
- caption- text (scope) – set to null, not all images have a caption
-with text you don’t have to enter value
- alt_author – varchar – 100
- order of fields doesn’t matter – queries that you ask the database that will structure responses.
- subject_person (controlled form of the person’s name) VARCHAR 100
- subject_corporation – VARCHAR 100
- subject_topic – VARCHAR 100
- location – text
- click save
- if there is something wrong, there will be red letters
- color coding based on what part of the table
- if you want to change one field – click on the pencil
- gets this list from a database query – what you see here is what your database contains
- proofread table – check spelling
- click on insert – can enter data straight into database – can test the table
Step 2 – Move Database into Dreamweaver
- leave the phpmyadmin window open, for reference
- enter dreamweaver
- works in last 3 versions of dreamweaver – does not work in dreamweaver mx
- create new site – not ftp and rds server
- first page of site definition dialogue
give site a name – don’t put any spaces in name
inClass2
- http address can fill in later
http://www.imagearts.ryerson.ca/jpascoe/inClass2/
- want to use server technology – php mysql
- edit locally, then upload to remote testing server (80% of the time)
- where to store files – at business: default will be your username and your documents folder -on your mac will be your site
- ryerson: don’t use default – can save to weston drive
- my computer – Data d drive- create folder name same as site name
- always confirm that its correct
- connect locally (usually) or connect by ftp (in this case) – if in grad lab connect to user name
- FTP
- ftp.imagearts.ryerson.ca (find out from whoever is managing your server what the ftp is)
- folder to store files: ppcm07/jpascoe
- login: username
- password
- test connection – don’t move until you have connected to web server successfully
- URL: always have to fix this -
change ftp to http://www.imagearts.ryerson.ca/jpascoe/inClass2 (folder name that you put your site in)
- same answer as first page
- error message – click ok and move on
- site definition: no, to check in and check out
- done
- top folder is root folder
- right click on folder – create new – images (copy images into this folder)
- manage sites – edit – advanced – default images folder – navigate images folder we just created and select it
- Make a page
- Click on root folder – Create new file instead of new folder
- Descriptive title for pages – insert.php – open
- give page a title – insert all
- send data between server and page – create a form
- needs entry fields and submit button – send into database
- insert – 3rd button – forms – first button – create new form
- form – text entry fields – make connection to database
- application – databases – + – mysql connection -
- connection name- anyname you want (rules apply)
- my sql server – localhost
- user name -ryerson user name
- password – last 7 digits of student number
- click select – connecting to databases that you have – your name, and information_schema (never use this one) – select database that has same name as username
- username should appear in last field
- when you work somewhere else – database name will be different
- drum – database
- click + sign by database connection – results in three items – only one you care about is tables – click + by tables – click + by name of table to see the fields table contains
- can see the name of each field when creating insert form in site
- insert bar – forms – new form
- cursor dashing inside red square – part of form
- Form elements – text field
- Text field – single line entry – ID for text entry should match field name
- ID: filename (get caps the same) – instructions to computer
- Label: what data entry person will read – please enter the filename
- dpme
- label shows up – text field is there
- click right arrow to put cursor where u want it
- repeat
- ID: category, label: please enter the category
(will know based on ID how to link it to the table)
- Caption: need text area instead of field (next button) – because its longer
- label: type in the caption
- need two buttons: submit and reset
- button – on the forms section
- reset: highlight submit button – properties panel (bottom of page) – Action – 2 choices, submit or reset (by default it is submit) – click reset – button changes to reset – don’t need label
-SAVE
- need to tell dreamweaver what to do when buttons are clicked
- no field for primary key – don’t want to send value, already auto-increment
- need to define server behavior
- application -server behaviour – click + – insert record – which form to send (not advised to have more than one form per page) -
Insert record
automatically form 1
connection: my connection
insert table: inclass2
columns:
- database gets values from dreamweaver form
- after inserting , go to: insert2.php (select webpage you want it to go to after it sends the data – have it go back to this page)
- little golden dot at bottom of form – insert stuff into database and return to this page
- upload and test – yes to dependent files
- test it in a browser – http://www.imagearts.ryerson.ca/jpascoe/inclass2/insert2.php
- worked if now mysql errors – get question mark at end of url
- type in filename of image correctly
- create page to view records
- under site – new file
in class assignment – do it next week (niso framework document – table 2 – list of metadata) – dublin core (only 15 fields)
content standard – online template
think about database assignment – what fields you need
http://www.ncecho.org/
- viewrecords.php
- title – Viewrecords
- need to show records from database
- bind data in webpage to data in database – tab name is bindings
- application – bindings
- bindings tab – click + – recordset (query)
- think of records set as a search – defining a search
- name only matters if you have alot of recordsets – connection is the one already set up – will fit in the table with first one it finds – select table you want to grab data from – columns all – filter (none – want all of them) – sort by filename – ascending (can do author, last name etc.)
- Test will do the query for you
- inclass ID – primary keys generated by sql
- bindings – recordset (drum=table) – click +
- lightning bolts – dynamic data (database data)
- use a table to organize
- Table: insert bar – common or layout – table – one column and as many rows as the fields you want to show – i.e 4 fields you put in 4 rows
- table width – 200 min. (table will expand to fit whatever is in it)
ok
- first item you want to be the image – common -images – image – select image source – select file name from data sources – recordset will appear – filename; format – none; url will need to change, put in before angle bracket type in: images/
ok
- type something into alternate text – alt attribute – if image doesn’t appear – this text will show up (not something specific since don’t knowwhat image)
- other three rows will be info from database – drag lightning bolt fields from recordset and drop into table
SAVE
Files tabs – highlight viewrecords.php – upload and put dependent files
test webpage in browser -
if filename is wrong – get error for picture
- this is why you keep myadmin open
- set repeated region – make dreamweaver automatically repeat
- go back to dreamweaver (always test)
- select table (click inside what you want to select – dreamweaver shows hierarchy along bottom of window – click button table)
- application – server behaviour – click + – repeat region; show – all records; makes it show all records on the same page
- repeat region = grey square – everything inside will get repeated
- SAVE and UPLOAD
- refresh view on browser
- shows everything in database
- if you have stuff on the back
- have 2 fields for filename
- add one more field – add one at end of table
- field: filename_verso
- digital scan is part of the data
2 weeks to do in class assignment (do this again with all 10 of the images)
- dublin core – embedded metadata in database
Like this:
Like Loading...
