Archive

Posts Tagged ‘PHP Developer’

Timezones in MySQL and PHP

September 22, 2011 Leave a comment

Timezones in web applications are often dealt with the same way as character sets. Either incorrectly or ignored. The case of unicode is improving slowly as developers discover the need for international language support.
The problem with not handling timezones correctly is not apparent in the usual case of the webserver and the database server being in the same timezone. A lot of PHP code passes the task of timestamps on to MySQL, e.g. by calling NOW() on inserting or updating records. It is nessesary to know in what timezone the timestamps are stored to process them correctly.

Often a specific timezone is assumed for displaying date and time. This could very well be incorrect for a large number of visitors. If the database server is in yet another timezone, things begin to get out of sync.

MySQL’s handling of timezones is – obviously – separate from that of PHP. Along with the fact that the MySQL timezone can only be changed by users with SUPER privileges, this means that MySQL cannot be relied on for creation of timestamps in correct timezone. In other words, the usual call toNOW() is not an option.

PHP 5.1 introduced the date_default_timezone_set() method for setting the timezone PHP will use for functions like date() (or alternatively the date.timezone php.ini directive). This allows for a flexible and consistent way of creating timestamps in the correct timezone form within PHP. One user in London might start a thread while a response comes from New York. To handle this consistently and make sure both users see local time and the correct timespan between the posts, use date_default_timezone_set() to create the timestamps from PHP in a fixed timezone like GMT.

Time for an example to illustrate the practical use of this. I created a simple class Timer for dealing with these operations. The methods will be called statically as there is no need to instantiate the class.


class Timer 
{   
    static function DatetimeInGMT() {
        return date("Y-m-d H:i:s", time()-date("Z",time()));
    }

    static function GMTDatetimeToLocal($datetime) {
        $time = strtotime($datetime);
        return date("Y-m-d H:i:s", $time+date("Z",$time));
    }
}


Timer::DatetimeInGMT() produces a timestamp in GMT. I use it instead of MySQL’s NOW()because it calculates the time relative to the timezone set in PHP rather than that of MySQL.

When reading the timestamp back in to PHP, another function call is needed to convert it back to whatever timezone PHP is in at that time (it might be a different user viewing with another timezone setting). That’s the job of Timer::GMTDatetimeToLocal($datetime).

These two very simple functions and a correct setting of PHP’s timezone will ensure that dates are stored in a consistent way and displayed correctly.

 

 

Ouch! I’ve Been Banned By Google!

September 19, 2011 Leave a comment

 

This question has become very common these days. Waking up to find out that your site has disappeared from the rankings of Google is shocking and nothing can be worse than for someone who runs an  business that this. There are certain times when the website does not rank for its own name. These are very clear signs that your site has been banned by .

 

Google does not offer any warnings before it bans your site. You will only be able to find out when the visitors to your site drops considerably. This will be followed by the sales reducing by a high margin. A high percentage of site owners may be left without an understanding of what actually transpired thus scratching their heads and spending sleepless nights about how to get back.

 

Your site cannot be banned without a reason.

 

There are certain Google’s rules which when violated, will make your website banned from the search engines.

 

