An important part of the job as a front-end developer is to stay up to date and in contact with new tools, trends and workflows. That’s why you cannot miss this upcoming webinar to explore the latest trends in UI technologies!
Solved
get author ID from user-avatar plugin
Posted on 2011-09-08
when a member is logged into my membership site, and posts a comment on my blog, their photo gets displayed. I'd like to be able to return the id of the author logged in so I can display their photo on a page. When I view the source code, the path is:
http://www.domain.com/wp-content/plugins/user-avatar/user-avatar-pic.php?id=21
As you can see I'm using the user-avatar plugin. How can I dynamically pull the id and place that author id in the url above? I do have a plugin called exec-php so I can embed php into the page.
Any ideas?
http://www.domain.com/wp-content/plugins/user-avatar/user-avatar-pic.php?id=21
As you can see I'm using the user-avatar plugin. How can I dynamically pull the id and place that author id in the url above? I do have a plugin called exec-php so I can embed php into the page.
Any ideas?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
4
10 Comments
I am not familiar with the user-avatar plugin. But if you have a table with the user photos then there should be relationship between the member and its photo. You can put the member id from the table in the URL. Say for the above URL the photo belongs to some member id 3 then you can have
http://www.domain.com/wp-content/plugins/user-avatar/user-avatar-pic.php?id=21&mid=3
Now you can fetch the member info from the member table with the corresponding mid
http://www.domain.com/wp-content/plugins/user-avatar/user-avatar-pic.php?id=21&mid=3
Now you can fetch the member info from the member table with the corresponding mid
Yes, I understand that but just need the php code to pull back dynamically the author id. Any ideas on that?
Check the answer at the bottom at this question..
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_27298165.html?cid=1135#a36504888
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_27298165.html?cid=1135#a36504888
Okay, so this is what that thread has.
However, I need to display the author image. How can I obtain that?
However, I need to display the author image. How can I obtain that?
<a href="details.php?id={$row['id']}">read more...</a>
then on detail.php all you need is:
<?php
if( isset($_GET['id']) && !empty($_GET['id']) )
{
mysql_connect('localhost','username','password') or die( mysql_error() );
mysql_select_db('databaseName') or die( mysql_error() );
$sql='SELECT * FROM TableName WHERE id='.mysql_real_escape_string($_GET['id']);
$result=mysql_query($sql) or die('Unable to execute <br />'. htmlentities($sql,ENT_QUOTES). '<br />'. mysql_error() );
while($row=mysql_fetch_assoc($result) ){
//assuming you have a description field
echo $row['description'];
}
}
exit;
?>
The $_GET variable in this example is id and in the example i showed for URL your GET variable will be mid. So get the info from the member table where memberid=$_GET['mid'] and change the query accordingly
I've requested that this question be closed as follows:
Accepted answer: 0 points for COwebmaster's comment http:/Q_27298834.html#36513357
for the following reason:
thanks PranjalShah
Accepted answer: 0 points for COwebmaster's comment http:/Q_27298834.html#36513357
for the following reason:
thanks PranjalShah
Featured Post
A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
This article discusses how to implement server side field validation and display customized error messages to the client.
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog.
…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
Suggested Courses
Course of the Month7 days, 2 hours left to enroll
704 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.