Page with index.php?id=1

Question

Hello,

I would like to know how to create pages like: index.php?id=1
with ID calls from the SQL database?

This would be to separate news on different pages.

News 1 would be on the page: index.php?id=1
News 2 would be on the page: index.php?id=2
News 3 would be on the page: index.php?id=3
...

Thanks in advance

Configuration: Windows 7 / Firefox 7.0.1

DoulyCreations · Answer

It should be something like:

<?php
if(!isset($_GET['id']))
{
include('default_page.php');
}
else
{
$Request = "SELECT * FROM news WHERE id = '".$_GET['id']."'";
// Process Request and display the result

// Check if the result is not empty: if(empty($Result))
}
?>
--
When there’s a will, there’s a way! Or maybe not...

Mihawk · Answer

Hello,

Indeed, the variables passed via the URL are called GET variables; they can be easily retrieved in PHP to incorporate them into SQL queries.

See here: https://openclassrooms.com/fr/courses/918836-concevez-votre-site-web-avec-php-et-mysql/912799-transmettez-des-donnees-avec-lurl

--
Mihawk
"As long as we don't do it, we don't know."

Page with index.php?id=1

2 answers

Slow startup on asus vivobook after battery drained

Very slow computer

Outlook problem

Trio gigaset a605h no longer works

exorbitant cost of a landline in france without internet in 2026

Update w10 kb5122878 impossible

Retrieving conversation histories: mediapart-bardella case

Black screen with my thumbnails on the pc screen

Gmail password problem

Microsoft 365