The possible reasons that may make your site get banned include:

 

  • Meta Tags and Robots: Looking at your robots and Meta tags may be the best way forward since it may be possible that your robots have been set in a way to exclude Google spiders from indexing your site. If your site has a robot .txt file, it would make sense if you look at it. Your Meta tags should never show something like this: < Meta name=”ROBOTS”=cont=”NOINDEX”>
  • When this appears on your site, Google will definitely be prevented from ranking to your site. Your choice of a robot code may also lead to your site not being ranked by Google. Ensure that your choice of robot codes is set to allow the  visit all your web pages.
  • Cloaking: You must have heard about cloaking, right? This is a term used to describe a site that sends web pages that have been altered to search engines that crawl the sites. You will note that when different content is returned to the users than what is returned to the search engines with the aim of causing some distortion in search engine rankings. This is one of the malpractices that can have your site banned from Google rankings. Google tries as much as possible to ensure that the quality of the search results is not only consistent but also of high quality. Any site which is involved in cloaking may be banned by Google permanently.
  • So when your website displays different information for a real person and for search engine spiders, your site is said to be cloaking. The cloaked pages are keyword-packed with the intention of displaying different information, which will make it get ranked highly. If you have a site and have included such manipulations, it is high time that you stop. Failure to do this will have your site banned by Google.
  • Duplicate websites and content: Creating content for websites is not an easy task. A site that has duplicate content is penalized by Google. You may have your site banned when someone copies your content, which was original. It is thus important to monitor your content and make sure that noother site is using them. This can be done by carrying out a Google search by using a few of your quotation marks around the content/ (“). If you find out that someone has copied your content; you will find it necessary to visit http://www.google.com/dmca.html where you’ll be able to learn more about infringement of copyrights. If your content has been copied without your knowledge, it may be necessary that you check http://www.copyscape.com.
  • Presence of hidden links or texts: There are many ways that you can have a text hidden. Some of the methods that are used are sneakier than others. When a link or a text is not visible to a human being but only to a , it is considered to be hidden. Texts can be hidden by using white and text colors on a white background or making use of cascading style sheets to hide the texts. When this is done, it’s just a matter of time, and you will have your site banned by Google.
  • Spamming or stuffing of keywords: Google allows up to a maximum of 5 percent of keyword density in the content that appears on your site. There are certain web pages that have been stuffed by keywords unnecessarily. It is important that you use your keywords the right way.
  • Buying links: Buying links will deal a huge blow to your Google rankings. It may not get your site banned, but you will drop down in your Google rankings. Your investment in getting links faster will be a waste. To move up the Google rankings, you may consider staying away from buying links.
  • Creating doorway redirects: Sites that have created sneaky redirects risk getting banned by Google. When its spiders locate such mistakes in your site, it will definitely get banned.

 

How to get back into Google rankings

 

Google states that site owners should not make use of sneaky redirects, hidden links or texts and also avoid loading your web pages with words that are irrelevant. Sending automated messages to Google from your website is not acceptable. Furthermore, doorway pages that have been created for the search engines and not for website users should not be part of your site.

 

To get back into the ranking list, you should ensure that you have checked your sites for the above ethical malpractices and make the necessary modifications. You will need to do this since, even if you resubmit the site for consideration, chances of being rejected are higher.

 

If you would like to resubmit your site for re-inclusion ion Google rankings, you will need to log into the Google’s Sitemaps which will take you to the bottom of your account page. You will see “Submit a re-inclusion request”. This will direct you to this link:https://www.google.com/webmasters/sitemaps/reinclusion?hl=en

 

What does this mean?

 

Well,you will have to register your website to be considered for reinclusion. After you’ve done this, you will check boxes that will not only you agree to being guilty of the mistakes you committed but also agree to making modifications also a box to promise that you will not commit the mistake again.

 

There is a box that will allow you to explain yourself. In this space, you will need to include everything that you believe will get your site ranked.

 

After you have gone through this procedure, Google will send its spiders to your site again to check if your site has been cleaned. It may take a few months to get indexed and during this waiting period, you should not tamper with your site not unless it is very necessary.

 

After you have done the above, it does not hurt sending Google an email. It is not necessary but it may help get things done faster.

 

Got comments? had similar experience? please comment and share your knowledge!
 
Contact me :
bhavinrana07[@]gmail.com


Categories: .htaccess, Androide developer, CakePHP, CakePHP Developer India, freelance developer, Freelance PHP Developer, Freelance PHP Programmer, Freelance Programmer India, freelance web, freelance web designer, get a freelancer, Google, Hire Dedicated Programmer, Hire Dedicated Programmer India, Hire PHP Developer India, Hire PHP Professional, Hire PHP Professional India, Hire PHP Programmer India, Hire Web developer, Hire Web Developer India, Indian Freelancer, iphone application developer, iphone developer, iphone website designer, JavaScript, joomla customization india, Joomla Developer, joomla developer india, jquery, mysql, oscommerce Customization, oscommerce developer, php, PHP Freelancer India, php freelancing india, php freelancing india mumbai, PHP programmer, Php programming, Programming Facts Blog, web developer ahemdabad india, web developer india, Web development India, Word Press Reserch, Wordpress Customization Services, Wordpress Developer, Wordpress Developer India, wordpress freelance developer, wordpress freelance programmer, wordpress freelancer, Wordpress Freelancer India, Wordpress Programmer, Wordpress Shopping Cart, Wordpress theme customization, wordpress theme integration Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Importance of PHP Development for Web development

