Introduction As of MySQL 5.0 built-in (native) functions, user-defined functions and stored functions are now supported by the mysql engine. Although these functions are widely available to the developer their use isn’t fully exploited. In this article I am going to present the top MySQL functions that come in handy. Hash...
read more
You will often want to extract content from HTML pages to operate on it.A good example is when creating a SEO tool that returns the keyword density or performs other content-related SEO specific operations.Of course, you cannot just grab the HTML source code and operate directly on it.What you need is the content of the page.And...
read more
A cryptographic hash function is a procedure that takes in a variable amount of data and returns a fixed-size bit string known as the data’ signature or hash value. Among the hash functions the most widely used is by far MD5, but currently it’s days are numbered because of breakthroughs in cracking it. One approach I...
read more
A few times I came across the need to check if a current row exists in the database and then update it or if it doesn’t exist simply insert it. There are many ways you can achieve that, I’m gonna show you two of them and make a comparison between them. Before we move further you should know that I’m using Microsoft...
read more
What is RSS? RSS is a technology that is being used by millions of web users around the world to keep track of their favorite websites easily and efficiently. RSS stands for ‘Real Simple Syndication’ and many people describe it as a ‘news feed’ that you subscribe to. Basically it’s the internet’s...
read more