Home jQuery

jQuery slideToggle Example – Solution to Table Row’s Long List of Options

When building a web application, there are some situations where you want to have long list options for a table row data.

This is where jQuery slideToggle example will be very useful.

In our example for today, I have a list of “Authors”, I wanna have the ability to go to their websites, list of articles, or social networking links easily when the list is shown.

But of course, the “Options” column space is limited.

I have something to introduce to you, a company called "Small Tree," where they design for collaborative editing teams, they provides post production workflow solutions that combine the highest possible performance, ease of use, and reliability, backed by their industry-leading technical support.

Solving Your Table Row Data’s Long List Of Options

Here is how I solved it.

  • I only put three options on the first load. As you can see we have “Edit”, “Delete” and “More” options.
  • The “More” options which is highlighted in “green” will give the user a cue that it can be clicked and more options will be shown, it will beautifully animate to show “more options”.
  • “More” text will become “Less” and will be highlighted in “red” which will give the user a cue that you can hide the options.

other-options-were-shown

CSS code – styling our table.

body{
    font-family:arial,sans-serif;
}

table a{
    color:#039;
    font-weight:bold;
    text-decoration:none;
}

table a:hover{
    color:#000;
    font-weight:bold;
}

th {
    background-color:#b9c9fe;
    color:#039;
    padding: 10px;
}

td {
    background-color:#e8edff;
    padding: 10px;
}

.verticalOption{
    margin:8px 0;
}

.moreOptionsLink{
    background-color:green;
    color:#fff;
    padding: 0 2px;
}

.moreOptionsLink:hover{
    color:#fff;
}

.moreOptions{
    display:none;
}

HTML code – we are using static HTML in this example, in the real world, this HTML should be generated dynamically.

<!-- our example table -->
<table border='0' cellpadding='2'>
    <tr>
        <th>Firstname</th>
        <th>Lastname</th>
        <th>Email</th>
        <th>Username</th>
        <th>Options</th>
    </tr>
    <tr>
        <td>JM</td>
        <td>Dalisay</td>
        <td>jm@gmail.com</td>
        <td>dalisay</td>
        <td>
            <!-- It is important to understand our "Options" HTML structure. -->
            <a href="">Edit</a> / 
            <a href="">Delete</a> /
            <a href="" class="moreOptionsLink">More</a>
            
            <!-- 
                Here are the hidden "moreOptions" 
                    which will be shown when "More" was clicked 
                    and hidden when "Less" was clicked 
            -->
            <div class="moreOptions">
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Articles</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">View Online</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Website</a>
                </div>
                <div class="verticalOption">
                    <a href="https://www.facebook.com/CodeOfANinja" target="_blank">Facebook</a>
                </div>
                <div class="verticalOption">
                    <a href="http://twitter.com/ninjazhai" target="_blank">Twitter</a>
                </div>
                <div class="verticalOption">
                    <a href="https://plus.google.com/103126728967620382717" target="_blank">Google+</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">LinkedIn</a>
                </div>
            </div>
        </td>
    </tr>
    <!-- more table rows should be here -->
</table>

jQuery code – the animation and magic. :)

<!-- include our jQuery -->
<script src="js/jquery-1.9.1.min.js"></script>
<script>
$(document).ready(function(){

    // when "More" or "Less" (class moreOptionsLink) was clicked.
    $(".moreOptionsLink").click(function(){
    
        var txt = $(this).text();
        
        if(txt=='More'){
            /*
             * change the text to "Less"
             * change the background color to "red"
             * which means it shows all the options
             */
            $(this).text('Less');
            $(this).css("background-color","red");
        }
        
        else{
            /*
             * change the text to "More"
             * change the background color to "green"
             * which means it hides other options
             */
            $(this).text('More');
            $(this).css("background-color","green");
        }
        
        /*
         * to animate the container of other options
         * we use jQuery "next" to select the "moreOptions" of the current row
         */
        $(this).next(".moreOptions").slideToggle("fast");
        
        // so that it won't refresh the page
        return false;
    });
});
</script>

Codes combined:

<html>
<head>
    <title>A Way To Solve Long List Of Options Of Your Table Row Data</title>
    
    <!-- just some styling -->
    <style>
    body{
        font-family:arial,sans-serif;
    }
    
    table a{
        color:#039;
        font-weight:bold;
        text-decoration:none;
    }
    
    table a:hover{
        color:#000;
        font-weight:bold;
    }
    
    th {
        background-color:#b9c9fe;
        color:#039;
        padding: 10px;
    }

    td {
        background-color:#e8edff;
        padding: 10px;
    }

    .verticalOption{
        margin:8px 0;
    }
    
    .moreOptionsLink{
        background-color:green;
        color:#fff;
        padding: 0 2px;
    }
    
    .moreOptionsLink:hover{
        color:#fff;
    }
    
    .moreOptions{
        display:none;
    }
    
    </style>
</head>
<body>

<!-- our example table -->
<table border='0' cellpadding='2'>
    <tr>
        <th>Firstname</th>
        <th>Lastname</th>
        <th>Email</th>
        <th>Username</th>
        <th>Options</th>
    </tr>
    <tr>
        <td>JM</td>
        <td>Dalisay</td>
        <td>jm@gmail.com</td>
        <td>dalisay</td>
        <td>
            <!-- It is important to understand our "Options" HTML structure. -->
            <a href="">Edit</a> / 
            <a href="">Delete</a> /
            <a href="" class="moreOptionsLink">More</a>
            
            <!-- 
                Here are the hidden "moreOptions" 
                    which will be shown when "More" was clicked 
                    and hidden when "Less" was clicked 
            -->
            <div class="moreOptions">
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Articles</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">View Online</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Website</a>
                </div>
                <div class="verticalOption">
                    <a href="https://www.facebook.com/CodeOfANinja" target="_blank">Facebook</a>
                </div>
                <div class="verticalOption">
                    <a href="http://twitter.com/ninjazhai" target="_blank">Twitter</a>
                </div>
                <div class="verticalOption">
                    <a href="https://plus.google.com/103126728967620382717" target="_blank">Google+</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">LinkedIn</a>
                </div>
            </div>
        </td>
    </tr>
    <tr>
        <td>Edward</td>
        <td>Morden</td>
        <td>edward_cullen@yahoo.com</td>
        <td>edward</td>
        <td>
            <a href="">Edit</a> / 
            <a href="">Delete</a> /
            <a href="" class="moreOptionsLink">More</a>
            <div class="moreOptions">
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Articles</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">View Online</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Website</a>
                </div>
                <div class="verticalOption">
                    <a href="https://www.facebook.com/CodeOfANinja" target="_blank">Facebook</a>
                </div>
                <div class="verticalOption">
                    <a href="http://twitter.com/ninjazhai" target="_blank">Twitter</a>
                </div>
                <div class="verticalOption">
                    <a href="https://plus.google.com/103126728967620382717" target="_blank">Google+</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">LinkedIn</a>
                </div>
            </div>
        </td>
    </tr>
    <tr>
        <td>Vanessa</td>
        <td>Hudgens</td>
        <td>vane@yahoo.com</td>
        <td>vanessa</td>
        <td>
            <a href="">Edit</a> / 
            <a href="">Delete</a> /
            <a href="" class="moreOptionsLink">More</a>
            <div class="moreOptions">
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Articles</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">View Online</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Website</a>
                </div>
                <div class="verticalOption">
                    <a href="https://www.facebook.com/CodeOfANinja" target="_blank">Facebook</a>
                </div>
                <div class="verticalOption">
                    <a href="http://twitter.com/ninjazhai" target="_blank">Twitter</a>
                </div>
                <div class="verticalOption">
                    <a href="https://plus.google.com/103126728967620382717" target="_blank">Google+</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">LinkedIn</a>
                </div>
            </div>
        </td>
    </tr>
    <tr>
        <td>Michael</td>
        <td>Jackson</td>
        <td>mike@gmail.com</td>
        <td>michael</td>
        <td>
            <a href="">Edit</a> / 
            <a href="">Delete</a> /
            <a href="" class="moreOptionsLink">More</a>
            <div class="moreOptions">
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Articles</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">View Online</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">Website</a>
                </div>
                <div class="verticalOption">
                    <a href="https://www.facebook.com/CodeOfANinja" target="_blank">Facebook</a>
                </div>
                <div class="verticalOption">
                    <a href="http://twitter.com/ninjazhai" target="_blank">Twitter</a>
                </div>
                <div class="verticalOption">
                    <a href="https://plus.google.com/103126728967620382717" target="_blank">Google+</a>
                </div>
                <div class="verticalOption">
                    <a href="https://codeofaninja.com/" target="_blank">LinkedIn</a>
                </div>
            </div>
        </td>
    </tr>
</table>

<!-- include our jQuery -->
<script src="js/jquery-1.9.1.min.js"></script>
<script>
$(document).ready(function(){

    // when "More" or "Less" (class moreOptionsLink) was clicked.
    $(".moreOptionsLink").click(function(){
    
        var txt = $(this).text();
        
        if(txt=='More'){
            /*
             * change the text to "Less"
             * change the background color to "red"
             * which means it shows all the options
             */
            $(this).text('Less');
            $(this).css("background-color","red");
        }
        
        else{
            /*
             * change the text to "More"
             * change the background color to "green"
             * which means it hides other options
             */
            $(this).text('More');
            $(this).css("background-color","green");
        }
        
        /*
         * to animate the container of other options
         * we use jQuery "next" to select the "moreOptions" of the current row
         */
        $(this).next(".moreOptions").slideToggle("fast");
        
        // so that it won't refresh the page
        return false;
    });
});
</script>

</body>
</html>

Download Source Code
You can download all the code used in this tutorial for only $9.99 $5.55!

Related Tutorials

Thank you for learning from our post about jQuery slideToggle Example - Solution Row's Long List of Options!

Home jQuery

FbAlbumPreview jQuery Plugin

Hi there guys! Today I want to share with you a jQuery plugin that I made.

This jQuery plugin will enable your users to preview your web albums instantly.

My inspiration here is the Facebook albums, if you have a Facebook account (I’m sure you have, haha!) and wanted to view the list of albums, you can experience this functionality:

For me, above is a very simple Facebook feature and yet, it’s awesome. It is very convenient for a user to have an album preview just by doing a hover.
Here’s our index.html code:

<html>
    <head>
        <title>FB Album Preview jQuery Plugin by https://codeofaninja.com/</title>
        <!– add some styles –>
        <link rel=‘stylesheet’ type=‘text/css’ href=‘css/style.css’ />
       
    </head>
<body>

<h3>
    Demo of FB Album Preview jQuery Plugin by <a href=‘https://codeofaninja.com/’>The Code Of A Ninja</a>
</h3>


<!– -You can generate all these HTML and JS codes using your server side script -The number of photos or thumbnails to be previewed depends on you –>

<div id=‘mainContent’>

    <!– album # 1 –>

<div class=‘albumDetails’>

<div class=“fbAlbum”>
            <!– the first image is the album cover photo –>
            <img class=“active” src=“images/1.jpg” />
            <img src=“images/2.jpg” />
            <img src=“images/3.jpg” />
            <img src=“images/4.jpg” />
            <img src=“images/5.jpg” />
        </div>


