9lessons programming blog
Loading Search
9lessons Bring Friends
Wall Script
Follow Me:
Monday, May 16, 2011

Facebook Wall Script 3.0 with PHP and Jquery

Facebook wall script with expanding URLs one of the popular post on 9lessons. It is just collaboration of my previous jquery articles. Recent days I received lots of requests from my readers that asked to me how to display old updates. So that I have decided to release new version with user control support. This script very easy to install few lines of code changes, take a quick look at following steps.

Facebook Wall Script 3.0 with PHP and Jquery

Download Script     Live Demo

The download script contains three folders called includes,css and js with PHP files.
includes
-- functions.php 
-- db.php //Database connection
js
-- wall.js 
-- jquery.oembed.js
-- jquery.min.js // 1.4.2 version
css
-- wall.css
//Files
index.php, load_messages.php, load_comments.php, message_ajax.php,comment_ajax.php, delete_message_ajax.php, delete_comment_ajax.php

Facebook wall script

Sample database design for Facebook wall script. Contains there tables users, messages and comments.
Users Database Design
Step 1
You have to create following tables otherwise find out wall.sql and execute SQL queries.

Users
Contains user management details username, password, email and etc.
CREATE TABLE `users` (
`uid` int(11) AUTO_INCREMENT PRIMARY KEY,
`username` varchar(255) UNIQUE KEY,
`password` varchar(100),
`email` varchar(255) UNIQUE KEY
)

Messages
Contains messages/updates details messages, created, user and etc.
CREATE TABLE `messages` (
`msg_id` int(11) AUTO_INCREMENT PRIMARY KEY,
`message` varchar(255)
`uid_fk` int(11),
`ip` varchar(30),
`created` int(11),
FOREIGN KEY(uid_fk) REFERENCES users(uid)
)

Comments
Contains user management details username, password, email and etc.
CREATE TABLE `comments` (
`com_id` int(11) AUTO_INCREMENT PRIMARY KEY,
`comment` varchar(255)
`msg_id_fk` int(11),
`uid_fk` int(11),
`ip` varchar(30),
`created` int(11),
FOREIGN KEY(uid_fk) REFERENCES users(uid),
FOREIGN KEY(msg_id_fk) REFERENCES messages(msg_id)
)

Step 2
MySQL database configuration settings.

db.php
You have to modify Host, Username and Password.
<?php
define('DB_SERVER', 'Host');
define('DB_USERNAME', 'User Name');
define('DB_PASSWORD', 'Password');
define('DB_DATABASE', 'Database');
$connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
$database = mysql_select_db(DB_DATABASE) or die(mysql_error());
?>

Step 3
Root file it includes javascript and css files such as Jquery 1.4.2, jquery.oembed.js, wall.js and wall.css. Note: Expanding URL oembed plugin works with Jquery 1.4.2 problem with Jquery higher versions.

index.php
Contains PHP and HTML code. Included db.php, functions.php, sessions.php and load_messages.php.
<?php
include_once 'includes/db.php';
include_once 'includes/functions.php';
include_once 'session.php';
$Wall = new Wall_Updates();
$updatesarray=$Wall->Updates($uid);
?>
<link href="css/wall.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.oembed.js"></script>
<script type="text/javascript" src="js/wall.js"></script>
What's up?
<form method="post" action="">
<textarea cols="30" rows="4" name="update" id="update" maxlength="200" ></textarea>
<br />
<input type="submit" value=" Update " id="update_button" class="update_button"/>
</form>
<div id="content">
<?php include('load_messages.php'); ?>
</div>

Step 4
Session configuration.
session.php
User authentication success login.php should generate user id value as session.
<?php
session_start();
$uid=$_SESSION['user_id']; // In demo $uid=1
?>

Step 5
Final step if you want to add new functionalities just modify functions.php
CSS design: Status Message Design with CSS

