Completed

Mysql PHP database query and display results in a webpage and more

I am not asking for the developer to create an entire site, as I will provide the basic webpage template for the developer to add their scripts into.

I want users to be able to query a mysql database.

They will be able to search by keyword and display and sort the results by :

- most viewed

- most downloaded

- user rating

- newest

Or they will just be able to display the items in order based on one of those four criteria listed above.

They will also be able to choose how they want the results displayed, - either in a grid format or a list view and lastly how many to show at a time (ex.20 | 40 | 80 | ALL) and provide pagination for the results (previous / 1 / 2 / 3 )etc.

The list view will simply be the title, image thumbnail, rating, # downloads listed in a row one after the other and the grid will be displayed with 4 across. You can see examples of this on the webpage of [login to view URL]

When the user clicks on one of the items it will take the user to a different page where the title, description, larger size image, number of times the item has been viewed, number of times downloaded, a user rating, and a link to download a file that is related to that item, and a list of the comments left by previous reviewers.

On that page, the user can then submit a review, leaving a short message and giving the product a rating on a 1-10 scale. The user will only be able to submit one review per item, as the user will be tracked by either IP or cookie. I ask the developer to help in choosing the best method, either IP, cookie or both.

Of course the program will keep track of the number of times an item has been downloaded,viewed, and the ratings it has received.

There should also be an admin 'switch' that will turn off/on the ability to leave reviews and also turn off the displaying of the rating

You can checkout a very rough example which is not fully functioning at [login to view URL] That page and how it works was done by another developer who could not successfully finish the job nor did it operate in a efficient manner. Include the text, Initiative, in your bid to know you have at least read this far. I will not provide his code as I do not want it used for a base.

I will provide the mysql tables but again the tables and their uses can be modified to be more efficient and less taxing on the server.

It is unknown at this point if I will allow access to the server, so you may need to develop it on your localhost.

The site should use PHP, and Mysql databases and must be safe from any form of mysql/php injection.

The site should also be setup to maxmize search engine optimization.

There will be followup work for a developer who can successfully complete the job.

I will create milestone, but will not release the final payment until all bugs have been fixed and the job requirements met.

Skills: MySQL, PHP, SEO, Web Security, Website Design

See more: how to fetch data from database in php one by one, php code to retrieve data from mysql database and display, how to display data from database in html table using java, how to display data from database in php form, display mysql table in html, how to fetch data from database in php and display in html table, how to display data from database in php in table, how to retrieve data from database and display it in textboxes using php, update photo mysql php database, mysql php generic query table display, mysql query display results csv file, php query display results table, mysql php database front end open source, php database query xml parser, mysql remote database query

About the Employer:
( 16 reviews ) Milwaukee, United States

Project ID: #15929253

Awarded to:

dboyzhang

Initiative, I can create the system for you. I have completed many similar projects. Will use cookie and IP address to avoid duplicated reviews. Relevant Skills and Experience php, mysql, ajax, css Proposed Milestone More

$250 USD in 5 days
(342 Reviews)
7.3

51 freelancers are bidding on average $183 for this job

hits

INITIATIVE. We have developed similar functionalities for many sites. We have expertise in PHP and MySql. I am confident of delivering well and ensure ongoing services for future projects. Relevant Skills and Experien More

$526 USD in 7 days
(997 Reviews)
9.0
Pratishtha

We are a dedicated team of Web Development and Design - Responsive experts, SEO, PPC, Social Media & iPhone Apps development with more than 10 years of experience in this industry. Relevant Skills and Experience MySQL More

$250 USD in 30 days
(790 Reviews)
9.1
minhhoangduc

For submit a review, leaving a short message, i think cookie should be best because IP is always dynamic while cookie only lost when the users refresh their browser. Relevant Skills and Experience Hello, I'm a PHP CER More

$250 USD in 5 days
(573 Reviews)
8.1
OutsourceMan

