Category Archives: PHP & MySQL

MySQL field types cheat-sheet

logo-mysql

MySQL supports a number of column types, which may be grouped into three categories: numeric types, date and time types, and string (character) types. It’s sometimes hard to remember all the MySQL field type specifications, supportive number ranges and so on. This cheat sheet gives you all details needed, describes field type specifications. Continue

PHP Quick-Tip: rounding numbers

PHP ounding decimal numbers

In PHP rounding numbers is pretty easy and yet some newbies is having trouble with acquiring expected results… Continue

Bracketless VS traditional if-else statement

concatenating-php-strings

There is no secret that some developers are using traditional statements, some – bracket-less. But witch one is better to use?
I’ve dived directly into testing. Continue

Replacing text into clickable links

php-replacing-text-urls-into-clickable links

Ever wondered how these PHP magicians converts text urls into clickabe links? There are several ways to do this, but probably the best one to use is ereg_replace. Continue

Redirecting via PHP/HTML

redirecting-php_header_location-html

There is a lot ways to redirect your users e.g. from old domain to the new one or refresh site automatically when you are working on the design. I’ll review HTML, PHP and apache mod_rewrite ways to do this. Continue