If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

PHP website development

Hi All,

I am trying to build a photography studio website using PHP, MySQL, and Apache. I am new to the language though. I went through a book and worked through all the examples but it still isn't totally clear. Anyway I need to make a pretty decent site. So far I have really basic things on it and it seems to be ok but the question I have right now is that I am trying to build albums on the site and I need to use the different tables in the database. I am just wondering if there is a way to use the photo names that I put into the database in my code...as in is there anyway to retrieve the photos from there after I link the PHP script and MySQL together or do I always have to put the photo location into the script?

There is so much that I want to do with the site and I have tried looking at different sites and tutorials online but it is difficult for me to understand them as the language is still so new to me.

with respect, you will not be able to build a "pretty decent site" with out experience. Just like I wouldn't photograph a wedding (my dad was a pro, when they still used glass plates), I suggest you hire a professorial web developer, if you want a professional website.

I never said I needed to build a professional site. I just said that I needed to build a site and that I want to learn how to make it pretty decent. What is the point in learning a new computer language if I am just going to hire someone else to build it???

I never said I needed to build a professional site. I just said that I needed to build a site and that I want to learn how to make it pretty decent. What is the point in learning a new computer language if I am just going to hire someone else to build it???

I think this begs the question: Do you want...
a) a "pretty decent" (and/or "professional-looking," whatever) website?
b) a "learning experience"?

ok what I am trying to do is build a website for a photography studio (its a project I am working on...not for an actual studio or anything ok) and I am currently trying to build a client page where they can see a bunch of different albums. They log into their album and there is their photos. I have the login part working the thing is that I can't figure out how to

1. have it so that they can only view their album.
2. i want to know if there is anyway that i can pull the photos from the database itself. As in, that I have a database set up for the studio and I have a table for albums and a table for photos etc. I am wondering if from the table called albums or photos or whatever can i take the photos from there or do I always have to type in the name of the photo ie. <img src="location.jpeg> etc.

Basically, to limit users to their images only, you would only select their images from the DB. One way to do this is to store the userid in the session, and store images with the user_id of the person it belongs to, then construct a query along the lines of:

Sadly, nobody codes for anyone on this forum. People taste your dishes and tell you what is missing, but they don't cook for you. ~anoopmailI'd rather be a comma, then a full stop.User Authentication in PHP with MySQLi - Don't forget to mark threads resolved - MySQL(i) warning

Ok I will send my two codes in two different posts. Right now I have two seperate pages, 1 for galleries, and 1 for client login. Now with the galleries and stuff I have only posted like one or two photos for each gallery as a bit of practice etc. So here is the code for the galleries.