使用单独的URL自动创建的新页面

Question

I'm very new to web development. I'm creating a travel website. Hotels details (id, Hotel name, location, description) are stored in a MySQL database. When submit the new hotel create form, I need a new page to be created automatically with separate URL. Can you help me to solve this problem?

Answer 1

You can use GET parms in your hotel URL. For example:

hotel.php?hotelID=1

In your SQL database you save the hotelID. In the hotel.php you use $_GET['hotelID'] for you sql select statement and generate your site.

Your statement may look like this:

$hotelId = (int) $_GET['hotelID'];
$sql = "SELECT * FROM hotels WHERE hotelID = {$hotelId}";