Ditutup

Photography DB

Hello

I was just wondering if I could get an estimate for how much it would cost to create a search feature for a photography database I’m working on.

Here is a short description: Search of tagged photographs by tag and/or by date and display in a paged format with display of a larger version and download of the original. So, a mock up of the site is available at [url removed, login to view] There is some authentication code in there so that only University people can view the site, but I disabled it for now so you can view it.

There will be two search criteria. Keywords that will be assigned to each photo and the date that it was taken. Both of these, as well as many other variables, will be taken from the header info of the jpg and then parsed into the database. The first thing I need to cover is how the file will be named. Basically it will be exported out of Adobe Lightroom and a program called jhead will extract camera settings and tags or keywords inserted into the file in Lightroom. What we’re thinking is that the name of the file will be the date the photograph was taken.

So, if you go to [url removed, login to view] the first photo of the bunch is three women sitting at a table. If you click on this photo you’ll see a bigger preview. This photo was taken on July 8, 2008. When jhead lists the info, it shows the date as 2008:07:08 13:03:00. The 13:03:00 is the time it was taken. So, we’re thinking of calling the file 2008-07-08-13-03-00.jpg. This photo would then be put into a directory called: 2008-07. So, all photos taken July 2008 would be in this directory. All this, including creating the thumbnails and putting them into their own directory, would be done automatically and then be put into the database. Someone else is taking care of this part. So, when searching for this photo by date ([url removed, login to view]), we would like it so that you could search by day, but if you’re not sure of the day, then you leave the day field empty or something and it only searches the month and year. I guess they should be able to do that with the year as well, so if they want to search by year only, they leave month and day empty and they search by year. Now for this, is it better for the year / month / day to be in separate fields in the database, or can the date go in as 2008-07-08. Or do we even need a date field since the first part of the file name is the date?

Now the other thing is keyword search. How this works will effect how the pictures get tagged in Lightroom. Is it better to have multiword tags underscored? So, for example, on this page: [url removed, login to view] with the three women, if someone types in Terry, they will get photos with Terry Collins in them. But if someone types in Terry Collins, will they get photos of another person whose name also begins with Terry? If the name was tagged Terry_Collins, then we could instruct the user to use underscores instead of spaces which would eliminate the unnecessary other Terry’s that would come up, which I think is preferable.

When you click on Download high-resolution version, we don’t want the image to show up in the browser, but to bring up a download dialogue box. This is the first rendition of the Photo DB. It will likely evolve over time as it gets used. People may want additional search criteria, but for now, this is all we are looking at. Unfortunately, you won’t be able to access the database, but I can send you screen shots of how it looks in phpmyadmin and if you need anything changed, I can change it.

Thanks!

peter

Kemahiran: PHP

Lihat lebih lanjut: www photography, search photography, search photograph, search for photography, search for photographs, photography working, photography search, photography part time, photography original, on page photography, example of cover page, example of a cover page, creating php table, care now, care here, what is adobe lightroom, pictures of women, how much is adobe lightroom, photography cost, how to get into photography, taking photos, s+db, php db, photography, photography need

Tentang Majikan:
( 0 ulasan ) Windsor, Canada

ID Projek: #376162

28 pekerja bebas membida secara purata $1046 untuk pekerjaan ini

lightcresent

get it done... Thanks

$1250 USD dalam 21 hari
(480 Ulasan)
9.0
VALUEONWEB

VALUEONWEB is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. We have experti Lagi

$1200 USD dalam 25 hari
(211 Ulasan)
7.9
CrossBiz

Please view PMB

$1000 USD dalam 14 hari
(60 Ulasan)
7.4
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Lagi

$1100 USD dalam 45 hari
(55 Ulasan)
7.3
qualifiedcoders

hi we can help you with this [url removed, login to view] pmb for details thanks.

$1000 USD dalam 15 hari
(21 Ulasan)
7.2
dagdya99

Hi, I'm interested in working with you. I have more than 5 years of working experience in Web technologies like PHP, MySQL, SQL Server, HTML, Java Script, AJAX etc. I've successfully completed various web proje Lagi

$800 USD dalam 12 hari
(208 Ulasan)
7.1
mitrasubir

Hi, Please check PMB for details. Thanks KD

$1200 USD dalam 21 hari
(38 Ulasan)
6.6
gigapromoters

Lets do it.

$1100 USD dalam 20 hari
(20 Ulasan)
6.4
ManiksSoftware

Hi, We possess extensive experience of developing numerous high-end websites and are highly organized and adept at meeting tight deadlines that are so common in this industry. Please see PMB. Regards Manu

$1400 USD dalam 45 hari
(5 Ulasan)
5.8
Jam87

Hi, please check PM for details. Thanks

$800 USD dalam 10 hari
(20 Ulasan)
5.7
Rulon

I can help you

$999 USD dalam 15 hari
(16 Ulasan)
5.7
pkumar125

Please see PMB

$1000 USD dalam 30 hari
(8 Ulasan)
5.7
Mitj

Hi! Please check your PMB.

$990 USD dalam 18 hari
(9 Ulasan)
5.4
lautaro

Hello! Please, check PMB. Thanks.

$750 USD dalam 10 hari
(19 Ulasan)
5.3
musaulker

Hello, I'm a software engineer working over 5 years. I have PHP-MySQL experience. I'm interested in your Photography DB.. Your regards,

$1500 USD dalam 15 hari
(18 Ulasan)
5.0
ydude

Please check PM. Thanks,

$750 USD dalam 14 hari
(16 Ulasan)
4.8
semosoftware

Professional Service. Please check PMB

$1500 USD dalam 30 hari
(3 Ulasan)
4.8
sticklertechno

Hello sir, We are ready to work with you. Please check PMB.. Thanks

$750 USD dalam 20 hari
(5 Ulasan)
4.4
AGSTechnologies1

We have gone through the information that you have provided and understand your requirements very well. We have excellent expertise in PHP5, MYSQL, DRUPAL, JOOMLA, HTML, CSS, AJAX, JAVA, J2ME, JSP, SEO, SEM, ASP.NET, V Lagi

$1450 USD dalam 30 hari
(2 Ulasan)
3.8
nickProfessional

Hi, We are a web development company based in MI, USA. We are experts in Web 2.0 technologies. We can complete the project in 4-5 days. Kindly revert back to discuss further. Regards, [url removed, login to view]

$1000 USD dalam 4 hari
(5 Ulasan)
3.6