<div class=‘albumTitle’><a href=”>Profile Picture</a></div>


<div class=‘photosNum’>5 photos</div>

    </div>

   
    <!– album # 2 –>

<div class=‘albumDetails’>

<div class=“fbAlbum”>
            <!– the first image is the album cover photo –>
            <img class=“active” src=“images/6.jpg” />
            <img src=“images/7.jpg” />
            <img src=“images/8.jpg” />
        </div>


<div class=‘albumTitle’><a href=”>Mobile Uploads</a></div>


<div class=‘photosNum’>3 photos</div>

    </div>

   
    <!– album # 3 –>

<div class=‘albumDetails’>

<div class=“fbAlbum”>
            <!– the first image is the album cover photo –>
            <img class=“active” src=“images/9.jpg” />
            <img src=“images/10.jpg” />
            <img src=“images/11.jpg” />
            <img src=“images/12.jpg” />
        </div>


<div class=‘albumTitle’><a href=”>Wall Photos</a></div>


<div class=‘photosNum’>4 photos</div>

    </div>

   
</div>


<!– include jQuery library and our FB album preview plugin –>
<script src=“js/jquery.min.js”></script>
<script src=“js/fb.album.preview.js”></script>

<!– this is how we’re gonna use the plugin –>
<script type=‘text/javascript’>
$(document).ready(function(){
    // since all albums images container are under the class ‘fbAlbum’,
    // that’s what we are gonna user as the selector
    $(‘.fbAlbum’).FbAlbumPreview();
});
</script>

</body>
</html>

Our CSS code:

body{
    font-family: ‘helvetica neue’, helvetica, arial, sans-serif;
}

.fbAlbum {
    position:relative;
    width:206px;
    height:206px;
    cursor:pointer;
}

.fbAlbum IMG {
    position:absolute;
    top:0;
    left:0;
    z-index:8;
    width:206px;
    height:206px;
}

.fbAlbum IMG.active {
    z-index:10;
}

.fbAlbum IMG.last-active {
    z-index:9;
}
           
.albumDetails{
    float:left;        
    width:206px;
    height:270px;
    margin:20px;
}

.albumTitle{
    font-family: ‘helvetica neue’, helvetica, arial, sans-serif;
    white-space: nowrap;
    font-weight:bold;
    font-size:14px;
    padding:10px 0 5px 0;
    text-align:center;
   
}

.albumTitle a{
    text-decoration:none;
    color:#3B5998;
}

.albumTitle a:hover{
    text-decoration:underline;
}

.photosNum{
    color:gray;
    line-height:19px;
    font-size:11px;
    text-align:center;
    font-family: ‘lucida grande’, tahoma, verdana, arial, sans-serif;
}

#mainContent{
    width:750px;
    margin:0 auto;
    margin-top:100px;
}

.clearb{
    clear:both;
}

Customization code: Yes, you can supply values to customize the view and fade speed effect of this plugin. The default is viewSpeed = 1000 and fadeSpeed = 500. viewSpeed should always be greater than fadeSpeed.

   $(‘.fbAlbum’).FbAlbumPreview({
        viewSpeed: 800,
        fadeSpeed: 400
    });

viewSpeed – refers to how long the user can take a look at the thumbnail image
fadeSpeed – how long the transition (fade effect) from one image to another will take place

FbAlbumPreview jQuery plugin Code (compressed)

/*FbAlbumPreview jQuery Plugin by Mike Dalisay - https://codeofaninja.com/ */
(function(a) {
    a.fn.FbAlbumPreview = function(b) {
        var c = a.extend({
            viewSpeed: 1e3,
            fadeSpeed: 500
        }, b);
        return this.each(function() {
            var b;
            var d = c.fadeSpeed;
            var e = false;
            a(this).hover(function() {
                var f = a(this);
                b = setInterval(function() {
                    f.find("IMG").show();
                    var a = f.find("IMG.active");
                    if (a.length == 0) {
                        a = f.find("IMG:last")
                    }
                    var b = a.next().length ? a.next() : f.find("IMG:first");
                    a.addClass("last-active");
                    b.css({
                        opacity: 0
                    }).addClass("active").animate({
                        opacity: 1
                    }, d, function() {
                        a.removeClass("active last-active");
                        e = true
                    })
                }, c.viewSpeed)
            }, function() {
                clearInterval(b);
                if (e == true) {
                    var c = a(this);
                    c.find("img").hide();
                    c.find("IMG.active").removeClass("active");
                    var f = c.find("IMG:first").fadeOut(d).fadeIn(d).addClass("active");
                    e = false
                }
            })
        })
    }
})(jQuery)

Download Source Codes
You can download all the code used in this tutorial for only $9.99 $5.55!

Related Tutorials

Thank you for learning from our post about FbAlbumPreview jQuery Plugin.

Home jQuery

Convert a DIV Area to an Editable HTML Form

Hello guys! today we are going to do a code that converts a DIV area to an editable HTML form and save the changes to the database.

We are going to use jQuery, PHP & MySQL ofcourse.

My inspiration for this post is Youtube!

For beginners, this post covers some useful stuff like:

  • jQuery on(), post(), hover(), text(), val(), serialize(), css(), show() and hide() function examples
  • For PDO, we'll cover how to use the SELECT and UPDATE commands for database interaction.
  • You will also learn or see an example on how to submit form without page refresh (AJAX).

Our database would look like this:

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(32) NOT NULL,
  `lastname` varchar(32) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;
–
– Dumping data for table `users`
–

INSERT INTO `users` (`id`, `firstname`, `lastname`, `gender`, `username`, `password`, `modified`) VALUES
(28, 'John', 'Dalisay', 'Male', 'john', 'john123′, '2012-07-23 13:26:39′);

The Code

our libs/db_connect.php code, change as you needed.

<?php
$host = "localhost";
$db_name = "codeofaninja";
$username = "root";
$password = "";
try {
    $con = new PDO("mysql:host={$host};dbname={$db_name}", $username, $password);
}catch(PDOException $exception){ //to handle connection error
    echo "Connection error: " . $exception->getMessage();
}
?>

our index.php code:

<html>
    <head>
        <title>Div to Form – https://codeofaninja.com/</title>
        <!–just to include some styles –>
        <link rel="stylesheet" type="text/css" href="css/style.css" />
    </head>
<body>
<div id='banner'>
    <h2>Code of a Ninja Programming Blog</h2>
    <div>Converting a div to an editable HTML form and save changes to database</div>
</div>

<?php
//just getting the id of the user to be edited
$id = $_REQUEST['id'];

//connect to database
include 'libs/db_connect.php';

try {

    //prepare query
    $query = "select id, firstname, lastname, gender from users where id = ? limit 0,1″;
    $stmt = $con->prepare( $query );
    
    //this is the first question mark on the query above
    $stmt->bindParam(1, $id);
    
    //execute our query
    $stmt->execute();
    
    //store retrieved row to $row variable
    $row = $stmt->fetch(PDO::FETCH_ASSOC);
    
    //values to fill up our form
    $firstname = $row['firstname'];
    $lastname = $row['lastname'];
    $gender = $row['gender'];
    
}catch(PDOException $exception){ //to handle error
    echo "Error: " . $exception->getMessage();
}

?>
<!–start of our form –>
<form id='user_form'>

<!–id field is hidden, this is used to identify what row is to be edited–>
<input type='hidden' value='<?php echo $id; ?>' name='id'/>

<!–
    -just a form made with divs
    -when this div was clicked, it will be a form
–>
<div id='form_div'>
    
    <div class='field'>
        <div class='field_lbl'>Firstname:</div> <!–field name divs –>
        <div class='field_val'>
            <div class='field_div'>
                <!–
                    -this shown on page load
                    -and is hidden when the form_div was clicked
                    -and will be shown again when the user clicked anywhere outside the form_div or cancel button
                –>
                <div id='firstname_text'><?php echo $firstname; ?></div>
            </div>
            <div class='field_input'>
                <!–
                    -this is hidden on page load
                    -and is shown when form_div was clicked
                    -and will be hidden again when the user clicked anywhere outside the form_div or cancel button
                –>
                <input type='text' value='<?php echo $firstname; ?>' name='firstname' id='firstname'/>
            </div>
            <div class='clear_fix'></div>
        </div>
        <div class='clear_fix'></div>
    </div>
    <div class='clear_fix'></div>
    
    <!–same explanation above are given to these next fields–>
    <div class='field'>
        <div class='field_lbl'>Lastname:</div>
        <div class='field_val'>
            <div class='field_div'>
                <div id='lastname_text'><?php echo $lastname; ?></div>
            </div>
            <div class='field_input'><input type='text' value='<?php echo $lastname; ?>' name='lastname' id='lastname' /></div>
            <div class='clear_fix'></div>
        </div>
        <div class='clear_fix'></div>
    </div>
    <div class='clear_fix'></div>
    
    <div class='field'>
        <div class='field_lbl'>Gender:</div>
        <div class='field_val'>
            <div class='field_div'>
                <div id='gender_text'><?php echo $gender; ?></div>
            </div>
            <div class='field_input'>
                <select name='gender' id='gender'>
                    <option <?php if($gender == "Male") echo "selected";  ?> >Male</option>
                    <option <?php if($gender == "Female") echo "selected";  ?>>Female</option>
                </select>
            </div>
            <div class='clear_fix'></div>
        </div>
        <div class='clear_fix'></div>
    </div>
    <div class='clear_fix'></div>
    
    <!–
    -these buttons are hidden on page load
    -they are shown when form_div was clicked
    -and will be hidden again when the user clicked anywhere outside the form_div or cancel button
    —>
    <div class='btns'>
        <input type='button' value='Save' id='save_btn' />
        <input type='button' value='Cancel' id='cancel_btn' />
    </div>
    
</div>

</form>

<script src="js/jquery.min.js "></script>
<script type='text/javascript'>
$( document ).ready( function(){

    enable_hover(); //hover effect is enabled on page load

    $('#form_div').click(function(){
        edit_mode();
    });
    
    //when clicked the cancel button
    $('body').on('click', '#cancel_btn', function(){
        normal_mode(); //back to normal mode
    });
    
    //we used the jquery delegate func for live events
    $('body').on('click', '#save_btn', function(){
        
        //save first here
        //get the current values
        var fn = $('#firstname').val();
        var ln = $('#lastname').val();
        var gender = $('#gender').val();
        
        //the make it appear in the UI
        $('#firstname_text').text(fn);
        $('#lastname_text').text(ln);
        $('#gender_text').text(gender);
        
        //save the actual data
        //we use jquery serialize to serialize the form and easily get the form values
        //this is how to submit or post form without page refresh
        $.post("save.php", 
            $("#user_form").serialize(),
            function(data) {
                //you can do any event you want here
                alert(data); //alert that the date were saved
                normal_mode(); //back to normal mode
            });
            
    });
    
    //this way we can detect if the user clicked outside the form_div area
    $("body").click(function(e) {
        if (e.target.id == "form_div" || $(e.target).parents("#form_div").size()) { 
            //if clicked inside form_div area,
            //do nothing
        } else {
            //if the user clicked outside the form_div area, 
            //we'll be in normal mode
            normal_mode();
        }
    });
   

    
});

