PHP and MySQL Results page

Hello everyone,

I hope you are doing great. I have a new project I need help with. This time I need help with PHP and MySql.

I have a database created (the structure, no content yet), and some pages. The database will contain details from hotels and tours that I will sell in my page (this is a tourism website obviously). Both hotels and tours are linked by destinations, and I have some tasks based on that. Tours, Hotels, and Destinations are all separate tables in DB, and all have different details (pictures, text, etc).


Task 1:


I want a page to show a random hotel from a destination. First, you would need to pull from the database the hotels for that destination, and its details (columns), and then using a function make it randomly show 1 of them and its content.


Task 2:


Create a page where all the hotels from X area are listed (results page).

I will tell you which columns from the tables of the db need to be shown in the page.

Page should not show more than 10 results, the rest should be access with a next page menu.


Those should be enough details for you to place a bid.

Thank you.

The amount of columns for the random hotels is only 3, and for the results page is around 6.

I know that the most complex code is the one to show no more than 10 results in the results page, so I am removing this part of the project so bids go down.

The database is already created, the html/php files are already created, and all the graphics are created. All I need is the php code.

I need to make this clarification because the bids are way too high.


Skills: HTML, Javascript, MySQL, PHP, Website Design

See more: i want to create website and sell them, create a website for tourism, and mysql, php create function, javascript and mysql, make page sell website, php to place, php and mysql, page hotel, random page, page sell, hotel structure, task javascript php, structure php, mysql structure, mysql content, database created php, using rest access, tourism website content, mysql php rest, next page, mysql area, structure javascript project, mysql show, results page

About the Employer:
( 45 reviews ) Kissimmee, United States

Project ID: #1123002

Awarded to:


Lets get it done!

$30 USD in 0 days
(11 Reviews)

8 freelancers are bidding on average $89 for this job


Would be very glad to work with you on this project. Please contact me.

$150 USD in 1 day
(84 Reviews)

IF U HAVE ANY MORE [url removed, login to view] PROVIDE [url removed, login to view]

$100 USD in 10 days
(199 Reviews)

Hi, Let's start! Check PMB!

$75 USD in 3 days
(35 Reviews)

please check pm

$30 USD in 1 day
(16 Reviews)


$80 USD in 5 days
(1 Review)

Let me do it for you,,

$150 USD in 3 days
(1 Review)

Please check PM. Thanks.

$150 USD in 5 days
(1 Review)

I am very much interested in working on this job. Please check PMB

$100 USD in 2 days
(0 Reviews)