I am looking to find some resources on creating a photo gallary with php and mysql. Its my goal to have a login page wich i can create. Then the next step would have that user after he logs in to go to a page where he can upload images to the mysql dba. The next step would then have the gallery page pull up all the images from the dba that the user uploaded.

I am not sure where to begin after I create a login page and have that direct the login user to the upload portion. I have 2 other questions. How do i go about creating a form that will alow the images to be stored in the mysql if thats at all possible and second how will i get them to display in an orderly fassion. I currently have my images hard coded into my html and its a pain to uplaod and remove or add. You may view my gallery at http://www.nathanaelmiller.com/spain.php

    you would be best off storing the names and file paths of your images in mysql, and just store the images on disk.

    first thing you will need to check out are the upload functions, followed shortly after by the [man]mysql[/man] functions.

    as for the layout. no problems.... i cant see why you couldnt just use the page you allready have as a template.

      I guess I see i need to do three things:
      first: creat a login page that directs to the upload browse file so that i can upload images the the server in an images folder.

      second: use msql to sort the images by name or id

      third: call up the images on the gallery page using the field name in mysql

      would this bee the design idea i need to create?

        that pretty much covers it. why not start on the login... and give us a yell if you need a hand?

          Write a Reply...