Count Number of tables in a Schema

This is a very Simple query to find the number of tables present in a purticular schema of the database


select information_schema as your default schema and use the following query to find the count of number of tables in a particular schema


SELECT count(*) FROM 'TABLES' WHERE TABLE_SCHEMA = 'YOUR_SCHEMA_NAME*'



*YOUR_SCHEMA_NAME = NAME OF THE SCHEMA TO WHICH YOU ARE FINDING THE COUNT

Switch Off Foreign Key Constraint

I used to use this code regularly but when i found it for the first time it took me to read many pages to read after getting the code i thought this would be useful for all people like me who want to Switch off the Foreign key Constraint in their tables

This is helpful when you are actually want to create tables irrespective of the Foreign key constraint 

To Turn Off - SET FOREIGN_KEY_CHECKS = 0;

To Turn On - SET FOREIGN_KEY_CHECKS = 1;

OAuth 2.0

Now its time to Switch on the easier and secured version of OAuth Protocol OAuth 2.0 so here is the presentation i have made which makes u people easy to understand the Protocol and important points to have talk to the server 


Presentation  - Download 




The presentation is based on the Oauth 2.0 written by the developers of Microsoft and Facebook on January 2012

Difference between Echo and Print in Php

We have Echo we have print in php which we use to display the output to the user

Both Echo and Print does the same work - Displaying the output on the screen

But there are couple of differences between them

Echo

1. Output one or more strings
2. Allows More parameters works only with the short open tags
3. It is not a function
   
4. It takes less memory
   

Print

1. Output only one string
2. It allows only one parameter
   
3. Its not a real function but its a language construct
4. It take a little more memory than echo
   

Train Seating Arrangement

I have refered many sites to get this searting arrangement this is almost common in all Indian Trains

Please click Download to get he seating arrangement

Curl Using PHP in a Gist

cURL: It is  a client that deals with URL so its named as cURL so as to say that it deals with URL only 

It is used to make client communicate with the server using command line 
arguments using cURL syntax

Its main use is to provide security to the URL's sent through the browser to the server
 
 The main commands in cURL  which i found is important are


1. curl_init() - with which the main curl operation starts

2.curl_setop($charecter,options,value) - 


                    $charecter = curl handle returned by curl_initi()

           options = curl provides various options with general syntax 

curlOPT_XXX 

                         other options are found in - PHP website

          value = value of the url

3. curl_exec() - which is used to execute a $charecter in which the information has be moved 

4.curl_close() - this is used to close the curl connection

          

Connect With Facebook API in Simple 7 Steps

Here is the presentation or Document Where i have described Simple 7 Steps To Connect to Facebook this can be used to any Social Networking Site

Download the Presentation From this Link ---- Download