September 16, 2011 Leave a comment
One of the biggest examples of technological advancements is the immense change in programming platforms. With a range of Application existing in the market for web application, PHP and Dot Net is considered as a leading and a highly accepted website development application technology. Basically PHP which is a scripting language which used to generate dynamic web pages which in turn bring interactivity with your users.  This language can also be written in HTML. But nowadays, PHP along with MY SQL is being used to construct some of the most powerful online databases.

Keeping in view the complex nature of PHP web development, hiring of highly skilled and experienced PHP developers becomes extremely crucial. Several benefits of hiring a PHP developer include reducing development cost since PHP also integrates with a number of open source applications like Joomla, Drupal, WordPress etc. Being an open source technology it allows the user to make use of all platforms like Apache, Solaris, windows, Linux and various other platforms in order to take advantage of the investments made.

When you hire PHP developer you should care to find if he or she knows how effectively the XML is supported with 5th version. Now XML files work unified way and the efficiency of processing data has become compatible with W3C school specification. With SimpleXML in support 5th version has made parsing RSS files, REST results too much easy.
Wordpress Developer India

However it is also very important to note that in order to use PHP in an efficient way PHP tools are required. PHP tools are divided into different categories depending upon their functionality. For e.g. Webgrind is a debugging tool whereas PHP/SWF Charts is an outstanding tool for image manipulation and graphs.

If you are getting a website developed and you are confused in selecting the right programming language, have a look at your compatibility level. Moreover, Simple test is a testing and optimization tool while PHPE clipse runs on probably all major operating systems like Windows, Linux etc. While FirePHP is a data entry tool which helps to enter data in Firebug, Phing is a tool which can be utilized to do file transformations, run PHP Unit file system and CVS/SVN operations. Apart from that, if you need to connect the website with an existing application which has been developed on DOT net then you should select the same programming platform for web development purposes.

How to get number of days between two dates using MySQL

While developing web application , in many many places we face the problem where we can use only MYSQL and get the number of number of days between two given dates using MySQL. Syntax – DATEDIFF(FirstDate,SecondDate) This function will calculate the difference bretween two dates and give the out put in number of days. It will give the result positive only if first date is grater than second date. If Second date is greater than First date than it will give the negative result.

Example: Query : SELECT DATEDIFF(‘2010-01-05’, ‘2009-12-15’); Result : 21 Query : SELECT DATEDIFF(‘2009-12-15’, ‘2010-01-05’); Result : -21 hope this will  help full for some. 😀 let me know if any solution require !
Categories: Androide developer, ASP, asp.net, CakePHP Developer India, Flash Designer, freelance developer, Freelance PHP Developer, Freelance PHP Programmer, Freelance Programmer India, freelance web, freelance web designer, Freelance web developer, get a freelancer, Graphic Designer, Hire Dedicated Programmer, Hire Dedicated Programmer India, Hire PHP Developer India, Hire PHP Professional, Hire PHP Professional India, Hire PHP Programmer India, Hire Web developer, Hire Web Developer India, India, india web development, Indian Freelancer, ipad, iphone application developer, iphone developer, iphone website designer, java, JavaScript, joomla, joomla customization india, Joomla Developer, joomla developer india, Media, mysql, oscommerce Customization, oscommerce developer, php, PHP Developer, PHP Developer India, PHP Development, PHP Freelance, PHP Freelancer, PHP Freelancer India, php freelancing india, php freelancing india mumbai, PHP programmer, PHP Programmer India, Php programming, PHP Web Development, php web programmer, Programming Facts Blog, reelance SEO and PPC Consultant, web design india, web designer, web designer india, Web Developement Company USA, web developer, web developer ahemdabad india, web developer india, Web development India, wordpress, Wordpress Blog Developer, Wordpress Customization Services, Wordpress Developer, Wordpress Developer India, wordpress freelance developer, wordpress freelance programmer, wordpress freelancer, Wordpress Freelancer India, Wordpress Programmer, Wordpress Shopping Cart, Wordpress theme customization, wordpress theme integration Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
%d bloggers like this: