PHP and MySQL with MySQLi: Joins (Part 9/9)

Official site

Twitter

[sodukukun]

Imagine after 8 years this one still helps students for their activities 😊

[CryordieGamingHD]

You explain better than my teacher who is a IT engineer

[ChristopherMills]

Thank you for this video. A very well articulated video.

[rubrnyx]

Thanks a lot for the detailed explanation! You helped me a lot! :)

[wootroot]

Thank you guys for this series. It has really helped me out. :)

[chitphoowai]

Thank you so much This video has really helped for my project.

[BunnyCentauri]

You can also do FROM people AS p (for example)

This way you don't have to type people over and over again -- you can just type p

[atiquerehman]

than you bro it's very unique way

[rosettaling]

Fantastic tutorials..loved every one of them.. :-)

[tojoshan]

Great tutorial. Thanks! Btw love your accent :)

[RedForShort]

Hey, can you help me?
In my site users can create posts. Then, within their accounts, they can look at all their posts in a list form. Works great! But...
I want them to be able to click each post and be taken to the post itself. On a new page. I think it's something to do with passing the post id through the browser address bar like '?p=31' or something, but i cant figure it out. How do you link it and have the post page use that id to grab the info from the database? Hope that makes sense? Anybody?

[nicksaini]

i want to ask if table 1 have one two many relation with table 2 after joining the table its return duplicate records also .. what we do in that condition please reply me and i dont want to add php array for that have to write loads of code everytime i fetch with join can it have some decent solutions .

[doncampan]

excellent series alex, but i am getting this error:

Notice: Trying to get property of non-object etc.
:(

[nahhas]

Thank you so much for this video. you solve a big problem which I can do it for 10 hours and I dont know how I can do it... if we want add a 3th table how we can do this like add cities...

[rjd]

is it posible to join to columns with different value??? for example the user_id of people has a value of 5 and the value of country_id is 6??? because i'm thinking what if the data will be inserted by the user? how will the data be inserted into different tables with joins? is there somebody can enlighten me...

[Ado-ENA]

what if i need to find only people without country??

[SuthesanSA]

Good you also show how not to do it :), than we know. All of guides miss that!

[KimYoungUn]

you sound like thenewboston but thanks for those tutorials hope you earned some good youtube moneys of it

[sanjaykumar]

It would be much more fine making the country in peoples table as a foreign key referring id in countries table.

[pianoLee-sxdx]

Hey guys... i am trying to do if statement in this code and i have got two users but one of them should be able to access the site because she had primer level accessed but can't.


ut if I do this, then it won't work:

include_once 'includes/dbh.php';



$sql = "SELECT users.user_first, user_access.access_type as accesslevel FROM users
LEFT JOIN user_access ON users.user_access = user_access.id

";



$result = mysqli_query($conn, $sql);
$resultCheck = mysqli_num_rows($result);
if($resultCheck > 0) {
while($row = mysqli_fetch_assoc($result)) {
if ($row['accesslevel'] != 'primer level') {
header("Location:
exit();
} else {
echo ' Welcome to the content';

}


}
}