PHP - Facebook Like Social Networking With Php Mysql

Hi everone i am currently building a social network website, i have it mostly finished but one thing i am trying to do is instead of my members having the profile name of www.domain.com/ members.php?username=04836flfgkfifg84 for example,

i want it to be like twitter or facebook where it is like www.facebook.com/Brendan

Can someone help me out on doing this?

I'm writing a mini social network and I'm having trouble figuring out how to deal with privacy settings.
I have established a range of privacy options (level 1-4): 1. Only Facebook friends can see profile (users connect via FB) 2. Only current classmates 3. Past + current classmates 4. All users in given group
I am writing a function to return a list of available users based on a given parameter (eg. Find all classmates of a user). Obviously I have to respect users privacy settings, so I thought to query against all users with level 2 permissions, however I realise that I may miss out some classmates who are FB friends but have permission levels set to 1.

Secondly, I'm looking to find out the relationship between two users (a function that I can plug in 2 user IDs and return their relationship...classmates, FB friends, past classmates, no relationship) which I can then use to determine whether a user has permission to view another users profile.

I don't have much code as of yet, because I spent a long time exploring one avenue which I now realise to be the wrong one!

Any suggestions/help would be greatly appreciated!

I am creating a simple social network, and i want the post visible only on its circle of friends but the problem is...
let say user_a, user_b, user_c already registered and user_a and user_c connected/friends already and all their posts and comments are visible on their circle
but when user_b write a post oh his wall, it's also visible to user_a and user_c which i dont want to happen. I dont know what was wrong on codes below.
 
