Educate And Advocate

Thursday, March 22, 2012

Closing the PopUp and redirecting Parent Window

I have tried for few hours to solve this problem Here is the simple example which helps you to solve the Problem

Problem:
Create a PopUp window on submission of a value in PopUp the PopUp Closes and the Parent Windows redirects to Some other Page

Solution:
Here is the simple way to solve it

Create 2 php pages

1. popup.php
Copy this Code

<html>
    <head>
    </head>
    <body>
        <a href="#" onclick="window.open('popupcode.php','Login','height=500,width=420,scrollbars=yes');return false;">PopUp</a>
    </body>
    </html>

Go Deep>>>

Tuesday, March 20, 2012

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

Tuesday, March 13, 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

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

Print

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

Tuesday, March 6, 2012

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

Friday, March 2, 2012

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