330403 simple PHP & MySQL project
N/A
Dibayar saat pengiriman
Hello and thank you for taking the time to look over this post. I have a very simple project it should only take a skilled coder no longer then a hour or two to complete. I would complete this myself but I do not have any more time to search the boards and solve myself Time is now becoming a issue.
With that being said I would like any programmer to heavily comment their code So I can review and Help me better understand PHP and MYSQL.
Now for the project There are two basic problems I need addressed. I am working on a site that that caters to temporary corporate housing. I have built the first part of the content management system, and the first problem I need addressed is part of the add a new property section. The problem is the user has to upload a image to the server on one paged called imageUpload.php. On this page there is a simple script that uploads the image to the server ,re-sizes it and creates a thumbnail then save both images to the server. But currently the user must remember the image file's name and its extension and put its info in the form field on the InsertPropertyInDatabase.php.
I want the upload script to both upload the file and put it's name in the database all on one form on the same page. I do not want to have to use the page [url removed, login to view] at all I want the to combine both pages. I know this can be done through php's loop function fairly easily. This is a problem on two sperate pages that needs to be addressed.
The second problem I have is I just need some one to build/code some basic mysql quearys for the property listings page. Currently the property master page is set to display each property by ID in DESC order. I just need the following search options,
SEARCH BY: STATE, CITY, PROPERTY NAME, ZIP CODE,
I would like each of the above as separate categories in “htlm Menus <select>” just like the search bar at this url “ [url removed, login to view] “ I need the queries to filter by those terms with the addition option of “ALL” example all states, all cities for that state, all properties. The zip code needs to be a text field search option that looks for corresponding zip codes and list all properties for that zip code or redirects to a specified page if the zip code does not exist. I also need a little javascript/php on the <select> tags that update the menus once one is selected. Example when the user first chooses a state in the dropdown menu the cities menu will update and only list the cities for that state and the properties for those cities in that state then if the user chooses a city the menus will update again with only the properties for that city. Then there is the main submit/search button that will execute the query and list the properties. Here is the ulr for the listings search page. [url removed, login to view] with 4 sample properties in the database thus far.
Please note there will be no design or graphics required this is all primarily simple code and queries in the following languages PHP, MYSQL, JAVASCRIPT and a very little HTML.
ID Proyek: #2076212