CREATE TABLE IF NOT EXISTS `user`(
    `uid` INT(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `uname` VARCHAR(25) NOT NULL,
    `pword` CHAR(60) NOT NULL,
    `fullname` VARCHAR(30) NOT NULL,
    INDEX(`uname`)
) Engine = InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;

CREATE TABLE IF NOT EXISTS `friend`(
    `fid` INT(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `friend_id` INT(11) NOT NULL,
    `my_id` INT(11) NOT NULL,
    `stat` ENUM('0','1') NOT NULL,
    INDEX(`friend_id`, `my_id`),
    FOREIGN KEY(`friend_id`) REFERENCES `user`(`uid`)
    ON UPDATE CASCADE
    ON DELETE CASCADE
) Engine = InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;

public function viewFriendIfExistOnTbl($uid)
    {
        $query = $this->mysqli->query("SELECT `friend_id` FROM `friend` WHERE `my_id` = '$uid' LIMIT 1");
        if ($query->num_rows > 0) {
            return true;
        }
    }
 

Hi phpfreaks members,

I got a little social network website, http://www.tranceprofile.com

I got a php script for members to log in to my website.
When they are logged in they can view there own profile and edit it.

I got my login script on two places, http:www.tranceprofile.com/login.php
and my index.php page.

Well here is my problem: When they log in they are send to my index.php page as a logged in user.
I want them to be redirected to the http://www.tranceprofile.com/profile.php page.

I hope you guys can help me out!

Best regards, Mitch Oosterhuis.

Login script:

<table width="400" align="center" cellpadding="6" style="background-color:#FFF; border:#666 1px solid;">
  <form action="login.php" method="post" enctype="multipart/form-data" name="signinform" id="signinform">
    <tr>
      <td width="23%"><font size="+2">Log In</font></td>
      <td width="77%"><font color="#FF0000"><?php print "$errorMsg"; ?></font></td>
    </tr>
    <tr>
      <td><strong>Email:</strong></td>
      <td><input name="email" type="text" id="email" style="width:60%;" /></td>
    </tr>
    <tr>
      <td><strong>Password:</strong></td>
      <td><input name="pass" type="password" id="pass" maxlength="24" style="width:60%;"/></td>
    </tr>
  <tr>
      <td align="right">&nbsp;</td>
      <td><input name="remember" type="checkbox" id="remember" value="yes" checked="checked" />
        Remember Me</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input name="myButton" type="submit" id="myButton" value="Sign In" /></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td colspan="2">Forgot your password? <a href="forgot_pass.php">Click Here</a>
  <br /></td>
    </tr>
    <tr>
      <td colspan="2">Need an Account? <a href="register.php">Click Here</a><br />        <br /></td>
    </tr>
  </form>
</table>

 So I would like it as a custom script or as a wordpress plugin.

The features a


I would like to build a social network.
The main to features I’m interested in:
1. Member can join only by invitation. The person that invites another person must write a review about the invited person, add a photo, what he does, share the name and contact: email, phone, city, connected to ( until here all these is mandatory in order for the person to join the network ) and website link ( optional ).
Only then the person that is invited will receive an email with a link from where to register his account. ( this only for members that will have the right to invite others. For the other type only the admin has the right to make it from just a member, a member with invitation rights. In this case the member will receive an email with a link registration ).
The review of a member can be edited only the member who introduced that person in the network ( and the admin ). In case of any edit there will be a notification for the admin with the original version and the new version. The admin of the site has to allow the modification in order for the review to change.
2. The person that is already in the network can invite a number of … ( this will be fixed and determined by the admin. However the admin can raise the number of invitation for a particular member at his will ). This applies for the 2 types of invitations.
There will be 2 types of invitations: to join the network and have the right to invite others OR only member ( no right to invite others ).
When a person registers to the network, the one who invited him will have one less invitation for the type of member he introduced ( member with invitation rights or member ).
If a member wants to invite more people than his invitation are, then it can purchase invitations ( both types ) for different prices ( example: 1 invitations 10$, 2 invitations – 40$ - value determined by the admin ). So a payment integration is needed ( Paypal ).
The exception for all this: if a visitor wants to join the network without any invitation he can only pay his way in. However this option will be displayed on the public pages. After payment confirmation the visitor can be redirected to the register page. Admin will make the account active. A sign “paying member” will be shown on this member profile page.

After a member is registered and logs in to his account will have the right to:
- Add more photos
- Add more website links
- Add more details at his contact information
- Change his unique number.
- Have the option to add members ( both types )
- Add updates to his wall.
- Search and contact other members via email.
So once you log in to the account there is no restriction ( within the network ) or no difference from what you can do on other social sites.

Search:
First the search will be done in the reviews and after that on the post that members made.
The search results will be displayed in the same order ( the words from the reviews will have priority and after that will be displayed the content from posts – that will be arranged in chronologic order – last one will be the first ).
But a member can filter those results – review only or posts only.
Sponsored bids will be displayed first.

The handshake section:
Here you will be notified if one of your “looking for” or “offering” announces has expired. When expired the announcement can’t be find on searches or on your profile page.
The notification will be active for 7 days. By active I mean: if you click the notification it will take you to the announcement and there you will have an option – make active ( so that other can find the announcement in their searches or in your profile ) another 30 days.

The Admin section:
The site will be default “no robots” ( not indexed by search engines ). However an option should be in the admin to switch from off “no robots”. This option will apply only for the internal part – profile pages. The pages and link on the first page ( what is public ) can be indexed by search engines.
A simple editor from where you can create pages ( something like the section pages in Wordpress ). Any page you create will appear on the first page.
After a period of time a member with invitation rights will receive invitation. Example: after one year you will have an extra one invitation for both types of member. What is needed in the admin: a section from where you can modify this time ( time should be in months and the admin will enter the number – example if he puts 1 – that means after 1 month will receive invitation. There should be 2 sections: one time for members that can invite, and one for members only ).
A section where you can limit the number of entries for “looking for” and “offering”
The section from where you can edit the html code.
An option to send newsletters.
You will receive and email if another person contacted you via internal email section.
Option to delete members.
 

We are building a site for users to post articles on certain topics and we want to show their number of followers on various social media platforms.

Apart from them having the means to add it manually, there must be a method of syncing with their account, that they punch in, so that it dynamically updates our database with their number of followers.

How is it done?

Hi Guys

 http://www.phpfreaks.com/forums/Smileys/nrg_alpha/cool.gif
Cool

I have social networking application. I am trying to query a database to get the ids of all the users friends.  With the ids of all the users friends I am then trying to  query a second database with  the status feed  that contains all users status data.

 

I would like to echo the users friends status data only from the second database

 

code is below hope you can help.

 

Thank you.

 

<?Php
session_start();
?>
<?Php
//connect.
include("connect.php");
//Time ago coverting code.
include_once("classes/develop_php_library.php"); // Include the class library

 

$id=$_SESSION['id'];

 

/*find-out users friends*/
$findperson=mysql_query("SELECT * FROM friends WHERE sessid='$id'");

 

$timeAgoObject = new convertToAgo; // Create an object for the time conversion functions

 

$findfriend=mysql_num_rows($findperson);

 

//Count if the person has any friends. If they have friends get the ids of all their friends
if($findfriend>0)
{
while($rati=mysql_fetch_assoc($findperson))
{
    $fried=$rati['friendid'];

 

    //query the status table to give the users friends status.

 

    $mediafeeds=mysql_query("SELECT * FROM status WHERE userid='$fried' LIMIT 0,8");

 

    $media_num=mysql_num_rows($mediafeeds);
}

 

//count to see if their any status updates from users friends.

 

if($media_num>0)
{

 

//display all the users friends status data.
$datamedia="<TABLE BORDER='0' CELLPADDING=8 bgcolor='#FFFFFF' align='center' width='350px' height='30px'>";

 

while($mini=mysql_fetch_assoc($mediafeeds))
{
$user_id=$mini['userid'];
$viewer_nme=$mini['username'];
$viewer_picture=$mini['viewerpics'];
$media_pic=$mini['contentpic'];
$desc_ption=$mini['description'];
$date_time=$mini['date'];

 

$convertedTime = ($timeAgoObject -> convert_datetime($datetime)); // Convert Date Time
$datetime = ($timeAgoObject -> makeAgo($convertedTime)); // Then convert to ago time

..

//This is just a table with the data of all the users friends data.


$datamedia.="<tr><td valign='top' cellpadding='5' width='10%' bgcolor='#FFFFFF' align='center' >$viewer_nme<br/><a href='friendsprofile.php?uid=$uidd&&viewer=$id'><img src='".$mediapic."' width='80' height='80' align=left></td>
      <td valign='top' align='left' cellpadding='5' width='60%' bgcolor='#D3D3D3' cellpadding='0'>$introduction<br/>$titlenamed$titled<br/>$descd$desc_ ption<br/><br/>$datetime</td></tr>";

 


    }
$datamedia.="</TABLE>";
echo $datamedia;
}
else
{
echo "<font color='#333333' size='2' face='sans-serif' align=left><div align='center'> Your friends have not current activities.</div></font>";
}
}

else

{

 

 

}

Hey, everyone.

My name is Matthew and I have a new project I would like developing.

It is a social network site based on Twitter where you can upload content and follow other users.

I am looking for someone experienced in developing who will be able to start this from the beginning.

The project should take around 1-2 months to be up and running fully.

If you are interested please send me
a) Your Portfolio
b) Your Location
c) Your Price per hour ($)

