August 2012
Beginner
583 pages
16h 1m
English
Content preview from Learning PHP, MySQL, JavaScript, and CSS, 2nd EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
members.php
Using Example 21-9, members.php, your users will be able to find other members and choose to add them as friends (or drop them if they are already friends). This program has two modes. The first shows a user’s profile, and the second lists all members and their relationships to you.
Viewing a User’s Profile
In the first mode a test is made for the GET variable 'view'. If it exists, a user wants to view
someone’s profile; the program does that using the showProfile function, along with providing a
couple of links to the user’s friends and messages.
Adding and Dropping Friends
After that the two GET
variables, 'add' and 'remove', are tested. If one or the other has
a value, it will be the username of a user to either add or drop as a
friend. This is achieved by looking up the user in the MySQL friends table and either inserting a friend’s
username or removing it from the table.
Of course, every posted variable is first passed through sanitizeString to ensure it is safe to use
with MySQL.
Listing All Members
The final section of code issues a SQL query to list all
usernames. The code places the number returned in the variable $num before outputting the page
heading.
A for loop then iterates
through each and every member, fetching their details and then looking
them up in the friends table to see
if they are either being followed by or are a follower of the user.
Anyone who is both a follower and a followee is classed as a mutual
friend.
The variable $t1 is nonzero when the user ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.