function edit_mode(){

    $('#form_div').css({ 'background-color' : '#fff' }); //just make a white background
    $('#form_div').unbind('hover'); //disable hover
    
    $('.field_div').hide(); //hide the text
    $('.field_input').show(); //show the form element
    $('.btns').show(); //show the buttons

}

//the normal state is the appearance of the page/element when it was first loaded
function normal_mode(){
    enable_hover(); //enable the hover effect again
    $('.field_div').show(); //show the texts
    $('.field_input').hide(); //hide the input elements
    $('.btns').hide(); //hide the buttons
}

//hover effect is used when NOT in 'edit form' mode
//we unbind this effect when we are in the 'edit form' mode
function enable_hover(){
    $('#form_div').hover(
        function(){ //when we hover form_div, bg will be gray with a bit of rounded corners
            $(this).css({
                    'background-color' : '#dcdcdc',
                    '-moz-border-radius' : '5px',
                    'border-radius' : '5px'
                    });
        },
        function(){ //when mouse is not hovered, bg will be transparent
            $(this).css({'background-color' : 'transparent'});
        }
    );
}
</script>

</body>
</html>

our save.php code:

<?php
//this is where the data were updated/saved
//connect to database
include 'libs/db_connect.php';

try{
    
    //write query
    //in this case, it seemed like we have so many fields to pass and 
    //its kinda better if we'll label them and not use question marks
    //like what we used here
    $query = "update 
                users 
            set 
                firstname = :firstname, 
                lastname = :lastname,
                gender = :gender
            where id = :id";

    //prepare query for excecution
    $stmt = $con->prepare($query);

    //bind the parameters
    $stmt->bindParam(':firstname', $_POST['firstname']);
    $stmt->bindParam(':lastname', $_POST['lastname']);
    $stmt->bindParam(':gender', $_POST['gender']);
    $stmt->bindParam(':id', $_POST['id']);
    
    // Execute the query
    if( $stmt->execute() ){
        echo "Record was updated.";
    
    }else{
        echo "Unable to update record.";
    }

}catch(PDOException $exception){ //to handle error
    echo "Error: " . $exception->getMessage();
}
?>

our style.css file:

body{
    margin:0;
    font-family:arial, verdana, tahoma;
}
#banner{
    margin:0 0 50px 0;
    padding:20px;
    width:100%;
    height:100px;
}

#form_div{
    padding:10px;
    width:500px;
    margin:0 auto;
}

.field{
    padding: 10px;
}

.field_lbl{
    float:left;
    margin:0 10px 0 0;
    width:80px;
    font-weight:bold;
}

.field_val{
    float:left;
}

.field_div{
    display:block;
}

.field_input{
    display:none;
}

.btns{
    display:none;
    margin:0 0 0 8px;
}

.clear_fix{
    clear:both;
}

Thank you guys for your kind comments, messages and suggestions. I really appreciate it!

Download Source Code

You can download all the code used in this tutorial for only $9.99 $5.55!

Related Tutorials

Thank you for learning from our post about Convert a DIV Area to an Editable HTML Form.

Home Facebook

Display Facebook Data To Website Using PullFb Class

Update: Hi guys! The script on this page is not actively developed anymore, but we have the alternatives! Learn how to display Facebook page data using our links below:

Hi guys! Today I’m going to post about this class I made for pulling data from your Facebook fan page.

In this post we are going to pull data such as photo albums, photos, events, event members, videos and their corresponding likes and comments.

I previously posted about pulling Facebook photos, events and videos with separate but simple methods.

Now this class (pull_fb.class.php), tries to work out all those functions in one with some newly added features.

Display Facebook Data To Website Using PullFb Class

Facebook Database – Facebook API – Your Website

Some people says the old Facebook PHP SDK (2.1.2) don’t work so I used the latest PHP SDK version 3.0.1 that can be downloaded on GitHub. And for this post, the you can download the code I used here:

DOWNLOAD CODE

Facebook Photos

For pulling Facebook albums and photos to website, this version has some new features which includes Facebook like count, comments, comments like count and pagination. Here’s a sample code on how I used the PullFb class to achieve it.

LIVE DEMO

Our index.php code:

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″/>
        <title>The Code Of A Ninja – Pull Photos From Facebook</title>
        <link href=”http://demo.codeofaninja.com/images/favicon.ico” rel=”SHORTCUT ICON”>
        <link rel=”stylesheet” type=”text/css” href=”css/style.css” />
       
    </head>
<body>

<div style=’font-size: 16px; font-weight: bold; margin: 0 0 10px 0;’>
    This demo is synchronized with this
    <a href=’https://www.facebook.com/pages/COAN-Dummy-Page/221167777906963?sk=photos’>
        Dummy Page Album
    </a>
</div>

<?php
echo “<p>COAN Dummy Page Albums</p>”;

//get page number
//if page num was not set, default to page 1
$page_num = isset( $_GET['page'] ) ? $_GET['page'] : 1;

//include our class
include ‘pull_fb.class.php’;

//pass appId, appSecret, and page number
$pull_fb = new PullFb( ‘change_to_your_app_id’, ‘change_to_your_app_secret’, $page_num );

//pass your fan page id
$album_result = $pull_fb->getAlbums( ’221167777906963′ );

//loop through the albums
foreach( $album_result as $key => $value ){
   
    if( trim( $key ) != ‘pull_fb’ ){ //because pull_fb is the settings for paging
   
        //pass album cover photo id to get album cover image
        $album_cover = $pull_fb->getAlbumCover( $value['cover_pid'] );
       
        //display the album details
        echo “<div class=’object_item’>”;
           
            //album cover
            echo “<div class=’field_item’ style=’height:auto;’>”;
                echo “<div class=’lbl’>Album Cover Photo:</div>”;
                echo “<a href=’show_photos.php?aid=” . $value['aid'] . “‘>”;
                    echo “<img src=’$album_cover‘ border=’1′ width=’400px’>”;
                echo “</a>”;
            echo “</div>”;
           
            //album name
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Name:</div>”;
                echo “<div class=’val’>” . $value['name'] . “</div>”;
            echo “</div>”;
           
            //album date created
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Created Date:</div>”;
                echo “<div class=’val’>” . date( ‘l, F d, Y h:i:s A’, $value['created'] ) . “</div>”;
            echo “</div>”;

            //description
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Description:</div>”;
                $description = empty( $value['description'] ) ? “N/A” : $value['description'];
                echo “<div class=’val’>” . $description . “</div>”;
            echo “</div>”;
           
            //where album photos were taken
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Location:</div>”;
                $location = empty( $value['location'] ) ? “N/A” : $value['location'];
                echo “<div class=’val’>” . $location . “</div>”;
            echo “</div>”;
           
            //link to facebook
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album FB Link:</div>”;
                echo “<div class=’val’><a href=’” . $value['link'] . “‘ target=’_blank’>Click Here!</a></div>”;
            echo “</div>”;
           
            //how many photos in the album
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Photo Count:</div>”;
                echo “<div class=’val’>” . $value['photo_count'] . “</div>”;
            echo “</div>”;
           
            //videos included in the album
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Video Count:</div>”;
                echo “<div class=’val’>” . $value['video_count'] . “</div>”;
            echo “</div>”;
           
            //number of likes
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Like Count:</div>”;
                echo “<div class=’val’>” . $value['like_info']['like_count'] . ” people like this album</div>”;
            echo “</div>”;
           
            //number of comments
            echo “<div class=’field_item’ style=’height:auto;’>”;
                echo “<div class=’lbl’>Album Comment Count:</div>”;
                echo “<div class=’val’>” . $value['comment_info']['comment_count'] . ” comments</div>”;
           
            //pass the album object id to get comments
            $comments_result = $pull_fb->getComments( $value['object_id'] );
           
            //loop through comments
            foreach( $comments_result as $key => $value ){
           
                //you can set values to variables
                $text = $value['text'];
                $time = date( ‘l, F d, Y h:i:s A’, $value['time'] );
                $fromid = $value['fromid'];
                $likes = $value['likes'];
               
                //get commenter’s name by passing pass fromid
                $profile_name = $pull_fb->getProfileName( $fromid );
               
                //display the comment details
                echo “<div style=’display:block; text-align:left; float:left; border-bottom:thin solid blue; width:100%;’>”;
                    echo “<div>”;
                   
                        //provide link to commenter’s profile
                        echo “<a href=’https://www.facebook.com/profile.php?id={$fromid}‘ target=’_blank’>”;
                            echo “{$profile_name}“;
                        echo “</a>”;
                        echo ” says:”;
                       
                    echo “</div>”;
                   
                    //display comment
                    echo “<div style=’font-style:italic;’>{$text}</div>”;
                   
                    //the time and number of likes of the comment
                    echo “<div>{$time} | {$likes} people liked this comment</div>”;
                echo “</div>”;
               
            }
           
            echo “<div style=’clear:both;’></div>”;
            echo “</div>”;
        echo “</div>”; //end object_item
        echo “<div style=’clear:both;’></div>”;
    }
   
}

//paging here
//show the page buttons based on the settings returned from getAlbums()
echo “<div style=’font-size:24px;’>”;
    //paging here  
    if( $value['prev_button'] ){
        echo “<a href=’index.php?page=1′>&#9668;&#9668; First</a> “;
        echo “<a href=’index.php?page={$value['prev_page']}‘>&#9668; Previous</a> “;
    }
   
    if( $value['next_button'] ){
        echo “<a href=’index.php?page={$value['next_page']}‘>Next &#9658;</a> “;
        echo “<a href=’index.php?page={$value['last_page']}‘>Last &#9658;&#9658;</a>”;
    }
echo “</div>”;

?>

  </body>
</html>

Our show_photos.php code

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″/>
        <title>The Code Of A Ninja – Pull Data From Facebook</title>
        <link href=”http://demo.codeofaninja.com/images/favicon.ico” rel=”SHORTCUT ICON”>
        <link rel=”stylesheet” type=”text/css” href=”css/style.css” />
       
    </head>
<body>

<div style=’font-size: 16px; font-weight: bold; margin: 0 0 10px 0;’>
    This demo is synchronized with this
    <a href=’https://www.facebook.com/pages/COAN-Dummy-Page/221167777906963?sk=photos’>
        Dummy Page Album
    </a>
</div>

<?php
//get page number
//if page num was not set, default to page 1
$page_num = isset( $_GET['page'] ) ? $_GET['page'] : 1;

//get album id from the url
$album_id = empty( $_REQUEST['aid'] ) ? die( “Album ID cannot be empty” ) : $_REQUEST['aid'];

//include our class
include ‘pull_fb.class.php’;
   
//pass appId, appSecret, and page number
$pull_fb = new PullFb( ‘change_to_your_app_id’, ‘change_to_your_app_secret’, $page_num );

//get the album name based on album id
$album_name = $pull_fb->getAlbumName( $album_id );

//provide link to albums
echo “<div><a href=’http://demo.codeofaninja.com/tutorials/pull-facebook-data/’>Back To Albums</a> | Album Name: <b>” . $album_name . “</b></div>”;

