Get a Freelance Job

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.

Using the SQL CREATE statement, create the following two tables using the following fields:

Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to either utilize one of the listed fields as the table’s primary key or you will need to create an additional field to use as the primary key. The primary key from the Job Title table will appear as the foreign key in the Employee table.

Kudler Fine Foods is a

Kudler Fine Foods is a

Project #1

Save all of your code in Notepad as a *.txt file and attach it when you submit the project. Take screen shots of all successful implementation of each set of SQL.

Data Changes and SQL Statements

Resource: Table Queries assignment

Use the database and tables that are attached to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the store. Check results by selecting all columns from both tables.

Between, Like, and Union:

Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.

Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.
Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.

Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.

Write a SQL query that uses the UNION of the two tables to produce a third table.

Save each query in a txt file and take a screen shot of its results and submit them as an attachment.

Group:

Use the updated database to write the following queries, using the SQL GROUP statement:

Select employees’ last names and group them by EEO-1 classification.

Select employees’ last names and group them by salary.

Select employees’ last names and group them by salary in their EEO-1 classification.

Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.

Save all the SQL statements in a txt file and submit as an attachment.

Screen Shot