IE 8 CSS Hack

April 9th, 2009

In some cases, IE8 still can’t render CSS correctly. This is the magic trick to target only IE 8 .

.selector { property /*\**/: value\9 }

ex:
.myText { color /*\**/: #cc0000\9 }

CSS , ,

Modify Foreign Key

April 6th, 2009

To modify a Foreign Key in MySQL follow this steps :
1) Show table to see what is the name of Foreign Key we want to delete

SHOW CREATE TABLE table

2) Delete the Foreign Key

ALTER TABLE table DROP FOREIGN KEY table_ibfk_x

3) Create the new Foreign Key

ALTER TABLE table ADD CONSTRAINT `table_ibfk_x` FOREIGN KEY (`Field_id`) REFERENCES `references_table` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION

MySQL ,

phpMyAdmin

March 13th, 2009

In config file ( config.inc.php) you can’t set $cfg['Servers'][$i]['only_db'] = ‘my_db . It will return NO DATABASES FOUND

$cfg['Servers'][$i]['only_db']

If set to a (an array of) database name(s), only this (these) database(s) will be shown to the user. Since phpMyAdmin 2.2.1, this/these database(s) name(s) may contain MySQL wildcards characters (“_” and “%”). If you want to use literal instances of these characters, escape them .

use 'my\_db' and not 'my_db'


MySQL, PHP

Removing Dotted Links

March 1st, 2009

If you don’t like the dotted outline that appears around every link (see image bellow) you can use  this CSS trick :

outline: none;

dottedlinks

Example :

a {
  outline: none;
}


Later edit : You must add the pseudo class of :focus to work on all IE versions.
(thanks to Eric Hoffman )

CSS ,

Design for Browser Size Not Screen Size

March 1st, 2009

People working professionally with web know the difference between screen size and browser content area, but to make it clear I wanted to illustrate that screen size is irrelevant in comparison to other more important metrics.

You can find more information about screen resolution and page layout here

web design , ,