//get photos of the album
$photos_result = $pull_fb->getPhotos( $album_id );

//loop through the photos
foreach( $photos_result as $key => $value ){
   
    if( trim( $key ) != ‘pull_fb’ ){ //because pull_fb is the settings
   
        //set caption to ‘None.’ if no caption was set
        $caption = !empty( $value['caption'] ) ? $value['caption'] : “None.”;
       
        //display the photo details
        echo “<div class=’object_item’>”;
       
            //the photo
            echo “<div class=’field_item’ style=’height:auto;’>”;
                echo “<div class=’lbl’>Photo:</div>”;
                echo “<a href=““ . $value['src_big'] . ““ title=““ . $caption . ““ rel=’lightbox’>”;
                    echo “<img src=’” . $value['src_big'] . “‘ border=’1′ width=’400px’ />”;
                echo “</a>”;
            echo “</div>”;
           
            //caption
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Photo ID:</div>”;
                echo “<div class=’val’>” . $value['pid'] . “</div>”;
            echo “</div>”;
           
            //caption
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Caption:</div>”;
                echo “<div class=’val’>” . $caption . “</div>”;
            echo “</div>”;
           
            //date created
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Created Date:</div>”;
                echo “<div class=’val’>” . date( ‘l, F d, Y’, $value['created'] ) . “</div>”;
            echo “</div>”;

            //date modified
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Modified Date:</div>”;
                echo “<div class=’val’>” . date( ‘l, F d, Y’, $value['modified'] ) . “</div>”;
            echo “</div>”;
           
            //photo position in the album
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Photo Position:</div>”;
                echo “<div class=’val’>” . $value['position'] . “</div>”;
            echo “</div>”;
           
            //link to facebook
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album FB Link:</div>”;
                echo “<div class=’val’>”;
                    echo “<a href=’” . $value['link'] . “‘ target=’_blank’>Click Here!</a>”;
                echo “</div>”;
            echo “</div>”;
           
            //number of likes
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Album Like Count:</div>”;
                echo “<div class=’val’>” . $value['like_info']['like_count'] . ” people like this</div>”;
            echo “</div>”;
           
            //number of comments
            echo “<div class=’field_item’ style=’height:auto;’>”;
                echo “<div class=’lbl’>Album Comment Count:</div>”;
                echo “<div class=’val’>” . $value['comment_info']['comment_count'] . ” comments</div>”;
               
                //pass the object id to get comments of this photo
                $comments_result = $pull_fb->getComments( $value['object_id'] );
               
                //loop through retrieved comments
                foreach( $comments_result as $key => $value ){
               
                    //you can set the values to variables
                    $text = $value['text'];
                    $time = date( ‘l, F d, Y h:i:s A’, $value['time'] );
                    $fromid = $value['fromid'];
                    $likes = $value['likes'];
                   
                    //get commenter’s name by passing pass fromid
                    $profile_name = $pull_fb->getProfileName( $fromid );
                   
                    //display the comment details
                    echo “<div style=’display:block; text-align:left; float:left; border-bottom:thin solid blue; width:100%;’>”;
                        echo “<div>”;
                            //provide link to commenter’s profile
                            echo “<a href=’https://www.facebook.com/profile.php?id={$fromid}‘ target=’_blank’>”;
                                echo “{$profile_name}“;
                            echo “</a>”;
                            echo ” says:”;
                        echo “</div>”;
                       
                        //display comment
                        echo “<div style=’font-style:italic;’>{$text}</div>”;
                       
                        //the time and number of likes of the comment
                        echo “<div>{$time} | {$likes} people liked this comment</div>”;
                    echo “</div>”;
                   
                }
               
                echo “<div style=’clear:both;’></div>”;
               
            echo “</div>”;
           
        echo “</div>”;
   
    }
   
}

    //paging here
    //show the page buttons based on the settings returned from getPhotos()
    echo “<div style=’font-size:24px;’>”;
       
        if( $value['prev_button'] ){
            echo “<a href=’show_photos.php?aid={$_GET['aid']}&page=1′>&#9668;&#9668; First</a> “;
            echo “<a href=’show_photos.php?aid={$_GET['aid']}&page={$value['prev_page']}‘>&#9668; Previous</a> “;
        }
       
        if( $value['next_button'] ){
            echo “<a href=’show_photos.php?aid={$_GET['aid']}&page={$value['next_page']}‘>Next &#9658;</a> “;
            echo “<a href=’show_photos.php?aid={$_GET['aid']}&page={$value['last_page']}‘>Last &#9658;&#9658;</a>”;
        }
    echo “</div>”;
   
?>

    <!– START JLIGHTBOX –>
   
    <link rel=”stylesheet” type=”text/css” href=”jQuery-lightbox/css/jquery.lightbox-0.5.css” media=”screen” />
    <script type=”text/javascript” src=”jQuery-lightbox/js/jquery.js”></script>
    <script type=”text/javascript” src=”jQuery-lightbox/js/jquery.lightbox-0.5.js”></script>
   
    <script type=”text/javascript”>
   
        $(function() {
            $(‘a[@rel*=lightbox]‘).lightBox(); // Select all links that contains lightbox in the attribute rel
        });
   
    </script>
   
    <!– END JLIGHTBOX –>
   
  </body>
</html>

Facebook Events

For pulling Facebook events, it features pulling the event members and their corresponding RSVP status. As for the paging, maybe you can do the same approach I used in pulling Facebook albums and photos.

LIVE DEMO

Our show_events.php code:

<!DOCTYPE html>
<html xmlns=”http://www.w3.org/1999/xhtml”
    xmlns:fb=”http://www.facebook.com/2008/fbml”>
        <head>
            <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″/>
            <title>The Code Of A Ninja – Pull Events From Facebook</title>
            <link href=”http://demo.codeofaninja.com/images/favicon.ico” rel=”SHORTCUT ICON”>
            <link rel=”stylesheet” type=”text/css” href=”css/style.css” />
        </head>
<body>
<?php

//get page number
//if page num was not set, default to page 1
$page_num = isset( $_GET['page'] ) ? $_GET['page'] : 1;

//we have to set timezone to California
date_default_timezone_set(‘America/Los_Angeles’);

//include our class
include ‘pull_fb.class.php’;

//pass appId, appSecret, and page number
$pull_fb = new PullFb( ‘change_to_your_app_id’, ‘change_to_your_app_secret’, $page_num );

//just a heading
echo “<div style=’font-weight: bold; margin: 0 0 20px 0;’>”;
echo “This event list is synchronized with this “;
echo “<a href=’https://www.facebook.com/pages/COAN-Dummy-Page/221167777906963?sk=events’>”;
echo “COAN Dummy Page Events</a></div>”;

//pass your fan page id
$event_result = $pull_fb->getEvents( ’221167777906963′ );

//looping through retrieved data
foreach( $event_result as $key => $value ){

    //see here http://php.net/manual/en/function.date.php for the date format I used
    //The pattern string I used ‘l, F d, Y g:i a’
    //will output something like this: July 30, 2015 6:30 pm

    //getting ‘start’ and ‘end’ date,
    //’l, F d, Y’ pattern string will give us
    //something like: Thursday, July 30, 2015
    $start_date = date( ‘l, F d, Y’, $value['start_time'] );
    $end_date = date( ‘l, F d, Y’, $value['end_time'] );

    //getting ‘start’ and ‘end’ time
    //’g:i a’ will give us something
    //like 6:30 pm
    $start_time = date( ‘g:i a’, $value['start_time'] );
    $end_time = date( ‘g:i a’, $value['end_time'] );

    //display the album details
    echo “<div class=’object_item’>”;
   
    //event image
    echo “<div style=’float: left; margin: 0 8px 0 0;’>”;
            echo “<img src={$value['pic_big']} />”;
    echo “</div>”;
       
        echo “<div style=’float: left;’>”;
           
            //event name
            echo “<div class=’field_item’>”;
                echo “<div class=’val’ style=’font-size: 26px’>”;
                    echo “<a href=’https://www.facebook.com/events/{$value['eid']}/’ target=’_blank’>”;
                        echo $value['name'];
                    echo “</a>”;
                echo “</div>”;
            echo “</div>”;
           
            //event date / time
            echo “<div class=’field_item’>”;
                echo “<div class=’val’>”;
                if( $start_date == $end_date ){
                        //if $start_date and $end_date is the same
                        //it means the event will happen on the same day
                        //so we will have a format something like:
                        //July 30, 2015 – 6:30 pm to 9:30 pm
                        echo “on {$start_date} – {$start_time} to {$end_time}“;
                }else{
                        //else if $start_date and $end_date is NOT the equal
                        //it means that the event will will be
                        //extended to another day
                        //so we will have a format something like:
                        //July 30, 2013 9:00 pm to Wednesday, July 31, 2013 at 1:00 am
                        echo “on {$start_date} {$start_time} to {$end_date} at {$end_time}“;
                }
                echo “</div>”;
            echo “</div>”;
           
            //event location
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>Location:</div>”;
                echo “<div class=’val’>” . $value['location'] . “</div>”;
            echo “</div>”;
           
            //event description
            echo “<div class=’field_item’>”;
                echo “<div class=’lbl’>More Info:</div>”;
                echo “<div class=’val’>” . $value['description'] . “</div>”;
            echo “</div>”;
       
            echo “<div style=’clear: both’></div>”;
           
            //get people invited to the event
            $event_members = $pull_fb->getEventMembers( $value['eid'] );
           
            //loop through event members
            foreach( $event_members as $event_member ){
           
                //get profile pic and name of the event member
                $result = $pull_fb->getProfileDetails( $event_member['uid'] );
                $pic_square = $result[0]['pic_square'];
                $name = $result[0]['name'];
               
                //display event member details
                echo “<div style=’padding:8px 0; text-align:left;’>”;
               
                    //small square profile pic
                    echo “<div style=’float:left; width:40px;’>”;
                        echo “<img src=’{$pic_square}‘ width=’30px’ height=’30px’ />”;
                    echo “</div>”;
                   
                    //provide link to event member profile
                    echo “<div>Name: “;
                        echo “<a href=’https://www.facebook.com/profile.php?id={$event_member['uid']}‘ target=’_blank’>”;
                            echo $name;
                        echo “</a>”;
                    echo “</div>”;
                   
                    //rsvp status
                    echo “<div>RSVP Status: {$event_member['rsvp_status']}</div>”;
                   
                echo “</div>”;
            }
           
        echo “</div>”;
   
    echo “<div style=’clear: both’></div>”;
   
    echo “</div>”;
       
}

?>
</body>
</html>

Facebook Videos

For pulling Facebook videos, it features pulling the comments and likes. As for the paging, maybe you can do the same approach I used in pulling Facebook albums and photos.

LIVE DEMO

Our show_videos.php code:

<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″/>
        <title>The Code Of A Ninja – Pull Videos From Facebook</title>
        <link href=”http://demo.codeofaninja.com/images/favicon.ico” rel=”SHORTCUT ICON”>
        <link rel=”stylesheet” type=”text/css” href=”css/style.css” />
    </head>
