Pass the form values from one domain to another domain with POST values.

yes. we can pass the form values from one domain to another domain with using POST method. We have to add action attribute in <form> tag.

<form method="POST" action="http://www.anotherdomain.com" target="_parent">

</form>

Restrict cut, copy and paste in text area using Jquery

HTML:

<textarea id="textarea_id" > </textarea>

Script:

$(document).ready(function() {

$('#textarea_id').bind('cut copy paste', function(e) { e.preventDefault(); });

});

Remove or Delete duplicate records in a table in MySQL

Remove the duplicate records in a table, it will delete records which is having greater than the sno

For example: table name: players

sno	name	coach_id
1	Sachin	1
2	Sachin	5
3	Kohli	1
4	Ganguly	2
5	Kohli	4
6	Gambir	3

Query:

DELETE FROM players USING players , players AS virtualtable

WHERE players .sno > virtualtable.sno

AND players .name = virtualtable.name

Output:

sno	name	coach_id
1	Sachin	1
3	Kohli	1
4	Ganguly	2
6	Gambir	3

Display limited records with out using LIMIT in MySQL

If you want to get display limited records with out using LIMIT option in MySQL.

For example: table name: players

sno	name	coach_id
1	Sachin	1
2	Dravid	5
3	Kohli	1
4	Ganguly	2
5	Sehwag	4
6	Gambir	3

Query:

SELECT one.sno, one.name FROM players AS one

WHERE ( SELECT COUNT(*) FROM players AS two WHERE two.sno <= one.sno ) <= 3

Output:

sno	name	coach_id
1	Sachin	1
2	Dravid	5
3	Kohli	1

Get data condition related information from a single table

If you want to display the data with condition based from a single table.

For example: table name: players

sno	name	coach_id
1	Sachin	1
2	Dravid	5
3	Kohli	1
4	Ganguly	2
5	Sehwag	4
6	Gambir	3

Query:

SELECT player.sno, player.name, coach.name AS coachname

FROM players AS coach

JOIN players AS player ON coach.sno = player.coach_id

Output:

sno	name	coach_id
1	Sachin	Sachin
2	Dravid	Sehwag
3	Kohli	Sachin
4	Ganguly	Dravid
5	Sehwag	Ganguly
6	Gambir	Kohli

Facebook and Drupal 6 Implementation

Drupal for Facebook

1.Download Drupal for Facebook Module. And place into sites/all/modules folder.
2.Download Facebook-PHP-SDK library and place into sites/all/libraries folder. Folder should be facebook-php-sdk.
3.In settings.php files, you have to add the following lines,
1.include "sites/all/modules/fb/fb_url_rewrite.inc";
2.include "sites/all/modules/fb/fb_settings.inc";
3.$conf['fb_api_file'] = 'sites/all/libraries/facebook-php-sdk/src/facebook.php';

4.Then enable the following module
1.fb.module
2.fb_app.module
3.fb_connect.module
4.fb_user.module

5.Goto admin/reports/status page and verify the Facebook PHP SDK loaded or not.

6.Then you have to generate the API/Secret key in facebook for your site.
1.App Display Name - Your application display name – Human readable without space
2.App Namespace: Your namespace of your domain (All letters are small)
3.Contact Email – Your Email id
4.Category – Other
5.Website – Site URL – http://www.domain/com

7.Go to admin/build/fb page and configure the Application for Facebook API settings.

8.You have add the following attribute in your html tag: xmlns:fb="http://www.facebook.com/2008/fbml"

Login Button Interface
=================

Manual
---------

$_fb_app = fb_invoke(FB_OP_CURRENT_APP);

$facebook = new Facebook(array(

'appId' => $_fb_app->apikey,

'secret' => $_fb_app->secret,

'cookie' => true,

));

$loginUrl = $facebook->getLoginUrl();

global $base_url;

$params = array( 'next' => $base_url . '/' ); // Custom redirection after logout link press

$logoutUrl = $facebook->getLogoutUrl($params);

?>

Or Drupal Theme

print theme('fb_login_button', t('Connect with Facebook'), array('attributes' => array('size' => 'large', 'background' => 'dark', 'onclick' => 'removePopup();')));

Or FML Tag

<fb:login-button>Connect with Facebook < /fb:login-button>

Or Javascript

<a href=”javascript: doLogin();” > Connect with Facebook < /a>

JS:

doLogin();

function doLogin() {

FB.login(function(response) {

if (response.session) {

FB.api('/me', function(response) {

//alert('User: ' + response.name);

//alert('Full details: ' + JSON.stringify(response));

}

);

}

} , {perms:''});

}

Required Versions:
==============
Drupal 6.x
DFF - 6.x-3.0-beta1
facebook-php-sdk - Facebook PHP SDK (v.3.1.1)

Issues in DFF and Drupal
===================
Whereever they using getSession() function inside fb module folder, we have to repalce getUser() function. Because getSession() is not exist in Facebook PHP SDK kit.