Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
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 },
...
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 ...
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 =, <,...
The setDate() Method in Javascript
To set the day of the month (1-31), we use setDate() method
Example
<!DOCTYPE html>
<html>
<body>
<h1>Evon technologies</h1>
<p>The Example of setDate() method to set the date of a month</p>
&l...
How to detect web browser of user using PHP
Hello Reader! If you are developing the website which depends on user's web browser then you must first find out the web browser that is opened. By using PHP you can get easily this info using the library code below:-
<?php
function detec...
How to detect If user have internet explorer 8 or 9 or higher using PHP
On developing the customer user based web server, developer should choose all supported version of web browser and code according to web browser. If you are looking for detecting the version of all IE using PHP then the code below will help you p...
Types of testing
Unit testing
individual software components or modules are tested in this kind of testing. It is done by programmer and not by testers, as if one must have detailed knowledge of the internal program design and code.
Black Box Testing
Des...
Character set in MySQL
Character set in MySQL is a set of characters that are valid to store in a string. Each character set has one or more collation. Collation is a set of rules to compare characters. To see all the list of Character Set that MySQL supports you need ...
The Fundamentals of Database
Hello Readers,
These are the some important fundamentals of database.
Entity and Entity Relationships:
An Entity is place, question or thing for which we can gather or collect data.
For example, we take the example of employee. Here, ...
self versus $this in php
Hello Readers,
We can use the self in static function while this is not.
we can use accessible class variable and methods with self and this are:
for self self::
for this $this->
$this needs an instantiated object while self...
Using Union All in Linq
This is a simple example of how we use UNION ALL in Linq.
In fact there is no UNION ALL operator in Linq but we have an equivalent of UNION ALL as Concat operator.
So suppose we have two list (oldEmployees and newEmployees) which hold name...
How to upload multiple files using Jquery
Hello Reader's!. Now multiple files on a single getting in fashion so you can use any of the multiple upload library code, But here we'll see how to use Jquery and PHP to do the same
For getting it start we need a html form page and it'll go ...
How to unzip file on Server with Terminal
If you are looking to unzip any zip folder or file on server please use the below command:
Open your terminal and give command
unzip /var/www/html/abc.zip
*Note :: Please change path with your file path
How to connect server with terminal
If you are looking to connect server with your linux terminal. Please follow the below process:
1) You should have .pem file, username and IP address or URL of your server.
2) Open Terminal
3) Get to your folder under .pem file reside. Like I...
How to parse and Excel file in PHP
Hello Reader!
If you want to read a Excel file in PHP then you can learn the library code below
read('excel_file.xls'); // reads and stores the excel file data
// Test to see the excel data stored in $sheets property
var_export($excel...
How to get current date time with you region using PHP
If you are using PHP and want to get the current date time with respect to your time zone then just use the code below :-
$DateTime = new DateTime(null, new DateTimeZone('Asia/New Delhi'));
$DateTime->setTimezone(new DateTimeZone('Asia/Ne...
multiprogramming, multitasking and multiprocessing
In multiprogramming one or more programs gets loaded in the main memory of the system which can be executed. At most one process can run on the system while all the others are waiting for their turn.
To maximize the use of CPU time, is the id...
Some Common Test Scenarios for Security Testing
Hello, Readers.
By this blog, I am sharing some common test scenarios for the Security Testing. I hope these will help in the time of security testing:-
1- Verify that secure or protect pages should be used HTTPS protocol.
2- Verify for SQ...
Keyboard Shortcuts for Wordpress
In my previous blog Keyboard Shortcuts for all Web Browsers, I discussed about some commonly used keyboard shortcuts every Web Developer or a Web Designer will love to use. In this blog I will tell you about some keyboard shortcuts you can use wh...
SQL As statement
If we want to give temporarily name to a table then we can do easily with " as " statement .
Sometime permanent name of table is very confusing so we need temporary name of table to make easy understanding .
Syntax
select old_col_name as...
Convert String to Date in Java
Its very easy in java to convert String to Date.
Java provides SimpleDateFormat to handle Date related functionality.
Here we call parse() method of SimpleDateFormat.
Example
import java.text.SimpleDateFormat;
import java.util.Date;...
How to maximise the maximum size of POST in PHP
If your form sending much more POST request than the default size and you want to increase the size of POST then see the steps:-
Open the file php.ini
you can file the location of file from exicuting the PHP line below
<?php phpinfo(); ...
How to create user in MySQL Database?
Whenever you create a new user in MySQL it wiil stored in the User table of mysql database. There are two ways to create users:
Create user statement:
CREATE USER username@hostname
IDENTIFIED BY 'password'
For example:
CREATE ...
How to convert given seconds into day format using PHP
On converting the given time in seconds you have to follow the calculation in days and hours etc. Using PHP you can get the format by using the code below:-
Here I created the function ConvertToSec ($sec) as param:
function ConvertToSec($...
How to insert multiple rows into mysql by a single query using codeigniter
Most of time we need to insert multiple rows at a time into the database but some developer use multiple INSERT statements to insert multiple rows while it is a bad approach to solve this problem. Codeigniter provides a insert batch function.
Ex...
How to change the password of the MySQL account?
There are different ways to change the password of MySQL account. They are:
Changing password using UPDATE statement:
For this you need to go to the User table of mysql database. To change password you need to execute the following comm...
How to check if user's session is already started in PHP
If you want to know weather the session is already begin or not in PHP then, you can use of the syntax from PHP manual
see the example below
if (!isset($_SESSION)) session_start();
2.
And in case you are using PHP < 5.4 you hav...
Retrieving Objects parse.com android
Hi,
After saving object Saving Object parse.com Android
Now I am writing here how to retrieve object using some key here using objectId.
If you have objectId then it is very easy to retrieve object value.
parseObject use ParseQuery to han...
How the see the body of a submit post using PHP
POST is a common mode of sending or passing the values from one page to another, But on getting what exact is inside the post PHP will offer you the code syntax.
Consider the example below:-
We will get the body part froma POST request or c...
onfocus event in Javascript
When a user clicks on an input field and it gets focus
Example
<!DOCTYPE html>
<html>
<head>
<script>
function evon(i) {
i.style.background = "grey";
}
</script>
</head>
<body>
Ent...
Asp .Net MVC HTML Helpers
Asp .Net MVC HTML Helpers :--
HTML helpers helps to render HTML controls (Like TextBox, label,Checkbox etc) in the view.Suppose you want to display a TextBox and Label on the view,you need to write below html helper code in view:--
@Html.T...
SQL Random Function
Using this function we can retrieve random row from a table in database . Mostly it is used in online exam , for random passwords etc .
Every Database has their own syntax for random function .
Syntax for MySQL Database
select col_name from...
How to get first n Characters from a given string using PHP
Hello Readers!
On a given string if you want to take out the first n number of characters from it then PHP offers you 'substr' to get the characters.
Consider an example below:-
Suppose I want to get the first 5 characters from string, $MySt...
SQL Last ( ) Function
It work similar to Last ( ) function but it return the last column from a table in database .
Syntax
select last ( col_name ) from table_name ;
It support in Ms Access Database . But for other database there is different statement for L...
