Help With PHP?

[iRawrHotel]

Hello,
I'm learning PHP,
and I'm wondering what it's called when you use info from a database, to generate a URL, such as that used in RevCMS for news, where it loads the ID, and shows the news article relating to that ID.

&

Can anyone link me to a good tutorial on PHP Sessions?
I'm trying to get it to work but it's hard!!!

Thanks in advance

 

[AquaJakes]

w3schools

 

[iRawrHotel]

w3schools

Ive tried them, but It doesn't really cover everything,
I need to know how to create it,
and then be able to use it to show the username,
and also if they're not logged in/timed out, to redirect them to the login page.

 

[ViiTactiiCZz]

using a while? :L
$query = query here
while($news = mysql_fetch_assoc($query))
{
echo $news['title'];
}

 

[iRawrHotel]

using a while? :L
$query = query here
while($news = mysql_fetch_assoc($query))
{
echo $news['title'];
}

What do you mean?

 

[ViiTactiiCZz]

What do you mean?

do something like
$id = $_GET['id'];
mysql_query("SELECT * FROM news WHERE `id` = '" . $id . "'");
while($news = mysql_fetch_assoc($query))
{
echo $news['content'];
}

then visit page.php?id=IDHERE and it should display the article

its also a $_GET

 

[AlexFallen]

thenewboston.org check it out, you might find what you are looking for on there.

 

[Jeffrey]

codeacadmey.com or something Just search up code academy

 

[Markshall]

Never recommend W3Schools, it's a piece of shit.

Something like this should do.

<?php
include('inc/db.php');
//...
 
$NewsID = (int) $db->escape_string($_GET['id']);
 
$NewsQ = $db->query("SELECT * FROM `News` WHERE `NewsID` = '{$NewsID}'");
if ($NewsQ->num_rows > 0) {
    $NewsA = $NewsQ->fetch_assoc();
 
    echo '<h3>' . $NewsA['Title'] . '</h3>';
    echo '<hr />';
    echo '<p>' . htmlspecialchars($NewsA['Content']) . '</p>';
}else{
    echo 'This news article does not exist.';
}
?>