You are here

Week 2 - Incorporating SQL

This week I learned the basics of the SQL language and how to incorporate it into HTML/PHP. I had to figure out a ton of stuff for myself which I am proud of doing. Although it's a headache sometimes trying to fix my code...

I think the hardest part of this week was building functional webpages that use all three languages, and putting the ideas in my head into actual code. So far I've been playing around with scripts that can read a Saturn image file, and go back to the main database and collect information about that image to display it. I made a page that can look in the /images/saturn directory, display all the images in there and pull up from the database a table of information associated with that image, as well as other things. I've attached the code I used, the file needs to have extension of .php to work.

AttachmentSize
Plain text icon extractpage.txt5.68 KB
Plain text icon PNGsearcher.txt1.88 KB