Looking to Build/Redesign a Website or Blog ?

To speak to Rakshit, call +91 968 704 2303

September 29, 2010

No Comments

Difference between IN and FIND_IN_SET

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.

September 29, 2010

No Comments

GROUP_CONCAT MYSQL group by function

GROUP_CONCAT() function is used to concatenate column values into a single string. Note that this function will not count null values. This is very useful if you need records from database with multiple rows in single string with specified seperator(e.g. Comma seperated). This situation will come in one to may relation of tables. You may get this error while retriving records using joins. “Operand should contain 1 column(s)”.

September 25, 2010

3 Comments

Openx Track/Log Clicks Customization

Openx is an ad sever platform who provide you ad serving solution to power all of your digital advertising. I am working with mobile advertising platform application and i have used Openx-2.8 for ad delivery. Now my client needs some customization for tracking clicks/ log clicks by country, region and city. Openx is tracking clicks in ‘data_bkt_c’ table and transfer it to another table ‘data_summary_ad_hourly’ after every one hour. This are the total clicks for particular campaign or zone.

September 24, 2010

1 Comment

Openx Track/Log Requests Customization

Openx is an ad sever platform who provide you ad serving solution to power all of your digital advertising. I am working with mobile advertising platform application and i have used Openx-2.8 for ad delivery. Now my client needs some customization for tracking requests/ log requests by country, region and city. Openx is tracking requests in ‘data_bkt_r’ table and transfer it to another table ‘data_summary_ad_hourly’ after every one hour. This are the total requests for particular campaign or zone.

September 20, 2010

No Comments

Openx Track/Log Impressions Customization

Openx is an ad sever platform who provide you ad serving solution to power all of your digital advertising. I am working with mobile advertising platform application and i have used Openx-2.8 for ad delivery. Now my client needs some customization for tracking impressions/ log impressions by country, region and city. Openx is tracking impressions in ‘data_bkt_m’ table and transfer it to another table ‘data_summary_ad_hourly’ after every one hour. This are the total impressions for particular campaign or zone.

September 14, 2010

5 Comments

Write Array in txt file with PHP

Every programmer knows how to interact with file functions like fopen, fwrite, fread and fclose. Also most of us are aware with writing values in text file by using fwrite file handling function. Today i face a situation where i need to write array in text file using php as i am interacting with XML-RPC

September 12, 2010

1 Comment

Access forbidden error in XAMPP

Today i was setting drupal for multisite and for that i made some changes in virtual host file and some files of apache. I was getting Access forbidden! You don’t have permission to access the requested object. It is either read-protected or not readable by the server.