Archive | Ecommerce RSS feed for this section

Introduction to MySQL Query Expansion – Part 1

12 Sep

We all know that back in stone age, the cave-man had no issues with data incompatibility, storage and search because stones & leaves were the only medium for data storage and search but that is past and  today we are in 21st century where we have to dealt with tons and tons of data and the data searching becomes more important.

Today we are going to learn the basics of MySQL Query Expansion. There are some cases,  where you want to find some information based on limited knowledge that you have. You use some keywords to search for information, and typically those keywords are too short. To solve this problem and help users to find what they want based on the too-short keywords, MySQL full-text search engine introduces a concept called query expansion.

What is query expansion?

The term query expansion in MySQL is used to broaden the search result of the full-text searches based on automatic relevance feedback which is sometimes referred as blind query expansion. Let us understand  how MySQL full-text search engine performs the steps when the query expansion is used:

  • First, MySQL full-text search engine looks for all the rows that match the search query provided by you.
  • Second, it checks all rows in the search result and then it finds all the relevant words.
  • Third, it performs a search again but based on the relevant words instead of the original keywords provided by the users.

Since you understood the basic concepts of query expansion, it might be clear  that you can use the query expansion when the search results are too short. You need to  perform the searches again but with query expansion to offer users more information that are related and relevant to the user.

Lets us understand the syntax:

In order to use query expansion, you need to use the WITH QUERY EXPANSION search modifier in the AGAINST()function. The following illustrates the syntax of the query using the WITH QUERY EXPANSION search modifier.

SELECT column1, column2
FROM table1
WHERE MATCH(column1,column2)
      AGAINST(‘keyword’,WITH QUERY EXPANSION);
In the next post, I’ll be continuing this topic with relevant examples and will see some quick facts about the full- text search. Please share your feedback and share if you like this topic.
Advertisements

Integrating PayUmoney payment gateway in PHP

10 Jun

payumoney

Today I am going to explain, how you can integrate PayUmoney in your custom PHP based website. In initial stage of plan to integrate PayUmoney to the website seems to be little confusing to those who are not doing regular coding but once you get involved, it seems to be easy one.  If you have gone through the technical document of PayUmoney, then most of the things are clearly mentioned as easy to understand.

Here is the step by step guide to integrate PayUmoney payment gateway in your site:

  1. Go to https://test.payumoney.com/ and sign up as a merchant account.
  2. At time of sign up you need to use your valid email id.
  3. Then fill all required business details. Use this details for PAN no. ABCDE1234F (use your PAN Number) and DOB – (dd/mm/yyyy) .
  4. Add your bank detail, note you can add whatever bank name and details use this IFSC – ALLA0212632 in place of IFSC.
  5. Don’t worry about bank details verification as you know this is your test account only.
  6. Once your required steps are completed and your account is live,then write mail to support team : (techsupport@payumoney.com) for activating your account and to provide salt key.
  7. Now after activation you can get your key go to Manage Account ⇒ My Account ⇒ Merchant -Key Salt copy your key and paste in your code.
  8. After receiving you salt key, you are ready to test the code which can be downloaded from PayUmoney site also.

I hope following these easy steps, you can easily integrate PayUmoney to your website.

Sample Code

You can also download the sample code from github.com

https://github.com/payumoney-india/PayUMoney_PHP_Module/archive/master.zip

 

Note:- Don’t forget to change the Merchant Key & Salt in the code.

 

Magento version 1.8 available to Download

10 Oct

Finally wait is over for new version. New Magento version 1.8 is available,Are you happy with 1.7? if yes that’s good but you can try the newer version. Download it from here.
1. Security Updates :- The security feature of the system has witnessed a major overhaul with the recent update….

6 Things Online Retailers Can Learn From Amazon

9 Oct

This post was originally written by Jeff Oxford , an Internet marketing consultant and founder of 180 Marketing who specializes in SEO for e-commerce.
With global ecommerce sales reaching over $1 trillion in 2012, it’s easy to see why so many companies are taking their business online. One o…

Page Speed the Key to User Experience & Tools

9 Oct

I was analyzing the page speed of my site and found that it need to be worked on seriously. I am working on it and in the mean while thought to share my views. You are definitely agree to me that page speed play an important role in online business. For User Experience it is one of the important…

Programmatically update coupon expiry date in magento

4 Oct

 
In my last post, I have discussed on how to update the expiry date of coupon via SQL Query in magento. In this post I am giving an alternate method of updating the expiry date of coupon and believe that it is a better way than the raw query. Below is the code which will update the expiry…

How to update expiry date of coupon in Magento

3 Oct

I have asked by one of my colleague to update the expiration date of coupon code in Magento, I thought of writing a script which will update the date of all coupon. Suddenly thought of a shortcut method and updated in database.
Here is the simple query:-
UPDATE salesrule_coupon set…

%d bloggers like this: