PHP Freelancer PHP Freelancer India PHP Programmer India PHP Freelancer Indian Freelancer Freelance Programmer Freelance Developer Freelance Web Developer Freelance Programmer India Hire PHP Developer India Wordpress Developer India CakePHP Developer India
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
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.
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.
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)”.
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.
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.
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.
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
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.
I am 
Recent Comments