Entity Tutorial

Good entity tutorial  by Lullabot

https://www.lullabot.com/blog/video/what-are-drupal-entitieshttps://www.lullabot.com/blog/video/what-are-drupal-entities

Drupal Modules Used

Login Destination

https://www.drupal.org/project/login_destination

----------------------------------------------------------------------------------------------------------
Views data export

https://www.drupal.org/project/views_data_export

-----------------------------------------------------------------------------------------------------------

Search 404

https://www.drupal.org/project/search404

-------------------------------------------------------------------------------------------------------

Gallery formatter

https://www.drupal.org/project/galleryformatter

----------------------------------------------------------------------------------------------------------

Embedded Media Field

https://www.drupal.org/project/emfield

------------------------------------------------------------------------------------------------------------

Nodequeue

https://www.drupal.org/project/nodequeue

-----------------------------------------------------------------------------------------------------------

String Overrides

https://www.drupal.org/project/stringoverrides

-----------------------------------------------------------------------------------------------------------

Features (also used for transfering content types)

https://www.drupal.org/project/features

--------------------------------------------------------------------------------------------------------

Node export

https://www.drupal.org/project/node_export

--------------------------------------------------------------------------------------------------------

Node Convert

https://www.drupal.org/project/node_convert

-------------------------------------------------------------------------------------------------------

Organic groups

https://www.drupal.org/project/og

Youtube video gallery

Demo:http://flipit.im/showcases

modules used:
colorbox
Video Embed Field

Installation:
------------
1. Download and unpack the Libraries module directory in your modules folder
(this will usually be "sites/all/modules/").
Link: http://drupal.org/project/libraries
2. Download and unpack the Colorbox module directory in your modules folder
(this will usually be "sites/all/modules/").
3. Download and unpack the Colorbox plugin in "sites/all/libraries".
Make sure the path to the plugin file becomes:
"sites/all/libraries/colorbox/jquery.colorbox-min.js"
Link: https://github.com/jackmoore/colorbox/archive/1.x.zip
Drush users can use the command "drush colorbox-plugin".
4. Go to "Administer" -> "Modules" and enable the Colorbox module.


Make a view of your content type

and in manage fields of your content type select thumbnail preveiw with colorbox

When adding videos just enter youtube video url on Video Embed Field like https://www.youtube.com/watch?v=2DfmD6R-dt0

Great Module to display Your newely added image filed of any other field horizontally.

Demo:http://paragonllcapps.com/?q=node/7

Grid Field Formatter

https://drupal.org/project/grid_field_formatter

Depends on


Field formatter settings

https://drupal.org/project/field_formatter_settings


Add these modules 

Go to admin/config/content/grid-field-formatter

enable fields for whom you want these option to be available.

Go to

Home » Administration » Structure » Content types » Apps >> Manage Display Click on configure icon on right side of field and then select the checkbox

Enable multi-value field display with a grid layout.
Enter Number of columns you want to have and you are done.

Show facebook Posts on your Page

Facebook Wall

You can show on a page by creating a region and then assigning block of Facebook Wall plugin in it and display where ever you want in your any TPL file by printing hat particular block.

Example http://www.goodstreets.org/facebook_wall and http://www.goodstreets.org/

Module Link:https://drupal.org/project/facebook_wall

Select Query with multiple conditions

Like we use

Select * from tablename where this=that and this=that

we can do same in Drupal7 as follows

 $query1 = db_select('field_data_field_coupon_date1','f')->fields('f')->condition('entity_id',$enitiy_id,'=')->condition('revision_id',$revision_id,'=')->condition('field_coupon_date1_value',$date,'='); 
$result1 = $query1->execute();
$row1 = $result1->fetchAssoc();

Select Query with a condition , Limit and Order By Clause Drupal 7

$query = db_select('opinions','o')->fields('o')->condition('approved','Yes','=')->condition('bid',$node->nid,'=')->orderBy('opinion_id', 'DESC')->range(0,3); 
$result = $query->execute();
$row = $result->fetchAssoc();
print_r(($row); // to view all fields name
print $row['uid'];