Programmer

Happy Holidays Google Logo: Interactive Doodle Plays Music, Dances To 'Jingle Bells' (VIDEO)

noreply@blogger.com (Anonymous) — Sat, 24 Dec 2011 09:04:00 +0530

Google is spreading the holiday cheer with Friday'sGoogle Doodle.

The interactive Google logo, which today is outlined in Christmas lights, features colored boxes under each letter. When you click one of the boxes, the entire background turns black, Google's "G" is replaced by a snowflake and you hear one of the notes from the beginning of "Jingle Bells."

Clicking all of the corresponding boxes allows you to play the beginning of the song, and when you click the last box (it doesn't have to be in any order), "Jingle Bells" plays. The logo transforms, with letters become a dancing snowman, a ringing bell, and a dancing Santa head, among others.

But Google doesn't stop there. When the "Jingle Bells" rendition is over, you're taken to a page that shows you the search results for "happy holidays."

The search giant is famous for its whimsical changes to the company logo to, in the worlds of Google, "celebrate holidays, anniversaries and the lives of famous artists, pioneers and scientists."

Past Google Doodles have celebrated the birthday of Muppets creator Jim Henson, guitar legend Les Paul and Egypt's historic elections.

Earlier this month, Google announced that it had revamped its Google Doodle site so users could continue to enjoy the doodles when they're no longer posted on the homepage.

But enough about the doodle. Turn up the speakers on your computer and get Googling!

Check out the festive doodle (below) and click through the rest of the slideshow to see some of our favorite doodles ever.

Note: At around 5:20 p.m. EST on Friday, the logo's interactive features were unavailable.

Login or Signup with Jquery and PHP

noreply@blogger.com (Anonymous) — Thu, 8 Dec 2011 20:53:00 +0530

Some users doesn't like to filling the registration form. So that I had implemented login and singup fields in same block just controlling with jquery and PHP. It's is very simple javascript and basic PHP code.

Download Script Live Demo

Javascript code

$('#signup').click(function(){} - signup is the ID of the radio.

Using$("#login_block").hide() hide the login block and $("#signup_block").show()

shows signup block.

  
  <script type="text/javascript"

  src="http://ajax.googleapis.com/

  ajax/libs/jquery/1.4.2/jquery.min.js"></script>

  <script type="text/javascript">

  $(document).ready(function()

  {

  $('#signup').click(function()

  {

  $('#password').val('');

  $('#login_block').hide();

  $('#signup_block').show();

  });

  $('#login').click(function()

  {

  $('#newpassword').val('');

  $('#signup_block').hide();

  $('#login_block').show();

  });

  });

  </script>

HTML Code

Contains simple html code. signup_block style display none.

  
  <form method="post" 

  action="loginup.php">

  <div>

  <label>Email</label> <br/>

  <input type="text" 

  name="email"/><br 

  />

  <input type="radio" 

  name="choose" 

  id="login" 

  checked="checked"/> I 

  have an account <br 

  />

  <input type="radio" 

  name="choose" 

  id="signup"/> I 

  am new!<br 

  />

  </div>

  <div id="login_block">

  <label>Password</label><br 

  />

  <input type="password" 

  name="password" 

  id="password"/><br/>

  <input type="submit" value=" Login "/> 

  </div>

  <div id="signup_block" 

  style="display:none">

  <label>Choose 

  password</label><br/>

  <input type="password" 

  name="newpassword" 

  id="newpassword" 

  /><br/>

  <input type="submit" 

  value=" Signup "/>

  </div>

  </form>

loginup.php

  
  <?php

  if($_POST)

  {

  $email = $_POST['email'];

  $password = $_POST['password'];

  $newpassword = $_POST['newpassword'];

  if($_POST['password'] && $_POST['email'])

  {

  $sql=mysql_query("SQl 

  select statement");

  echo "Login 

  success";

  }

  else if($_POST['newpassword'] && $_POST['email'])

  {

  $sql=mysql_query("SQl 

  Insert values statement");

  echo "Registration 

  Success";

  }

  }

  ?>

jQuery Username Availability check

noreply@blogger.com (Anonymous) — Thu, 8 Dec 2011 20:22:00 +0530

This post about Twitter used jQuery plug-in JavaScript code in registration page username Availability check and update Screen name.

This is very useful stuff, this is the best way to implement it and the only thing you have to modify just some database connection parameters.

jQuery Plug-in :Download

Step1: Modifiy dbconnection.php

Change MySQL connection parameters in dbconnection.php

  
  <?php

  $mysql_hostname = "Host 

  name";

  $mysql_user = "UserName";

  $mysql_password = "Password";

  $mysql_database = "Database 

  Name";

  $prefix = "";

  $bd = mysql_connect($mysql_hostname,

  $mysql_user, $mysql_password) or die("Could not connect database");

  mysql_select_db($mysql_database, $bd) or die("Could not select

  database");

  ?>

Step2: cofigure check.php

Change table name and column name in SQL query.

  
   <?php

   // This is a code to check the username from a mysql database table

  if(isSet($_POST['username']))
  {
  $username = $_POST['username'];
  
  include("dbconnection.php");
  
  $sql_check = mysql_query("SELECT 
  user FROM {$prefix}users WHERE user='$username'");
  
  if(mysql_num_rows($sql_check))
  {
  
  echo '<span 
  style="color: red;">The username <b>'.$username.'</b> is already in
  use.</span>';
  }
  else
  {
  
  echo 'OK';
  }}
  
   ?>

Step 3. Add JQuery framework on your page

jQuery Plug-in :Download

First, you have to download the jQuery

plugin and add a link to the

framework within the tag<head> of

the page:

Step 4. Registration.php Code

HTML code for this example is very simple:

  
  <script src="js/jquery.js" type="text/javascript">/script>

  <script type="text/javascript">

  pic1 = new Image(16, 16); 

  pic1.src = "loader.gif";

  $(document).ready(function(){

  $("#username").change(function()

  { 

  var usr = $("#username").val();

  if(usr.length >= 3)

  {

  $("#status").html('<img

  align="absmiddle" src="loader.gif" /> Checking availability...');

  $.ajax({ 

  type: "POST", 

  url: "check.php", 

  data: "username="+

  usr, 

  success: function(msg){ 

  $("#status").ajaxComplete(function(event,

  request, settings){ 

  if(msg == 'OK')

  { 

  $("#username").removeClass('object_error');

  // if necessary

  $("#username").addClass("object_ok");

  $(this).html(' <img align="absmiddle" src="accepted.png" /> ');

  } 

  else 

  { 

  $("#username").removeClass('object_ok');

  // if necessary

  $("#username").addClass("object_error");

  $(this).html(msg);

  }});}});}

  else

  {

  $("#status").html('The 

  username should have at least 3characters.');

  $("#username").removeClass('object_ok'); // 

  if necessary

  $("#username").addClass("object_error");

  }});});

  //-->

  </script>

  <div>

  <label>User name:</label>

  <input type="text" id="username" name="username" class="inn"/> 

  </div>

  <div id="status"></div>

Download

source code

Update Screen Name

settings.js : enables jQuery functionalities

javascript code enables the jQuery functionalities.

  var twitter=function()

  {

  var rtn={updateUrl:function(value){$("#username_url").html(value)},

  screenNameKeyUp:function(){

  jQuery("#user_screen_name").keyup(function(event){var

  screen_name=jQuery("#user_screen_name");

  }

  )

  },return rtn}();

Copy jquery.js and settings.js in js folder

Registration.php Final code

  <html>
  <head>
  
  <script src="js/jquery.js" type="text/javascript">/script>
  
  <script src="js/settings.js" type="text/javascript"></script> 
  
  
  
  <script type="text/javascript">
  pic1 = new Image(16, 16); 
  pic1.src = "loader.gif";
  
  $(document).ready(function(){
  
  $("#username").change(function()
  { 
  
  var usr = $("#username").val();
  
  if(usr.length >= 3)
  {
  $("#status").html('<img
  align="absmiddle" src="loader.gif" /> Checking availability...');
  
  $.ajax({ 
  type: "POST", 
  url: "check.php", 
  data: "username="+
  usr, 
  success: function(msg){ 
  
  $("#status").ajaxComplete(function(event,
  request, settings){ 
  
  if(msg == 'OK')
  { 
  $("#username").removeClass('object_error');
  // if necessary
  $("#username").addClass("object_ok");
  $(this).html(' <img align="absmiddle" src="accepted.png" /> ');
  } 
  else 
  { 
  $("#username").removeClass('object_ok');
  // if necessary
  $("#username").addClass("object_error");
  $(this).html(msg);
  }});}});}
  else
  {
  $("#status").html('The 
  username should have at least 3characters.');
  $("#username").removeClass('object_ok'); // 
  if necessary
  $("#username").addClass("object_error");
  }});});
  
  //-->
  
  
  </script>
  </head>
  <body>
  <div>
  
  
  <label>User name:</label>
  
  <input type="text" id="username" name="username"onkeyup="Twitter.updateUrl(this.value)" class="inn"/> 
  
  http://xyz.com/<span 
  id="username_url" class="url">USERNAME</span>
  
  </div>
  <div id="status"></div>
  
  <script type="text/javascript">
  $( function () {
  twitter.screenNameKeyUp();
  $('#user_screen_name').focus();
  });
  
  
  



   

   </script>

  
  </body>
  </html>

Download

source code

Visual Database Desing with MySQL Workbench

Jquery Basics Series - 3

noreply@blogger.com (Anonymous) — Sat, 26 Nov 2011 01:09:00 +0530

Previous series I had discussed about jQuery effects. Now time to talk about custom animation with jQuery using animate(). This is very interesting using this we can make beautiful web projects.

Jquery Basics Series - 1

Jquery Basics Series - 2

Custom Animation with animate() $(selector).animate()

While clicking the anchor link class='animate' it's
calling the class arrow adding
animation effect.Take a look at live demo

 <script type="text/javascript">
 
 $(function() 
  
 {
 $('.animate').click(function()
  
 {
 
 $('.arrow').animate(
  
 {
 "paddingLeft": "800px",
 "opacity": "0.0",
  
 }, "slow" );
  
 });
 
 });
 
 </script>
 
 <a href="#" 
 class="animate">animate()</a>
  
 <div>
 
 <span style="font-size:48px; 
 font-weight:bold" 
 class="arrow">==></span>
  
 </div>

Jquery Color Plugin: Download Link
Change Background Color

Some readers asked to me how to change background color while clicking delete
button Delete Records with Animation Effect using jQuery and Ajax.
Using jquery.color.js plug-in
we can implement when delete it turns red background. Take a look at live demo

 <script type="text/javascript"
 src="jquery.color.js"></script>
 
 <script type="text/javascript">
 
 $(function() 
 
 {

 $('#box').hover(function()
 
 {
 
 $(this).animate(
 
 {
 "backgroundColor":
 "#333333",
 
 }, "slow" );
 
 });
 
 });
 
 </script>
 
 <div id="box"></div>

Working with Mouseover() and Mouseout() Events.

Take a look at live demo

 <script type="text/javascript"
 src="jquery.color.js"></script>
 
 <script type="text/javascript">
 $(function() 
 {
 $('#box').mouseover(function()
 {
 
 $(this).animate({
 "backgroundColor":
 "#333333",
 "borderBottomWidth":
 "20px",
 "borderBottomColor":"#cc0000",
 "color":"#ffffff"
 }, "slow"
 );
 }).mouseout(function()
 {
 
 $(this).animate({
 "backgroundColor":
 "#96BC43",
 "borderWidth":
 "3px",
 "borderColor":"#333333",
 "color":"#000000",
 "borderBottomColor":"#333333",
 }, "slow"
 );
 });
 
 });
 
 </script>
 
 <div id="box">9lessons.blogspot.com</div>

CSS Code

 #box
 {
 background-color:#96BC43;
 border:solid 3px #333333; 
 height:160px;
 font-size:46px;
 font-weight:bold;
 }

Working with Keyup() Event

Take a look at this following link I had given code and nice demo.
Live Preview with jQuery

Jquery Basics Series - 2

noreply@blogger.com (Anonymous) — Sat, 26 Nov 2011 00:59:00 +0530

Very good response about "Jquery Basic Series - 1". Last series discussed about jquery installation and introduction. In this post I want to explain about animation Effectsand Attributes.

" style="font-weight: inherit; font-family: inherit; font-style: inherit; font-size: 15px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-color: initial; outline-width: 0px; outline-style: initial; outline-color: initial; padding-top: 9px; padding-right: 9px; padding-bottom: 9px; padding-left: 9px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; border-top-color: rgb(204, 204, 204); border-right-color: rgb(204, 204, 204); border-bottom-color: rgb(204, 204, 204); border-left-color: rgb(204, 204, 204); background-image: initial; background-attachment: initial; background-origin: initial; background-clip: initial; background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;" />

Effects

Fading Out and In : $(selector).fadeOut() and $(selector).fadeIn()
Sliding Up and Down : $(selector).slideUp() and $(selector).slideDown()
Sliding Toggle : $(selector).slideToggle()
Custom animation effect : $(selector).animate() //
I will discuss this in upcoming post.

Fading Effect

Fading Out and In the div tag id='box'.
Here you can change the effect speedfadeOut(speed,callback) Eg. fadeOut("fast"
or "slow"), fadeOut(300).
Take a look atLive Demo

<script type="text/javascript">

 $(function() 

{

 $('.fadeOut_box').click(function()

{

$('#box').fadeOut("slow");

 //Sliding effect just replace fadeOut() to slideUp()

});

$('.fadeIn_box').click(function()

{

$('#box').fadeIn("slow");

 //Sliding effect just replace fadeIn() to slideDown()

});

});

 </script>

<body>

<a href="#" 

class="fadeOut_box">fadeOut()</a>

<a href="#" 

class="fadeIn_box">fadeIn()</a>

 <div id="box"></div>

</body>

CSS code

#box

{

background-color:#96BC43; 

border:solid 3px #333333; 

height:160px;

margin-top:30px;

}

Attributes

attr()

Using this method attr() makes
it easy to retrieve a property value from the matched element. $(selector).attr(properties);
Eg Attributes: id, class, title, src, href, etc... Take a look at Live Demo

<script type="text/javascript">

 $(function() 

{

$('.link').click(function()

{

 var id=$(this).attr("id");

 var class=$(this).attr("class");

 var href=$(this).attr("href");

 alert(id);

 alert(class);

 alert(href);

});

});

 </script>

<a href="http://9lessons.blogspot.com" 

class="link" 

id="901">link</a>

html()

Get the html contents (innerHTML) of the matched element. $(selector).html().
Take a look at Live Demo

<script type="text/javascript">

$(function() 

{

$('.link').click(function()

{

var href=$(this).attr("href");

$("h1").html(href);

});

});

</script>

<a href="http://9lessons.blogspot.com" 

>Click </a>

Link HREF value : <h1></h1>

addClass()

Adds the specified class to each of the set of matched elements. $(selector).addClass().
Take a look at Live Demo

<script type="text/javascript">

$(function() 

{

$('.changeclass').click(function()

{

$(".big").addClass("small");

});

});

</script>

<a href="#" 

class="changeclass" 

>Click </a>

<div class="big">9lessons.blogspot.com</div>

CSS Code

.big

{

font-size:106px;

}

.small

{

font-size:12px;

}

Jquery Basics Series - 3

Jquery Basics Series -1

noreply@blogger.com (Anonymous) — Sat, 26 Nov 2011 00:40:00 +0530

Hi Friends, if you really want to learn jQuery follow basic series on ProgrammingDumps. Jquery is an awesome javascipt library, it’s helpyou for developing dazing web projects. In this tutorial I want to discuss very basic level jquery and working with Click()event.

How to add jQuery to your website

Installing

You can download jquery.js file form jquery.com.

<script type="text/javascript"src="jquery.js"></script>                                

OR

Recommended

 <script type="text/javascript"
 src="http://ajax.googleapis.com/ajax/
 libs/jquery/1.3.0/jquery.min.js"></script>

Jquery Code

Generally used script run this when the HTML is all ready. Live Demo

 
 <script type="text/javascript">
 
 $(document).ready(function()
 
 {
 
 alert('Welcome 
 9lessons Jquery Basic Series');
 
 });
 
 </script>

Similar as previous script. Take a look at Live Demo

 <script type="text/javascript">
 
 $(function() 
 
 {
 
 alert('Welcome 
 9lessons Jquery Basic Series');
 
 });
 
 </script>

Run this when the whole page has been downloaded. Take a look at Live Demo

 <script type="text/javascript">
  
 $(window).load(function()
 
 {
 alert('Loaded Whole Page including images)');
 
 });
 
 </script>

<p>&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;span class="Apple-tab-span" style="white-space:pre"&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt; &amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/span&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/p&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;</p>

jQuery Stucture

Here $ = jquery, selector is a DOM element and function execute a jquery fuction.

$(selector).function(parameters);

DOM -
Document Object Model Wiki

Selectors

-> Select DOM elements eg: $('h1') ,$('div'), $('li')..

-> Select ID : $('#id_name')

-> Select Class : $('.class_name')

Working with Click() Event

Structure $(selector).click().
Take a look at Live Demo

 <script type="text/javascript">
 
 $(function() 
 
 {
 
 $('#button_action').click(function()
 {
 
 alert('Hey 
 Button');
 });
 
 $('.link_action').click(function()
 {
 
 alert('Hey 
 Link');
 });
 
 });
 
 </script>
 
  <body>

  <include type='button'
  value='BUTTON'
  id='button_action'/>
 
  <a href='#'
  class='link_action'>LINK</a>
 
  </body>

Hide and Show With Click Event

Hiding and Showing the div tag. Take a look at Live Demo

 <script type="text/javascript">
  
 $(function() 
 {
  
 $('.hide_box').click(function()
 {
 $('#box').hide();
 });
 
 $('.show_box').click(function()
 {
 $('#box').show();
 });
 
 });
 
 </script>
 
  <body>

  <a href="#"

  class="hide_box">HIDE</a>

  <a href="#"
  class="show_box">SHOW</a>
 
  <div id="box"></div>
 
  </body>

Jquery Basics Series - 2

System Development Life Cycle(SDLC) Presentation

noreply@blogger.com (Anonymous) — Sun, 20 Nov 2011 10:36:00 +0530

Software development life cycle

SOFTWARE ENGINEERING (TESTING)

noreply@blogger.com (Anonymous) — Sun, 20 Nov 2011 10:34:00 +0530

Testing is a very critical aspect of the software quality assurance (SQA) and represents the ultimate review of specification design and code generation. The design process focuses on the logical internals of the software, ensuring that all the statement has been tested and all functional external i.e. defined input will produce actual result that agree with the required result.

There are two types of testing

1. White box testing.

2. Black box testing.

WHITE BOX TESTING – It is also called as glass testing. It is predicted on the close examination of procedural details .Here providing test cases that exercises specific sets of condition and for loops tests the logical paths through the software. It demonstrate that each functional operational at the same searching for error in each function.

BLACK BOX TESTING – This is also called as the behavioral testing and it focuses on the functional requirement of the software. It enables the software engineer to derive set of inputs conditions that will fully exercise all functional requirements for a program. There seta are used to demonstrate that software functional are operational and integrity of external database is maintained. It helps to ensure that the internal operations are performed according to specific and all components have been adequately exercised.

SOFTWARE ENGINEERING (SYSTEM ANALYST)

noreply@blogger.com (Anonymous) — Sun, 20 Nov 2011 10:33:00 +0530

SYSTEM ANALYST : - A System Analyst is a person whose conducts a study identifies activity and objectives and determine a procedure to achieve the objectives it is a person with unique skills.

ROLE OF SYSTEM ANALYST

AS A CHANGE AGENT
INVESTIGATOR AND MONITOR
ARCHITECT
PSYCHOLOGIST
SALES PERSON
POLITICIAN

1. AS A CHANGE AGENT :- Analyst replace the old system with new system.

2. INVESTIGATOR AND MONITOR :- Identity the problems and controls the complete project development.

3. ARCHITECT :- Design all the charts required for the system development.

4. PSYCHOLOGIST :- The Analyst can understand the problem of the developer psychologically.

5. SALES PERSON :- Analyst sales the project.

6. POLITICIAN :- Because he has to interact with different levels of managements.

SOFTWARE ENGINEERING "SOFTWARE TESTING"

noreply@blogger.com (Anonymous) — Sun, 20 Nov 2011 10:30:00 +0530

Testing is the process to uncover all the errors.

TESTING OBJECTIVES:-

1. Testing is the process of executing the program to find all the erros.

2. A Group test has a high probability of finding errors.

3. A Successful test uncovers all the errors that have not been found .

TESTING PRINCIPAL:-

· The Test should be according to the customers requirement.

· There should be a planning for testing before starts.

· The pareto principle implies that 80 percent of the errors uncovered during testing will likely be traceable to 20 percent of all the program component.

· Testing should be begin “in the small” and progress towards testing “in the large”

· Exhaustive testing is not possible . it is imposible to execute every combination of paths during testing , it is possible however to adequately cover program logic and to ensure that all the conditions in the component level design have been exervised.

· To be most effective , testing should be conducted by an independent third party.

SOFTWARE ENGINEERING (SOFTWARE CRISIS)

noreply@blogger.com (Anonymous) — Sun, 20 Nov 2011 10:28:00 +0530

SOFTWARE CRISIS CAN BE CLASSIFIED IN TWO WAYS

FROM PROGRAMMERS POINT OF VIEW

FROM USERS POINT OF VIEW

FROM PROGRAMMERS POINT OF VIEW:-

PROBLEM OF COMPATIBILITY
PROBLEM OF PORTABILITY
PROBLEM OF DOCUMENTATION
PROBLEM OF PIRACY OF SOFTWARE
PROBLEM IN COORDINATION TO WORK WITH OTHER PEOPLE
PROBLEM THAT ARISE DURING ACTUAL RUN TIME IN THE ORGANIZATION
PROBLEM OF MAINTENANCE IN PROPER MANNER.

FROM USERS POINT OF VIEW:-

HOW TO CHOOSE SOFTWARE FROM TOTAL MARKET AVAILABILITY
HOW TO ENSURE THAT WHICH SOFTWARE IS COMPATIBLE WITH OUR HARWARE.
PROBLEM OF VIRUSES.
PROBLEMS OF SOFTWARE BUGS.
CERTAIN SOFTWARE RUNS ON SPECIFIC OS.
PROBLEM OF DIFFERENT VERSIONS OF SOFTWARE.
SECURITY PROBLEM FOR PROTECTED DATA IN SOFTWARE.

3.SOFTWARE ENGINEERING (RAD MODEL)

noreply@blogger.com (Anonymous) — Sun, 20 Nov 2011 09:53:00 +0530

The Rapid Application Development model is incremental software development cycle,it is higher speed adaptation of linear sequential model in which rapid development is achieved by using component based construction.the work is divided into sub tasks. Each sub task is assigned to a different team, so application development will be fast.

It performs the following steps

COMMUNICATION
PLANNING

After planning each team performs sequentially the following task

MODELING

Business modeling
Data modeling
Process modeling

2. CONSTRUCTION

Code generation
Testing

3. DEPLOYMENT
In this the product dilivers to the customers

2. SOFTWARE ENGINEERING (WATERFALL MODEL)

noreply@blogger.com (Anonymous) — Sun, 20 Nov 2011 09:48:00 +0530

WATER FALL MODEL

1. COMMUNICATION

PROJECT INITIATION
REQUIREMENT GATHERING

2. PLANNING

ESTIMATING
SCHEDULING
TRACKING

3. MODELING

ANALYSIS
DESIGN

4. CONSTRUCTION

CODING
TESTING

5. DEPLOYMENT

DELIVERY
SUPPORT
FEEDBACK

ADVANTAGES AND DISADVANTAGES

ADVANTAGES

Oldest and simlest method
useful in situtation where requirements are fixed
it is a procedural model
it provides better quality
it is the sequential approach of software development

DISADVANTAGE

Real projects rarly follow this model
difficult for customers to state all the requirements in advance
customers must have patience
it takes long time in software delivery

1.SOFTWARE ENGINEERING (PROCESS MODELS)

noreply@blogger.com (Anonymous) — Sun, 20 Nov 2011 09:44:00 +0530

It defines the set of activities ,actions, tasks,milestones and output products required to develop high quality software. it provides stability ,organization and control for the activities. these are also called prescriptive process models there are many models but generic framework activities are same for all.

SOME PROCESS MODELS ARE:-

WATERFALL MODEL
INCREMENTAL MODEL
PROTOTYPE MODEL
RAD MODEL
SPIRAL MODEL
WIN WIN SPIRAL MODEL
COMPONENT BASED MODEL

CORE JAVA HINDI TUTORIALS PART-1

noreply@blogger.com (Anonymous) — Thu, 17 Nov 2011 16:07:00 +0530

1.Java Introduction:

2.Oops Concept And Java Features:

3.What Will You Need:

4.Installation Of Java Software:

5.Setting Path

6.Saving And Running Program 1

7.Write First Java Program

8.Saving And Running Program

9.What Are Variables

10.Declaring Variables

11.Datatypes

12.Assignment Operator And Arithmetic Operators

13.Program For Arithmetic Operators

14.Arithmetic Compound Assignment Operator

15.Increment

16.Decrement

17.Bitwise Operator

18.Relational Operator

19.Conditional If

20.Program Of If Statement

21.Program Of Nested If Conditional Statement

22.Program Of If Else Ladder

23.Switch Case

24.While Loop

25.Do While Loop

26.Program Of While Loop

27.Program Of Do-While Loop

28.For Loop And Its Program

Download This All Videos And Pleas Share Your Opinion By Commenting this post

Remove n’th table column - jQuery plugin

noreply@blogger.com (Anonymous) — Mon, 14 Nov 2011 22:18:00 +0530

My usual short Friday post. Today I would like to share with you a new utility I wrote to work with HTML tables. We already have jQuery functions to add table row, remove table row (on user click), add table row number plugin and now here is jQuery code to remove table column.

jQuery utility to remove table’s n’th column:

$.fn.removeCol = function(col){
    // Make sure col has value
    if(!col){ col = 1; }
    $('tr td:nth-child('+col+'), tr th:nth-child('+col+')', this).remove();
    return this;
};

Just add this code to your javascript file and use it in your jQuery code like this:

// Remove all table's second columns
$('table').removeCol(2);
// Remove table's first column (default)
$('table').removeCol();

The function takes column number to delete as an argument and removes that column. If you don’t supply any column number it removes the first table column by default.

Dynamically create iframe with jQuery

noreply@blogger.com (Anonymous) — Mon, 14 Nov 2011 22:16:00 +0530

This article explains and shows how to dynamically create an iframe in your HTML document’s DOM using jQuery and/or JavaScript. It also gives you an example code. This post is not extensive explanation of how to manage and work with iframes using jQuery. This post simply shows you how to dynamically create iframes using jQuery and JavaScript and serves as a note.

Creating iframe is similar to creating any DOM element. All you need to do is to use jQuery factory like this:

// Create an iframe element
$(‘<iframe />’);
// You can also create it with attributes set
$('&amp;lt;p&amp;gt;'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;);&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="com" style="color: rgb(136, 0, 0); "&amp;amp;amp;gt;// Finnaly attach it into the DOM&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;$&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;(&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'&amp;amp;amp;lt;iframe id="myFrame" name="myFrame"&amp;amp;amp;gt;'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;).&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;appendTo&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;(&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'body'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;);&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;/pre&amp;amp;amp;gt;&amp;amp;amp;lt;p style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 20px; background-color: rgb(255, 255, 255); "&amp;amp;amp;gt;Don’t forget that the iframe source is just an iframe’s attribute. So you can set that just like any other attribute.&amp;amp;amp;lt;/p&amp;amp;amp;gt;&amp;amp;amp;lt;pre class="prettyprint" style="padding-top: 0.5em; padding-right: 0.5em; padding-bottom: 0.5em; padding-left: 0.5em; border-top-style: none; border-right-style: none; border-bottom-style: none; border-width: initial; border-color: initial; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); line-height: 20px; "&amp;amp;amp;gt;&amp;amp;amp;lt;span class="com" style="color: rgb(136, 0, 0); "&amp;amp;amp;gt;// Setting iframe's source&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;$&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;(&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'&amp;amp;amp;lt;iframe /&amp;amp;amp;gt;'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;).&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;attr&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;(&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'src'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;,&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt; &amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'http://www.google.com'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;);&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt; &amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;/pre&amp;amp;amp;gt;&amp;amp;amp;lt;p style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 20px; background-color: rgb(255, 255, 255); "&amp;amp;amp;gt;&amp;amp;amp;lt;strong&amp;amp;amp;gt;UPDATE:&amp;amp;amp;lt;/strong&amp;amp;amp;gt;&amp;amp;amp;lt;/p&amp;amp;amp;gt;&amp;amp;amp;lt;p style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 20px; background-color: rgb(255, 255, 255); "&amp;amp;amp;gt;As BinaryKitten point’s out below, with jQuery 1.4 you can do it using the following syntax:&amp;amp;amp;lt;/p&amp;amp;amp;gt;&amp;amp;amp;lt;pre class="prettyprint" style="padding-top: 0.5em; padding-right: 0.5em; padding-bottom: 0.5em; padding-left: 0.5em; border-top-style: none; border-right-style: none; border-bottom-style: none; border-width: initial; border-color: initial; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); line-height: 20px; "&amp;amp;amp;gt;&amp;amp;amp;lt;span class="com" style="color: rgb(136, 0, 0); "&amp;amp;amp;gt;// Set attributes as a second parameter&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;$&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;(&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'&amp;amp;amp;lt;iframe /&amp;amp;amp;gt;'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;,&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt; &amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;{&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;&amp;amp;amp;amp;nbsp; &amp;amp;amp;amp;nbsp; name&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;:&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt; &amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'myFrame'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;,&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;&amp;amp;amp;amp;nbsp; &amp;amp;amp;amp;nbsp; id&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;:&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt; &amp;amp;amp;amp;nbsp; &amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'myFrame'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;,&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;&amp;amp;amp;amp;nbsp; &amp;amp;amp;amp;nbsp; &amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;...&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;&amp;amp;amp;lt;br&amp;amp;amp;gt;&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;}).&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pln" style="color: rgb(0, 0, 0); "&amp;amp;amp;gt;appendTo&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;(&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="str" style="color: rgb(0, 136, 0); "&amp;amp;amp;gt;'body'&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;span class="pun" style="color: rgb(102, 102, 0); "&amp;amp;amp;gt;);&amp;amp;amp;lt;/span&amp;amp;amp;gt;&amp;amp;amp;lt;/pre&amp;amp;amp;gt;&amp;amp;amp;lt;div style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; font-size: 13px; line-height: 20px; background-color: rgb(255, 255, 255); float: right; width: 180px; padding-top: 10px; padding-right: 10px; padding-bottom: 10px; padding-left: 10px; "&amp;amp;amp;gt;&amp;amp;amp;lt;div style="float: left; margin-top: 20px; margin-right: 20px; margin-bottom: 20px; margin-left: 20px; width: 50px; "&amp;amp;amp;gt;&amp;amp;amp;lt;iframe allowtransparency="true" frameborder="0" scrolling="no" src="http://www.facebook.com/plugins/like.php?app_id=154588181286699&amp;amp;amp;amp;amp;href=http%3A%2F%2Fjquery-howto.blogspot.com%2F2011%2F08%2Fadd-jquery-to-your-greasemonkey-script.html&amp;amp;amp;amp;amp;send=false&amp;amp;amp;amp;amp;layout=box_count&amp;amp;amp;amp;amp;width=50&amp;amp;amp;amp;amp;show_faces=false&amp;amp;amp;amp;amp;action=like&amp;amp;amp;amp;amp;colorscheme=light&amp;amp;amp;amp;amp;font=arial&amp;amp;amp;amp;amp;height=90" style="border-top-style: none; border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; overflow-x: hidden; overflow-y: hidden; width: 50px; height: 90px; "&amp;amp;amp;gt;&amp;lt;/p&amp;gt;

HTML: The difference between attribute and property

noreply@blogger.com (Anonymous) — Mon, 14 Nov 2011 22:14:00 +0530

In this short post I will explain the difference between attributes and properties in HTML. The .prop()function introduced in jQuery 1.6 raised a lot of questions about the difference and I hope this post will help you to understand it.

What is an attribute?

Attributes carry additional information about an HTML element and come in name=”value” pairs. Example:

. Here we have a div tag and it has a classattribute with a value of my-class.

What is a property?

Property is a representation of an attribute in the HTML DOM tree. So the attribute in the example above would have a property named className with a value of my-class.

Our DIV node
 |- nodeName = "DIV"
 |- className = "my-class"
 |- style
   |- ...
 |- ...

What is the difference between attribute and property?

Attributes are in your HTML text document/file, whereas properties are in HTML DOM tree. This means that attributes do not change and always carry initial (default) values. However, HTML properties can change, for example when user checks a checkbox, inputs text to textarea or uses JavaScript to change the property value.

Here is a visual representation:

HTML                          DOM
<input value="default" />     value = default

----------------
Current values:
Attribute: "default"          Property:  "default"

Assume user inputs his name "Joe" into the inputbox. Here are what attribute and property values of an element will be.

HTML                          DOM
<input value="default" />     value = Joe

----------------
Current values:
Attribute: "default"          Property:  "Joe"

As you can see, only element’s property is changed, because it is in the DOM and dynamic. But element’s attribute is in HTML text and can not be changed!

I hope this helps to understand the difference between attributes and properties. If you have any questions please leave them on jQueryHowto Facebook page.

Also, stay tuned for the next post about the difference between jQuery.attr() andjQuery.prop() and when to use one over another.

Google Plus Style Drag and Drop adding Groups

noreply@blogger.com (Anonymous) — Sun, 13 Nov 2011 11:09:00 +0530

Are you looking for Google plus style drag and drop adding friends in groups or circle. Google plus circle implementation so cool, same way I have tried similar user groups adding application with drag and drop effect using jquery and php. I hope it’s useful for your social media web projects.

Download Script Live Demo

Sample database contains three tables and relationship between Members and Groups.

Members
Table contains members(users) data such as member_id, member_image and etc.

CREATE TABLE IF NOT EXISTS `members` (
`member_id` int(9) NOT NULL AUTO_INCREMENT,
`member_name` varchar(220) NOT NULL,
`member_image` text NOT NULL,
`dated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`member_id`)
);

Groups
Contains groups information.

CREATE TABLE IF NOT EXISTS `groups` (
`group_id` int(9)  AUTO_INCREMENT,
`group_name` varchar(220),
`sort` int(9),
`date` timestamp  DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`group_id`),
KEY `sort` (`sort`)
);

User_group
Members and Groups table relationship table contains user_id(same as memeber_id),group_id, member_id() and sort(ordering)

CREATE TABLE IF NOT EXISTS `user_group`

(
`id` int(9) NOT NULL AUTO_INCREMENT,
`user_id` int(9) NOT NULL,
`group_id` int(9) NOT NULL,
`member_id` int(9) NOT NULL,
`sort` int(9) NOT NULL,
PRIMARY KEY (`id`)
);

Javascript
Here draggable applying for two classes .members and .group


<script type="text/javascript"
src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.js"></script> 
<script type="text/javascript"
src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.14/jquery-ui.js"></script> 
<script type="text/javascript"
src="jquery.livequery.min.js"></script> 
<script type="text/javascript" > 
$(function()  
{  
// Initiate draggable for public and groups 
var $gallery = $( ".members, .group" ); 
$( "img", $gallery ).live("mouseenter", function() 
{ 
var $this = $(this); 
if(!$this.is(':data(draggable)'))  
{ 
$this.draggable({ 
helper: "clone", 
containment: $( "#demo-frame" ).length ? "#demo-frame" : "document",  
cursor: "move" 
}); 
} 
}); 
// Initiate Droppable for groups 
// Adding members into groups 
// Removing members from groups 
// Shift members one group to another 
$(".group").livequery(function(){ 
var casePublic = false; 
$(this).droppable({ 
activeClass: "ui-state-highlight", 
drop: function( event, ui ) { 
var m_id = $(ui.draggable).attr('rel'); 
if(!m_id) 
{ 
casePublic = true; 
var m_id = $(ui.draggable).attr("id"); 
m_id = parseInt(m_id.substring(3)); 
}  
var g_id = $(this).attr('id'); 
dropPublic(m_id, g_id, casePublic); 
$("#mem"+m_id).hide(); 
$( "<li></li>" ).html( ui.draggable ).appendTo( this ); 
}, 
out: function(event, ui) { 
var m_id = $(ui.draggable).attr('rel'); 
var g_id = $(this).attr('id');  
$(ui.draggable).hide("explode", 1000); 
removeMember(g_id,m_id); 
} 
}); 
}); 
// Add or shift members from groups 
function dropPublic(m_id, g_id,caseFrom) 
{ 
$.ajax({ 
type:"GET", 
url:"groups.php?m_id="+m_id+"&g_id="+g_id, 
cache:false, 
success:function(response){  
$.get("groups.php?reload_groups", function(data){  
$("#groupsall").html(data); 
$("#added"+g_id).animate({"opacity" : "10" },10); 
$("#added"+g_id).show(); 
$("#added"+g_id).animate({"margin-top": "-50px"}, 450); 
$("#added"+g_id).animate({"margin-top": "0px","opacity" : "0" }, 450); 
}); 
} 
}); 
} 
// Remove memebers from groups 
// It will restore into public groups or non grouped members 
function removeMember(g_id,m_id) 
{ 
$.ajax({ 
type:"GET", 
url:"groups.php?do=drop&mid="+m_id, 
cache:false, 
success:function(response){ 
$("#removed"+g_id).animate({"opacity" : "10" },10); 
$("#removed"+g_id).show(); 
$("#removed"+g_id).animate({"margin-top": "-50px"}, 450); 
$("#removed"+g_id).animate({"margin-top": "0px","opacity" : "0" }, 450); 
$.get("groups.php?reload", function(data){ $("#public").html(data); }); 
} 
}); 
}  
}); 
</script>

groups.php


<?php 
require_once("multipleDiv.inc.php"); 
// Initiate Object 
$obj = new Multiplediv(); 
// Add or Update Ajax Call 
if(isset($_GET['m_id']) and isset($_GET['g_id'])) 
{ 
$obj->addMembers((int)$_GET['m_id'], (int)$_GET['g_id']); 
exit; 
} 
// Remove Memebers from groups Ajax call 
if(isset($_GET['do'])) 
{ 
$obj->removeMember($_GET['mid']); 
exit; 
} 
// Reload groups each ajax call 
if(isset($_GET['reload'])){ echo $obj->getMembers_reload(); exit; } 
if(isset($_GET['reload_groups'])){ echo $obj->getmembergroups_reload(); exit; } 
// Initiate Groups and members  
$members = $obj->public_members(); 
$groups = $obj->groups(); 
?> 
Friends 
<div id="main_portion"> 
<div id="public"> 
<!-- Initiate members --> 
<?php 
if(!isset($members)) 
$members = $obj->public_members(); 
if($members) 
{ 
foreach($members as $member) 
{ 
extract($member); 
echo "<div class='members' id='mem".$member_id."'>\n"; 
echo "<img src='images/".$member_image."' rel='".$member_id."'>\n"; 
echo "<b>".ucwords($member_name)."</b>\n"; 
echo "</div>";  
} 
} 
else 
echo "Members not available"; 
?> 
</div> 
<div id="groupsall"> 
Groups 
<!-- Initiate Groups --> 
<?php 
if(!isset($groups)) 
$groups = $obj->groups(); 
if($groups) 
{ 
foreach($groups as $group) 
{ 
extract($group); 
echo "<div id='".$group_id."' class='group'>\n"; 
echo ucwords($group_name); 
echo "<div id='added".$group_id."' class='add' style='display:none;'
 ><img src='images/green.jpg'></div>"; 
echo "<div id='removed".$group_id."' class='remove' style='display:none;'
 ><img src='images/red.jpg'></div>"; 
echo "<ul>\n"; 
echo $obj->updateGroups($group_id); 
echo "</ul></div>"; 
} 
} 
?> 
</div> 
</div>

multipleDiv.inc.php
Download this and modify database connection credentials.


<?php 
// Database declaration's 
define("SERVER", "localhost"); 
define("USER", "username"); 
define("PASSWORD", "password"); 
define("DB", "database"); 

class Multiplediv 
{ 
........................ 
........................ 
......................... 
}  
?>

Designing Your Own Lightbox in Javascript

noreply@blogger.com (Anonymous) — Sat, 12 Nov 2011 23:35:00 +0530

In nowadays web 2.0 world use of Lightbox is very common. While Lightbox, fancybox (similar to the former) are great scripts and have wide uses, creating a script similar to these is never a bad idea. If you learn, read on else use of one of those scripts, they’re great and easy-to-use.

For those of you who haven’t heard about the script or don’t know what they do, see the following image:

Chances are, you might surely have seen it somewhere or the other. These scripts are generally used to display some content in kind of like a dialog box (modal one, for those of you who're geeks) while the rest of the content gets blackened. Looks great? Yes it does!

Okay, for those of you still here I wanna confess that I didn’t put enough time knowing how those scripts actually work. I just got an idea myself the other day and thought it just might work. This is not to say that I myself have invented some new way, it’s just that I don’t know how those scripts work but I know one way that gives similar results.

As you can see from the above image, there is not much to a simple Lightbox clone, we have a (1) Blackening effect (2) The content box.

Blackening Effect: For this I’ll create a “div” element on the fly and set its properties such that it has a black color and some transparency, a large z-index means floats on top of the rest of the content and back content (with normal z-index) cannot be interacted with anymore. We’ll fill the current screen with this “div” which will require us to place this element at the topmost and leftmost coordinates relative to the current viewable area. This will be (0, 0) when the page isn’t scrolled at all.
We’ll also have to size the element to have it span the whole viewable area of the browser.
These two things will make sure that no matter where we have scrolled in a page and whatever be the window size, this black overlay element always covers the current viewport.
2. Content Box: A nicely styled box with a close button is all we need. We’ll place it at the center of the screen. Since we have calculated the topmost and leftmost coordinates relative to the current viewport and we also have the current viewport’s dimension, we can easily position this at the center, no brainer! We’ll give this a z-index larger than the black overlay element such that this is at the top of everything.
Besides this, we’ll also have to take care that these two elements move along with the page in case user tries to scroll the page when the our lightbox is open. This will make sure that (1) black overlay element always fills the screen (2) content box is always at the center.

Sounds pretty simple? Well, it is! It’ll call this Blackbox, you may call it whatever you feel like. Here is the code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 

<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> 
<title>Blackbox - A very simple Lightbox clone</title> 

<script type="text/javascript"> 
/* 
 * Script: Blackbox (very simple Lightbox clone) 
 * Author: Arvind Gupta (contact@arvindgupta.co.in) 
 * Date: 14-Nov-09 
 * Copyright: 2009 Arvind Gupta 

 *            You may freely use this script wherever 
 *         you want and in whatever way you wish 
 *         but please don't remove this note. 
 * 
 */ 

// OBJECTS 

// Black overlay element 
var darkbox; 
// Content box 
var content; 

// FUNCTIONS 
function init() 
{ 
   // Set "onScroll" event handler 

   window.onscroll = scroll_box; 
} 

function open() 
{ 
   // Create elements 
   darkbox = document.createElement('div'); 
   content = document.createElement('div'); 

   // Style them with the existing ids 
   darkbox.id = 'darkbox'; 
   content.id = 'content'; 

   // FILL CONTENT BOX 

   // Have the close button 
   content.innerHTML = '<a style="position: absolute; top: -30px; right: -30px; text-decoration: none;" href="javascript:close();"><img style="border: none;" src="fancy_closebox.png" /></a>'; 
   // The main content 

   content.innerHTML += '<div id="main_content"><h1>Hello</h1><p>Hello World!<br /> How is this looking?</p></div>'; 

   // Add these elements to the body 

   document.body.appendChild(darkbox); 
   document.body.appendChild(content); 

   // Calciulate coordinates and such 
   var pos_top = document.documentElement.scrollTop 
   var pos_left = document.documentElement.scrollLeft; 
   var screen_width = document.documentElement.clientWidth; 
   var screen_height = document.documentElement.clientHeight; 

   // Place the "darkbox" element and give it the size 

   darkbox.style.top = pos_top + 'px'; 
   darkbox.style.left = pos_left + 'px'; 
   darkbox.style.height = screen_height + 'px'; 
   darkbox.style.width = screen_width + 'px'; 

   // Now place the content box at the center 
   content.style.left = (pos_left + (screen_width / 2.0) - (content.offsetWidth / 2.0)) + 'px'; 
   content.style.top = (pos_top + (screen_height / 2.0) - (content.offsetHeight / 2.0)) + 'px'; 
} 


function scroll_box () 
{ 
   // If "Darkbox" open 
   if(darkbox != null) 
   { 
      // Find new topmost, leftmost position w.r.t the current viewport
      // Also find new window size 

      var pos_top = document.documentElement.scrollTop 
      var pos_left = document.documentElement.scrollLeft; 
      var screen_width = document.documentElement.clientWidth; 
      var screen_height = document.documentElement.clientHeight; 

      // Positions elements accordingly 
      darkbox.style.top = pos_top + 'px'; 
      darkbox.style.left = pos_left + 'px'; 
      darkbox.style.height = screen_height + 'px'; 
      darkbox.style.width = screen_width + 'px'; 

      content.style.left = (pos_left + (screen_width / 2.0) - (content.offsetWidth / 2.0)) + 'px'; 
      content.style.top = (pos_top + (screen_height / 2.0) - (content.offsetHeight / 2.0)) + 'px'; 
   } 
} 


function close() 
{ 
   // Delete elements 
   document.body.removeChild(darkbox); 
   document.body.removeChild(content); 
} 
</script> 

<style> 
#darkbox { 
   position: absolute; 
   top: 0px; 
   left: 0px; 
   opacity: 0.6; 
   filter:alpha(opacity=60); 
   background: #000; 
} 

#content { 
   position: absolute; 
   z-index: 1001; 
   background: #fff; 
   border: 10px solid #000; 
   width: 500px; 
   height: 300px; 
} 
#content #main_content { 
   overflow: auto; 
   width: 500px; 
   height: 300px; 
} 

</style> 
</head> 

<body onload="init();"> 
<a href="javascript:open()">Open Box</a> 
</body> 
</html>

FAQ on Indexes in SQL

noreply@blogger.com (Anonymous) — Sat, 12 Nov 2011 21:07:00 +0530

FAQ on Indexes in SQL

28. What is Index? It's purpose?
Indexes in databases are similar to indexes in books. In a database,
an index allows the database program to find data in a table without
scanning the entire table. An index in a database is a list of values
in a table with the storage locations of rows in the table that
contain each value. Indexes can be created on either a single column
or a combination of columns in a table and are implemented in the form
of B-trees. An index contains an entry with one or more columns (the
search key) from each row in a table. A B-tree is sorted on the search
key, and can be searched efficiently on any leading subset of the

search key. For example, an index on columns A, B, C can be searched
efficiently on A, on A, B, and A, B, C.

29. Explain about Clustered and non clustered index? How to choose
between a Clustered Index and a Non-Clustered Index?
There are clustered and nonclustered indexes. A clustered index is a
special type of index that reorders the way records in the table are
physically stored. Therefore table can have only one clustered index.
The leaf nodes of a clustered index contain the data pages.
A nonclustered index is a special type of index in which the logical
order of the index does not match the physical stored order of the
rows on disk. The leaf nodes of a nonclustered index does not consist
of the data pages. Instead, the leaf nodes contain index rows.
Consider using a clustered index for:
o Columns that contain a large number of distinct values.
o Queries that return a range of values using operators such as
BETWEEN, >, >=, <, and <=. o Columns that are accessed sequentially. o Queries that return large result sets. Non-clustered indexes have the same B-tree structure as clustered indexes, with two significant differences: o The data rows are not sorted and stored in order based on their non-clustered keys. o The leaf layer of a non-clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows. Each index row contains the non-clustered key value and one or more row locators that point to the data row (or rows if the index is not unique) having the key value. o Per table only 249 non clustered indexes. 30. Disadvantage of index? Every index increases the time in takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be very much. 31. Given a scenario that I have a 10 Clustered Index in a Table to all their 10 Columns. What are the advantages and disadvantages? A: Only 1 clustered index is possible.

32. How can I enforce to use particular index?
You can use index hint (index=) after the table name.
SELECT au_lname FROM authors (index=aunmind)

33. What is Index Tuning?
One of the hardest tasks facing database administrators is the
selection of appropriate columns for non-clustered indexes. You should
consider creating non-clustered indexes on any columns that are
frequently referenced in the WHERE clauses of SQL statements. Other
good candidates are columns referenced by JOIN and GROUP BY operations.
You may wish to also consider creating non-clustered indexes that
cover all of the columns used by certain frequently issued queries.
These queries are referred to as "covered queries" and experience
excellent performance gains.
Index Tuning is the process of finding appropriate column for
non-clustered indexes.
SQL Server provides a wonderful facility known as the Index Tuning
Wizard which greatly enhances the index selection process.

34. Difference between Index defrag and Index rebuild?
When you create an index in the database, the index information used
by queries is stored in index pages. The sequential index pages are
chained together by pointers from one page to the next. When changes
are made to the data that affect the index, the information in the
index can become scattered in the database. Rebuilding an index
reorganizes the storage of the index data (and table data in the case
of a clustered index) to remove fragmentation. This can improve disk
performance by reducing the number of page reads required to obtain
the requested data
DBCC INDEXDEFRAG - Defragments clustered and secondary indexes of the
specified table or view.
**

35. What is sorting and what is the difference between sorting &
clustered indexes?
The ORDER BY clause sorts query results by one or more columns up to
8,060 bytes. This will happen by the time when we retrieve data from

database. Clustered indexes physically sorting data, while
inserting/updating the table.

36. What are statistics, under what circumstances they go out of date,
how do you update them?
Statistics determine the selectivity of the indexes. If an indexed
column has unique values then the selectivity of that index is more,
as opposed to an index with non-unique values. Query optimizer uses
these indexes in determining whether to choose an index or not while
executing a query.
Some situations under which you should update statistics:
1) If there is significant change in the key values in the index
2) If a large amount of data in an indexed column has been added,
changed, or removed (that is, if the distribution of key values has
changed), or the table has been truncated using the TRUNCATE TABLE
statement and then repopulated
3) Database is upgraded from a previous version

37. What is fillfactor? What is the use of it ? What happens when we
ignore it? When you should use low fill factor?
When you create a clustered index, the data in the table is stored in
the data pages of the database according to the order of the values in
the indexed columns. When new rows of data are inserted into the table
or the values in the indexed columns are changed, Microsoft® SQL
Server™ 2000 may have to reorganize the storage of the data in the
table to make room for the new row and maintain the ordered storage of
the data. This also applies to nonclustered indexes. When data is
added or changed, SQL Server may have to reorganize the storage of the
data in the nonclustered index pages. When a new row is added to a
full index page, SQL Server moves approximately half the rows to a new
page to make room for the new row. This reorganization is known as a
page split. Page splitting can impair performance and fragment the
storage of the data in a table.
When creating an index, you can specify a fill factor to leave extra

gaps and reserve a percentage of free space on each leaf level page of
the index to accommodate future expansion in the storage of the
table's data and reduce the potential for page splits. The fill factor
value is a percentage from 0 to 100 that specifies how much to fill
the data pages after the index is created. A value of 100 means the
pages will be full and will take the least amount of storage space.
This setting should be used only when there will be no changes to the
data, for example, on a read-only table. A lower value leaves more
empty space on the data pages, which reduces the need to split data
pages as indexes grow but requires more storage space. This setting is
more appropriate when there will be changes to the data in the table.

SQL Queries FAQ

noreply@blogger.com (Anonymous) — Sat, 12 Nov 2011 21:01:00 +0530

SQL Queries FAQ

T-SQL Queries
1. 2 tables
Employee Phone
empid
empname
salary
mgrid empid
phnumber

2. Select all employees who doesn't have phone?
SELECT empname
FROM Employee
WHERE (empid NOT IN
(SELECT DISTINCT empid
FROM phone))

3. Select the employee names who is having more than one phone numbers.
SELECT empname
FROM employee
WHERE (empid IN
(SELECT empid
FROM phone
GROUP BY empid
HAVING COUNT(empid) > 1))

4. Select the details of 3 max salaried employees from employee table.
SELECT TOP 3 empid, salary
FROM employee
ORDER BY salary DESC

5. Display all managers from the table. (manager id is same as emp id)
SELECT empname
FROM employee
WHERE (empid IN
(SELECT DISTINCT mgrid
FROM employee))

6. Write a Select statement to list the Employee Name, Manager Name
under a particular manager?
SELECT e1.empname AS EmpName, e2.empname AS ManagerName
FROM Employee e1 INNER JOIN
Employee e2 ON e1.mgrid = e2.empid
ORDER BY e2.mgrid

7. 2 tables emp and phone.
emp fields are - empid, name
Ph fields are - empid, ph (office, mobile, home). Select all employees
who doesn't have any ph nos.
SELECT *
FROM employee LEFT OUTER JOIN
phone ON employee.empid = phone.empid
WHERE (phone.office IS NULL OR phone.office = ' ')
AND (phone.mobile IS NULL OR phone.mobile = ' ')
AND (phone.home IS NULL OR phone.home = ' ')

8. Find employee who is living in more than one city.
Two Tables:Emp City
Empid Empid
empName City
Salary
SELECT empname, fname, lname
FROM employee
WHERE (empid IN
(SELECT empid
FROM city
GROUP BY empid
HAVING COUNT(empid) > 1))

9. Find all employees who is living in the same city. (table is same
as above)
SELECT fname
FROM employee
WHERE (empid IN
(SELECT empid
FROM city a
WHERE city IN
(SELECT city
FROM city b
GROUP BY city
HAVING COUNT(city) > 1)))

10. There is a table named MovieTable with three columns - moviename,
person and role. Write a query which gets the movie details where Mr.

Amitabh and Mr. Vinod acted and their role is actor.
SELECT DISTINCT m1.moviename
FROM MovieTable m1 INNER JOIN
MovieTable m2 ON m1.moviename = m2.moviename
WHERE (m1.person = 'amitabh' AND m2.person = 'vinod' OR
m2.person = 'amitabh' AND m1.person = 'vinod') AND (m1.role = 'actor')
AND (m2.role = 'actor')
ORDER BY m1.moviename

11. There are two employee tables named emp1 and emp2. Both contains
same structure (salary details). But Emp2 salary details are incorrect
and emp1 salary details are correct. So, write a query which corrects
salary details of the table emp2
update a set a.sal=b.sal from emp1 a, emp2 b where a.empid=b.empid

12. Given a Table named "Students" which contains studentid, subjectid
and marks. Where there are 10 subjects and 50 students. Write a Query
to find out the Maximum marks obtained in each subject.

13. In this same tables now write a SQL Query to get the studentid
also to combine with previous results.

14. Three tables – student , course, marks – how do go @ finding name
of the students who got max marks in the diff courses.
SELECT student.name, course.name AS coursename, marks.sid, marks.mark
FROM marks INNER JOIN
student ON marks.sid = student.sid INNER JOIN
course ON marks.cid = course.cid
WHERE (marks.mark =
(SELECT MAX(Mark)
FROM Marks MaxMark
WHERE MaxMark.cID = Marks.cID))

15. There is a table day_temp which has three columns dayid, day and
temperature. How do I write a query to get the difference of
temperature among each other for seven days of a week?
SELECT a.dayid, a.dday, a.tempe, a.tempe - b.tempe AS Difference
FROM day_temp a INNER JOIN
day_temp b ON a.dayid = b.dayid + 1

OR
Select a.day, a.degree-b.degree from temperature a, temperature b
where a.id=b.id+1

16. There is a table which contains the names like this. a1, a2, a3,
a3, a4, a1, a1, a2 and their salaries. Write a query to get grand
total salary, and total salaries of individual employees in one query.
SELECT empid, SUM(salary) AS salary
FROM employee
GROUP BY empid WITH ROLLUP
ORDER BY empid

17. How to know how many tables contains empno as a column in a database?
SELECT COUNT(*) AS Counter
FROM syscolumns
WHERE (name = 'empno')

18. Find duplicate rows in a table? OR I have a table with one column
which has many records which are not distinct. I need to find the
distinct values from that column and number of times it's repeated.
SELECT sid, mark, COUNT(*) AS Counter
FROM marks
GROUP BY sid, mark
HAVING (COUNT(*) > 1)

19. How to delete the rows which are duplicate (don't delete both
duplicate records).
SET ROWCOUNT 1
DELETE yourtable
FROM yourtable a
WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.name1 = a.name1 AND
b.age1 = a.age1) > 1
WHILE @@rowcount > 0
DELETE yourtable
FROM yourtable a
WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.name1 = a.name1 AND
b.age1 = a.age1) > 1
SET ROWCOUNT 0

20. How to find 6th highest salary
SELECT TOP 1 salary
FROM (SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

21. Find top salary among two tables
SELECT TOP 1 sal
FROM (SELECT MAX(sal) AS sal
FROM sal1
UNION
SELECT MAX(sal) AS sal
FROM sal2) a
ORDER BY sal DESC

22. Write a query to convert all the letters in a word to upper case
SELECT UPPER('test')

23. Write a query to round up the values of a number. For example even
if the user enters 7.1 it should be rounded up to 8.
SELECT CEILING (7.1)

24. Write a SQL Query to find first day of month?

SELECT DATENAME(dw, DATEADD(dd, - DATEPART(dd, GETDATE()) + 1,
GETDATE())) AS FirstDay
Datepart Abbreviations
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
weekday dw
hour hh
minute mi, n
second ss, s
millisecond ms

25. Table A contains column1 which is primary key and has 2 values (1,
2) and Table B contains column1 which is primary key and has 2 values
(2, 3). Write a query which returns the values that are not common for
the tables and the query should return one column with 2 records.
SELECT a.col1
FROM a, b
WHERE a.col1 <>
(SELECT b.col1
FROM a, b
WHERE a.col1 = b.col1)
UNION
SELECT b.col1
FROM a, b
WHERE b.col1 <>
(SELECT a.col1
FROM a, b
WHERE a.col1 = b.col1)

26. There are 3 tables Titles, Authors and Title-Authors. Write the
query to get the author name and the number of books written by that
author, the result should start from the author who has written the
maximum number of books and end with the author who has written the
minimum number of books.

27.
UPDATE emp_master
SET emp_sal =
CASE
WHEN emp_sal > 0 AND emp_sal <= 20000 THEN (emp_sal * 1.01) WHEN emp_sal > 20000 THEN (emp_sal * 1.02)
END

SQL Injection Problem, Example and Solution for Preventing

noreply@blogger.com (Anonymous) — Sat, 12 Nov 2011 20:57:00 +0530

SQL Injection Problem, Example and Solution for Preventing:

What is SQL Injection Problem? SQL injection is a strategy for attacking databases.

Example of SQL Injection Problem:An ASP page asks the user for a name and a password, and then sends the following string to the database:
SELECT FROM users WHERE username = 'whatever' AND password = 'mypassword'

It seems safe, but it isn't. A user might enter something like this as her user name:
' OR 1>0 --

When this is plugged into the SQL statement, the result looks like this:
SELECT FROM users WHERE username = '' OR 1>0 -- AND password = ''

This injection comments out the password portion of the statement. It results in a list of all the names in the users table, so any user could get into your system.

How to Prevent SQL Injection Problem.
There are numerous ways a malicious user might penetrate your system using SQL injection and various defenses, but the simplest approach is to avoid dynamic SQL. Instead, use stored procedures everywhere.

Asp.net Connectivity with SQL Server 2005

noreply@blogger.com (Anonymous) — Fri, 11 Nov 2011 20:09:00 +0530

Asp.net Connectivity with SQL Server 2005
You will get number of queries on forums for connecting application to database. Most of time they are unable to connect because of incorrect connection string.

Step 1: Adding connection string code to web.config file

Syntax for connection string


;Initial catalog =[dbname];user id=[username];password=[password];" />

Example for connection string

Here, its an example of Windows Authentication Mode

Step 2: Writing Code

Lets write code to display data in gridview.

{
string sqlconn = ConfigurationManager.AppSettings["conn"].ToString();
SqlConnection conn = new SqlConnection(sqlconn);
SqlDataAdapter da = new SqlDataAdapter("select * from employee", sqlconn);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}

Solution for everyone, anytime

For all who are facing problem while connection application to backend, I would
suggest them to connect the application SqlDataSource Control and configure the
datasource through wizard, so that a misprint of character in your connection
string can be avoided and you can be on work without posting query on forum.

Finally Exception that you might face while connecting to .net application with sql server 2005 on windows vista operating system.

Asp.net connectivity with Sql Server 2005 is same as connecting to Sql Server
2000, but you can be put into trouble due to incorrect connection string and may
receive following error exception

The user is not associated with a
trusted SQL Server connection.

A connection was successfully
established with the server, but then an error occurred during the login
process.

To resolve the above error, check that connection string
you have used for connectivity is correct.

SQL OPERATORS

noreply@blogger.com (Anonymous) — Fri, 11 Nov 2011 19:35:00 +0530

The Operators Supported by SQL*Plus are as under
1) Comparision Operators
2) Logical Operators
3) Arithmetic Operators
4) Operators used to negate conditionsThey are discussed in brief as under.

SQL COMPARISION OPERATORSComparision Operators as the name sujjests are used to test values in SQL statement.
The comparision operators are as under
* Equality (=)
* Non-Equality (<>)
* Greater-than (>)
* Less-than (<) * Greater-than or equal to (>=)
* Less-than or equal to (<=) All Operators Works according to their names.

For example:-

1)SQL> select * from emp
where
emp_name='RAHUL';
->It will select all details of employee whose name is rahul.

2) SQL> select emp_name from emp
where
emp_age > 50;
-> It will list names of those employee whose age is above 50 yrs.

3) SQL> select emp_name from emp
where
emp_job = 'ACCOUNTANT' OR emp_job= 'MUNIM';
->It will list names of those employee whose status is munim or accountant in the company.
->Note, if any of condition satisfies than the record will display as they are joint using or operator(discussed later).

SQL LOGICAL OPERATORS-> Logical operators are those operators that are use SQL keywords to make comparision instead of symbols.
->A Logical operator is used to combine the results of two conditions.
The Logical Operators are AND, OR and NOT.
They also covers
* LIKE
* BETWEEN
* IN
* IS NULL
* ALL and ANY

AND- AND operator display records only when both conditions are satisfied.
eg:
SQL>select * from emp
where
emp_age < emp_name="'SAJID';">The above eg shows rows for those employee whose age is less than 50 yrs and name is sajid

OR- OR operator display records on matching of any condition.
eg:
SQL>select * from emp
where
emp_age < emp_name="'SAJID';">The above eg shows rows for those employee whose age is less than 50 yrs or name is sajid.

NOT- explained under negate operators.

LIKE
->LIKE operator is used to search a character pattern, without knowing exact character value.
->The LIKE operator used wildcard operators to compare a value to similar values.
->There are two wildcards used in conjunction with LIKE operator.
( % ) The percent sign-The percent sign represents Zero, one
or multiple characters.
( _ ) The Underscore-The underscore represents single
number or characters.
->These symbols can be used in combinations.
eg:
1)SQL> select * from emp
where
emp_name LIKE 'A%';
->Finds any name that start with A and continues for any length.

2) SQL>select * from emp
where
emp_name LIKE '%A';
->Finds any name that ends with A.

3) SQL>select * from emp
where
emp_name LIKE '%A%';
->Finds any name that have A in any position.

4) SQL>select * from emp
where
emp_salary LIKE '3___5';
->Finds any value in a five digit number that starts with 3 and end with 5.

5) SQL>select * from emp
where
emp_salary LIKE '_5%5';
->Finds any values that have a 5 in the second position and ends with a 5.

BETWEEN->The BETWEEN operator is an extension of comparision operator as to make more user friendly.
->The BETWEEN operator is used to search for values whose minimum and maximum values are given. Maximum and minimum values are included as a part of search.
-> A Between operator can be used with both character and
numeric datatypes. However, one cannot mix the data types.
eg:
1)SQL>select * from emp
where
emp_salary BETWEEN 5000 AND 10000;
->It searches for those employee whose salary is lies between 5000 and 10000, including the values 5000 and 10000.

IN->The IN operator search the value from a predetermined list, if any of the value matches than row will be displayed.
eg:
1)SQL>select * from emp
where
emp_job
IN ('ACCOUNTANT','PROGRAMMER','OPERATOR');
->It will display all details of those employee whose status in company is either accountant, programmer or operator.Note IN operator is basically use to remove multiple OR operators. The above statement using OR operator will be
emp_job='ACCOUNTANT' OR emp_job='PROGRAMMER' OR emp_job='OPERATOR';
Note here emp_job is repeated three times which is not efficient way of generating query, so using IN operator we can reduce our burden and also make our statement more efficient.

2)SQL>select * from emp
where
emp_depart_no IN ('5','10','15','20');
->It will display details of those employee whose department number is either 5,10,15 or 20.

IS NULL->IS NULL operator is used to compare a value with a NULL value.
eg:
->Let search for the employee who haven't have their email-id
1) SQL> select * fromemp
where
email_id IS NULL;
->It will display records of those employee who haven't created their email-id.
NOTE:- If you tried NULL operator to use with equality operator it will not give proper result.consider above eg. if you modify above statement using equality operator it will display improper result.
email_id = NULL does not find a NULL value. You will be prompted with the message no rows selected even though there are rows with a NULL values.

2)SQL>select * from emp
where
emp_salary IS NULL;
->It will display records of those employee whose pay field is NULL. This is consider as invalid's records and should be deleted immediately.

ALL and ANY
ALL->The ALL operator compares a value to all values in another value set.
eg:
1)SQL>select * from emp
where
emp_salary > ALL
(select emp_salary from emp where emp_job = 'OPERATOR');
->It will compares salary value to see whether it is greater than all salaries of the employee whose status is operator.

2)SQL>select * from emp
where
emp_age <= ALL (select emp_age from emp where emp_state='CA'); ->It will compares age value to see whether it is less than or equal to all employee's age who is staying in CA.

ANY->The ANY operator compares a value to any values in another value set.
eg:
1)SQL>select * from emp
where
emp_salary > ANY
(select emp_salary from emp where emp_job = 'PROGRAMMER');
->It will compares salary value to see whether it is greater than ANY salaries of the employee whose status is programmer.

2)SQL>select * from emp
where
emp_age <= ANY (select emp_age from emp where emp_state='CA'); ->It will compares age value to see whether it is less than or equal to any employee's age who is staying in CA.

SQL ARITHMETIC OPERATORS
->The arithmetic operators are mentioned as under
1) Addition ( + )
2) Subtraction ( - )
3) Multiplication ( * )
4) Division ( / )They work same as we have been taught so far.
->Let consider usage of arithmetic operator by following result table It contains field like rno, stname, std, div, totsub, totmarks.
where rno is roll number, stname is student name, std is standard, div is division, totsub is total subjects and totmarks is total marks.

1) To find percentage of all student
SQL>select rno,stname,(totmarks / totsub) as percentage
from result;
->Here help of division operator is taken to get percentage.

CONCEPT OF ALIASES
Aliases - Aliases is a temporary name assign to the field created at
execution of statement or field already there in a table.

consider the above example, field is created at the execution of statement and the name percentage is aliases for it.
eg:
1)SQL>select ename as employee_name from emp;
->here field is already there in a table and temporary name is created to display field title more user friendly.
->Note aliases is not compulsory on a field it is used just to interface more user friendly with sql statements.

Now back to the discussion of arithmetic operators,
continue with the examples

2)SQL>select prodname as Product_Name,qty as Quantity,
price as Price_per _unit,(qty*price) as Amount
from product
where
prodname = 'SCREW';
->Here query contains aliases Product_Name for prodname, Quantity for qty, Price_per_unit for price and Amount for (qty*price)
->This query display product name, quantity, price and amount for records whose prodname is screw.
->Here Amount is a field which will be created at the time of execution. It uses the multiplication operator.

Similarly we use arithmetic operators according to our requirement but the only point to note is that while using multiple operators operators works according to the precedence.
* and / have higher priority than + and - operator, but we can make priority of + and - higher than * and / by adding parenthesis to the statement.

SQL NEGATE OPERATORS
The Negate Operators reverses the meaning of the logical operators with which it is used.
We have explained some NOT operators which are mentioned as under.
* NOT EQUAL ( <> ) or ( != ).
* NOT BETWEEN
* IS NOT NULL
* NOT LIKE
* NOT IN
NOT EQUAL->Not equal works exactly oposite to the equal operator.
eg:
1)SQL>select * from emp
where
emp_job <> 'ACCOUNTANT';
->Here all records are selected excluding those whose status is accountant in company.

2)SQL>select * from emp
where
emp_salary != 5000;
->Selects all records excluding those whose salary is 5000.
NOTE:- Operator ( <> ) and ( != ) works same.

NOT BETWEEN-> This operator is used negate the between operator.
eg:
1)SQL>select * from emp
where
emp_salary NOT BETWEEN 2000 and 3000.
->It will select all records excluding those whose salary is between 2000 and 3000, including 2000 and 3000.

IS NOT NULL->It will check whether the selected field is not empty(null).
eg:
1)SQL>select * from emp
where
email_id IS NOT NULL;
->Selects records of those employee who have their email-id.

NOT LIKE->The NOT LIKE operator used wildcard operators to compare a value that is not similar.
->It supports both wildcard character that are mentioned in like operators.
eg:
1)SQL> select * from emp
where
emp_name NOT LIKE 'A%';
->Finds any name that do not start with A and continues for any length.

2) SQL>select * from emp
where
emp_name NOT LIKE '%A';
->Finds any name that do not ends with A.

3) SQL>select * from emp
where
emp_salary NOT LIKE '1___0';
->Finds any value in a five digit number that do not starts with 1 and end with 0.

NOT IN->The NOT IN operator search the value that is not mentioned in a predetermined list, if any of the value matches than row will be displayed.
eg:
1)SQL>select * from emp
where
emp_job
NOT IN ('PROGRAMMER','OPERATOR');
->It will display all details of employee excluding those whose status in company is either programmer or operator.

2)SQL>select * from emp
where
emp_depart_no NOT IN ('5','10','15','20');
->It will display details of employee excluding those whose department number is either 5,10,15 or 20.