Is it necessary to create a separate page for each article on a website to include article numbers in the URL?
It is not necessary to create a separate page for each article on a website to include article numbers in the URL. Instead, you can use a single page template to display different articles based on the article number in the URL. This can be achieved by parsing the article number from the URL and fetching the corresponding article content from a database.
<?php
// Assuming the URL structure is like: example.com/article.php?article=1
// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "articles";
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Get article number from URL
$article_number = $_GET['article'];
// Fetch article content from database
$sql = "SELECT * FROM articles_table WHERE article_number = $article_number";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Output data of each row
while($row = $result->fetch_assoc()) {
echo "Article Title: " . $row["title"]. "<br>";
echo "Article Content: " . $row["content"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();
?>
Keywords
Related Questions
- What are some best practices for sorting and filtering data in PHP when working with MySQL databases?
- Are there specific bot names or IDs that should be blocked in PHP to prevent them from skewing website statistics?
- What is the recommended approach for saving user input from buttons in a PHP-based calculator?