to boyle.matthew(@)gmail.com and hopefully we can talk further.


Thanks, Matthew

I'm learning to develop social media buttons, and I'm trying to figure out, how to find out the correct submit links to the social media sites?

For example:

Digg has their submit link like this:


return "<a href='http://digg.com/submit?url=$link&amp;

title=$title&amp;bodytext=$text'>Digg This</a>";


Digg also requires to use urlencode for the variables inside the URL.


But delicious has their submit link like this:

return "<a href='http://del.icio.us/post?url=

$link&amp;description=$text&amp;replace=no'>Add to Delicious</a>";




When I go on delicious.com (under this URL: http://www.delicious.com/help/api#posts_add)  I will find the link:

Code: [Select]
https://api.del.icio.us/v1/posts/add?

Which is stated on the API page, but that link won't work. I rather have to use the link I showed earlier.

So my question is, what is the proper way in figuring the correct submit links for each website and how to format them properly to their requirements, I can not find any information on the websites?

So I can build social media buttons to the other sites as well.

My employer asked if I could change an existing contact form on their website to allow clients to enter their Social Security Number along with the normal contact information if the client decide to do so, instead of going through the motion of physically send in the form via snail mail, fax, or in person (like it is currently handled).
But since this piece of information is of such delicate nature, I wonder how I should approach this from both a legal standpoint and from a programming standpoint.
The form currently sends the information entered by the user to an inbox with mail(), so my initial thought was to somehow encrypt the information, limiting the risk of someone getting a hold of this information once the use user clicks "Send". But is full blown SSL really necessary for this? Are there easier options? And what should I think about before enabling this?

Not sure where to start, and it may not be entirely PHP.

I am helping a friend with a small social network (5,000 users). They want to add a feature where each user gets given their own email account in the format username@domain.com with domain.com being the domain of the social network.

Is this too much? I've never thought of anything like this before.

How would we create the email accounts? Can PHP do it? Would it be an API through the web host / email space provider?

Hello everybody,   I am honestly quite a newb when it comes to mod_rewrite.   We run a small social media page with different areas and I would like to change the URLs to something more clean and professional.   User profiles look like this:

http://www.sky-mp3.com/index.php?action=cm&siteid=59&wahl=artists&tat=details&keyid=477

siteid 59 is the artists list and the keyid at the end is the ID of the artist but should be like:

http://www.sky-mp3.com/mischura 

or in worse case like:

http://www.sky-mp3.com/user/mischura 

CMS pages look like this:

http://www.sky-mp3.com/index.php?siteid=106

but should be like:

http://www.sky-mp3.com/charts

(page name instead of siteid)   What I know so far: - I have to add something to the .htaccess file - I need to change something in the code (but I don`t know where)   Im good he?   What would be the first step on the path to clean URLs for me? I found alot of infos here and there but found nothing yet for this specific case.   Kind regards from and thx in advance from Cologne            

Hi, I have some code which displays my blog post in a foreach loop, and I want to add some social sharing code(FB like button, share on Twitter etc.), but the problem is the way I have my code now, creates 3 instances of the sharing buttons, but if you like one post, all three are liked and any thing you do affects all of the blog post. How can I fix this?


<?php
include ("includes/includes.php");

$blogPosts = GetBlogPosts();

foreach ($blogPosts as $post)
{
echo "<div class='post'>";
echo "<h2>" . $post->title . "</h2>";
echo "<p class='postnote'>" . $post->post . "</p";
echo "<span class='footer'>Posted By: " . $post->author . "</span>";
echo "<span class='footer'>Posted On: " . $post->datePosted . "</span>";
echo "<span class='footer'>Tags: " . $post->tags . "</span>";
echo '
<div class="addthis_toolbox addthis_default_style ">
<a class="addthis_button_facebook_like" fb:like:layout="button_count"></a>
<a class="addthis_button_tweet"></a>
<a class="addthis_counter addthis_pill_style"></a>
</div>
<script type="text/javascript">var addthis_config = {"data_track_clickback":true};</script>
<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#username=webguync"></script>';

echo "</div>";
}


?>

<?php
class Post{
	private $user_obj;
	private $con;

	public function __construct($con, $user){
  	$this->con = $con; 
   	$this->user_obj =  new User($con,$user);
	}
	public function submitPost($body,$user_to){
	$body = strip_tags($body);////Removing HTML TAGS
	$body = mysqli_real_escape_string($this->con,$body);
	$check_empty = preg_replace('/\s+/', '', $body);//delte all spaces

	if($check_empty != ""){


	//Current Date and time
	$date_added = date("Y-m-d H:i:s");

	//get username
	$added_by = $this->user_obj->getUsername();

	//if user have not a profile send to the none
	if($user_to == $added_by){
	$user_to = "none";
	}
	////insert query
	$query = mysqli_query($this->con,"INSERT INTO posts VALUES('','$body','$added_by','$user_to','$date_added','no','no','0')");
	$retured_id = mysqli_insert_id($this->con);

	//insert notification

	//Update post count for user
	$num_post = $this->user_obj->getNumPosts();
	$num_post++;
	$update_query = mysqli_query($this->con,"UPDATE users SET num_post = '$num_post' WHERE username = '$added_by'" );
}
	public function loadPostsFriends(){
	$str = ""; //string to return
	$data = mysqli_query($this->con,"SELECT * FROM posts where deleted = 'no' ORDER by id DESC");
	while($row = mysqli_fetch_array($data))
	{
		$id = $row['id'];
		$body = $row['body'];
		$added_by = $row['added_by'];
		$date_time = $row['date_added'];

		/// Creating user post on other user profile
		if($row['user_to'] == "none"){
			user_to = "";
			else {
             $user_to_obj = new User($con,$row['user_to']);
             $user_to_name = $user_to_obj->getFirstandLastname();
             $user_to = "to <a href='" . $row['user_to'] . "'>" .$user_to_name . "</a>";
			}
			// check if user account was closed 
			$added_by_obj = new User($this->con,$added_by);
			if($added_by_obj ->isClosed()){
				continue;
			}
			$user_details_query = mysqli_query($this->con,"SELECT first_name,last_name,profile_pic FROM users where username = '$added_by'");
			$user_row = mysqli_fetch_array($user_details_query);
			$first_name = $user_row['first_name'];
			$last_name = $user_row['last_name'];
			$profile_pic= $user_row['profile_pic'];

			///time stamp
			$date_time_now = date("Y-m-d H:i:s");
			$start_date = new Date_Time($date_time);////Time_of_post
			$end_date = new Date_Time($date_time_now);///Current_time
			$intervel = $start_date->diff($end_date);
			if($intervel->y >< 1 ){
            if($intervel ==1 )
            	$time_message = $intervel->y . " year ago";/// 1 Year Ago
            else
            	$time_message = $intervel->y . " years ago"; //1+ year ago
			}
			else if($intervel-> m >= 1 ){
				if($intervel->d == 0){
					$days = " ago";
				}
				else if($intervel->d == 1){
					$days = $intervel->d."day ago";
				}
				else
				{
					$days = $intervel->d."day ago";
				}
				if($intervel->m == 1){
					$time_message = $intervel->m." month".$days;
				}
				else 
					$time_message = $intervel->m." months".$days;
			}
		}
		else if($intervel->d >= 1){
				if($intervel->d == 1){
					$days = "Yesterday";
				}
				else
				{
					$days = $intervel->d."days ago";

				}
		
			}
			else if($intervel->h >= 1){
				if($intervel->h == 1){
					$time_message = $intervel->h." hour ago";
				}
				else
				{
					$time_message = $intervel->h." hours ago";

				}

		}
		else if($intervel->i >= 1){
				if($intervel->i == 1){
					$time_message = $intervel->i." minute ago";
				}
				else
				{
					$time_message = $intervel->i." minutes ago";

				}
	}
			else{
				if($intervel->s < 30){
					$time_message = "Just Now";
				}
				else
				{
					$time_message = $intervel->s." seconds ago";

				}
				
			}
			$str .= "<div class='status_post'>
				         <div calss='post_profile_pic'>
				         <img src='$profile_pic' width='50'> 	
				        </div>
				        <div calss='posted_by' style='color#ACACAC;'>
				        <a href = '$added_by'> $first_name $last_name </a> $user_to &nbsp;&nbsp;;&nbsp;;&nbsp;$time_message
				        </div>
				        <div id = 'post_body'$body<br></div>
				         </div>
				"
			
		}
		echo $str;
	}
}
?>

When i run this code this show me the error Parse error: syntax error, unexpected 'public' (T_PUBLIC) in C:\xampp\htdocs\social\Classes\Post.php on line 39

the line 39 is public function loadPostsFriends()

I check the code again and again but i cant find the error please help in this error

On Facebook, when you click on "view friends" on one of your friends' profile, a window pops up. Is that made with PHP? Or is it flash or something? In case it's PHP, what would you use to make something like that? Thank you in advance!