Jump to content

make profile pic show next to name


searls03

Recommended Posts

ok so I am having trouble showing the proper profile pic next to the proper name.  it is showing the currently logged in users pic next to every name.  I need to know how to make it so the the proper pic shows next to the proper name.  I inserted comments, hopefully you can find them, there are a bunch of ////////////////////////////where my comments start.  haha.  I hope someone understands what I am saying, cause this is difficult to explain.

 

<?php
session_start();
include('dbcon.php');
$username1 = $_SESSION['username'];
$name1 = $_SESSION['name'];
// set time of last activity
$userTime = time();
mysql_query("update `sessions` set  `activity` = '$userTime' where username='$username1'");
$inactivityTime = time() - 120; // 2 minutes
mysql_query("update `sessions` set `loggedin` = '0' where `activity` < '$inactivityTime' ");
$username = $rows['f_name'];
$sql = mysql_query("SELECT * from pics WHERE personname='$username'");/////////////////////////////this is where pic is being pulled from
while($row = mysql_fetch_array($sql)){
$link123 = $row["link"];
}
function checkValues($value)
{
	 $value = trim($value);

	if (get_magic_quotes_gpc()) {
		$value = stripslashes($value);
	}

	 $value = strtr($value,array_flip(get_html_translation_table(HTML_ENTITIES)));

	 $value = strip_tags($value);
	$value = mysql_real_escape_string($value);
	$value = htmlspecialchars ($value);
	return $value;

}	

