Creating a Database

1. www.imagearts.ryerson.ca/jsheptytskyzall/phpmyadmin/

2. Sign In

3. Select a database or Create a new one

4. Create a Table (bottom of the page) + number of fields (Dublin Core 15 + primary key) 

5. Assign Fields
   1. Primary Key - tablename_ID (INT) Extra (autoincrement) select first bullet button to assign primary key.
   2. Author – CHAR/Varchar (max 255 including spaces) Null (not null indicates that the field must have input. Null for author because there may not be one.)
   3. Title – TEXT
   4. Date - DATE (because date formats vary, VARCHAR (30) can be used to include such variations ei. c 1890, year only etc. DATE can perform calculation but has a set format)

A supplementary field can be added to include only year (intYear for example) INT, if calculations are nessesary. 

   5. Medium – VARCHAR (30) set length at the maximum of the longest option
   6. Content/Caption –  TEXT (no value)
   7. altAuthor – VARCHAR (100)
   8. subjectPerson – VARCHAR (100) null
   9. subjectTopic – VARCHAR (100) null
   10. subjectCorporation – VARCHAR (100) null
   11. Place/Location – TEXT Use authoritative name
   12. etc.

6. Save – check SQL query, red will signify problems.

Can Edit fields and Insert date directly in SQL

DREAMWEAVER

New Site
Yes. Server Technilogy – mySQL
Edit locally, then upload. Select/Create folder.
No check IN/OUT.

  create image folder
   go back to edit sites/ advanced/ local info/ set image folder/ done
   create new file/ insert.php

      create a form on the page – text entry fields, get from Applications/+ MySQL Connections/
      Connection Name: whatever
      My SQL Server : localhost (almost always)
      Username/Password
      Database – select (should be the one created in phpmyadmin)

Golden drum should appear

shared connections
tables (only this one is of relevance)
   + sitename
      + fields
views

On insert.php
   insert form
     - insert field
          Input Tag Accessebility Window
          ID – Field Name
          Label – User prompt
          insert all fields in table + add submit and reset buttons

Applications -Database – Insert Record

New File – view.php

Applications – Bindings + Recordset
         Connection – define
         Table – choose appropriate table
         Columns: All
         Filter: none
         Sort: Filename - Assending

Back to the file view.php
     Create a table – first row – add image
                              – select image source – data sources – select
    Image Tag Accessibility Attributes – Alt text (….) – Long description (none)

-remaining fields can be draged and dropped from Recordset
Check in browser

Back to the file
– select the table
Application – Server Behaviour + Repeat region
Repeat Region – Recordset
Show – alll records
(grey square will appear around the repeat region.
Save – Upload – Check in Browser