functions.php
Contains PHP code.
<?php
class Wall_Updates
{
// Updates
public function Updates($uid)
{
$query = mysql_query("SELECT M.msg_id, M.uid_fk, M.message, M.created, U.username FROM messages M, users U  WHERE M.uid_fk=U.uid and M.uid_fk='$uid' order by M.msg_id desc ") or die(mysql_error());
while($row=mysql_fetch_array($query))
$data[]=$row;
return $data;
}
//Comments
public function Comments($msg_id)
{
$query = mysql_query("SELECT C.com_id, C.uid_fk, C.comment, C.created, U.username FROM comments C, users U WHERE C.uid_fk=U.uid and C.msg_id_fk='$msg_id' order by C.com_id asc ") or die(mysql_error());
while($row=mysql_fetch_array($query))
$data[]=$row;
if(!empty($data))
{
return $data;
}
}
//Avatar Image
public function Gravatar($uid)
{
$query = mysql_query("SELECT email FROM `users` WHERE uid='$uid'") or die(mysql_error());
$row=mysql_fetch_array($query);
if(!empty($row))
{
$email=$row['email'];
$lowercase = strtolower($email);
$imagecode = md5( $lowercase );
$data="http://www.gravatar.com/avatar.php?gravatar_id=$imagecode";
return $data;
}
else
{
$data="default.jpg";
return $data;
}
}
//Insert Update
public function Insert_Update($uid, $update)
{
$update=htmlentities($update);
$time=time();
$ip=$_SERVER['REMOTE_ADDR'];
$query = mysql_query("SELECT msg_id,message FROM `messages` WHERE uid_fk='$uid' order by msg_id desc limit 1") or die(mysql_error());
$result = mysql_fetch_array($query);
if ($update!=$result['message'])
{
$query = mysql_query("INSERT INTO `messages` (message, uid_fk, ip,created) VALUES ('$update', '$uid', '$ip','$time')") or die(mysql_error());
$newquery = mysql_query("SELECT M.msg_id, M.uid_fk, M.message, M.created, U.username FROM messages M, users U where M.uid_fk=U.uid and M.uid_fk='$uid' order by M.msg_id desc limit 1 ");
$result = mysql_fetch_array($newquery);
return $result;
}
else
{
return false;
}
}
//Delete update
public function Delete_Update($uid, $msg_id)
{
$query = mysql_query("DELETE FROM `comments` WHERE msg_id_fk = '$msg_id' ") or die(mysql_error());
$query = mysql_query("DELETE FROM `messages` WHERE msg_id = '$msg_id' and uid_fk='$uid'") or die(mysql_error());
return true;
}
//Insert Comments
public function Insert_Comment($uid,$msg_id,$comment)
{
$comment=htmlentities($comment);
$time=time();
$ip=$_SERVER['REMOTE_ADDR'];
$query = mysql_query("SELECT com_id,comment FROM `comments` WHERE uid_fk='$uid' and msg_id_fk='$msg_id' order by com_id desc limit 1 ") or die(mysql_error());
$result = mysql_fetch_array($query);
if ($comment!=$result['comment'])
{
$query = mysql_query("INSERT INTO `comments` (comment, uid_fk,msg_id_fk,ip,created) VALUES ('$comment', '$uid','$msg_id', '$ip','$time')") or die(mysql_error());
$newquery = mysql_query("SELECT C.com_id, C.uid_fk, C.comment, C.msg_id_fk, C.created, U.username FROM comments C, users U where C.uid_fk=U.uid and C.uid_fk='$uid' and C.msg_id_fk='$msg_id' order by C.com_id desc limit 1 ");
$result = mysql_fetch_array($newquery);
return $result;
}
else
{
return false;
}
}
//Delete Comments
public function Delete_Comment($uid, $com_id)
{
$query = mysql_query("DELETE FROM `comments` WHERE uid_fk='$uid' and com_id='$com_id'") or die(mysql_error());
return true;
}
}
?>

Collaboration of Previous post.
Live Update and Delete Records with Animation Effect using Jquery and Ajax
Facebook like multi Toggle Comment Box with jQuery and PHP
Submit multiple forms with jQuery and Ajax
Delete Records with Random Animation Effect using jQuery and Ajax

How to add new function/method.
For example if you want to get image path value. Just include the following function inside class Wall_Updates{}. Alter table users add image_path text;
public function Image_Path($uid)
{
$result = mysql_query("SELECT image_path FROM users WHERE uid = $uid");
$user_data = mysql_fetch_array($result);
echo $user_data['image_path'];
}

Display image paht value.
<?php
$Wall = new Wall_Updates();
$image=$Wall->Image_Path($uid);
$user->Image_Path($uid);
echo "<img src='$image'/>"
?>


Installation Video


Note: New subscribers email data update every 18 hours
Comments
{ 329 comments }
Jay said...

This is amazing! Wow really liked it.

Anonymous said...

amazing, but i think than the comments schema on database must be comment text

Άγγελος Α. Αλεξόπουλος said...

Really great work.... But can you help me with a php version problem. I am using php 5.3 and I get the "Function eregi_replace() is deprecated
"error. Please can you update the toLink function with the preg_replace.?

Thanks a lot mate for your really nice and ellegant work.. Keep up!

Anonymous said...

download is not working it is going to the tutorial. also why is there no facebook connect for the comments on this site?

Exr Rh said...

Amazing : )

Anonymous said...

Srivas, ur the MAN!

Srinivas Tamada said...

Subscriber emails update every 18 hours.

Why no facebook connect for comments?

9lessons.info powered by blogger

Irwan said...

Good Tutor Srinivas. Its amazing. I like it.
Im very very thank to you

Anonymous said...

