jquery event.target
Hello Readers,
Definition: The DOM(Document Object Model) element that initiated the event.
It is often useful to compare event.target to this in order to determine if the event is being handled due to event bubbling.
The target pr...
TRIM mysql function
TRIM([{BOTH | LEADING | TRAILING} [remstr] FROM] str), TRIM([remstr FROM] str)
TRIM mysql function is used for trimming a given character even left or right and if not given then both side. If trimming character is not passed with this functio...
How to pass mulitple values to update records with a single query
Hello Readers if you want to update mulitple record by multiple id, then you have to use in clause in MySql
Lets see the example as below:-
$ids = array(474,25, 99,101);
Here I have an array $ids with multiple id's. Now this array w...
SUBSTRING mysql function
SUBSTRING(str,pos), SUBSTRING(str FROM pos), SUBSTRING(str,pos,len), SUBSTRING(str FROM pos FOR len)
SUBSTRING mysql function returns substring from a string. You can use this function with some above types.
If you pass only one argument with...
How to pass an arrray in PHP via Ajax
Hello Readers if you want to send the array into another PHP page then you can use the code below:-
I have array made by function .push. In array is very large data. How is the best way send this to PHP script?
dataString = array(a->b);...
SQL Tutorial -> Sql = Operator
<-- Chapter 7: SQL NOT IN Operator
Chapter 8
SQL = Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
D...
SQL Tutorial -> Sql NOT IN Operator
<-- Chapter 6: SQL IN Operator
Chapter 7
SQL NOT IN Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
...
SPACE(N) mysql function
SPACE(N)
If you want to add spaces in a string then you can use SPACE function of mysql. SPACE function returns a string consisting of N space characters means SPACE will returns the white space equal to passed argument n, where n is a intege...
SQL Tutorial -> Sql IN Operator
<-- Chapter 5: SQL Where
Chapter 6
SQL IN Operator
Lets see an example from the below table "employees" :-
employee_id
name
code
designation
salary
101
ABC
E-101
Engineer
12000
102
DEF
E-102
Doctor
80...
How to add two objects into one using PHP
Hello Reader's if you want to add two or more objects into one. Then you can see it into the example below:-
Ideally if you want the data to be together, you should have a parent class which has all these member functions and you should have a...
How to convert string to binary and binary to string using PHP
Hello Readers if you want to convert your string into binary using PHP then you can use the code syntax as below:-
$value = unpack('H*', "This string is converting into binary");
echo base_convert($value[1], 16, 2);
Output:-
010100110...
RTRIM(str) mysql function
RTRIM(str)
RTRIM() mysql function returns the string str with trailing space characters removed.
In mysql if you want to remove a white space from the right side of a string then you can use this RTRIM mysql function. RTRIM mysql function re...
How to superimpose one image over another using PHP
Hello Readers if you have two images i.e. one png and one jpg, Then by using PHP you can merge both on a single one.
Lets see the example as given below:-
<?php
# If you don't know the type of image you are using as your originals.
$...
RPAD(str,len,padstr) mysql function
RPAD(str,len,padstr)
RPAD mysql function returns the string str, right-padded with the string padstr to a length of len characters means if you want to get a string to a given length and if the length of string is sorter than add the given cha...
RIGHT(str,len) mysql function
RIGHT(str,len)
In mysql, if you want some character from the right in a string then you can use RIGHT() mysql function means this function returns the rightmost len characters from the string str or returns NULL if any argument is NULL.
H...
REVERSE(str) mysql function
REVERSE(str)
If you want to reverse a string in mysql then you can use the REVERSE(str) mysql function. REVERSE() function returns the string str with the order of the characters reversed means if you want to reverse a string then you can pass...
How to delete table/database in MySQL?
We can drop table or database by using DROP keyword.
Syntax:
The DROP TABLE statement is used to delete a table.
DROP TABLE table_name;
The DROP DATABASE statement is used to delete a database.
DROP DATABASE database_name;
E...
How to delete an INDEX in a table in MySQL?
We can drop INDEX from table by using DROP INDEX statement, it is used to delete an index form a table.
Syntax:
ALTER TABLE table_name DROP INDEX index_name;
Example: Suppose you have created an INDEX named "person_user_name_idx" on th...
REPLACE(str,from_str,to_str) string function in MySQL
REPLACE(str,fromStr,toStr)
When you want to replace a string from other string in a string then you can use REPLACE function. REPLACE function returns the string str with all occurrences of the string from Str and replace it by the string to S...
How to create INDEXES in tables in MySQL?
We create INDEX in a table to find data data fast and efficiently. It allows the database to find data without reading all the records of the table. When we apply search and queries to table INDEX
are used to make them fast.
To create indexes i...
REPEAT(str,count) mysql function
REPEAT(str,count)
If you want to repeat a string str at given times then you can use the REPEAT mysql function. REPEAT function returns a string consisting of the string str repeated count times. It returns an empty string if count is less tha...
QUOTE(str) mysql string function
QUOTE(str)
Quotes function used to produce a result that can be used as a properly escaped data value in an SQL statement of a string. The string is returned enclosed by single quotation marks and with each instance of backslash (\), single q...
How to implode multi-dimensional array keys using PHP v5.5
Hello Readers, If you want to implode the array keys from multi-dimensional array then now PHP 5.5 offers you much easier way to do this.
Lets see the example as below:-
Array
(
[0] => Array
(
[studenID] =>...
I'm getting import CSV error while uploading files in php
Hi i'm developing the panel where admin can import the csv file directly to mysql database. But I'm getting the error.
My code is
<?php
//ENTER THE RELEVANT INFO BELOW
$mysqlDatabaseName ='bilmos';
$mysqlUserName ='root';
$mysqlPasswor...
MAKE_SET(bits,str1,str2,...) mysql function
MAKE_SET(bits,str1,str2,...)
MAKE_SET function returns a set of values which are from string containing substrings separated by , characters, consisting of the strings that have the corresponding bit in bits set. str1 corresponds to bit 0, str...
Jquery difference between .append() and .appendTo() method
Hello Readers,
If we want to insert any element or content within define particular element using jQuery, then we can use jQuery .append() or .appendTo() method.
jQuery .append() and .appendTo() both methods are doing the similar ta...
How to show custom lines on Google Map
Hello Reader's if you are integrating the Google Map in the website and you also want to show custom line on the map, Then this blog is very helpful you.
Lets see the working of this custom map.
<!DOCTYPE html>
<html>
<head&g...
What is mouse enter event in Jquery
Hello Friends,
Here I am discussing about mouse enter event in jquery. Mouseenter can call a specific action when your mouse cursor enter in a specific html entity like button,specific div id, class etc.
In the below example we are hiding sp...
How to show bounce effect on google map marker
Hello Reader's if you are integrating the google map with marker showing your address, Then you can also make the marker with bounce effect.
Lets see my code as below:-
<!DOCTYPE html>
<html>
<head>
<script
src="http:...
How to make gradient in backgound of a div
Hello Readers if you need to show mix colored in the background of the div then instead of using the photoshop images you can also do it by using CSS3.
Lets see the code css for this:-
background:-webkit-gradient(radial, 165 0, 0, 220 -257,...
How to get Clean URL in Drupal 7
Hello Friends,
In Drupal generally URL setup like "http://www.abc.com/?=node/38". If you are looking to setup clean URL like "http://www.abc.com/node/38". Please follow the below steps for the same::
1) Open administrative panel
2) After...
How to make 3d effect of a div using CSS
Hello Reader's if you want to make your html webpage to look like 3d image then you can use the code below.
Here in the code css will make the background shadow of div, Which will make it appear in 3d.
Let's see the code:-
-moz-box-shadow:...
How to put text align to veritcal using CSS 3
Hello Reader's if your are looking for the code to write the text with alignment upward, Then you can use the code css as below:-
-webkit-transform: rotate(90deg);
-moz-transform: rotate(90deg);
-o-transform: rotate(90deg);
writing-mode: tb...
How to make mouser hower motion on image using CSS
Hello Reader's if you want to make the animation in the image then you can use the cssmaker css. And here by using the css code below you can see and learn how to make this:-
.classname {
transition:All 1s ease;
-webkit-transition:All 1s eas...
Listing of record fields in Odoo9
When we are using list records field then it returns a large amount of meta-information (client programs also use list records field) which should be filtered before printing, string(the field's label) are the most interesting items for a human u...
Read records in Odoo9
When we face any issue in database records value at that situation we use read records value and record data is accessible with the read() method, which takes a list of ids (as returned bysearch()) and optionally a list of fields to fet...
Count records in Odoo9
Count record show the records value of database and retrieve a list of records and count them, search_count() can be used to retrieve only the number of records matching the query. It takes the same domainfilter as search()&nb...
Paginations in Odoo9
Paginations is the most important for odoo framework and its help to produce the inventory value of database and By default a search will return the ids of all records matching the condition, which may be a huge number. offset and ...
List records in Odoo9
List reord is the most important part of Odoo data base with the help of list records we can manage all database in odoo framework and search() takes a mandatory domain filter and returns the database identifiers of all records mat...
Calling methods in Odoo9
With the help of call method we have to create xmlrpc/2/object, it is used to call methods of odoo models and send value in database.
For example you can see below code and use in your odoo module.
models = xmlrpclib.ServerProxy('{}/xmlrpc/2/...
Jquery difference between .append() and .after() method
Hello Readers,
Often, we see that jQuery .append() method and jQuery .after() method work similarly, but there is a little bit difference between these methods.
Here we will discuss about functionality of following functions and it ...
How to make border with round radius for all the images in website
Hello Reader's you want to make the edges with border and round in shape for all the images in you website then you just need to put CSS3 to update as below:-
border:solid 5px #000000;
-moz-border-radius: 32px;
-webkit-border-radius: 32px;
...
How to show new messages in desing using CSS
Hello Reader's if you want to make nice view to show the messages and alert count then you can use the Badge of bootstap
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta c...
how to show color in button of html form using Bootstrap CSS
Hello Reader's if you want to show color in the buttons then you can use bootstrap css.
In this blog you can see and learn how to make them customize. Lets see my code as below:-
<!DOCTYPE html>
<html lang="en">
<head>
...
jQuery .append() and .prepend() method
Hello Readers,
Here we will discuss about jquery .append() and .prepend() methods.
jQuery .apend method: jQuery .append() method insert any content or data inside in sentence at the last index. In other word .append() method puts ...
How to put all the links target to sections of home
Hello readers if you want a single page website in which all the pages and links will be the sections of Home page. By using the bootstrap you can make it. Here you can see my code working as single page website.:-
<!DOCTYPE html>
...
How to make iconic hower on link using Javascript
Hello Reader if you want to make the nice and iconic hower on link then you can use Javascript as below:-
<!DOCTYPE html>
<html lang="en">
<body>
<div class="container">
<h3>Tooltip Example</h3>
...
How to make simple popup using Bootstrap
Hello Reader's if you are looking for nice and light design of popus, then bootstrap offers you much better way of doing this.
Lets see the code as written as below:-
<!DOCTYPE html>
<html lang="en">
<head>
...
LTRIM(str) Function mysql
LTRIM(str)
LTRIM(str) function returns the string str after remove the leading space characters means if you want to remove the all spaces from the left side of a string in mysql you can use this LTRIM mysql function.
Here I am giving a examp...
The best Carousel slider for website
Hello Reader's if you are looking for the simple and light Slider to integrate into your website then Carousel slider is the best. You can take my code as below:-
<!DOCTYPE html>
<html lang="en">
<head>
<meta ch...