POSTED BY Rakshit Patel in MYSQL

Do you want to make a connection with multiple database in Zend Framework? Today i worked on multiple MYSQL database connection in Zend Framework as my client wants separate database to reduce the load of site. Its very easy to manage multiple database connection with ZF. You just need to add below code in bootstrap.php file and use the db object accordingly.

POSTED BY Rakshit Patel in Helpful Tips and Tricks

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.

POSTED BY Rakshit Patel in MYSQL

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.

POSTED BY Rakshit Patel in Helpful Tips and Tricks

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.

POSTED BY Rakshit Patel in HTML/CSS

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.

POSTED BY Rakshit Patel 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 some times openx deliver blank ads/banner or shows blank image with 1px width and 1px height. To solve this [...]

POSTED BY Rakshit Patel in MYSQL

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

POSTED BY Rakshit Patel in MYSQL

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.

POSTED BY Rakshit Patel in MYSQL

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..

POSTED BY Rakshit Patel in MYSQL

You may be confused with IN() and FIND_IN_SET() MYSQL functions. There are specific case/situation for both functions where to use which Mysql function. IN() function is used when you have a list of possible values and a single value in your database.