Great but what about add pictures with a lightbox ????

Owner 9buku.com said...

Salam,..
how to add notifications to the email,...

Jeffrey said...

Excelente hermano, mil y mil gracias.

Pascal said...

Hay,
Thats really usefull ;)

Anonymous said...

God Bless you.....

Loco Life Latino said...

Table Messages: COMMA MISSED LINE 3
Table Comments: COMMA MISSED LINE 3

What do you mean by "... how to display old updates."? Because i didnt find anything related about in this script

Good tutorial! Greetings.

Diane said...

Hello, this post it's really great.
How can I do to refresh the wall, I mean to make a new comment show automatically while the user has opened its wall? Take care.

muzeeb said...

Hi Everyone ,
I would like to implement Parent Child relationship between html tables using Datatables plugin and php.

Could u show me one example how to implement with php and jquery plugin.

muzeeb said...

Hi evryone,

How to select an image(blob) from the oracle database and how to insert an image into oracle database using php and jquery.

Could u please give me a example.

Sanchit said...

Very Nice Tutorial and i am proud of u that u r indian

Anonymous said...

great tutorial, can you make a version with voting system?

hoponhiggo said...

anybody else encountered 'Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /home/chiggo12/public_html/pwnedbookv4/includes/functions.php on line 10'

???

Barrett said...

Great script thanks

smit desai said...

FOREIGN KEY(uid_fk) REFERENCES users(uid)
this is not working

I can use only primary key , unique key & index key plz help me

Srinivas Tamada said...

@SmitDesai Create 'Users' tables first

Anonymous said...

Note for anybody who may be struggling with this like i was..This is written in PHP5. You must be using PHP5 for this to work.

Diane said...

Hello, this post it's really great.
How can I do to refresh the wall, I mean to make a new comment show automatically while the user has opened its wall? Take care.

Anonymous said...

i have uploaded script to my site and changed the db files as explained. The box to insert a message is displayed and messages are stored in my database but not on the page.

Anybody know why?

Smit said...

Thanx for your previous help

I create all table & given correct locations

but now I get error on index page as below

php_network_getaddresses: getaddrinfo failed: No such host is known.

sam said...

hi,nice tutorial...
Is it possible to combine your Collapsed Comments funtion to this.
Mind to add it to this tutorial??...
Thankx in advance.

Srinivas Tamada said...

@Smit

May be problem with $ip=$_SERVER['REMOTE_ADDR']; meanwhile just disable this line.

Smit said...

sorry but same error again

php_network_getaddresses: getaddrinfo failed: No such host is known.

I removed $ip=$_SERVER['REMOTE_ADDR'];
line which is twice in function.php

& yes i would like to tell i upload all this file in zymic.com

is there problem in server ?

Ecommerce website development said...

Wow.Its really wonderful script on php.This blog really helps visitors understand face wall script.I must appreciate your efforts.

Srinivas Tamada said...

@Sam

Collapsed Comments

http://www.9lessons.info/2009/12/display-collapsed-comments-like.html

Srinivas Tamada said...

Download CSS update replace following css class on css/wall.css

.stcommenttext
{
margin-left: 45px;
min-height: 40px;
word-wrap: break-word;
overflow: hidden;
padding: 3px;
display: block;
font-size: 11px;
width: 340px;
}

dave said...

@Anonymous

I think its because the page displays messages of either the demo user or logged-in users, so we would need to set a login form...
Srinivas, is it necessary to login as a user to post? If so, how to implement that?

Thanks for the tutorial!

Anonymous said...

Hi! I visit your blog very often, but I didn't comment your posts until now. The scripts posted here are really great. I'm working with ASP.NET not PHP, and every script I found here is just a good guide to me to do that working in ASP.NET with jQuery of course. Great work, keep going on.

Diane said...

Hello, how can I implement a automatic refresh like facebook? can you please do a tutorial? it would be really great. please.

Folksnode said...

hi, how can i search with (select) the post from all my fiends (only) not the whole database in mysql to post in the wall..? if you know i really appreciate your help...
you do great tutorials, keep going on.

Jegan Raja said...

nice tutorial. planing to use in my social project

hoponhiggo said...

Still having problems with messages and comments not being displayed when the pages is refreshed.

Anybody else know a fix to this?

Ketahui Selengkap nya Tentang Ku... said...

hey sir..!!!
I only want status update like that.. real time...

Anonymous said...

Great tutorial

Anonymous said...

Why when i put a link of youtube video is cok and in my downloaded code only shows the link?

Shuya Ays said...

hey i know it is very easy .....but i'm dont know about mysql creating table , i download your script ..... and go doing what you say.. but i m getting this error msg : Table 'surban6_world.messages' doesn't exist where suraban6_world is my Mysql Username .. have any idea please help me ....

