Home / 2015 / November

Monthly Archives: November 2015

Sorting Arrays – PHP

Welcome to all, Today we practise how to sort an array using php. We know this same problem solving using C, CPP or JAVA etc. But here I share how to solve this problem in php. To arrange the elements in an array in numerical order from highest to lowest …

Read More »

AND and OR Operators – SQL

Hi Guys, Today we share our idea related to AND and OR operator with example. The AND and OR operators are the conditional operator in SQL. It is used to filter the data or records based on conditions. The main difference between AND and OR operators are: the AND operator …

Read More »

MYSQL Functions

Hi all, Welcome to MYSQL functions tutorial. MYSQL functions are useful while performing mathematical calculations, string concatenations, sub-strings etc. SQL provides many built in functions to performe these functionality or performing calculations on data. The most commonly used MySQL functions including: Aggregate functions String functions Date time functions control flow …

Read More »

Difference Between ‘= =’ and ‘= = =’ in php

Hi Guys, In one of the recent web developer interview, one interviewer ask “what is the difference etween == and === in php”. All are face this same situation in interview panel. Nobody knows the theory part. Then everybody shocked. Based on this situation, I just describe what are the …

Read More »

Set Operation in SQL- UNION, UNION ALL, INTERSECT,MINUS operator

Hi Guys, Welcome to sql set operations. SQL support some set of operations to be performed on MYSQL tadabase table. These are used for getting meaningful results from table, based on different conditions. Union MySQL UNION operator to combine two or more SELECT statements into a single result set. UNION …

Read More »

Uses of session_id() in PHP

Hi all, In one of the recent web developer interview, one of them are ask to me “what are the uses of session_id() in php and what are the purpose.” Session_id() is one of the inbuilt function in PHP. The session_id() will be used to track existence of same user …

Read More »

Difference between document.ready and window.onload or pageLoad

Hi all, Today we are discuss one important topic related to document.ready and window.onload or pageLoad. $(document).ready() If the DOM is ready, jQuery’s document.ready() method gets called The $(document).ready() function executes when HTML document is loaded and DOM is ready. It is jQuery specific event It is cross browser compactibility …

Read More »

Retrieve the unique rows without using the DISTINCT keyword

Good Morning to all, We know the uses of DISTINCT keyword in SQL. Here I share some usesful information relates to “Retrieve the unique rows without using the DISTINCT keyword.” The DISTINCT keyword is used to return only distinct or different values. In table, the column may contain many duplicate …

Read More »

Concatenate two variables or strings – PHP

Hi Friends, The DOT(.) operator is used to concatenate two variable or string in PHP. The ‘.’ operator which returns the concatenation of its right and left string. eg: [crayon-5b77b8a8325c9187711245/] And also ‘.=’ operator used append the arguments on the right side to the left side arguments. eg: [crayon-5b77b8a8325d1009401772/] Example …

Read More »
Social Media Auto Publish Powered By : XYZScripts.com