LPAD(str,len,padstr) function mysql
LPAD(str,len,padstr)
LPAD mysql funtion returns the string str, left-padded with the string padstr to a length of len characters means if you want to extend a string to a certain length and insert some character in left side of string at the p...
How to color to your alert message using Bootstrap
Hello Reader's If you want to print the alert messages in color, i.e. Red for danger and Green for success messages then Twitter Bootstrap offers you a good way to showing this.
Let's see the example as below:-
<!DOCTYPE html>
<ht...
LOWER(str) mysql function
LOWER(str)
LOWER(str) function returns the string str with all characters changed to lowercase according to the current character set mapping. The default character set is latin1 (cp1252 West European).
Here is a example of this function-
...
LOCATE(substr,str)/LOCATE(substr,str,pos) function mysql
LOCATE(substr,str), LOCATE(substr,str,pos)
LOCATE function returns the position of first occurrence substring in passed string. The second syntax returns the first occurrence of substring after the given position (the thirds parameter of secon...
LENGTH(str) MySQL function
LENGTH(str)
LENGTH(str) mysql function returns the length of the string str, measured in bytes. This function counts a multibyte character as multiple bytes. hence it means for a string containing 4(four) 2-byte characters then LENGTH() return...
LEFT(str,len)
LEFT(str,len)
The LEFT mysql function returns the leftmost len characters from the string str or returns NULL if any argument is NULL.
The LEFT function is multibyte safe.
Here are some example which will explain you this function-
...
INSERT(str,pos,len,newstr) MySQL function
INSERT(str,pos,len,newstr)
If you want to insert a string inside another string then you can use this MySQL INSERT function. INSERT returns the string str, with the substring beginning at position pos and len characters long replaced by the st...
HEX mysql function
HEX(str), HEX(N)
A hexadecimal string is returened by HEX(), it is a representation of str for a string argument str, where each byte of each character in str is converted to two hexadecimal digits ans multibyte characters are converted more ...
How to expand the div with a click using Bootstrap
Hello Reader's if you are new to Bootstrap, And you want to expand the div with a single click.
Lets see the example below:-
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-sc...
How to Dispatch postgres notifications to the relevant polling threads and greenlets in openerp
In openerp Dispatch PostgreSQL notifications to the relevant polling threads to Bus.loop listen imbus on db PostgreSQL and create the listen imbus and check the condition dispatch to local threads and greenlets in channel.
Example
use this code...
How to handle a longpolling request in openerp
In openerp to handle a long-polling request, we need to bypass private attribute access because we do not know before starting that the thread and handles a long-polling request and rename the thread to avoid tests waiting for a long-polling.
Ex...
How to show animated image upload status bar
Hello Reader's if you are making the file upload in html form, Then you can also show the status of the file to upload.
Lets see the example code as below:-
<!DOCTYPE html>
<html lang="en">
<head>
<link rel="styles...
FROM_BASE64('encocded_string) function mysql
FROM_BASE64('string')
FROM_BASE64 function in mysql is used to decode the encoded value. The value which is encode with the BASE64 rule to encode by the MySQL function TO_BASE64, is decoded by this FROM_BASE64 mysql function.
The argument whi...
TO_BASE64(str) function MySQL
TO_BASE64('string')
TO_BASE64 function in mysql is used for encode any string with the string encode rule BASE64. This function returns a encoded string.
This function is added with the mysql version 5.6.1
In mysql there is different base-...
How to make Ajax loading icon using CSS
Hello Reader's if your website is taking too much time to load the data then you can show the ajax loading icon for the time.
Lets see how to put the loading icon in the website.
<!DOCTYPE html>
<html>
<meta name="viewport"...
How to make simple dropdown menu using CSS
Hello Reader's if you are new to designing the menu bar, Then you can see how to make the quick dropdown menu using HTML and CSS.
<!DOCTYPE html>
<html>
<title>findnerd dropdown example</title>
<meta name="viewpor...
The general css for header, body and footer for all website
Hello Reader's if you are new to designing the website then you must have to know the common CSS that must be inlcuded in every website.
Lets see the CSS in the example below:-
<!DOCTYPE html>
<html>
<title>W3.CSS</titl...
How to show max words left to insert into text area
Hello Reader's if you are making the html5 validation to set the max words inside the html form, Then by using Angular JS NG-Model you can easily make it.
Lets's see how to do it as in the example below:-
<!DOCTYPE html>
<html>
...
How to hide/show the html using Angular JS
Hello Reader's if you want your webpage to show or hide the html form with just a single click then choosing Angular will be the best way.
Lets see how to get it working in the example as below:-
<!DOCTYPE html>
<html>
<scrip...
How to reset the form using Angular JS
Hello Reader's If you want to reset your html form then the easiest way to do it is by using Angular JS.
Lets see its example as below:-
<div ng-app="myApp" ng-controller="formCtrl">
<form novalidate>
First Name:<br>...
How to make ajax hit in Angular JS
Hello Reader's if you want to get data from another webpage then you have to make ajax hit. Angular JS also provide you to get your data and redesign it into it's script.
Then you can generate the design itself. Let's see it's working example a...
How to sort the real time data from a text box using Angular JS
Hello Readers, If your web page have multiple lists of words and you want to sort them in real time. Then by using Angular js you can do it.
Let's see how it will work.
<!DOCTYPE html>
<html>
<script src="http://ajax.googleap...
Best way to show Angular JS on browser
Hello Reader's if you want to learn Angular JS then this blog is the best to understand it.
Here I'll create a script written in Angular that will reprint the charracter which are typed in text box.
<!DOCTYPE html>
<html>
<sc...
How to trigger an event in web page
Hello Reader's If you want to set the trigger to and event on the web page, Then using Javascript will be your best option. In this blog you will see how to set any event with its time in seconds.
Lets consider an example here I'm triggerring ...
How to get user's browser information using JS
Hello Reader's if you need to keep details of user who visits your website. Then you must know about their web browser. By using Javascript you can easily get this information.
Lets see how to get this informations:-
<!DOCTYPE html>
&l...
How to get user screen's height and width using Javascript
Hello Reader's if you are making the user screen compatible website then you must get the screen hight and width of user.
By using Javascript you can easily get it.
Lets see how to get screen size.
<!DOCTYPE html>
<html>
<b...
How to make range validation of textbox using Javascript
Hello Reader's if you are making the validation of text box to set it's max and min range, Then by using javascript you can do it faster.
Lets see the example as below:-
<!DOCTYPE html>
<html>
<body>
<p>Enter a ...
How to get retrun types of variables in JS
Hello Reader's if you want to get the return types of the variables in Javascript then in this blog you will learn about them.
for getting the return type you have to use the type of function in the JavaScript.
Let's see some of the return ty...
while and do while loops in Javascript
Hello Readers if you are confusing in while and do while loop in Javascript then this blog will be helpfull to you.
Lets see both of them working:-
First we will how while loop works:-
while (i < 10) {
text += "The number is " + ...
All date formats in Javascripts
Hello Reader's If your website getting the dates in different different date formats. Then you can see all the date formats that are valid in JS.
Let's see the below date formats in JS.
var d = new Date("2015-03-25");
var d = new Date("2015-...
Shortest way to find the max element of a array
Hello Reader's if you want to get the shortest way to get the max value of the given array, Then by using JS you do it fast.
To find the result you have to use Math.max() function.
Lets's see the working example as given below:-
<!DOCTY...
How to make calculation in Javascript
Hello Reader's If you want to make the mathematic calculations inside the html document, Then by using the JS you can make calculations.
You just have to use the document.write() function.
Lets see it working in the example as below:-
...
How to change the data inside the div dynamicaly via Javascript
Hello Reader's if you are developing the website that convert the real time data into the div, Then by using Javascript you can do it.
Let's see the example as below:-
<!DOCTYPE html>
<html>
<head>
<script>
functio...
How to show current timestamp by single click on page using Javascript
Hello Reader's if you want to show the current timestamp on the web page by just a single click, Then by using JS you can do it.
Lets see the example below:-
<!DOCTYPE html>
<html>
<body>
<h1>My First JavaScript...
How to add a column into a table in MySQL?
Sometimes we need to add a column that we require into the table. We can do this by using ADD keyword with ALTER command.
Syntax:
To add a column into a table, use the following syntax:
ALTER TABLE table_name
ADD COLUMN column_name data...
How to drop a column from table in MySQL?
Sometimes we need to drop a column that we don't need further from the table. We can do this by using DROP keyword with ALTER command.
Syntax:
To drop/delete the column from a table, use the following syntax:
ALTER TABLE table_name
DROP...
How to change the datatype of a column in MySQL?
Sometimes we need to change the data type of a column in a table. We can do this by using Modify keyword with ALTER command.
Syntax:
To change the data type of a column in a table, use the following syntax:
ALTER TABLE table_name
MODIFY...
Determine if string exists in input string
You can determine particular string exist in an input string with the help of strpos function. strpos returns false if the string is not found. It provides 0 if found at the beginning of string. It finds the position of occurrence of string wi...
Difference between UNION and UNION ALL operators in MySQL.
In MySQL UNION operator used to combine the result of multiple SELECT statements. When we apply the UNION operator then it selects only distinct values by default (No duplicate values are allowed).
UNION Operator
When we apply UNION operato...
How to insert data from one table to another in MySQL?
We can insert data from one table to another in MySQL. For this we use the INSERT INTO SELECT statement that selects the data from on table and inserts that data into another table.
INSERT INTO SELECT Syntax
We can select and insert all the...
Computed fields in Odoo9
Computed fields indicates many2one and one2many filed in selection filed . For example you can see below code in you .py file .
test = fields.Char(compute='_compute_upper',
inverse='_inverse_test',
sea...
Environment in Odoo9
Environment is the most important part of set in any framework.its indicates stores various contextual data used by the ORM method . For example you can see below code in you .py file .
@api.multi
... @api.returns('self')
... def demo_method...
How to replace a text with a string?
To replace a text with a string a function str_replace() is used. It replaces all the occurences of the string that you have searched with the string you want to give in that place.
For example:
<?php
$str = "String in which you replace ...
MongoDB supported datatypes
Supported datatypes by MongoDB is given below:
String: That is normally employed datatype for you to store the data. String inside mongodb have to be UTF-8 legitimate.
Integer: This kind is utilized for you to store a new statistical worth....
Can we bind a DropDownList using List<> in Asp .Net
Can we bind a DropDownList using List<> in Asp .Net
The Answer is :
Yes, we can bind a DropDown in Asp .Net using List<>. Please go through the following code for Example:-
Let's create a Class say DropdownClass, in the class ...
foreach() function in PHP
foreach() function provides an easy way to scan arrays & exactly do the same thing like for loop, so this function is said to be PHP foreach loop. foreach loop works only on arrays.
Syntax:
foreach ($arrayname as $value) {}
Example...
What Is Software Schedule ?
What Is Software Schedule ?
Normally software schedule is exactly associated to the volume or capacity of the project, endeavors (efforts) and expenses included.
Why we done scheduling for the software ?
There are mainly 3 basic reasons...
valueOf() method of JavaScript Array
JavaScript Array valueOf() method : The valueOf() method returns the copy of itself. This is the default method of an array object.
Syntax of Array valueOf() method :
array.valueOf()
Example of Array valueOf() method : In this exampl...
unshift() method of the JavaScript Array
JavaScript Array unshift() method : The unshift() method is used to add new item at the first position of an array. The unshift() method will return the new length of an array. The unshift() method will change the length of the array.
Synt...
slice() method of the JavaScript Array
JavaScript Array slice() method : The slice() method is used to get the elements between two position. The slice() method returns the array of extracted elements. It doesn't change the original array. The index starts from 0.
Syntax of the...