Vijay Gupta said...

I like this article. it is really nice.

Anonymous said...

Respect for Srinivas, I really like your articles. Maybe it's nice to add a function like:

add a title to the video you add, or text you add. Something like:


I read here a book:
- here the video / picture etc. -

Shuya Ays said...

you says that create a table ~~ Actually i dont know about PHP ~ MySql ~ will you post new topic on creating table for user ~ Message ~ comment ?? i will be thankfull if you explain that briefly. please post that soon ....

Srinivas Tamada said...

@Shuya

Import wall.sql file using mysql administrator or PhpMyAdmin

Shuya Ays said...

i try to import but it shows ErroR : MySQL said: Documentation
#1046 - No database selected

Srinivas Tamada said...

@Shuya Please try to learn at least basics.

Juan said...

Hi, I have a little trouble with this script.
At the time I click on the "update" button it doesn't update the messages, I mean, the message I wrote appears in the database but not on the wall, how can I fix it?

Diane said...

Hello, how can I implement a automatic refresh like facebook? can you please do a tutorial? it would be really great. please.

hoponhiggo said...

Srinivas,

Can you provide a little more detail and how to set this up?

I have created the tables, changed the database settings and uploaded the script.

However, messages are not displayed when the page is refreshed.

Also, in the database, it always shows the 'uid_fk' as '1' regardless of who is logged in and posted the messages.

Your scripts are quality but a little more detail and support is required

Srinivas Tamada said...

@Hopohiggo

Have you modified $uid value at session.php

shaan said...

great work mate ..thanks

Srinivas Tamada said...

Friends tonight I will release wall script installation screen-cast video.

Bryn Nicholas said...

As always first class. This is one of my fav blogs. Thanks again!

Bryn Nicholas said...

One thing I have noticed, it does fail on HTML validation. I've managed to modify the code and eliminate most of the errors however the code is repeating id's ($msg_id). Have you thought of how to get around this?

Srinivas Tamada said...

@Bryn

You have to add prefix for IDs. I feel private pages not required W3 validations and SEO standards

Kim said...

@Srinivas
I can`t seem to locate where you`ve defined that it only should load the current $Session user messages, and not all messages in the "messages" table.

Mark said...

Hi Srinivas, great tutorial but could you add some details on modifying the javascript? I've had no issues with customising the php and database side but I want to let users put in a name and email before posting. But I can't figure out how to pass the extra variables through your javascript script.

Srinivas Tamada said...

@Mark

Please check my previous post. This is just collaboration of my old posts.

Anonymous said...

@srinivas

Thank you for posting the video and clarifying the installation process.

I would like to ammend the script to show all messages. How can this be done?

George said...

Hello, how can I implement an automatic refresh like facebook? can you please do a tutorial/add a javascript code for that? it would be really great. please.
Thanks in advance.
Superb tutorial.

Diseño Web said...

Excellent tutorial, thank you for sharing :)

soon min said...

@srinivas

can u help me? can u tell me what should i code in session.php? please =[

Anonymous said...

I too am also having problems with the session.php

Anonymous said...

Srinivas, facebook and twitter updates feed time auto. Can you make a tutorial on this.

I am following your blog for a long time. You are doing a great work.

Smit said...

Working nice but I have doubt

1. I attach the whole thing with my register , login , logout , member page .
2. It is working fine .
3. As you told I changed session.php
User authentication success login.php should generate user id value as session.php as

?php
session_start();
$uid=$_SESSION['user_id']; // In demo $uid=1
?

4. problem here is the member is not able to view or comment to the other members post ; will you help me solve this problem ?

Thank you

Anonymous said...

Hello,

first of all thanks for sharing this awesome script.

It works great but i would like to ask you some things.

1) i want to make it work with TaskFreak users.
i made it and i change the queries.
But in session php i add

$uid = $pDefaultUserId;
where $pDefaultUserId is the user session id of logged user and after this i add a javascript alert of $pDefaultUserId to test it and on the alert i get the right id , but the comments and posts always getting user 0 .
Do you know why is that happening ?
if i add manually $uid 1 or 2 or anything else works great

2) i cannot add greek characters , i tried utf8 database , making all files utf8 , i tried with setnames, urf8 on mysqlquery, but nothing

3) when i add a video , i get the player like your demo , but after some visits on the page, or some refresh i'm not getting any more the player but only the link

4) and finally , is there any pagination for the comments ?

Anonymous said...

Srinivas are you for hire? i'd like to pay you to implement some of these scripts.

Srinivas Tamada said...

@Smit

Follow this tutorial my labs.9lessons database design

http://www.9lessons.info/2010/04/database-design-create-tables-and.html

allos said...

Hello,

first of all thanks for sharing this awesome script.

It works great but i would like to ask you some things.