<body>

<div class=’page_title’>
    These videos are synchronized with this
    <a href=’https://www.facebook.com/video/?id=221167777906963′ target=’_blank’>
        Dummy Page Videos
    </a>
</div>
<?php

//get page number
//if page num was not set, default to page 1
$page_num = isset( $_GET['page'] ) ? $_GET['page'] : 1;

//include our class
include ‘pull_fb.class.php’;

//pass appId, appSecret, and page number
$pull_fb = new PullFb( ‘change_to_your_app_id’, ‘change_to_your_app_secret’, $page_num );

//pass your fan page id
$videos_result = $pull_fb->getVideos( ’221167777906963′ );

//loop through each videos
foreach( $videos_result as $keys => $value ){
   
    //display video details
    echo “<div class=’object_item’>”;
   
        //video embed html
        echo $value['embed_html'];
       
        //video title
        echo “<div class=’field_item’>”;
            echo “<div class=’lbl’>Title:</div>”;
            echo “<div class=’val’>” . $value['title'] . “</div>”;
        echo “</div>”;
       
        //date created
        echo “<div class=’field_item’>”;
            echo “<div class=’lbl’>Date Created:</div>”;
            echo “<div class=’val’>” . date( ‘l, F d, Y’, $value['created_time'] ) . “</div>”;
        echo “</div>”;
       
        //video description
        echo “<div class=’field_item’>”;
            echo “<div class=’lbl’>Description:</div>”;
            echo “<div class=’val’>” . $value['description'] . “</div>”;
        echo “</div>”;
       
        //fb link to video
        echo “<div class=’field_item’>”;
            echo “<div class=’lbl’>FB Link:</div>”;
            echo “<div class=’val’><a href=’” . $value['link'] . “‘ target=’_blank’>Click Here!</a></div>”;
        echo “</div>”;
                   
        echo “<div class=’field_item’ style=’height:auto;’>”;
       
        //vid is the object id of video, pass to get the comments
        $comments_result = $pull_fb->getComments( $value['vid'] );
       
        //loop through comments
        foreach( $comments_result as $key => $value ){
       
            //you can set values to variables
            $text = $value['text'];
            $time = date( ‘l, F d, Y h:i:s A’, $value['time'] );
            $fromid = $value['fromid'];
            $likes = $value['likes'];
           
            //get commenter’s name by passing pass fromid
            $profile_name = $pull_fb->getProfileName( $fromid );
           
            //display the comment details
            echo “<div style=’display:block; text-align:left; float:left; border-bottom:thin solid blue; width:100%;’>”;
                echo “<div>”;
                    //provide link to commenter’s profile
                    echo “<a href=’https://www.facebook.com/profile.php?id={$fromid}‘ target=’_blank’>”;
                        echo “{$profile_name}“;
                    echo “</a>”;
                    echo ” says:”;
                echo “</div>”;
               
                //display comment
                echo “<div style=’font-style:italic;’>{$text}</div>”;
               
                //the time and number of likes of the comment
                echo “<div>{$time} | {$likes} people liked this comment</div>”;
            echo “</div>”;
           
        }

        echo “<div style=’clear:both;’></div>”;
        echo “</div>”;
        echo “</div>”;
    echo “</div>”;
   
}

?>
   
  </body>
</html>

June 9, 2012 Update: Display Facebook Feed on Website

PullFB Class

Now here’s the code of our class pull_fb.class.php

<?php
require ‘fb-sdk/src/facebook.php’;

class PullFb{
   
    //set properties
    public $facebook;
    public $page_num;
   
    //number of items you want to see per page
    //you can add for other objects such as videos, etc.
    public $albums_per_page = 2;
    public $photos_per_page = 4;
   
    //if you want to exclude some albums like the Profile Pictures and Wall Photos, do something like:
    //$excluded_albums = “AND name <> ‘Profile Pictures’ AND name <> ‘Wall Photos’”;
    //in my example, I’m gonna exclude the wall photos only
    public $excluded_albums = “AND name <> ‘Wall Photos’”;
   
    //same with excluding photos, just state the pid
    public $excluded_photos = “AND pid <> ’221167777906963_1513599′ AND pid <> ’221167777906963_1513596′”;
   
    public function __construct( $appId, $secret, $page_num ){
       
        //create facebook instance
        $this->facebook = new Facebook(array(
          ‘appId’  => $appId,
          ‘secret’ => $secret,
          ‘cookie’ => true, // enable optional cookie support
        ));
       
        //for the page number
        $this->page_num = $page_num;
    }
   
    //this will get facebook albums based on the $owner or fan page id
    public function getAlbums( $owner ){
       
        //we have to get the total number of albums first
        //i don’t know why the count function is not working
        $fql = “SELECT aid FROM album WHERE owner = {$owner} {$this->excluded_albums}“;
       
        //calculatePaging() will give us the paging settings
        //pass the fql and type of object
        $settings = $this->calculatePaging( $fql, ‘album’ );
       
        //get start and end limit for the next fql query
        $start_limit = $settings['start_limit'];
        $end_limit = $settings['end_limit'];
       
        //in this query we will include the paging based on the page number
        $fql = “SELECT
                    aid, object_id, owner, cover_pid, cover_object_id, name, created, modified,
                    description, location, size, link, visible, modified_major, edit_link,
                    type, can_upload, photo_count, video_count,
                    like_info, comment_info
                FROM
                    album
                WHERE
                    owner = {$owner} {$this->excluded_albums}
                LIMIT
                    {$start_limit}, {$end_limit}“;
                   
        //set params
        $params = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //get recordset
        $result = $this->facebook->api( $params );
       
        //we will include the settings to our result variable
        $result['pull_fb'] = $settings;
       
        return $result;
    }

    //this function was made for paging
    public function calculatePaging( $fql, $type ){
   
        //set the params based on passed fql
        //to count the total number of records
        $params = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //get recordset
        $result = $this->facebook->api( $params );
       
        //get the total number of items
        $number_of_items = count( $result );
       
        //we will have the following calculations for the pagination
        //we just need some simple math
       
        //decide how many albums to show per page
        //values was actually declared as class property
        //you can easily add for other types of object
        if( $type == ‘album’ ){
            $items_per_page = $this->albums_per_page;
        }else if( $type == ‘photo’ ){
            $items_per_page = $this->photos_per_page;
        }
       
        //this is the current page
        $curr_page = $this->page_num;
       
        //previous page will be the current page MINUS one
        $prev_page = $curr_page - 1;
       
        //next page will be the current page PLUS one
        $next_page = $curr_page + 1;
       
        //no need to calculate for the first page, obviously, it’s 1
        //calculate last page
        $last_page = round( $number_of_items / $items_per_page );
       
        //detect if prev button will be visible
        if( $curr_page != 1 ){
            $prev_button = true;
        }
       
        //get $albums_shown value
        //it is the number of photos from the first page up to the current page
        $items_shown = $items_per_page * $curr_page;
       
        //detect if next button will be visible
        //if the $number_of_albums were still higher than the $albums_shown, show the next page button,
        //but if they are equal, don’t show the next page button
        if( $number_of_items > $items_shown ){
            $next_button = true;
        }
       
        //get start limit for the fql query
        $start_limit = $items_per_page * $prev_page;
       
        //get end limit
        //i’m not sure why i had to + 1, maybe it’s a facebook bug?
        $end_limit = $items_per_page + 1;
       
        //these are the values or settings returned
        //i made it to an array
        $settings = array(
            ‘number_of_items’ => $number_of_items,
            ‘prev_page’ => $prev_page,
            ‘next_page’ => $next_page,
            ‘prev_button’ => $prev_button,
            ‘next_button’ => $next_button,
            ‘start_limit’ => $start_limit,
            ‘end_limit’ => $end_limit,
            ‘last_page’ => $last_page
        );
       
        return $settings;
    }
   
    //to get photos of an album, we have to pass the album id
    public function getPhotos( $album_id ){

        //we have to get total number of photos first
        //i don’t know why the count function is not working
        $fql = “SELECT object_id FROM photo WHERE aid = ‘” . $album_id .“‘ ORDER BY position DESC”;
       
        //calculatePaging() will give us the paging settings
        //pass the fql and type of object, this is ‘photo’
        $settings = $this->calculatePaging( $fql, ‘photo’ );
       
        //get start and end limit for the next fql query
        $start_limit = $settings['start_limit'];
        $end_limit = $settings['end_limit'];
       
        //query the photos
        $fql = “SELECT
                        object_id, pid, src_small, src, src_big, link, caption, created, modified, position, like_info, comment_info
                    FROM
                        photo
                    WHERE
                        aid = ‘” . $album_id .“‘ {$this->excluded_photos}
                    ORDER BY
                        position DESC
                    LIMIT
                        {$start_limit}, {$end_limit}“;
       
        //set the parameters
        $params = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );

        //get photos recordset
        $result = $this->facebook->api( $params );
       
        //add the settings to the result
        $result['pull_fb'] = $settings;
       
        return $result;
    }
   
    //to get album cover, you need to pass the cover_id or id of the photo
    public function getAlbumCover( $cover_pid ){
   
        //get album cover query
        $fql = “select src_big from photo where pid = ‘” . $cover_pid . “‘”;
       
        $params = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //run the query
        $result = $this->facebook->api( $params );
       
        //the the value and return it
        $value = $result[0]['src_big'];
       
        return $value;
    }
   
    //to get comments, you need to pass the object id, it can be a video, photo, album etc
    //check the fql tables to know object id https://developers.facebook.com/docs/reference/fql/
    public function getComments( $object_id ){
   
        //query the comment
        $fql = “SELECT
                text, time, fromid, likes
            FROM
                comment
            WHERE
                object_id = “ . $object_id;
       
        //set parameters
        $params = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //get recordset
        $result = $this->facebook->api( $params );
       
        return $result;
    }
   
    //to get profile name, you need to pass fromid or the profile id
    public function getProfileName( $fromid ){
        //query commenter / profile name
        $fql = “SELECT
                name
            FROM
                profile
            WHERE
                id = “ . $fromid;
       
        //set the paramters
        $params = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //get the resulting value
        $result = $this->facebook->api( $params );
        $value = $result[0]['name'];
       
        return $value;
    }
   
    //this time we will just get the profile name and profile thumbnail
    public function getProfileDetails( $fromid ){
   
        //select name and pic_square which can be used as profile thumbnail
        $fql = “SELECT
                name, pic_square
            FROM
                profile
            WHERE
                id = “ . $fromid;
       
        //set parameters
        $params = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //get and return the result
        $result = $this->facebook->api( $params );
       
        return $result;
    }
   
    //to get album name, pass the album id
    public function getAlbumName( $aid ){
   
        //query album name
        $fql = “SELECT
                name
            FROM
                album
            WHERE
                aid = ‘{$aid}‘”;
       
        //set parameters
        $params = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //return result value for album name
        $result = $this->facebook->api( $params );
        $value = $result[0]['name'];
       
        return $value;
    }
   
    //to get events, pass the uid or you fan page id
    public function getEvents( $uid ){
        //query the events
        //we will eid, name, pic_big, start_time, end_time, location, description  this time
        //but there are other data that you can get on the event table (https://developers.facebook.com/docs/reference/fql/event/)
        //as you’ve noticed, we have TWO select statement here
        //since we can’t just do “WHERE creator = your_fan_page_id”.
        //only eid is indexable in the event table, so we have to retrieve
        //list of events by eids
        //and this was achieved by selecting all eid from
        //event_member table where the uid is the id of your fanpage.
        //*yes, you fanpage automatically becomes an event_member
        //once it creates an event
        $fql = “SELECT
                    eid, name, pic_big, start_time, end_time, location, description
                FROM
                    event
                WHERE
                    eid IN ( SELECT eid FROM event_member WHERE uid = {$uid} )
                ORDER BY start_time asc”;
                               
        //set parameters
        $param = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );

        //get recordset and retur results
        $result = $this->facebook->api($param);
        return $result;
    }
   
    //this function will get the profile invited to the event
    //pass eid or event id
    public function getEventMembers( $eid ){
       
        //query the members
        $fql = “SELECT
                    eid, uid, rsvp_status
                FROM
                    event_member
                where eid = {$eid}“;
       
        //set params
        $param = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //get result and return it
        $result = $this->facebook->api( $param );
        return $result;
    }
   
    //get the videos
    //pass the owner or the fan page id
    public function getVideos( $owner ){
   
        //query to get videos
        //specify you fan page id, I got 221167777906963
        //you can also use the LIMIT clause here if you want to show limited number of videos only
        $fql = “SELECT
                    vid, owner, title, description, thumbnail_link,
                    embed_html, updated_time, created_time, link
                FROM
                    video
                WHERE owner={$owner}“;
                   
        //set parameters
        $param = array(
            ‘method’ => ‘fql.query’,
            ‘query’ => $fql,
            ‘callback’ => ”
        );
       
        //get recordset and return it
        $result = $this->facebook->api($param);
        return $result;
    }
   
}
?>

