Looking to Build/Redesign a Website or Blog ?

To speak to Rakshit, call +91 968 704 2303

October 29, 2010

2 Comments

Find a Lat/Long with in x miles/kilometer Radius

You are at the right place if you are looking for solution to get or check latitude and longitude is with in x miles of radius with given latitude and longitude. This is very easy with a single equation. Get all lat/long list from database if current lat/long is with in x miles of radius.

October 25, 2010

3 Comments

MYSQL Split/Explode function

Do you know any MYSQL split function or Explode function ? I guess no, as MYSQL does not have any function for split string or explode string. Today i need to explode one of my database field which contains latitude and longitude.

October 22, 2010

3 Comments

Parse/Get XML attribute using PHP SimpleXMLElement

Today i write something about xml parsing using PHP. I am taking xml file contents using file_get_contents function. Now parsing file contents by creating object of SimpleXMLElement. I can easily get all elements of xml using $xml->name or if it is an array than $xml->name[0]->fname. But the problem is with attributes. I have one array which have attributes. Below is the simple way to get/parse xml attributes.

October 13, 2010

No Comments

Go to top of webpage with jQuery Dialog box/model box

Today i was working with jQuery model box, everything was fine but the problem with page length. Page was long and i need to open jQuery Model box when visitor click on link which is at the bottom of the page. So when visitor click on the link, jQuery model box opens but it opens at the top of the page. I can not make simple back to page anchor tag.

October 12, 2010

No Comments

Show/Deliver default banner ad in Openx

Hello Friends, I am working with Mobile Ad networking site for one of my client and i wanted to show default banner ad when there is banners/ads are available to display or match the criteria. Also sometimes openx deliver blank ads/banner or shows blank image with 1px width and 1px height. To solve this issue,

October 6, 2010

No Comments

Search MySql records Group By Year from DateTime

I am working with Mobile Ad networking site for one of my client and i wanted to get the yearly records from datetime field. Actually i am transferring hourly data in to different table to reduce load time of reporting page. For this, i need to combine records by yearly from date or datetime field

October 6, 2010

No Comments

Search MySql records Group By Month from DateTime

I am working with Mobile Ad networking site for one of my client and i wanted to get the monthly records from datetime field. Actually i am transferring hourly data in to different table to reduce load time of reporting page. For this, i need to find the monthly record from date or datetime field.

October 5, 2010

2 Comments

Find Next and previous mysql records relative to current page

I have photo details page and i need to put next photo and previous photo link. To achieve this, i need to get previous record and next records relative to index or current photo record from mysql photo table. Generally we assume that it can be achieve by add one in current record’s auto increment id and minus one in current record’s auto increment id. But this is not the correct way to get next and previous record..