1) i cannot add greek characters , i tried utf8 database , making all files utf8 , i tried with setnames, urf8 on mysqlquery, but nothing

2) and finally , is there any pagination for the comments ?

Anonymous said...

hi, it's a great script
but is there a login script that i can use pleaz

Mcboudani said...

hello,
it's a great tutorial is there a login script that i can use with facebook wall 3.0 pleaz

Srinivas Tamada said...

Twitter and Facebook style load more results

http://www.9lessons.info/2009/12/twitter-style-load-more-results-with.html

Mcboudani said...

how to : PHP Login Page Example.
lock.php


and


pleaz

Anonymous said...

i tried to use the more result script you make but i can't get it to work. I see with Firebug that i get response from ajax_more.php with the right results , but nothing appears to the main page .
i add the script to the main index.
i add the limit to the query on functions.php and the
$msg_id=$row['msg_id'];
$message=$row['message'];

Any ideas ? Any guide on how to merge these two scripts ??

OLBER said...

I try to create the table with thats sentence:

CREATE TABLE `messages` (
`msg_id` int(11) AUTO_INCREMENT PRIMARY KEY,
`message` varchar(255)
`uid_fk` int(11),
`ip` varchar(30),
`created` int(11),
FOREIGN KEY(uid_fk) REFERENCES users(uid)
)

but Mysql on Phpmyadmin dont let me create, mysql shows this error:


#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'uid_fk` int(11),
`ip` varchar(30),
`created` int(11),
FOREIGN KEY(`uid_fk`) R' at line 4

Srinivas Tamada said...

@Olber

Execution tables order Users, Messages and finally Comments

OLBER said...

Thansk, the error was a "," after mesagge. Srinivas i cant download the files in zip, check the Url of download Script

Srinivas Tamada said...

@Olber

Subscriber mails updated.

hoponhiggo said...

@Srinivas

I have successfully installed this script, but the wall only shows posts of the logged in user.

How can i change this to show all posts?

Srinivas Tamada said...

@Hoponhiggo

You have to chage the Updates function SQL statement. Read the following link

http://www.9lessons.info/2010/04/database-design-create-tables-and.html

Said Mdee (Kompanda.com) said...

BUG FIX:

For the script to be a real facebook; from function.php on line 12 remove the words in double quotes below.

"and M.uid_fk='$uid'"

Leaving the words in the query results into seen your own posts (messages)

Thaninrat said...

Thankyou, this is really helpful.
I have learn a lot form your script.

Juan said...

What if I want to embed an image instead a video?

Kim said...

I`ve implemented the script, and I`m experiencing a bug. When another user are adding a message, the youtube embed code disappear and the URL is only showing. Have someone located this bug in the code?

light_img said...

I did. Because of this I'm trying to add "Facebook like url extractor" instead.

hoponhiggo said...

@srinivas

Could you please do a tutorial on how to implement a friends system to go with this script?

Kim said...

The solution to my problem is to donwload the latest oembed release:
http://code.google.com/p/jquery-oembed/downloads/detail?name=jquery.oembed.1.1.0.zip&can=2&q=
and use this instead

calkizz said...

Hello guys, and Srinivas Tamada, i have tried to implement this code and its working fine, the Updates are posting to the DB and are fetched back and displayed, My problem is here,

$('.commentopen').live("click",function()
{
var ID=$(this).attr("id");

......
How can i make this id unique so that when i click on a "comment" link it opens commen_text_area for that update. Because now its opening for only one no matter the one you click. How do i make this "id" Unique for each update.

I have tried
a href='#' id='' title="comment"

But its not working.
Please help.

calkizz@yahoo.com

Anonymous said...

Srinivas Tamada I love this script, i have modified to my needs except one issue... i need it to let people make longer posts i have altered the database, but i can't find where in the script that it shortens user input.

thanks!!!

Anonymous said...

Im sorry about my last post, it is actually only removing part of the links, I can post as much text if I want, if it is a link it takes out everything past & and the & sign... I have set up a simple form using the same database and the same tolink function, and it stores the information correctly. I also added a field image link, it works as long as there aren't any "special characters" in it, but if there is, it removes it and everything past it... thanks for any advice...judy

Diabola said...

heh ;)
Great work u did. I modified it my way, but it's not parsing anymore.
Could you explain this, how it's parsing links etc., i need to understand it, that would be more than nice :))

Thank you.

Anonymous said...

Ok there's bug with oembed.
If I post some link it's parsing, and if I then post some text the link before will not be parsed :/

Any Fixxing Ideas??

mmdohsaid said...

i got problem with Arabic it look hebro

usman said...

Hi when i click the download button it opens demo page
plz update it

Srinivas Tamada said...

@Usman

Download button available header right top.

Marco Neves said...

Hello is giving the script error how to solve this special character to follow the tutorial but the error message continued when I add that has "dog" = "Ã § Ã £ o"? will be error UTF8

Guna B.Sc(Che)., MCA said...

Hi, Your wall script is amazing...

Now the problem is i have a table called friends list with fields, id, user_id, rel_id(relation id).

Now i want to integrate friends message to my wall.. How to do that?

Thanks in advance

Harpreet Singh said...

Nice work you have a great mind.........nice work.

Anonymous said...

great work!

Anonymous said...

how to do multy sessions

Anonymous said...

How to creat pagination for the comments?

Rhoely Maguire said...

can I split this script between 'form input' with 'load_message.php' in the different file?
(sorry my english too bad)

Greg Graffin said...

good tut

Neha Palav said...

I have followed whatever u have said...there is no error in the database..bt wenevr i type and press the update button..nothing is displayed on my wall..please help me with the same...

MiGuE said...

Hi, I dont download the script, no email found subscribe below but I subscribe here! what happend please....

Anonymous said...

how would i add an image upload to your script?

MiGuE said...

good excuse.
Your script is very good thank you ... but I want to make is that registered users to leave comments on any page you place the application for comment.

Understood to be done through sessions but not to start. I could help with that thanks to research or have an idea where to begin because I'm new to php

Culex said...

Eregi has been depreseated, this should do the trick :-)

