December 29

List of all important MySQL functions

mysql-function

MySQL Group By Clause – The MySQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certain database table column(s).

MySQL IN Clause – This is a clause, which can be used along with any MySQL query to specify a condition.

MySQL BETWEEN Clause – This is a clause, which can be used along with any MySQL query to specify a condition.

MySQL UNION Keyword – Use a UNION operation to combine multiple result sets into one.

MySQL COUNT Function – The MySQL COUNT aggregate function is used to count the number of rows in a database table.

MySQL MAX Function – The MySQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.

MySQL MIN Function – The MySQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.

MySQL AVG Function – The MySQL AVG aggregate function selects the average value for certain table column.

MySQL SUM Function – The MySQL SUM aggregate function allows selecting the total for a numeric column.

MySQL SQRT Functions – This is used to generate a square root of a given number.

MySQL RAND Function – This is used to generate a random number using MySQL command.

MySQL CONCAT Function – This is used to concatenate any string inside any MySQL command.

MySQL DATE and Time Functions – Complete list of MySQL Date and Time related functions.

MySQL Numeric Functions – Complete list of MySQL functions required to manipulate numbers in MySQL.

MySQL String Functions – Complete list of MySQL functions required to manipulate strings in MySQL.

Category: MySQL | LEAVE A COMMENT
December 18

Difference between Include, Include_once, Require and Require_once

Include

The include() statement includes and evaluates the specified file.

Include Once

The include_once() statement includes and evaluates the specified file during the execution of the script. This is a behavior similar to the include() statement, with the only difference being that if the code from a file has already been included, it will not be included again. As the name suggests, it will be included just once.

Require

require() and include() are identical in every way except how they handle failure. They both produce a Warning, but require() results in a Fatal Error. In other words, don’t hesitate to use require() if you want a missing file to halt processing of the page.

Require_once

The require_once() statement includes and evaluates the specified file during the execution of the script. This is a behavior similar to the require() statement, with the only difference being that if the code from a file has already been included, it will not be included again.

Category: PHP | LEAVE A COMMENT
December 16

Steps to Integrate CCAVenue Payment Gateway using PHP

Payment Gateway

You can integrate CCAvenue Payment gateway by following steps;

Very first download “Generation Kit” from CCAvenue “How to Integrate”. Generate Working Key from the “Settings and Options” Link.

After this steps, this is time for coders;

Before all, copy the 32 bit working key that you have generated from CCAvenue and assign it to the variable by the name WorkingKey in the php files checkout.php and redirecturl.php. Then you need to include libfuncs.php3 in your payment gateway form page.

After this you need some parameters such as below;

  • Merchant_Id
  • Order_Id
  • Amount
  • Currency
  • Redirect_Url
  • checksum
  • TxnType
  • actionID

After setting this parameter,  redirection Response Variables should be send to our mentioned redirected file.

December 14

15 Useful Google Tools You Probably Didnt Know About

google

  • You can set a timer on Google (and get an alarm to sound when time is up) by looking up any amount of time on the website, followed by “timer.”
  • Google.com/sky lets you explore the far reaches of the universe using images from NASA satellite, Sloan Digital Sky Survey and Hubble Telescope.
  • Getting married? Google will help you plan your wedding, by guiding you through breaking the news, locating a venue, making a website and more.
  • Google nGrams is a fun tool that lets you search for words in 5.2 million books published between 1500 and 2008 so you can see how they’ve been used and changed over time.
  • Intimidated by huge numbers? Google will help you figure out how to pronounce that 12-string behemoth if you type “=english” after it.
  • There’s a “Manual” feature in Google Translate that lets you draw characters or symbols.
  • Similarly, Google Input Tools lets you type in over 80 different languages without having to download a special keyboard.
  • Find a gorgeous font that you can use for free using Google.com/fonts.
  • Google Scholar makes it incredibly easy to search for information in professional journals and papers.
  • Brush up your cultural knowledge by using Google Art Project to check out super high-resolution photos of artwork from the world’s greatest museums.
  • Think Insights is Google’s “digital cheat sheet” for marketers, where it uses its data to glean what’s on deck for the industry
  • Want to get a pulse on what people care about at any given moment? Google Trends shows the most searched terms every day.
  • You can even plot how different search terms have waxed or waned in popularity over time.
  • Panoramio combines Google Maps with your personal photos, thus letting you plot their pictures over the real-world locations where they were taken.
  • The Google Sound Search widget works like Shazam to help you identify songs you hear. It will also link you to buy each track in the Google Play Store.
  • Google Keep is a killer notes and reminder app that works across both desktops and smartphones.
For more details and for source, click here