This class can be easily modified or extend depending on your needs. You can play around different Facebook tables. Thanks for all your comments, suggestions, catches and contributions from the previous version. Feel free to do that again. :)

Regarding “Headers already sent…” issues, you can learn more fixing that here.

Note: A lot of you is trying this script in localhost, I think this won’t work. Please use this script on your real web host or buy from this bluehost link. Thanks!

Home jQuery

Google Plus Style Notification Box Tutorial

Hi guys! I like the Google+ notification box and lately I wondered how to code a notification box that look like something like that.

I love its simple design and box animation with easing.

So I decided to create my own version.

Today we are going to do a script that will look like the Google+ notification box. I was able to achieve this using jQuery, jQuery easing plugin and PHP.

You should see the live demo before coding:

The database I used (notifications.sql) is included in the code download. Here are the files I used:

  • css/style.css - stylesheet
  • img/ajax-loader.gif - loader image to show while loading the actual notification
  • js/jquery.easing.1.3.js - the plugin used for animation (easing)
  • js/jquery-1.7.1.min.js - our favorite JavaScript library (you can also use the google hosted)
  • config_open_db.php - connect to database
  • index.php - load the notification list and show/hide the box
  • item.php - load the actual notification

index.php code

<!DOCTYPE html>
<html>
	<head>
		<meta http-equiv="content-type" content="text/html; charset=UTF-8">
		<title>Google plus style notification box</title>
		<link rel="stylesheet" type="text/css" href="css/style.css" />
	</head>

<body>

	<div id='bar'>

		<!-- show_notifications when clicked, will show or hide the notification box with fade effect -->
		<div id='show_notifications'>Notifications</div>

		<div style='clear:both;'></div>

		<!-- wrapper is the notification box -->
		<div id="wrapper">

			<!-- div1 will hold the notification list -->
			<div class="full" id="div1">
				<div id='box_header'>
					<div id='noti_text'>Notifications</div>

					<!-- ajax loader was shown when a notification item was clicked -->
					<div id='loader'><img src='img/ajax-loader.gif' /></div>

					<div id='site_link'>
						<a href='https://www.codeofaninja.com/'>+Code of a Ninja</a> &#9658;
					</div>
				</div>

				<div id='noti_list'>
					<?php
					// php code will be here
					?>
				</div>

				<div id='box_footer'>
					<!-- Change link this to your notifications page -->
					<a href='https://www.codeofaninja.com/2012/03/goole-plus-style-notification-box.html?your-link-to-all-notifications/'>View all notifications</a> &#9658;
				</div>
			</div>

			<!-- div2 will hold the actual notification -->
			<div class="full" id="div2">
				<div id='box_header'>
					<div id='noti_text'>&#9668; <a href='#'><span id='back_to_noti'>Back to Notifications</span></a></div>
					<div id='site_link'>
						<a href='https://www.codeofaninja.com/'>+Code of a Ninja</a> &#9658;
					</div>
				</div>

				<div id='actual_notification'>
					<!-- Here is where the actual notification will be loaded -->
				</div>

				<div id='box_footer'>
					<!-- Change link this to your notifications page -->
					<a href='http://yourdomain.com/your-link-to-all-notifications/'>View all notifications</a> &#9658;
				</div>
			</div>


		</div>
	</div>

	<div style='margin-top:20px;'>
		Click the "Notifications" button to show or hide the box.
	</div>

	<div style='margin-top:300px;'>
		<a href='https://www.codeofaninja.com/2012/03/goole-plus-style-notification-box.html'>Tutorial Link Here</a>
	</div>

<!-- javascript code will be here -->

</body>
</html>

PHP Code

Replace "PHP code will be here" line above with the following code.

//this will load the notifications in the database
include 'config_open_db.php';

//selecting record, you can use the limit clause here
//$_GET['owner_id'] is just an example user id passed via url
//you should use session variable here
$sql = "select * from notifications where owner_id = '" . $mysqli->real_escape_string( $_GET['owner_id'] ) . "'";

//query the database
$result = $mysqli->query( $sql );

//count how many records found
$num_results = mysqli_num_rows( $result );

if($num_results>0){ //check if more than 0 record found
	while( $row = $result->fetch_assoc()  ){
		extract($row);

		//display the notification item
		echo "<div class='noti_item'>";

			//noti_id will identify what notification item was clicked
			//which will be used to load the actual notification for the next screen
			echo "<div class='noti_id'>{$id}</div>";
			echo $notification;
		echo "</div>";
	}
}else{
	echo "No notification found.";
}

JavaScript Code

Replace "javascript code will be here" line above with the following code.

<!-- include the jQuery library and jQuery easing plugin -->
<script type='text/javascript' src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script type='text/javascript' src="js/jquery.easing.1.3.js"></script>

<!-- this script will do the animations and loading actual notificaiton -->
<script type='text/javascript'>
$(window).load(function(){
	//show or hide the notification box
	$('#show_notifications').click(function(){
		$('#wrapper').fadeToggle();
	});

	//prepare/show #div2 on load
	$('#div2').css('left','440px').show();


	$('.noti_item').click(function(){

		//show the loader while waiting for the actual notificaiton to be loaded
		$('#loader').show();
		var noti_id = $(this).find('.noti_id').text();

		//item.php will load the actual notification based on the notification id
		$("#actual_notification").load("item.php?id=" + noti_id, function(){

			//after loading the actual notification,
			//hide the loader when the actual notification was loaded
			$('#loader').hide();

			//animate the box
			//hide #div1 (notification list)
			$('#div1').animate(
				{ left: '-440px' },{
					duration: '350',
					easing: 'easeOutQuint'
			});

			//then show #div2(actual notification)
			$('#div2').animate(
				{ left: 0 }, {
					duration: '350',
					easing: 'easeOutQuint'
			});

		});

	});

	//going back to notification list
	$('#back_to_noti').click(function(){

		//hide #div2 (actual notification)

		$('#div2').animate(
			{ left: '440px' },{
				duration: '350',
				easing: 'easeOutQuint'
		});

		//then show #div1 (notification list)
		$('#div1').animate(
			{ left: 0 }, {
				duration: '350',
				easing: 'easeOutQuint'
		});

		return false;
	});

});

</script>

item.php code

<?php
include 'config_open_db.php';

//selecting record
$sql = "select * from notifications where id = '" . $mysqli->real_escape_string( $_GET['id'] ) . "'";

//query the database
$result = $mysqli->query( $sql );

//count how many records found
$num_results = $result->num_rows;

if($num_results >0){ //check if more than 0 record found
    while( $row = $result->fetch_assoc() ){
        extract($row);
        echo "<div class='noti_indi'>";
            echo "<div class='noti_id'>{$id}</div>";
            echo $notification;
        echo "</div>";
    }
}else{
    echo "No notification found.";
}
?>

CSS code

body{
    font-family:arial;
    font-size:14px;
    padding:0;
    margin:0;
}

#bar{
    background-color:#f1f1f1;
    height:72px;
    border-bottom:thin solid #c0c0c0;
    width:100%;
}

#show_notifications{
    padding:8px;
    border:1px solid #c0c0c0;
    background-color:#fff;
    float:right;
    margin:20px 10px 5px 0;
    cursor:pointer;
    -moz-border-radius: 5px;
    -webkit-border-radius: 5px;
    border-radius: 5px;
    font-weight:bold;
}

#loader{
    float:left;
    margin-left:10px;
    display:none;
}

#wrapper{
    width:440px;
    overflow:hidden;
    position:relative;
    height:300px;
    float:right;
    margin:0 10px 0 0;
    display:none;
}

.full{
    position:absolute;
    width:100%;
}

#div1{
    left:0px;
    padding-bottom:35px;
}

#div2{
    display:none;
    background:#FFFF00;
    left:0px;
    padding-bottom:35px;
}

#box_header{
    height:15px;
    width:418px;
    border:thin solid #c0c0c0;
    line-height:15px;
    background-color:#fff;
    padding:10px;
}

#box_footer{
    height:15px;
    width:418px;
    position:absolute;
    bottom:4px;
    border:thin solid #c0c0c0;
    background-color:#fff;
    padding:10px;
    text-align:center;
    color:#4067C9;
}

#box_footer a{
    color:#4067C9;
    text-decoration:none;
}

#box_footer a:hover{
    text-decoration:underline;
}

#noti_text{
    float:left;
    font-weight:bold;
    color:#4067C9;
}

#noti_text a{
    color:#4067C9;
    text-decoration:none;
}

#noti_text a:hover{
    text-decoration:underline;
}

#site_link{
    float:right;
    color:#4067C9;
}

#site_link a{
    color:#4067C9;
    text-decoration:none;
}

#site_link a:hover{
    text-decoration:underline;
}

.noti_item{
    width:400px;
    height:56px;
    line-height:56px;
    border-bottom:thin solid #c0c0c0;
    border-left:thin solid #c0c0c0;
    padding:10px;
}

.noti_indi{
    width:418px;
    border-bottom:thin solid #c0c0c0;
    padding:10px;
}

.clear{
    clear:both;
}

#noti_list{
    height:232px;
    overflow-y:visible;
    overflow-x:hidden;
    border-right:thin solid #c0c0c0;
    background-color:#F0F0F0;
    cursor:pointer;
}