function tolink($text){
$text = html_entity_decode($text);
$text = " ".$text;
$text = preg_replace('/(((f|ht){1}tp:\/\/)[-a-zA-Z0-9@:%_\+.~#?&\/\/=]+)/i',
'\\1', $text);
$text = preg_replace('/(((f|ht){1}tps:\/\/)[-a-zA-Z0-9@:%_\+.~#?&\/\/=]+)/i',
'\\1', $text);
$text = preg_replace('/([[:space:]()[{}])(www.[-a-zA-Z0-9@:%_\+.~#?&\/\/=]+)/i',
'\\1\\2', $text);
$text = preg_replace('/([_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,3})/i',
'\\1', $text);
return $text;
}

miguel angel said...

Hola saludos de peru.
gracias por el post es muy bueno!!
ahora mi pregunta disculpa mi ingles no es muy bueno.
1. How I do for anyone to see the comments left byusers.
2. that users do identify to leave your comment
but that the comments look for all, not only for one users. like this comment box. thanks

Anonymous said...

Hi!

Something is wrong with oembed?

If another post doesnt contain link to video all others post with oembed wont show. Just a link.

B and C Hosting said...

The download link is bringing me back to the demo. Is there any download link ?

srinivasu.kanakamedala said...

sir ihave small peoblem with facebook wall sript...i created login and register page sir...but i could not generate the session id..please send me login.php to generate session id to wall.php...
thank you

fred said...

hello,
how to create a page with all users?

Anonymous said...

Hi!
My error the character coding.

Wrong character: áéűúó
This i get: áéűúó

Terry said...

GREAT WORK!!
How can I add the code for the http://www.9lessons.info/2009/12/display-collapsed-comments-like.html to the facebook script. A updated version with that would be nice.

Jonathan said...

hello can you help me convert eregi to preg_match because preg_match is faster.

In your code, you use eregi. This is your code tolink.php

$text = eregi_replace('(((f|ht){1}tp://)[-a-zA-Z0-9@:%_\+.~#?&//=]+)',
'\\1', $text);
$text = eregi_replace('(((f|ht){1}tps://)[-a-zA-Z0-9@:%_\+.~#?&//=]+)',
'\\1', $text);
$text = eregi_replace('([[:space:]()[{}])(www.[-a-zA-Z0-9@:%_\+.~#?&//=]+)',
'\\1\\2', $text);
$text = eregi_replace('([_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,3})',
'\\1', $text);

Thanks

Srinivas Tamada said...

@Janathan Sure. Thank you :)

Frankie Stans said...

Hi,

Great script and job done!
Question:
How can you remake this script so that only users of a certain group can display/add post to th group facebook wall? So FB authentication and connection is needed.

Greeting from cold Belgium :-)

Joe Smith said...

Hello buddy. great tutorial... one more thing though... I am using an array to hold all the users friends. for example

1, 45, 27, 17, 29, 93

the array is the id of the members... now when I want to only show the status messages for the peoples friends... how can I make the sql match against the array will i have to do another for each ? please give me an example code thanks buddie :)

Fire_crow said...

you are awesome !! thanks

Blogs 4 seo said...

Thanks for this great tutorials.I looking for that tutorials for my site.Thanks again.

Anonymous said...

I need to support with thai mysql
Help me pls..

Anonymous said...

thanks but where i get wall.js?

Admin said...

is there any way to limit the comment count?

jesperkaae said...

