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.

Evner: MySQL, PHP, SEO, Web Sikkerhed, Web Design

Se mere: 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, easy oop php database query, php database result display, mysql php select query dropdown, mysql php database interface creator, ajax mysql php database search live, admin panel mysql php database, php database query script, php database read display, mysql remote database query, php database query xml parser, mysql php database front end open source, php query display results table

Om arbejdsgiveren:
( 16 bedømmelser ) Milwaukee, United States

Projekt ID: #15929253

Tildelt til:

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 Flere

$250 USD in 5 dage
(342 bedømmelser)
7.3

49 freelancere byder i gennemsnit $185 på dette job

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 Flere

$250 USD in 30 dage
(824 bedømmelser)
9.1
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 Flere

$526 USD in 7 dage
(998 bedømmelser)
9.0
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 Flere

$168 USD in 3 dage
(300 bedømmelser)
8.0
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 Flere

$250 USD in 5 dage
(573 bedømmelser)
8.1
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 Flere

$250 USD in 3 dage
(154 bedømmelser)
7.4
$238 USD in 9 dage
(125 bedømmelser)
6.6
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 Flere

$200 USD in 7 dage
(190 bedømmelser)
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 Flere

$422 USD in 14 dage
(71 bedømmelser)
6.9
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 dage
(35 bedømmelser)
5.9
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 dage
(27 bedømmelser)
5.9
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 Flere

$155 USD in 3 dage
(87 bedømmelser)
6.1
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 Flere

$133 USD in 3 dage
(69 bedømmelser)
6.2
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, Flere

$250 USD in 3 dage
(64 bedømmelser)
6.1
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 Flere

$111 USD in 3 dage
(30 bedømmelser)
5.5
techmartsol

Initiative

$180 USD in 3 dage
(54 bedømmelser)
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 dage
(40 bedømmelser)
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] Flere

$166 USD in 5 dage
(75 bedømmelser)
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 Flere

$200 USD in 3 dage
(35 bedømmelser)
5.7
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 Flere

$133 USD in 2 dage
(48 bedømmelser)
5.6
prince369

hello sir i gone through your needs without wasting your time i request you just check my web portfolio [login to view URL] Looking forward to hear from you and keen to discuss further Relevant Skills Flere

$83 USD in 6 dage
(18 bedømmelser)
5.2