#actual_notification{
    height:232px;
    overflow-y:visible;
    overflow-x:hidden;
    background-color:#F0F0F0;
    border-left:thin solid #c0c0c0;
    border-right:thin solid #c0c0c0;
}

.noti_id{
    display:none;
}

Download Source Code

You can download all the code used in this tutorial for only $9.99 $5.55!

Related Tutorials

Thank you for learning from our post about Google Plus Style Notification Box Tutorial.

Home jQuery

jQuery Redirect onClick Event (New or Same Window)

jQuery Quick Tip: This time I'm gonna show you how to redirect a page to another page or website when a user selected a value from a dropdown list and clicked a button.

We have two buttons here, the first one will redirect you to a website in the same page and the second one will redirect you in new tab (or window, in safari.)

jquery redirect onclick event to a page

Here's the live demo and code:

jQuery Redirect onClick Step by Step

Step 1: Prepare basic HTML page code.

<!doctype html>
<html>
   <head>
      <title>jQuery Redirect OnClick</title>
   </head>
<body>

</body>
</html>

Step 2: Put a drop down list of URLs you want your page to redirect.

<!--
  Here are our form elements,
  we have the select box / dropdown list
  which contains our URLs or links
-->
<select id="websites" style="width:200px;">
  <option value="http://demos.codeofaninja.com/tutorials/jQuery/get_dynamic_div_height.php">Get Dynamic</option>
  <option value="http://google.com">Google</option>
  <option value="https://codeofaninja.com">Blog</option>
  <option value="http://apple.com">Apple</option>
</select>

Step 3: Put the buttons for opening the URL in the same window or another window or tab.

<!--
  And our buttons, the first one is "Open In Same Window"
  which opens the link selected on the dropdown in the same window.
 
  The other button is the "Open In New Tab" which opens the link in
  new tab (or window in safari)
-->
<input type="button" value="Open In Same Window" id="open_same_window" />
<input type="button" value="Open In New Tab" id="open_new_tab" />

Step 4: Include jQuery library and basic jQuery code.

<!-- include our library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script type='text/javascript'>
$(document).ready(function() {

});
</script>

