Archive

Posts Tagged ‘the search form’

Photo Upload/search (complete)

July 13th, 2009 Comments off

Recently this code was written for me by a programmer on this site. Unfortunately the code is not working correctly. I have attached a zip file containing the code for the uploader.php in the main directory and the viewer.php in the 2009 directory. I can give you access to the CPanel. Database and tables are created. The uploader does work but I am not convinced that the data is getting to the sql database. When i run the viewer the photos are there but the search feature is not finding any of the photos.

Here is the list of items I need completed on this project:

1 – Make sure that the uploader.php code is correctly working including storing the data in the sql database.

2 – Make sure that the viewer.php code is correctly working. The viewer does work but it automatically showing all photos stored in the directory called 2009. At the top of the viewer is has to options, [HOME] and [SEARCH]. I would like the option [HOME] changed to [ALL].

Viewer should not show any directories until user selects [ALL] which shows all subdirectories located in the 2009 directory which is the way we currently view all photos. If the user selects [SEARCH] then the criteria diplayed in the search form would be viewed only based on the data stored in the sql database.

3 – The search form is not correct. Should be set up that user could select just the date and all photos in sql database with that date would be viewed. Right now the LOCATION field is always populated with one of our office locations. Need to have it blank.

I have tested the search feature and it unable to locate any photos matching my search criteria. I uploaded a few photos and went back and searched for them with no luck.

To be my programmer choice you must communicate very well and must allow me to test the code to ensure it is working before I release any escrow money to you. I can give you access to the Cpanel to work with the sql database.

This project is 98% complete already with the code and a good programmer should be able to complete this quickly. I need a programmer to tweak it. I do have other projects coming up soon using this database.

Web2.0 + Small Mysql Db

April 2nd, 2009 Comments off

Hello, I need a very small project that need:
1) Simple Web2.0 Design
2) Database MySQL to manage data

What I need to do ?

1) Web2.0 Design:
a very simple layout (fixed width) of only 1 webpage (the homepage) that need to contain:
a) Header (very simple, it not need words like logo or something, just a simple header without logo)
b) 2 Buttons (Home – Contacts)
c) Search form (to search a file)
d) Under the Search form it need to have 2 columns (49% each size) that will contain:
e) Latest Added Files (extracted from MySQL)
f) Most Viewed Files (extracted from MySQL)

2) MySQL Database to handle data:

a) I need to insert 2 parameters:
b) File name (imagetest.gif)
c) Description with html tags (<b>Image of Cartoon</b>….)
Conditions:
d) If the file name exists then UPDATE the second parameter (description) else INSERT the filename and the description.

e) I do NOT need an Admin Panel for manage tables/values.
f) The filename need to be clickeable, so if an user click over one filename listed on “Latest Added Files” or “Most Viewed Files” it will print (under the search form) the filename and the description.
g) If an user search a file, the result will be printed under the search form

Note:
The results of a search or the result of a file will be printed between the search form and the Most Viewed Files / Latest Added Files columns.

An example of a very simple web2.0 design for a search homepage is like:
http://www.iconfinder.net/

Bear