hey Srinivas.
please help me! i need to made an include in the function file, but i can't when i do it over class it can't find it, and if i do it under public function it still dont work, where can i put a include php in the function file so it works?

robert said...

Very nice! is it possible to add "view all" comments if there are more than 10 comments???

Anonymous said...

This script is really super. Tried somebody to put it in a active site, not blog, which have already members? I tried but i have problems with connection to data base . You can advice me Srinivas.Indeesd you are very smart . Sorry for my bad english . You can help me pls ? I put on my site it,s work the script very well and it,s very nice but i have problem with the data base .It,s normal i must make other tables for conections . Ty in advance Dr Srinivas .

Omkar yadav said...

Hi
I have download the script but it's not working because that is the FAQ your sql query when execute then raised a error and when any users come to download the files then you did not provide the full script

Anonymous said...

hi srinivash here is some problem in script, because when we post a new text comment over the youtube or any video link, then video link didnt work.

moso said...

hi Srinivas I have problem character " áéűúó "

Srinivas Tamada said...

Coming week I'm going to release version 4.0

allos said...

Finally :D
I hope it will support pagination

Anonymous said...

where is load_message.php?

Rahul Sharma said...

hello thanks for the grt work . i have been using your version 3.0 and now u gonna release version 4.0 please can u also release update from 3.0 to 4.0 so that is easy for people to upgrade the script. thanks frnd

Abhimanyu singh rathore said...

hey its working fine but how to post comment as a diff. user ???

Abhimanyu singh rathore said...

hey how to post comment as a diff. user

heeheehaha45 said...

hello Srinivas Tamada ,
I download the code from the tutorial , it works fine in chrome, but problematic in firefiox6. The comment text of the messages is below the writer's picture. But when i view your online demo, everything works well. Is there any difference between your demo code and the download code?

Thanks

Anonymous said...

I'm waiting for version 4 :D :D
Will support greek characters ?
Show more button on bottom of comments ?
Like ?
Tell us what new :D :D

Anonymous said...

sir i their is no email update there...whenever i try to download script....plz help...

Anonymous said...

where is 4.0? :)

Anonymous said...

yeah :( where is it ? :'(

Brent said...

I have signed up and trying to download bit it tells me I am not signed up

http://www.9lessons.info/2011/05/facebook-wall-script-with-php-and.html

Anonymous said...

Sorry but the videos of youtube, i cant insert, can you help me...please
erick.fix @ hotmail.com

Srinivas Tamada said...

Youtube api updated. We have to update our jquery.oembed.js plugin.

araba said...

thank you admin

dave said...

also is version 4 coming out soon? thanks for this great script btw, i have learn't loads on your site!

Srinivas Tamada said...

Facebook Wall Script 4.0 commercial version.

Srinivas Tamada said...

Mails updated

Terry said...

When is 4.0 lesson coming?

Srinivas Tamada said...

It's ready demo video pending.

dave said...

will 4.0 have "load more" and paging, how much will it be and how long before release? Thanks

Anonymous said...

Wall Script 4.0 can deploy my site and database? or just for blog is Srinivas? I can use for all my users from my site? Tanks in advance

Anonymous said...

if i use facebook accound,how can I?

Djtale said...

If I had a comment with "+1", the wall displays "1". The + disappears.

Could someone help me to keep the + in my text ?

Thanks.

Anonymous said...

Exelente, me encanta :D

Tusar said...

Hi Srinivas. I am a regular visitor of 9lessons. Please suggest me how do i add this wall script to a drupal 7 site. I want to show the facebook wallposts of the site owner on his website. How do i do that. Please suggest me

Anonymous said...

nice tutorial

Anonymous said...

nice, very nice

Anonymous said...

hello frnd . thank u for such a nice script . can u plz tell me when u gonna release the version 4 of this script, i am very eager to buy it. thanks again

Anonymous said...

when is version 4 gonna release??? plz can u tell this

Srinivas Tamada said...

4.0 Release on 3rd Oct

Anonymous said...

Any word on 4.0?

Anonymous said...

but today is 5th Oct and... :(
I'm really curious to see version 4.0

Anonymous said...

Cant wait until 3rd OCT! :)

Farzin said...

Today is 5th of october. I am eagerly waiting for that.

Jeyaganesh said...

what is the syntac highlighter that u are using?

Srinivas Tamada said...

Wall Script 4.0 is UP

http://www.9lessons.info/2011/05/facebook-wall-script-with-php-and.html

Anonymous said...

why I have to buy wall script 4.0 if using wall script 3.0 and your posts I can create it easily by myself? :] ihihiiihi

Nguyễn Trọng Hóa said...

:D. i using wall script 3. it's greate

Anonymous said...

Where i can download this files : load_messages.php, load_comments.php, message_ajax.php,comment_ajax.php, delete_message_ajax.php, delete_comment_ajax.php

