March 6/ Class Notes- Dreamweaver

dreamweaver site

inClass2

yes server – php sql

files where: data (d drive)

new folder : give a name inClass2

and open it ( select)

edit locally

ftp

ftp.imagearts.ryerson.ca

ppcm07/username/inClass2

username

password

http://www.imagearts.ryerson.ca/serdem/inClass2/

go to the beginning: write the same thing

and say no to the last one., click done

right click to site-inclass2

new folder

inclass 2 – drop down list

manage sites

edit – advanced

select images click done

take images from inclass2 (weston) to data d …

you should have them in your dreamweaver .. 3 photos

we are going to make 2 pages.

insert data into our database

(small application)

other page : use the images on database

right clik – new file .php

insert.php

change the title – untitled document

its easily overlooked

web http.

php

rdms my sql

they talk to each other- they are all connected

web server only speaks HTML

php server only speaks php

rdms server only speaks sql

.php – dont even try to read it as html

send it to php

create a database connection

myConnection

localhost

serdem

password (7 digits)

clickdatabase and click your username

databases, my connection, tables

write insert new images

twice enter

format heading 3

forms – click the first square

text field – second one to the square

filename

enter filename:

enter category

enter caption

caption : delete the label

go to textarea , write caption

2 more buttons

to submit button

to reset button

button (up)

write submit

write reset ( go to reset form)

down – form#form1 – select the form ( selects altogether)

application – server behaviours

plus signt _ drop sign -

insert record

click my connection

after inserting go to : insert.php

http://www.imagearts.ryerson.ca/serdem/inClass2/insert.php

put all the folder names – click submit

http://www.imagearts.ryerson.ca/serdem/phpmyadmin/

serdem – inclass2 – browse

new file – viewall.php

table

4 coloumns 1

bindings

recordset

drag filename, category, caption and id

upload the viewall – say yes

erase recordset

tree sign – pope001

data sources

url : images/

click on table

go to server behaviour

repeat regions , all regions