SQL Update Statement
SQL Update statement is used to modify the records in table in database . We can modify either by change data or deleting data or to update the existing data .
We can modify the rows based on condition and condition come with where clause .
Syn...
How to make add item list using Angular JS
If you want to make a functionality of manually adding items to the list using Angular JS. Then you can use the following code of Angular JS it will work on client side and performs fast.
For the form the HTML will go like this:-
<div n...
Strings in C language
String is a collection of characters in an array.It is terminated by by \0 (null character)
There are two ways to declare string in c language.
1)By char array
declaring string by char array is as follows:
char ch[10]={'e','v','o','n'...
Manual Penetration Test
Manual Penetration Test:-
It is very hard to discover entire vulnerabilities by applying automated tools.There are few vulnerabilities which can be determined by manual checks only. Penetration testers can accomplish more better attacks on soft...
SQL Insert Statement
SQL insert statement is used to insert the data in a table in database . Using this statement we can insert single or multiple data in a table .
We can insert the data by two ways :
1) By SQL insert into statement : we can insert data either by...
How to get screen resolution under different devices
If you would like make adjustment under different screen resolution. Please follow the code below:
var width = jQuery(window).width();
var height = jQuery(window).height();
Uploading captured image into the specific folder server using volley library
This is one of the famous question which is unanswered clearly. I have posted it on stackoverflow link as follow:
http://stackoverflow.com/questions/33341069/uploading-captured-image-into-the-specific-folder-server-using-volley-library
I wa...
setTimeout() method in JavaScript
The setTimeout() method in JavaScript sets a time interval during which the CPU wait to perform the task specified in it. It alter the time interval of the CPU to perform the tasks.
The Syntax of the setTimeout() is as :
setTimeout(task1,Ti...
Audio Playing while App is in Background Mode
In order to continue your audio running while the app is in Background mode(like in the case of live Streaming), we just have to add this line in our AppDelegate method application didFinishLaunchingWithOptions:
[[AVAudioSession sharedInstanc...
TableView in Swift
To create a tableView in swift please follow following steps:
Step 1: Add a tableView in viewController.
Step 2: set the dataSource and delegate
Step 3: Create a prototype cell
Step 4: Change the class of prototypecell to "TableView...
Difference between interpreter and compiler
Interpreter
Translates one statement of a program at a time.
The time it takes to interpret source code is very less.
Interpreter program works line by line.
Error is reported as soon as first error is encountered
Example of languages that m...
How to rotate the image in Android?
If you are looking to rotate an image that is selected image from device then please go through the following steps:-
Step 1:- select image from gallery to which requires rotation
Bitmap bitmapImage;
File fpath;
String root=Envir...
How to put a slider using jQuery plugin and jQuery?
Adding a custom slider into a web page or website enhances the look and feel of the website. Hence, below is the code of making a custom slider and using it in your web site.
I am using jQuery and a plugin called SlidesJS. You just have to i...
Types Of Penetration Testing
Types Of Penetration Testing:-
There are mainly three types of penetration testing.These are mentioned as below :-
1) Application or Software Security Testing:- Applying the different-different approaches of the software anyone can confirm ...
Pointers in C language
Pointer is a variable which stores address of another variable. It points to an address of a value.
Pointers in C language is declared using * i.e. asterik symbol.
int *i;//pointer to int
char *ch;//pointer to char .
Example
#include ...
Instance Initialization Block
Instance Initialization Block is a block used to initialize instance variables or non-static variables in a class i.e., to initialize a state of an object. The Instance Initialization Block executes after the call of the constructor. It gets exec...
Image Slider In Javascript
If you want image slider using Javascript then you can use below code .
CSS Code :
<style type="text/css">
// to make a gap from top
body {
margin-top: 100px;
}
// give styling to list
.na...
Threads
Threads
Threads are used to get the multiple activities in a single process.
They are light weight programs.
They share memory and files and process state.
They have their own local variable and stack and program counter.
Every jav...
Static Keyword
Static Keyword
Static keyword can be applied on
1.Method
2.Variable
3.Class nested within another Class
4.Initialization Block
Static keyword can not be applied to
1.Class (Not Nested)
2.Constructor
3.Interface
4.Met...
Opacity in CSS
To specify the how transparent an element is, we use opacity. Basically it defines the clarity of the image.
Example
<!DOCTYPE html>
<html>
<head>
<style>
img.t {
opacity: 0.8;
}
</s...
How to give a sliding effect(slide down and slide up) on a div using jquery.
We are using simple jquery to implement a slide down and slide up effect on a div. Also a little styling can be done using css and HTML.
<html>
<div id="divTest" style="width: 40px; height: 40px; display: none; background-color: #fff...
SQL Order By Clause
With the help of SQL Order By statement we can sort our data in a table either in ascending order or descending order based upon the user, what he wants.
Note -> Some Databases have already sort the data order by default .
Syntax :
select...
SQL Null Meaning
What is Null ? Null means no data or missing data or we don't have a data in a table . If you think Null means 0 ( zero ) than you are wrong .
There can be two condition for Null
1) when SQL is Null
2) when SQL is not Null
If in a table yo...
SQL sum function
Sum ( ) , it is a function which return the aggregate sum of any expression , like salary of multiple employee , sum of population in any particular area etc .
Syntax :
select sum ( Expression ) from student where clause ; // expression can b...
SQL Date Statement
Basically Date is used to extract the data from a table in database . Suppose you want to find and extract the data from database for particular date then you can do this with the Date statement .
Example ->
Table name -> student
Stu...
How to find a string inside another string using Javascript
Suppose you have two strings and you need if they contains same words. Then in this case you have to use 'strName.indexOf' function.
Let's consider the example below:-
var MyString= "I'm explaining string match on findnerd portral";
var F...
How to generate random number using Javascript
In Javascript you have a number of functions to genrate random numbers between two given digits. Some of them are inbulit and some you can create for your own, But the simplest way to perform the operation is the code below:-
// Returns a rand...
How to use different versions of Jquery on a single page
If you calling the different versions of Jquery then your code can clash the mutual variables.
To use each of the Jquery versions separately you have to use " jQuery.noConflict()"
Consider the links with multiple Jquery versions below:-
&l...
How to compare two dates using Javascript
On using the javascript technology you can perform the comparison operation very quick in real time.
In this case we will see how to compare two given date:-
var DateOne = "1991-10-10".split('-');
var DateTwo = "2005-09-01".split('-');
v...
How to sort an given array using Javascript
Hello Reader!. If you dealing with a array full of unsorted keys then you can use some of the syntax to sort them in any order, Consider the cases below:-
var MyArray = [
{ Entry: { Fname: 'Micky', Lname: 'Jones' }, CustomerID: 56563 },
...
Google Map showing only one marker
Hi,
I am using Google Map in my app. I have added treeid, and its lat and lng location. I want to retreive these location and show in google marker using volley library.
But I am able to get only one marker location.Please help me where I a...
SQL Join Statement
Basically this tag is used with select statement to find and retrieve the data from multiple tables . And this can be done with the help of join query .
suppose i have two tables , name is student and teacher then i can add the columns with the...
How to add a PayPal button in Joomla?
At first you need to disable Tinymce editor in Joomla so that it does not strip out your HTML code.then go to site and click user manager and necessary user and choose no editor and then save. now in order to integrate Paypal button click artic...
SQL In statement
In SQL Database " In " is used as a operator. It help user to reduce the " OR " statements, means In operator avoid multiple statements .
It is used withe select , insert , update or delete statements only .
Advantage ->
It reduce the " or ...
How to convert an htaccess.txt file into a .htaccess file?
Change the configuration settings using directives in configuration files(.htaccess files) when using php as an apace module.Need to do "AllowoverrideAll" privileges to do so.If we don't have control over Apache configuration must use .htaccess ...
Please help to design the layout with attached image in Android
Please help in design the layout with attached image. please find the attached screen shot for reference
Suggest whether we go with grid layout or Relative layout . Please provide the respective xml layout.
If you suggest grid layout could ...
Difference Between The Database Testing and ETL Testing
Difference Between The Database Testing and ETL Testing:-
Database Testing refers to any database keeping projects whereas ETL Testing refers to Data integration projects or Data Warehouses. There performed high ranking tests on every one.
...
Where versus having in mysql
Hello Readers,
During processing WHERE is used to SELECT data in the original tables while HAVING is used to filter the data in the result set that was produced by the query
WHERE and HAVING clause are used together in a SE...
Few Common Test Scenarios for the Database Testing
Few Common Test Scenarios for the Database Testing:-
Hello Readers..
By this blog i am contributing few common test scenarios for the Database Testing. I expect these test scenario will be help full in the time of Database Testing. These are...
server side versus client side in php
Client side means the code runs on client machine namely like browser while server side means code runs on server side and sent output to the client.
In client side requests the pages from the server and displays them to the user in most of th...
SQL Joins
Joins
Joins in SQL are nothing but a technique to join the two table based on a common field.
OrderID CustomerID OrderDate
10308 2 1996-09-18
10309 37 1996-09-19
10310 77 1996-09-20
Custom...
Primary Key
Primary Key
A primary key in a table is a unique key that is the element in this column are unique and can not be null.
It is used to mantain the integrity.
It uniquely identify the row in the table.
It is a constraint on the table.
...
Virtual Memory in Operating system
It is a mechanism for the execution of processes which are not completely available in memory. The main advantage of this technique is that programs is larger than physical memory. Virtual memory is basically a separation of user logical mem...
ETL Testing Techniques and Process
ETL Testing Techniques And Process:-
ETL Testing Techniques:- ETL testing techniques are mentioned as below:-
1- Distinguishing the data source and the necessities or requirements.
2- Data or information acquirement.
3- Accomplish the bus...
Indexing
The index is used to search the data in a table.
The index is basically a data structure that search our data.
It is applied usually on a column of a table.
It is usually a B-tree but can also be hash table and other depending upon the ...
Data Structure and Different types of Data Structures
Data Structure can be defined as the way of structuring the data or logical representation between data elements. The Data structure is equal to the Organized data plus the Allowed operations on it.
It is a way of designing and accessing the d...
Operating System - Memory Management
Memory management is very essential feature of an operating system which manages primary memory. Memory management keeps into account each and every aspect of memory location when it is allocated to some process or when it is free. It checks ...
Referential Integrity
Referential Integrity
Referential Integrity is a concept in which the tables shares a relationship between them and that should be consistent.
Ex:
If we have a table called Employee and the other Employee Salary and columns in them of na...
What is ETL ?
Meaning Of ETL:-
ETL,simple meaning of ETL is - Extract-Transform-Load. ETL is a procedure by which data or information is loaded from the source or origin system to the data warehouse. Data or information is removed from an OLTP database and ...
SQL NULL Values
missing or unknown data is considered as null values.It indicates that value is not applicable for a set of attributes. NULL Value is different from an empty or zero value
To test for NULL values we use comparison operators, such as =, <,...