Step 5: Inside the basic jQuery code $(document).ready(function() {..., put the button click event triggers.

//this will be triggered when the first button was clicked
$("#open_same_window").click(function(){
  //this will find the selected website from the dropdown
  var go_to_url = $("#websites").find(":selected").val();
 
  //this will redirect us in same window
  document.location.href = go_to_url;
});

//this will be triggered when the second button was clicked
$("#open_new_tab").click(function(){
  //this will find the selected website from the dropdown
  var go_to_url = $("#websites").find(":selected").val();
 
  //this will redirect us in new tab
  window.open(go_to_url, '_blank');
});

Complete jQuery Redirect onClick Page

 <html>
   <head>
      <title>jQuery Redirect OnClick</title>
   </head>
<body>

<div style="margin:200px 200px;">
   <!--
      Here are our form elements,
      we have the select box / dropdown list
      which contains our URLs or links
   -->
   <select id="websites" style="width:200px;">
      <option value="http://demos.codeofaninja.com/tutorials/jQuery/get_dynamic_div_height.php">Get Dynamic</option>
      <option value="http://google.com">Google</option>
      <option value="https://codeofaninja.com">Blog</option>
      <option value="http://apple.com">Apple</option>
   </select>
 
   <!--
      And our buttons, the first one is "Open In Same Window"
      which opens the link selected on the dropdown in the same window.
     
      The other button is the "Open In New Tab" which opens the link in
      new tab (or window in safari)
   -->
   <input type="button" value="Open In Same Window" id="open_same_window" />
   <input type="button" value="Open In New Tab" id="open_new_tab" />
</div>

<!-- include our library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script type='text/javascript'>
$(document).ready(function() {

   //this will be triggered when the first button was clicked
   $("#open_same_window").click(function(){
      //this will find the selected website from the dropdown
      var go_to_url = $("#websites").find(":selected").val();
     
      //this will redirect us in same window
      document.location.href = go_to_url;
   });
 
   //this will be triggered when the second button was clicked
   $("#open_new_tab").click(function(){
      //this will find the selected website from the dropdown
      var go_to_url = $("#websites").find(":selected").val();
     
      //this will redirect us in new tab
      window.open(go_to_url, '_blank');
   });
 
});
</script>

</body>
</html>

Redirecting a page using JavaScript is fun. If you have any other techniques of doing this jQuery redirect onClick event, please drop it in the comments section below! Thanks!

Download Source Code
You can download all the code used in this tutorial for only $9.99 $5.55!

Related Tutorials

Thank you for learning from our post about jQuery Redirect onClick Event (New or Same Window)!

Home jQuery

jQuery: Get Dynamic Div Height

jQuery quick tip: I’m going to show you how to get the height of a dynamic div.

I was in a situation when I have to animate a div by maintaining/grabbing/pausing its current height first but it’s height is not specified in the CSS and is dynamic.

Anyway, this tutorial will focus on how to get the dynamic div’s height.

Here’s a live demo and script:

View Live Demo here

<html>
    <head>
        <title>jquery get dynamic div height</title>
        <!– just some styles –>
        <style type=‘text/css’>
        #div_1{
           width:150px;
            border:thin solid red; 
            float:left;
        }
        .btn{
            padding:10px; 
        }
        </style>
    </head>
<body>

<!– the div with some contents in which we will get the height –>
<div id=‘div_1′>
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis
dapibus, mauris ac feugiat bibendum. 
</div>

<!– onClick of this button, some text will be added and display the div_1 height –>
<input type=‘button’ class=‘btn’ id=‘add_text’ value=‘Add Text and Get New Height’ />

<!– This will display the current height –>
<div id=‘result’></div>

<script src=“https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js”>
</script>
<script type=‘text/javascript’>
$(document).ready(function() {
    //load the current height
    get_div_height();

    $(“#add_text”).click(function(){
        //append the some text to change current height
        $(“#div_1″).append(“The Code of a Ninja.”);
        
        //load the new height
        get_div_height();
    });

    //function to get current div_1 height
    function get_div_height(){
        var div_height = $(“#div_1″).height();
        $(“#result”).html(“div height is: “ + div_height + ” px”);
    }
    
});
</script>

</body>
</html>

You can also get your browser’s current window height by doing:

    $(window).height()

and your document’s height (height of html document) by:

    $(document).height()

more info on this link. :)

Home jQuery

Simple jQuery AJAX Pagination with PHP and MySQL – Step By Step Guide!

UPDATE: You should learn not only the AJAX pagination. Learn the PHP CRUD (create, read, update, delete, etc.) operations as well.

Go to our PHP, MySQL and AJAX CRUD Tutorial – Step by Step Guide!

Hi there! Today we are going to do a very simple yet useful script for your web apps.

A jQuery AJAX pagination with the help of a PHP pagination class. This is very easy to use and integrate with your project.

This code will load the paginated data via AJAX, we’ll have some loader image to make it look good and user friendly.

Paginated data was returned by our PHP script with the help of a Modified PS_Pagination Class (Yes, I modified it myself since I want to use this Awesome pagination class with jQuery.)

Paginating Your Data with jQuery AJAX and Awesome PHP Pagination Class

We are going to have the following files for today’s code:
1. images/ajax-loader.gif – for our loader animation
2. js/jquery-1.4.js – our favorite javascript library
3. libs/ps_pagination.php – the pagination class I modified
4. styles/style.css – style for our table data and page number navigation
5. db_connect.php – for database connection
6. index.php – our main UI
7. search_results.php – returns the data that will be displayed to index.php

1.0 Prepare our database table and data.

We’re gonna use the following sample table structure and data.

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(32) NOT NULL,
  `lastname` varchar(32) NOT NULL,
  `email` varchar(32) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `username`, `password`, `modified`) VALUES
(28, 'John', 'Dalisay', '', 'john', 'john123', '2012-01-15 07:26:14'),
(39, 'Jem', 'Panlilio', '', 'jemboy09', 'jem123', '2012-01-15 07:26:46'),
(40, 'Darwin', 'Dalisay', '', 'dada08', 'dada123', '2012-01-15 07:25:34'),
(46, 'Jaylord', 'Bitamug', '', 'jayjay', 'jay123', '2012-01-15 07:27:04'),
(49, 'Justine', 'Bongola', '', 'jaja', 'jaja123', '2012-01-15 07:27:21'),
(50, 'Jun', 'Sabayton', '', 'jun', 'jun123', '2012-02-05 10:15:14'),
(51, 'Lourd', 'De Veyra', '', 'lourd', 'lourd123', '2012-02-05 10:15:36'),
(52, 'Asi', 'Taulava', '', 'asi', 'asi123', '2012-02-05 10:15:58'),
(53, 'James', 'Yap', '', 'james', 'jame123', '2012-02-05 10:16:17'),
(54, 'Chris', 'Tiu', '', 'chris', 'chris123', '2012-02-05 10:16:29');

2.0 Create our database connection file

Create db_connect.php file. The following code is how we connect to the database. We are using the PDO extension here.

<?php
// Database credentials
$db_host = "your_db_host";
$db_name = "your_db_name";
$db_username = "your_db_username";
$db_password = "your_db_password";

try {
	// Get database connection
	$conn = new PDO("mysql:host={$db_host};dbname={$db_name}", $db_username, $db_password);
}

// Handle connection error
catch(PDOException $exception){
	echo "Connection error: " . $exception->getMessage();
}
?>

3.0 Prepare your loader image and jQuery

Create "images" folder and put your loader GIF image inside this folder. Generate and download your AJAX loader from the ajaxload.info website.

Create "js" folder. Download jQuery and put it inside the "js" folder.

If you're not yet familiar with jQuery, I highly recommend studying our jQuery Tutorial for Beginners – Step By Step Guide!

4.0 User interface

Our user interface will be represented by our index.php file.

<!DOCTYPE HTML>
<html>
	<head>
		<title>jQuery AJAX and PHP Pagination Demo - codeofaninja.com</title>

		<!-- Include custom CSS. -->
		<link rel="stylesheet" type="text/css" href="styles/style.css" />

	</head>
<body>

<div id='retrieved-data' style='height:15em;'>
	<!--
	This is where data will be shown.
	-->
    <img src="images/ajax-loader.gif" />
</div>

<script type = "text/javascript" src = "js/jquery-1.7.1.min.js"></script>
<script type = "text/javascript">
$(function(){
	// show the first page
	getdata(1);
});

function getdata(pageno){
	// source of data
	var targetURL = 'search_results.php?page=' + pageno;

	// show loading animation
	$('#retrieved-data').html('<img src="images/ajax-loader.gif" />');

	// load to show new data
	$('#retrieved-data').load(targetURL).hide().fadeIn('slow');
}
</script>

</body>
</html>

5.0 Getting the page data

This will be the code inside our search_results.php file, where our modified pagination class was used.

<?php
// Connect to database.
include 'db_connect.php';

// Include our pagination class / library.
include 'libs/ps_pagination.php';

// Query all data anyway you want
$sql = "select * from users ORDER BY firstname DESC";

/*
	Now, we are going to use our pagination class.
	This is a significant part of our pagination.

	I will explain the PS_Pagination parameters:

	> $conn is a variable from our config_open_db.php
	> $sql is our sql statement above
	> 3 is the number of records retrieved per page
	> 4 is the number of page numbers rendered below
	> null - We used null because we don't have any other parameters to pass

	(i.e. param1=valu1&param2=value2)
	You can use this if you are going to use this class for search results.
	The last parameter is useful because you will have to pass the search keywords.
*/
$pager = new PS_Pagination($conn, $sql, 3, 4, null);

// Our pagination class will render new recordset.
// Search results now are limited for pagination.
$rs = $pager->paginate();

// Count how many rows of data were returned.
$num = $rs->rowCount();

if($num >= 1 ){
	// Create our table header
	echo "<table id='my-tbl'>";
	echo "<tr>";
		echo "<th>Firstname</th>";
		echo "<th>Lastname</th>";
		echo "<th>Email</th>";
	echo "</tr>";

	// Loop through the records retrieved
	while ($row = $rs->fetch(PDO::FETCH_ASSOC)){
		echo "<tr class='data-tr' align='center'>";
		echo "<td>{$row['firstname']}</td>";
		echo "<td>{$row['lastname']}</td>";
		echo "<td>{$row['email']}</td>";
		echo "</tr>";
	}

	echo "</table>";
}else{
	// If no records found
	echo "No records found!";
}

// 'page-nav' CSS class is used to control the appearance of our page number navigation
echo "<div class='page-nav'>";
	// Display our page number navigation
	echo $pager->renderFullNav();
echo "</div>";
?>

6.0 Modified PS_Pagination Class

The previous section will not work without the PS_Pagination class we modified. Create "libs" folder. Open "libs" folder. Create ps_pagination.php file. Put the following code inside it.

<?php
/**
 * PHPSense Pagination Class
 *
 * PHP tutorials and scripts
 *
 * @package		PHPSense
 * @author		Jatinder Singh Thind
 * @copyright	Copyright (c) 2006, Jatinder Singh Thind
 * @link		http://www.phpsense.com
 * @modification		Mike Dalisay
 * @link				https://www.codeofaninja.com
 */

// ------------------------------------------------------------------------

class PS_Pagination {
	var $php_self;
	var $rows_per_page = 10; //Number of records to display per page
	var $total_rows = 0; //Total number of rows returned by the query
	var $links_per_page = 5; //Number of links to display per page
	var $append = ""; //Paremeters to append to pagination links
	var $sql = "";
	var $debug = false;
	var $conn = false;
	var $page = 1;
	var $max_pages = 0;
	var $offset = 0;
	
	/**
	 * Constructor
	 *
	 * @param resource $connection Mysql connection link
	 * @param string $sql SQL query to paginate. Example : SELECT * FROM users
	 * @param integer $rows_per_page Number of records to display per page. Defaults to 10
	 * @param integer $links_per_page Number of links to display per page. Defaults to 5
	 * @param string $append Parameters to be appended to pagination links 
	 */
	
	function PS_Pagination($connection, $sql, $rows_per_page = 10, $links_per_page = 5, $append = "") {
		$this->conn = $connection;
		$this->sql = $sql;
		$this->rows_per_page = (int)$rows_per_page;
		if (intval($links_per_page ) > 0) {
			$this->links_per_page = (int)$links_per_page;
		} else {
			$this->links_per_page = 5;
		}
		$this->append = $append;
		$this->php_self = htmlspecialchars($_SERVER['PHP_SELF'] );
		if (isset($_GET['page'] )) {
			$this->page = intval($_GET['page'] );
		}
	}
	
	/**
	 * Executes the SQL query and initializes internal variables
	 *
	 * @access public
	 * @return resource
	 */
	function paginate() {
		//Check for valid mysql connection
		
		
		//Find total number of rows
		$all_rs = $this->conn->prepare( $this->sql );
		$all_rs->execute();
		
		if (! $all_rs) {
			if ($this->debug)
				echo "SQL query failed. Check your query.<br /><br />Error Returned: " . mysql_error();
			return false;
		}
		$this->total_rows = $all_rs->rowCount();
		
		//Return FALSE if no rows found
		if ($this->total_rows == 0) {
			if ($this->debug)
				echo "Query returned zero rows.";
			return FALSE;
		}
		
		//Max number of pages
		$this->max_pages = ceil($this->total_rows / $this->rows_per_page );
		if ($this->links_per_page > $this->max_pages) {
			$this->links_per_page = $this->max_pages;
		}
		
		//Check the page value just in case someone is trying to input an aribitrary value
		if ($this->page > $this->max_pages || $this->page <= 0) {
			$this->page = 1;
		}
		
		//Calculate Offset
		$this->offset = $this->rows_per_page * ($this->page - 1);
		
		//Fetch the required result set
		$query = $this->sql . " LIMIT {$this->offset}, {$this->rows_per_page}";
		$rs = $this->conn->prepare( $query );
		$rs->execute();
		
		if (! $rs) {
			if ($this->debug)
				echo "Pagination query failed. Check your query.<br /><br />Error Returned: " . mysql_error();
			return false;
		}
		return $rs;
	}
	
	/**
	 * Display the link to the first page
	 *
	 * @access public
	 * @param string $tag Text string to be displayed as the link. Defaults to 'First'
	 * @return string
	 */
	function renderFirst($tag = 'First') {
		if ($this->total_rows == 0)
			return FALSE;
		
		if ($this->page == 1) {
			return "$tag ";
		} else {
			//return '<a href="' . $this->php_self . '?page=1&' . $this->append . '">' . $tag . '</a> ';
            //default to one (1)
            return " <a href='javascript:void(0);' OnClick='getdata( 1 )' title='First Page'>$tag</a> ";
		}
	}
	
	/**
	 * Display the link to the last page
	 *
	 * @access public
	 * @param string $tag Text string to be displayed as the link. Defaults to 'Last'
	 * @return string
	 */
	function renderLast($tag = 'Last') {
		if ($this->total_rows == 0)
			return FALSE;
		
		if ($this->page == $this->max_pages) {
			return $tag;
		} else {
			//return ' <a href="' . $this->php_self . '?page=' . $this->max_pages . '&' . $this->append . '">' . $tag . '</a>';
            $pageno = $this->max_pages;
            return " <a href='javascript:void(0);' OnClick='getdata( $pageno )' title='Last Page'>$tag</a> ";
		}
	}
	
	/**
	 * Display the next link
	 *
	 * @access public
	 * @param string $tag Text string to be displayed as the link. Defaults to '>>'
	 * @return string
	 */
	function renderNext($tag = '&gt;&gt;') {
		if ($this->total_rows == 0)
			return FALSE;
		
		if ($this->page < $this->max_pages) {
			//return '<a href="' . $this->php_self . '?page=' . ($this->page + 1) . '&' . $this->append . '" title=\'next to\'>' . $tag . '</a>';
            $pageno = $this->page + 1;
            return " <a href='javascript:void(0);' OnClick='getdata( $pageno )' title='Next Page'>$tag</a> ";
		} else {
			return $tag;
		}
	}
	
	/**
	 * Display the previous link
	 *
	 * @access public
	 * @param string $tag Text string to be displayed as the link. Defaults to '<<'
	 * @return string
	 */
	function renderPrev($tag = '&lt;&lt;') {
		if ($this->total_rows == 0)
			return FALSE;
		
		if ($this->page > 1) {
			//return ' <a href="' . $this->php_self . '?page=' . ($this->page - 1) . '&' . $this->append . '">' . $tag . '</a>';
            $pageno = $this->page - 1;
            return " <a href='javascript:void(0);' OnClick='getdata( $pageno )' title='Previous Page'>$tag</a> ";
		} else {
			return " $tag ";
		}
	}
	
	/**
	 * Display the page links
	 *
	 * @access public
	 * @return string
	 */
	function renderNav($prefix = '<span class="page_link">', $suffix = '</span>') {
		if ($this->total_rows == 0)
			return FALSE;
		
		$batch = ceil($this->page / $this->links_per_page );
		$end = $batch * $this->links_per_page;
		if ($end == $this->page) {
		//$end = $end + $this->links_per_page - 1;
		//$end = $end + ceil($this->links_per_page/2);
		}
		if ($end > $this->max_pages) {
			$end = $this->max_pages;
		}
		$start = $end - $this->links_per_page + 1;
		$links = '';
		
		for($i = $start; $i <= $end; $i ++) {
			if ($i == $this->page) {
				$links .= $prefix . " $i " . $suffix;                                       
			} else {
				//$links .= ' ' . $prefix . '<a href="' . $this->php_self . '?page=' . $i . '&' . $this->append . '">' . $i . '</a>' . $suffix . ' ';
                //$pageno = $this->page + 1;
                $links .= " <a href='javascript:void(0);' OnClick='getdata( $i )' title='Another page'>$i</a> ";
			}
		}
		
		return $links;
	}
	
	/**
	 * Display full pagination navigation
	 *
	 * @access public
	 * @return string
	 */
	function renderFullNav() {
        //echo $this->renderFirst() . " " . $this->renderPrev();
        
		return $this->renderFirst() . '&nbsp;' . $this->renderPrev() . '&nbsp;' . $this->renderNav() . '&nbsp;' . $this->renderNext() . '&nbsp;' . $this->renderLast();
	}
	
	/**
	 * Set debug mode
	 *
	 * @access public
	 * @param bool $debug Set to TRUE to enable debug messages
	 * @return void
	 */
	function setDebug($debug) {
		$this->debug = $debug;
	}
}
?>

7.0 Style page links

Style your page links, as for this tutorial, I used the following style.css:

<style type='text/css'>         
/*you can change you table style here*/  
#my-tbl {
    background-color: #FFF;
    color: black;
    padding: 5px;
    width: 700px;
    border: thin solid red;
}

#th{
    background-color: #000;
    color: #FFF;
    padding: 10px; 
    border-bottom: thin solid #000;  
}

.data-tr{
    background-color: #FFF;
    color: #000;
    border-bottom: thin solid #000;
}

.data-tr:hover {
    background-color: #FAEFCF;
    color: black;
    padding: 5px; 
    border-bottom: thin solid #000;
       
}

.data-tr td{       
    padding: 10px;            
    margin: 0px;         
}

/* you can change page navigation here*/
.page-nav{
    margin: 10px 0 0 0;
    padding: 8px;
}

.page-nav a{
    border: none;
    padding: 8px;
    text-decoration: none;
    background-color: #FFC;
    border: thin solid #FC0;
    color: #000;
}

.page-nav a:hover{
    border: thin solid #FC0;
    background-color: #FC0;
    color: #fff;
}

/*this is the style for selected page number*/
.page_link{
    padding: 8px;
}
</style>

I decided to delete the old MySQLi and PDO version pages and put it all in this one post. If you want to see the old comments, see MySQLi version old comments and PDO version old comments

Download Source Code

You can download all the code used in this tutorial for only $9.99 $5.55!

Thank you for learning from our post about: jQuery AJAX and PHP pagination example!

RELATED TUTORIAL: PHP, MySQL and AJAX CRUD Tutorial – Step by Step Guide!