My New Blog: http://blog.thinkdiff.net/

http://blog.thinkdiff.net/

I have moved from here to my new blog: http://blog.thinkdiff.net/

P.s: I will not maintain or update anything in this blog anymore. From today, it’s deprecated!

I’m the winner of Innovation Award December 2008 in phpclasses.org

Thanks Everyone, for giving vote to my class in PHPClasses.org.

I’m very happy to see that, I’m the winner of Innovation Award December 2008 in phpclasses.org. Here is the result

http://www.phpclasses.org/winners/

Eclipse vs NetBeans IDE for php, css, html, javascript

I’ve used 4 IDEs for php based web application development. In my old laptop, I used notepad++ to write php, html, javascript, css code. notepad++ is a very light weight IDE and takes less resources.

**notepad++ IDE is best if your laptop/pc’s configuaration is old.

MySQL – NULL vs ” vs ‘NULL’

Today, in one of my project I’ve to check empty fields.

The field name is: answer it’s type is TEXT and Default value is NULL

In my SQL query I was checked at first answer != NULL (if the answer is not null, i.e if the answer is not empty), But this was not showing the correct result.

Then I changed it to answer != ” ( i.e ” means empty string) then it showed the correct result.
Then I test with this answer != ‘NULL’, and it also showed the correct result.

Please vote me

One of my class is nominated for the award winning competetion in phpclasses.org.

http://www.phpclasses.org/browse/package/4977.html

Please vote me by visiting the above link and by clicking vote.

Or visit this link to vote me: http://www.phpclasses.org/vote.html

Facebook – Friends selection custom component

For 1 of my facebook application, I was  needed a custom friends selector. The purpose was, I’ve a page from where I’ve to select multiple friends and then I’ll submit those selected friend ids using ajax call without refreshing the page.

Then I searched the documentation of fbml. In facebook component, there are 2 types of friends selector

1. http://wiki.developers.facebook.com/index.php/Fb:multi-friend-selector
2. http://wiki.developers.facebook.com/index.php/Fb:multi-friend-selector_(condensed)

But both of these are totally controlled by facebook and these components are used to send invitation or request to friends. I need a component like figure 2. The fbml code for the second component is below:


<fb:request-form method="post" action="http://yourdomain.com/submit.php" content="Select Friends" type="gifts" invite="true">
<div class="clearfix" style="padding-bottom: 10px;">
<fb:multi-friend-selector condensed="true" selected_rows="0" style="width: 220px;" />
</div>
<fb:request-form-submit />
</fb:request-form>

But I need a component that is fully controlled by me. So,  I developed a friends selection component and I’m sharing it.

Here is the outlook of my component:

Download Custom Friends Selector for Facebook Application

There are 3 parts in this code:

1. First part is CSS
2. Second part is Javascript
3. Third part is HTML + PHP
4. So changed the file extension to .php

PHP Expert – A new group in facebook

Today I created a new group called PHP Expert in facebook.

I welcome all of you to join in this group and share whatever you like to develop web application using php.

http://www.facebook.com/group.php?gid=48608046806&ref=mf

Finally I got ZCE hardcopy certificate

After 6 months I got my ZCE Certificate. It looks cool. It comes with a sticker. Here it is: 

Facebook – IFrame vs FBML

For last 6 months, I’ve been working on several facebook application development including my personal apps. All the applications I developed using the FBML as canvas page url. For my last 2 applications, GRE + Sun dictionary I’ve to integrate flash application within canvas page. And I found there are several restriction applied to flash player if I use FBML as canvas page. So this is pain.

MySQL Workbench – Next-generation visual database design application

Visual database design is very essential. Almost every web application needs database. And by designing visual representation, relation of tables makes an developer easy to understand on the database. There are many tools to design database like DBDesigner, SQLYog. Recently I found another application that is called MySQL Workbench. It can be used to efficiently design, manage and document database schemata. After using it’s functionality, I found this is a really good tool for design database specially for MySQL.