function clickable_link($text = '')
{
	$text = preg_replace('#(script|about|applet|activex|chrome):#is', "\\1:", $text);
	$ret = ' ' . $text;
	$ret = preg_replace("#(^|[\n ])([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $ret);

	$ret = preg_replace("#(^|[\n ])((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $ret);
	$ret = preg_replace("#(^|[\n ])([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href=\"mailto:\\2@\\3\">\\2@\\3</a>", $ret);
	$ret = substr($ret, 1);
	return $ret;
}

$next_records = 10;
$show_more_button = 0;
if(checkValues($_REQUEST['value']))
{
	$userip = $_SERVER['REMOTE_ADDR'];
	echo "INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','$name1','".$userip."','".strtotime(date("Y-m-d H:i:s"))."')";

	mysql_query("INSERT INTO facebook_posts (post,f_name,userip,date_created) VALUES('".checkValues($_REQUEST['value'])."','$name1','".$userip."','".strtotime(date("Y-m-d H:i:s"))."')");

	$result = mysql_query("SELECT *,
	UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 1");

}
elseif($_REQUEST['show_more_post']) // more posting paging
{
	$next_records = $_REQUEST['show_more_post'] + 10;

	$result = mysql_query("SELECT *,
	UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit ".$_REQUEST['show_more_post'].", 10");

	$check_res = mysql_query("SELECT * FROM facebook_posts order by p_id desc limit ".$next_records.", 10");

	$show_more_button = 0; // button in the end

	$check_result = mysql_num_rows(@$check_res);
	if($check_result > 0)
	{
		$show_more_button = 1;
	}
}
else
{	
	$show_more_button = 1;
	$result = mysql_query("SELECT *,
	UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts order by p_id desc limit 0,10");

}

while ($row = mysql_fetch_array($result))
{
	$comments = mysql_query("SELECT *,
	UNIX_TIMESTAMP() - date_created AS CommentTimeSpent FROM facebook_posts_comments where post_id = ".$row['p_id']." order by c_id asc");		?>
   <div class="friends_area" id="record-<?php  echo $row['p_id']?>">
       <img src="<?php echo $link123;/////////////////////////////////////////////////////////////////////////////////////////////////////this is the original post, one spot where I am having issues ?>" style="float:left;" width="40" alt="" />
     <label style="float:left" class="name">

	   <b><?php echo $row['f_name'];?></b>

	   <em><?php  echo clickable_link($row['post']);?></em>
	   <br clear="all" />

	   <span>
	   <?php  
	   
	    // echo strtotime($row['date_created'],"Y-m-d H:i:s");
   		    
	    $days = floor($row['TimeSpent'] / (60 * 60 * 24));
		$remainder = $row['TimeSpent'] % (60 * 60 * 24);
		$hours = floor($remainder / (60 * 60));
		$remainder = $remainder % (60 * 60);
		$minutes = floor($remainder / 60);
		$seconds = $remainder % 60;

		if($days > 0){
		echo date('F d Y', $row['date_created']);
		}else if($days == 0 && $hours == 0 && $minutes == 0){
		echo "few seconds ago";		
		}elseif($days == 0 && $hours == 0){
		echo $minutes.' minutes ago';
		}else {
echo $minutes.' minutes ago';}

	   ?>
	   
	   </span>
	   <a href="javascript: void(0)" id="post_id<?php  echo $row['p_id']?>" class="showCommentBox">Comments</a>

	   </label>
	   <?php
		$userip = $_SERVER['REMOTE_ADDR'];
		if($row['userip'] == $userip){?>
	  	<a href="#" class="delete"> Remove</a>
	   <?php
		}?>
	    <br clear="all" />
		<div id="CommentPosted<?php  echo $row['p_id']?>">
			<?php
			$comment_num_row = mysql_num_rows(@$comments);
			if($comment_num_row > 0)
			{
				while ($rows = mysql_fetch_array($comments))
				{
					$days2 = floor($rows['CommentTimeSpent'] / (60 * 60 * 24));
					$remainder = $rows['CommentTimeSpent'] % (60 * 60 * 24);
					$hours = floor($remainder / (60 * 60));
					$remainder = $remainder % (60 * 60);
					$minutes = floor($remainder / 60);
					$seconds = $remainder % 60;						
					?>
				<div class="commentPanel" id="record-<?php  echo $rows['c_id'];?>" align="left">
                    <img src="<?php echo $link123;//////////////////////////////////////////////////////////////////////////////////////////////////////here are comments, one spot where i having issues ?>" width="40" class="CommentImg" style="float:left;" alt="" />
				  <label class="postedComments" >          <strong><font color="#3B5998">   <?php echo $rows['f_name'];?></font></strong>

					  <?php  echo clickable_link($rows['comments']);?>
				  </label>
					<br clear="all" />
					<span style="margin-left:43px; color:#666666; font-size:11px">
					<?php

					if($days2 > 0){
					echo date('F d Y', $rows['date_created']);}
					elseif($days2 == 0 && $hours == 0 && $minutes == 0){
					echo "few seconds ago";		
					}elseif($days2 == 0 && $hours == 0){
					echo $minutes.' minutes ago';
					}else{
echo $minutes.' minutes ago';}
					?>
					</span>
					<?php
					$userip = $_SERVER['REMOTE_ADDR'];
					if($rows['userip'] == $userip){?>
					  <a href="#" id="CID-<?php  echo $rows['c_id'];?>" class="c_delete">Delete</a>
					<?php
					}?>
				</div>
				<?php
				}?>				
				<?php
			}?>
		</div>
		<div class="commentBox" align="right" id="commentBox-<?php  echo $row['p_id'];?>" <?php echo (($comment_num_row) ? '' :'style="display:none"')?> >

			<label id="record-<?php  echo $row['p_id'];?>" >
				<textarea class="commentMark" id="commentMark-<?php  echo $row['p_id'];?>" name="commentMark" cols="60"></textarea>
			</label>
			<br clear="all" />
			<a id="SubmitComment" class="small button comment"> Comment</a>
		</div>
   </div>
<?php
}
if($show_more_button == 1){?>
<div id="bottomMoreButton">
<a id="more_<?php echo @$next_records?>" class="more_records" href="javascript: void(0)">Older Posts</a>
</div>
<?php
}?>

Link to comment
https://forums.phpfreaks.com/topic/244873-make-profile-pic-show-next-to-name/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.