Get userID from database

Question

I have a simple blog where I'm practicing some php and mysql. I'm trying to display the username of the post author (you know where it says posted by Author). I have two tables blog_members and blog_posts which are related 1 to many so I got a memberID field into the blog_posts. I'm trying to get the username of the member who's the author of the post. I was thinking to do a join or something but I can't figure this out. Here's what I was trying to do but it's not working because I'm sure I'm not using it properly.

$query1 = "SELECT username from blog_members JOIN blog_posts ON memberID = memberID ";
$result1 = mysqli_query($link, $query1);
$row1 = mysqli_fetch_array($result1);

PS: I got it working one way by using SESSION to get the userID but that works only if the user is logged is which is not the case, I want to display the name in any case.

Thanks!

need table name `ON blog_members.memberID = blog_posts.memberID` — Saty, May 24 '16 at 11:49

score 2 · Answer 1 · answered May 24 '16 at 11:53

Use inner join this way

And with a proper sanitize use $your_user_id for match

$query1 =  "SELECT username 
from blog_members 
INNER JOIN blog_posts ON blog_members.memberID = blog_posts.memberID 
WHERE blog_posts.memberID = '" .$your_user_id . "';";

score 0 · Answer 2 · answered May 24 '16 at 11:52

0

Try something like this, usng INNER JOIN :

$query1 = "SELECT blog_members.username FROM blog_members INNER JOIN blog_posts ON blog_members.memberID = blog_posts.memberID ";

reference : http://www.w3schools.com/sql/sql_join.asp

answered May 24 '16 at 11:52

Gabriel Bourgault

842
11
22

score 0 · Accepted Answer · edited Oct 01 '16 at 20:41

0

JOIN syntax is wrong in your query.

Use following query:

 $query1 = "SELECT username from blog_members JOIN blog_posts ON blog_members.memberID = blog_posts.memberID ";
 $result1 = mysqli_query($link, $query1);
 $row1 = mysqli_fetch_array($result1);

edited Oct 01 '16 at 20:41

marc_s

732,580
175
1,330
1,459

answered May 24 '16 at 11:55

Hardik Panchal

16
4

score 0 · Answer 4 · edited May 23 '17 at 12:19

0

Here is a solution using a simple WHERE condition (same performance Explicit vs implicit SQL joins) :

SELECT a.username FROM blog_members a, blog_posts b WHERE a.memberID = b.memberID

But if you need more information about MySQL Join : https://www.sitepoint.com/understanding-sql-joins-mysql-database/

Hope this helps !

edited May 23 '17 at 12:19

Community

1
1

answered May 24 '16 at 11:56

Alex

151
1
6

Get userID from database

4 Answers4