Page 1 of 1

[JOB] Single Website - PHP/MySQL - Image Site

Posted: Thu Jan 22, 2009 1:25 pm
by srednatonmi
I work a graphic designer, not a coder, so I'm looking for some extra help to get a little project off the ground.

Basically I'm making an image rating site, but the images are only rated by one user (admin). The main functionality is to have a backend where images can be uploaded, and are added in chronological order. Each image needs to have text that displays below it (I'm assuming in a MySQL database but I am open to other options).

This job could be bigger and if you work well with me, I will have other projects in the future.

I'm looking for a designer who can understand the project, doesn't mind talking by phone if need be (although I prefer an instant messaging service), and contributes ideas to improve the site.

I've attached an image of what the site will look like, so that you can get a better idea.

Please let me know if you have any questions or interest.
Anders
Screenshot of basic design. NOT final, but close.
Screenshot of basic design. NOT final, but close.
onepercent.jpg (199.31 KiB) Viewed 1340 times

Re: [JOB] Single Website - PHP/MySQL - Image Site

Posted: Fri Jan 30, 2009 1:39 am
by samyak
Hi!

I just sent you a private message. Hope to hear from you soon.

Amit

Re: [JOB] Single Website - PHP/MySQL - Image Site

Posted: Fri Jan 30, 2009 7:37 am
by RyanS
For the backend, I would suggest php scripts with a MySQL database that stores information about the image in table columns and the image itself on the local filesystem (ie in a secure directory of the webserver outside the document tree). The database will hold information only about the directory where the image is saved and not the image itself.

A slightly different approach is to store the uploaded image file in a blob column of the database, as a binary. This is considered (slightly) more secure because if the webserver machine is compromised, the MySQL database itself is still a line of defence. The downside here is that the backend system will be slower. It is faster for the webserver to grab a file from the local filesystem, as opposed to a database column.

The text (dynamic content) that you want to show with each image should go inside the database (a text column).

I hope this helps. Good luck.

Re: [JOB] Single Website - PHP/MySQL - Image Site

Posted: Wed Feb 11, 2009 2:52 pm
by mbdigital
Hi Anders,
I'd be keen to chat further about the project. Can you provide an email address / contact details?

Mike