PHP - Using Get To Display Universal Content On One Page Only

hey @requinix, I know you and I have talked about this before but I just want to clarify this issue.  Sadly, I have produced very few websites that have made use of dynamics in the form of database querying.  But, the next project that I'm looking at will require it.  The last thing I did with a query string involved the recording of downloads of file on a website.  and on the page, I had this code:

The archive is located he    <a href="dl.php?f=archive.zip">archive.zip</a>

and the ''dl'' page had this code:

if(!$_GET['f']) error('Missing parameter!');

        $stmt = $conn->prepare("INSERT INTO tblDownloads (ip, file, date, time) 
        VALUES (?, ?, ?, ?)");
        $stmt->bind_param("ssss", $ip, $file, $date, $time);
        $stmt->execute();
        $stmt->close();
        $conn->close();
	
	    header("Location: archive.zip");
	    exit;

and all the variables in the above ''dl'' page are declared in a file that is required by it, called ""conn.php"".

My question for anyone here is:

I am going to be producing a website similar to the testing site called ""jsFiddle"":  https://jsfiddle.net/ .  And it is slated to have a huge amount of content on it.  for example, a main page might have 100 links on it whereby, if a user clicks on any of them, it should take them to another page (or load async content) that illustrates and example of any given issue being asked about.  So, I know we've talked about $_GET before Requinix, and how most websites use it to produce dynamic content.  And we've also talked about the concept of markdown.  But once again, can someone here remind me....what's the best way to go about doing this?  Storing the actual ""answer to the issue"" content in a backend database and pulling/displaying it appropriately, kind of like what I am showing I did with the file in the above code?  thanks.

Adam

  * {
            box-sizing: content-box;
            }

<form id="contactForm" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES); ?>" method='post'>

<!-- HTML HERE -->

</form>

Hi folks,

I am in the middle of creating a CMS as a project. It's going pretty well so far but I am stuck and hoping to get some guidance.

When loading the main website, I want the contents from "Home" in the database to display unless a menu item is clicked.

Here is what I have so far:

<?php
include_once('includes/header.php');
require_once('admin/includes/config.php');
?>
    
    <div class="hero-wrap" style="background-image: url('images/uluru.jpg');" data-stellar-background-ratio="0.5">
      <div class="overlay"></div>
      <div class="container">
        <div class="row no-gutters slider-text justify-content-start align-items-center">
          <div class="col-lg-6 col-md-6 ftco-animate d-flex align-items-end">
          	<div class="text">
	            <h1 class="mb-4">Coaches For Hire <span>Book Now!</span></h1>
	            <p style="font-size: 18px;">The local Anangu, the Pitjantjatjara people, call the landmark Uluṟu (Pitjantjatjara [ʊlʊɻʊ]). This word is a proper noun, with no further particular meaning in the Pitjantjatjara dialect, although it is used as a local family name by the senior Traditional Owners of Uluru.</p>
	            <a href="https://www.youtube.com/watch?v=biuYA54nb7Y" class="icon-wrap popup-vimeo d-flex align-items-center mt-4">
	            	<div class="icon d-flex align-items-center justify-content-center">
	            		<span class="ion-ios-play"></span>
	            	</div>
	            	<div class="heading-title ml-5">
		            	<span>Learn more about Uluru</span>
	            	</div>
	            </a>
            </div>
          </div>
          <div class="col-lg-2 col"></div>
          <div class="col-lg-4 col-md-6 mt-0 mt-md-5 d-flex">
          	<form action="#" class="request-form ftco-animate">
          		<h2>Get A Quote</h2>
	    				<div id="searchBoxContainer" class="form-group">
	    					<label for="searchBox" class="label">Pick-Up Location</label>
	    					<input class="form-control" type="text" id="searchBox" placeholder="Start Typing..." />
	    				</div>
	    				<div id="searchBoxContainerAlt" class="form-group">
	    					<label for="searchBoxAlt" class="label">Drop-Off Location</label>
	    					<input type="text" class="form-control" id="searchBoxAlt" placeholder="Start Typing..." />
	    				</div>
	    				<div class="d-flex">
	    					<div class="form-group mr-2">
	                <label for="" class="label">Departure Date</label>
	                <input type="text" class="form-control" id="book_pick_date" placeholder="Date">
	              </div>
	              <div class="form-group ml-2">
	                <label for="" class="label">Return Date</label>
	                <input type="text" class="form-control" id="book_off_date" placeholder="Date">
	              </div>
              </div>
              <div class="d-flex">
              <div class="form-group mr-2">
                <label for="" class="label">Pick-Up Time</label>
                <input type="text" class="form-control" id="time_pick" placeholder="Time">
              </div>
              <div class="form-group ml-2">
                  <label for"" class="label">Passenger Numbers</label>
                  <input type="number" class="form-control" placeholder="Amount" />
              </div>
              </div>
	            <div class="form-group">
	              <input type="submit" value="Request Quote" class="btn btn-primary py-3 px-4">
	            </div>
	    			</form>
          </div>
        </div>
      </div>
    </div>
<script type="text/javascript" src="https://www.bing.com/api/maps/mapcontrol?key=AqIY0ivSCCdBIe3-EKGuox9cwBFw2wWRWIErZi1iy57EfD67PoiSra9wl_wu48de&callback=bingMapsReady" async defer></script>
<?php
$id = $_GET['id'];

$sql = "SELECT * FROM pages WHERE id = $id";
$result = $con->query($sql);

if ($result->num_rows > 0) {
while($row = $result->fetch_array()) {
?>
    <!-- HOW IT WORKS -->
		<section class="ftco-section ftco-no-pt ftco-no-pb">
			<div class="container">
				<div class="row no-gutters">

					<div class="col-md-12 wrap-about py-md-5 ftco-animate">
	          <div class="heading-section mb-5 pl-md-5">
	          	<span class="subheading"><?php echo $row['description']; ?>
	          	</span>
	            <h2 class="heading"><?php echo $row['name']; ?></h2>

	            <?php echo $row['body']; ?>
	          </div>
					</div>
				</div>
			</div>
		</section>
<?php
}
}
?>

<!-- FOOTER -->
<?php
include_once('includes/footer.php');
?>

I hope you can help and that I am making sense.

Cheers,

Dan