PHP & SQL - Converting user_id into username?

[cammy]

I'm currently trying to display the latest 6 photos taken by users as shown below...

But I don't know how to convert the user_id to the persons username. Nor do I know how to convert the timestamp to date and time.

Here's the current script.

<?php
$sql = $dbh->prepare("SELECT id,user_id,timestamp,url FROM camera_web ORDER BY id DESC LIMIT 6");
$sql->execute();
while ($photos = $sql->fetch())
{
echo'
<div class="boxphotos">
<a href="/news/'.filter($photos["id"]).'"><div class="photosimage" style="background-image: url('.filter($photos["url"]).');">
<div class="photosuser">
'.filter($photos["user_id"]).'
</div>
<div class="photostime">
'.filter($photos["timestamp"]).'
</div>

</div></a>
</div>';
}
?>

 

[GertjanA]

You could use an inner join on the SQL like SELECT t1.* and t2.user and merge the two tables.
Feel free to add me on discord so I can help you build the query for your need. (GertJanFRL#1527)

 

[cammy]

Added you, I searched this and saw this and will be trying to soon, no doubt I'll fail!
Thanks!

 

[Berk]

SELECT camera_web.*, users.username FROM camera_web JOIN users ON camera_web.user_id = users.id ORDER BY camera_web.id DESC

try this,and adjust how you want

 

[cammy]

SELECT camera_web.*, users.username FROM camera_web JOIN users ON camera_web.user_id = users.id ORDER BY camera_web.id DESC

try this,and adjust how you want

Thank you!
Struggling with the timestamp

 

[Ecko]

Thank you!
Struggling with the timestamp

You must be registered for see links

 

[cammy]

You must be registered for see links

<div class="photostime">
<?php date("d-m-y, H:i", '.filter($photos["timestamp"]).'); ?>
</div>
It's just blank D:

 

[Ecko]

$timestamp = filter($photos["timestamp"]);
$date = ("d-m-y, H:i, $timestamp);
echo $date;