Posts Tagged with "tips"

How to update fields from another table in MySQL

Posted by Stanislav Furman on May 28, 2014

This article is to continue the series of short handy MySQL tips that I started a while ago. 

If you need to update a number of column fields in a MySQL table with data from another table, there is a simple way to do it. Lets say you need to update user phone numbers in table1 with the corresponding phone numbers from table2. Then you could run the following query.

Continue reading

Important things you must know before register a domain name

Posted by Stanislav Furman on May 16, 2014

Important things to know before buy a domain name

Most of web developers from time to time buy domain names. But not all web developers know what can be behind that process and what unexpected problems may appear suddenly.

There is plenty of domain name registars like Go Daddy, Enom, 1nd1, etc. Each registar has its pros and cons. Sometimes a domain owner can face a very sudden problem. Unfortunately, this "problem" could have been known if domain buyers read Terms and Conditions carefully before they buy domains. Registars have a lot little "surprises" buried in the fine print of a registrars' "Terms of Service".

I heard a story from one of my collegues that a registar requested a 200$ fee to unblock my collegue's domain name after it was blocked based on a anonymous request! The registar didn't even try to contact the domain owner and understand the nature of the problem. They simply said "Pay us money!". It looks like a virtual extortion.

Continue reading

Unix shell commands to detect a DDoS attack and its source

Posted by Stanislav Furman on April 25, 2014
5 Unix shell commands to check if your server is under DDoS attack and its source

How to secure your php application

Posted by Stanislav Furman on February 21, 2012

Working on web projects you should consider most common dangers such as XSS ("Cross Site Scripting"), SQL Injection, Session Hijacking, Spoofed Form Submissions, etc. This little guide will help you to understand basics of web security and it will help you to protect your web applications against possible attacks.

Remember that security must be balanced with expense. Don't use paranoidal security approaches if it is not really needed.

Please note that this post covers only basic security approach which is quite enough for most of web sites but not enough for large, e-commerce projects. However, listed measures are fundamental for all types of web applications.

Continue reading

Another 12 SEO tips that everyone should know

Posted by Stanislav Furman on February 17, 2012

I have already posted a post with some SEO optimization tips. Let's continue this topic.

1. Try to put your keywords and key phrases closer to the beginning (top) of the page.

2. Use sitemap.xml to give search engines more information about the structure of your web site and pages.

3. Use mod_rewrite to build user-friendly URLs. www.yourdomain.com/cars/toyota/corolla looks better much than www.yourdomain.com/index.php?cat=cars&make=toyota&model=corolla. 

Continue reading

12 SEO tips that everyone should know

Posted by Stanislav Furman on February 10, 2012

1. The first thing that you have to know - content is your number one and it's your primary priority. Therefore, make sure that you publish good, clear and unique content that is based and focused on your target keywords.

2. Quality backlinks is your number two. Buliding of a network of backlinks is a very important thing in terms of Search Engine Optimization. Make sure backlinks contain your keywords or key phrases between the tags.

3. Remember that one single link from a good site can beat 10 links from other 10 web sites with poorer quality.

Continue reading