Please help me

Anonymous said...

for Wall Script 3,

the videos of youtube.com, i cant insert, can you help me...please

(Youtube api updated. We have to update our jquery.oembed.js plugin.)<- not working/no change

sven.schuett@wallraff.de

Anonymous said...

Hi I really liked this tutorial, I'm testing it because it seems very interesting, if all goes well I'd buy the 4.0 version. I've implemented without any problems, I have only one question, not how to make a user accesses the 'wall' of another user and leave your message or comment here.

I thought of creating a 'wall_id' for each 'wall' has an identification number belonging to a particular user so you can access it and leave my message, do not know if this would be the best option. If it should not be variations in multiple files or simply change the 'index.php' would suffice. Can anyone guide me about it? Does version 4.0 details how to do this? Greetings

Anonymous said...

Hi I really liked this tutorial, I'm testing it because it seems very interesting, if all goes well I'd buy the 4.0 version. I've implemented without any problems, I have only one question, not how to make a user accesses the 'wall' of another user and leave your message or comment here.

I thought of creating a 'wall_id' for each 'wall' has an identification number belonging to a particular user so you can access it and leave my message, do not know if this would be the best option. If it should not be variations in multiple files or simply change the 'index.php' would suffice. Can anyone guide me about it? Does version 4.0 details how to do this? Greetings

Fire_crow said...

for Wall Script 3,

the videos of youtube.com, i cant insert, can you help me...please

(Youtube api updated. We have to update our jquery.oembed.js plugin.)<- not working/no change

X2

please can you help me

Fire_crow@hotmail.com

Srinivas Tamada said...

@Youtube updated API HTTP to HTTPs

Anonymous said...

Deleting a post with images doesnt delete the images. How to?

Anonymous said...

hey,
the scripts are wonderful..how do i make the user see updates from other users???this is because each user is restricted to his/her comments...please help

Anonymous said...

@shrivina I have integrated your script into mysite I think there is a bug with snapshot.
When you access wall sometime you have to refresh the page several times before the webcam snapshots work. Do you know why this is happening? this even happens when script is standalone install.

Joseph said...

Hi srinivas?great work! How do i allow users to see other users comments and comment on them?

JC said...

Hi, this is a very good script, but how do i make it as dynamic users login for posting? as i have seem now it is only fixed to a user session and allow other users to actually comment them

Anonymous said...

I have a problem, I use your script for the Russian theme and I need utf-8, but with a change in the tables does not change, and the output is not that necessary.
If you change the message by hand to the table in Russian, it appears, as if to add to the wall for example, "Привет"("hello") prints "Ð ¿Ñ? Ð ¸ Ð ² ÐμÑ?" How to fix?

Александр said...

Спасибо за сайт, Много всего полезного нашел для своей социальной сети. Жаль этот скрипт купить не могу. Вразработке

Srinivas Tamada said...

Foreign Language fix.

http://www.9lessons.info/2011/08/foreign-languages-using-mysql-and-php.html

Anonymous said...

Could you please help us define the owner value for when users posts on friend's wall. I only found a reference in your post and didn't find a defined value.

Lanbre Groteo said...

I suscribed to mail list of 9lessons.info and I can´t download the file, why?

Anonymous said...

how to do pagination in my posts?

Anonymous said...

I have been struggling with the sessions.php when i put a value like 1 it works fine but when i do like $uid=SESSION["user_id"] the uid_fk is zero and no comments or messages will be loaded could you please clarify on this?thanks

Anonymous said...

is this real time?

marneezy said...

Hey Srinivas,
Thanks for another great PHP tutorial. Your code is real clean.

I had a question, when you reload the wall, why does it reload empty? I have set the user id to a session variable and it is storing in the database properly.

Is there a way to make the wall display all posts every time?

Thanks!!

Anonymous said...

hello Srinivas,

I have the same probleme with $uid

they dont work can help me to fix the problem

Anonymous said...

Hi Srinivas,

great Script!!! Can you please update the subscribers email? Can't wait to get the whole Script :D.

Tanks!!!

Anonymous said...

Hi!
My error the character coding.

Wrong character: õüäö
This i get: õüäö

NIkhil Pradhan said...

I signed up for your infomercials a day ago but i still cant download the wall script. can you plz help me with that?....love ur work btw!!

Anonymous said...

Hey, can someone please tell me why i cant download scripts even though i registered a day back? :( help.

Dannik said...

hey Srinivas Tamada! russian and romanian don`t work in your script, why? i change the db charset, but the russian and romanian don`t work, how to fix it?

Anonymous said...

i need .zip to version 3.0.! its free ?

Daniel (evameet@gmail.com) said...

please how do i create a sign in and signup script for this plugin

Post a Comment