MY NODE

Sunday, August 29, 2010

Javascript Go Back Link With History

Here is a really easy way to add a go back link to your page navigation.
This code uses JavaScript to get the browser history for the specific site.

<a href="#" onClick="history.go(-1)">Back</a> 
<input type=button value="Back" onClick="history.go(-1)">

You can change the -1 to any number of pages you need to go back in history :D

Thursday, August 26, 2010

How to add table row (tr) using jQuery

I think the easiest method is to find the last tr and insert the new row after the last tr.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>How to add table rows using jQuery</title>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>

<script>

$(document).ready(function(){    
    
    $('#add').click(function(){
                
        $('#my_tbl tr:last').after('<tr><td>&nbsp;</td><td>&nbsp;</td></tr>');        
    });
});    

</script>
</head>

<body>

<table id="my_tbl" border="1" cellpadding="1" cellspacing="1">
    <tr>
        <td> Head1 </td>
        <td> Head2 </td>
    </tr>
</table>

<br />

<input type="button" id="add" value="Add Row" />

</body>
</html>

View Demo

The only place where this code does not work is when there are no tr's in the table to start with. If that is the case you can always add a dummy <tr></tr> block to the top to start with.

Please comment if you know a better solution.

Monday, August 23, 2010

Best way to get all rows in a mysql table - mysql_num_rows() or count()

Normally there are two ways to get the total number of rows in a mysql table.

$result = mysql_query("select count(id) from table");
$data = mysql_fetch_array($result);
$all_rows = $data[0];

$result = mysql_query("select id from table");
$all_rows = mysql_num_rows($result);

As you have guessed the best server resource friendly method is to use mysql count() function instead of returning all the rows as a result-set to use in php mysql_num_rows() function.

Sunday, August 22, 2010

Convert html/css to pdf using php (html2pdf)

All web developers at one point will need to create pdf documents on the fly with dynamic data.
Usaully php developers go for the fpdf class. html2pdf is very effective php converter you could use in your project that convert html/css into a pdf document.

html2pdf

Wednesday, August 18, 2010

Video thumb rotator with jQuery Cycle Plugin

This is a simple code I used to rotate video thumbs which were retrieved using the YouTube API.
I use the jQuery Cycle Plugin to do the rotation on mouse over.

http://jquery.malsup.com/cycle/

Make sure you download the cycle plugin
http://jquery.malsup.com/cycle/download.html

<html>
<head>
<title>Video thumb rotator with jquery Cycle Plugin</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="jquery.cycle.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
    
    $('.adimagebg').cycle();
    $('.adimagebg').cycle('pause');
    
    $(".adimagebg").hover( function () {
        $(this).cycle({ 
            fx: 'fade',
            speed: 300,
            timeout:  1200
        });
    },
    function(){
        $(this).cycle('pause');
    });
});
</script>
</head>

<body>

    <div class="adimagebg">
        <a href="#"><img width="100" src="image1.jpg" border="0" /></a>
        <a href="#"><img width="100" src="image2.jpg" border="0" /></a>
        <a href="#"><img width="100" src="image3.jpg" border="0" /></a>
    </div>

</body>
</html>

View Demo

Tuesday, August 17, 2010

How to get the totalResults from YouTube video API search

Following code will get the total number of results returned for a given search query, This will help you design custom pagination for the results.

$query = $yt->newVideoQuery();
$query->setOrderBy('updated');
$query->setSafeSearch('none');
$query->setVideoQuery('Test');
$query->setAuthor('GoogleDevelopers');
$query->setMaxResults(10);
$query->setStartIndex(1);
        
$videoFeed = $yt->getVideoFeed($query->getQueryUrl(2));

$all_results = $videoFeed->getTotalResults()->text;

Thursday, August 12, 2010

How to get a editable video entry - youtube api

I'm playing with the youtube api these days, this is another tip I think which will save you some time.

The usual getVideoEntry method will not return you a editable video entries. you must pass some extra parameters like this (3rd parameter tell to get full metadata)

$videoEntry = $yt->getVideoEntry($id, null, true);

or you can use

$entry = $yt->getFullVideoEntry($id);

Tuesday, August 10, 2010

Fatal error: Class 'Zend_Uri_Http' ZendGdata (YouTube API)

I followed the YouTube API - Developer's Guide: PHP, yet I got this error running their code, don't know why they are not updating the guide.

Fatal error: Class 'Zend_Uri_Http' not found in /home/path/public_html/ZendGdata/library/Zend/Gdata/App.php

As the error show us the fix is really simple, just load the Class 'Zend_Uri_Http'

require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Gdata_YouTube');
$yt = new Zend_Gdata_YouTube();

Zend_Loader::loadClass('Zend_Gdata_AuthSub');
Zend_Loader::loadClass('Zend_Gdata_ClientLogin');
Zend_Loader::loadClass('Zend_Uri_Http');

2010/08/14 Note: you have to load this class in your page where you call the YouTube API service (not in any zend php client library files.)