So, this is the second last part of the long awaited MySQL datetime series. Previously we have leant how to work with MySQL datetime datatypes and how to automate some insertions using some MySQL datetime commands. Obviously the only thing left to discuss is, the (difficult) datetime arithmetic inside MySQL. As in any language, the datetime arithmetic is not as straight forward as normal arithmetic. The reason is simple, we can’t...

jQuery UI has always been my favorite tool for creating custom and rich User Interface. On my last project, I thought of using the UI dialog as reusable modal prompts, just like some jQuery plugins like Colorbox, Fancybox etc. But while doing that I faced some problem like, chaining the dialog to multiple class based selectors and attaching the dialog open events to respective anchor elements. After reading the documentation a bit, I...

As we know, HTTP POST and HTTP GET are two great means of passing user data to servers. Previously, we have discussed about how to create different pages via a single script using URL variables, ie using GET method. Now, there can be occasions where, you need to have HTTP POST forms to get data from users. The question is, can you use GET and POST method together to create different dynamic pages from a single script? The answer is...

The idea of this post originated from the topic, using PHP GET and POST method simultaneously via a single form. While writing about the tutorial, I felt that, one need to know the basics of HTML forms and PHP suparglobal POST and GET variables to understand how HTTP interaction takes place in between user and the Server. The most useful feature of any server side scripting language is the interactive capability of receiving and processing...

So far we have covered many of of useful datatypes of MySQL. Some of them are integers, text, varchar and most importantly, date and time and date-time manipulation. Now, let us proceed to the next useful sets of datatypes of MySQL. In this chapter, we will cover one of the most useful datatypes needed in real web applications to manage scores, numerical values in form of floating decimals. Unlike integers, we sometime need to store...

No doubt PHP is a powerful interpreter… It has everything a programmer need to make his program. Today we are going to talk about a little less used but very powerful language construct eval(). Basically it evaluates some string passed through it as PHP code. It may seem easy, but there are a few thing one need to know before using this construct. [Note, this is not a function]. Sometime the usage gets so much confusing which often...