Surely, We are ready to help you with Mysql PHP database query and display results in a webpage and more. Yes, I am agree with you when you 100% satisfied you will release the payment. Relevant Skills and Experience L More

$168 USD in 3 days
(291 Reviews)
8.0
forcitCample

Hi there, Let me help you with PHP work,I have grasped all your requirements very [login to view URL], work will progress accordingly. Relevant Skills and Experience MySQL, PHP, SEO, Web Security, Website Design Proposed Milesto More

$250 USD in 3 days
(152 Reviews)
7.3
techwelfare

Hello, we could do this project. but please let's clarify your project [login to view URL] will be increasingly important for us to focus on developing the best user experiences for all our clients. Relevant Skills and Ex More

$200 USD in 7 days
(186 Reviews)
7.2
webXpart

Hi, I checked the details and checked the link [login to view URL] I have more than 6-7 years experience on PHP,MYSQL and i am confident on your requirement. Relevant Skills and Experience Please ch More

$422 USD in 14 days
(68 Reviews)
6.9
$238 USD in 9 days
(109 Reviews)
6.6
kawalecove

Hello Sir, I checked your description and can work according to your requirement give us an opportunity to have a meet up and discuss in detail about your project Relevant Skills and Experience MySQL, PHP, SEO, Websi More

$133 USD in 3 days
(69 Reviews)
6.2
topithub

Mysql PHP database query and display results in a webpage Relevant Skills and Experience MySQL, PHP, SEO, Web Security, Website Design 7 years experience Proposed Milestones $111 USD - task

$111 USD in 3 days
(26 Reviews)
5.8
TuckerAlexander

Hi, I have built php/mysql search engines in the past. I can create the search result and content pages you need. Please view my portfolio page for similar work. Relevant Skills and Experience I'm proficient in html5, More

$250 USD in 3 days
(64 Reviews)
6.1
umernaeemucp

hi there i have read all the requirements and that is too much work will complete in 7 days Relevant Skills and Experience php Proposed Milestones $188 USD - final

$188 USD in 3 days
(40 Reviews)
5.7
sayootech

Hi , I am maahi have gone through your requirements (Mysql PHP database query and display results in a webpage and more). Relevant Skills and Experience [login to view URL] [login to view URL] [login to view URL] More

$166 USD in 5 days
(75 Reviews)
6.2
pabloramirezdz

Hello, I'm a web developer with 12+ years experience. I have solid knowledge of LAMP stack and HTML/CSS/JS. Relevant Skills and Experience PHP, MYSQL, JAVASCRIPT, HTML, CSS Proposed Milestones $200 USD - Features don More

$200 USD in 3 days
(33 Reviews)
5.8
bhaskarmandal

Hi, I am 5 years experienced web developer expert in PHP/ MySQl . Have strong knowledge in HTML / CSS / JS/ JQuery Relevant Skills and Experience please check my recent projects : 1 ) [login to view URL] 2 ) http More

$155 USD in 3 days
(84 Reviews)
6.1
BugKillerHkg

yes. of course, I'll release after finishing t requirement. Relevant Skills and Experience PHP, laravel, mysql, angular,react, vue, bootstrap etc. Proposed Milestones $155 USD - 1

$155 USD in 3 days
(31 Reviews)
5.8
techmartsol

Initiative

$180 USD in 3 days
(54 Reviews)
6.1
brendanmullan90

Hello there, my name is Brendan. I have read your project specifications and would love to come on board and complete this task for you. I am available to begin immediately. Relevant Skills and Experience - 9 years ex More

$133 USD in 2 days
(48 Reviews)
5.6
adampohp79

Dear Sir. I am Adam poh. I am web developer and I am php expert. I can realize your needs for protecting from injection attack. Please check my portfolio. Thanks. Relevant Skills and Experience I had developed several More

$111 USD in 3 days
(22 Reviews)
5.0
$155 USD in 3 days
(57 Reviews)
5.0