Archive for June, 2007

MOD_REWRITE tips and tricks

Before you begin to use mod_rewrite (RewriteRule, RewriteBase, and RewriteCond) code, keep in mind that each rule applied is executed on each and every HTTP request that accesses a file in or below the directory where the code resides.

The best way to support Transparent PNG in IE6

There are many way to support transparent .png images in IE browsers. However, this method seems the simplest and most “transparent to work with. It uses CSS compliant JavaScript .htc files and can be easily called thought the

behavior: url(iepngfix.htc);

How to implement:

Rasterize and Flatten Layer Effects

A tip so you can apply filters to layers with effects

If you apply layer style effects to text or shapes and then rasterize the layer, only the text or shape content is rasterized. The layer effects stay separate and editable. Usually, this is a good thing, but if you then apply a filter, it only gets applied to the text or shape and not the effects. To rasterize and flatten the entire layer contents, create a new, empty layer below the layer with your effects and merge down (Ctrl+E on Windows/Command+E on Mac).

Setting up .htaccess and .htpasswd (Godaddy Hosted)

A Simple approach for a password protect folder called /private

Open notepad and start typing… (When ready to save make sure the ext .txt is not there) 

File: .htaccess

AuthUserFile /home/content/u/s/e/username/html/private/.htpasswd

AuthGroupFile /dev/null
AuthName "Secure Directory"
AuthType Basic

<limit GET POST>
require valid-user
</limit>

 

Using Stored Procedures (MySql and PHP) in 3 Steps

1. Create the database and table (test | user)

2. Create the procedure. “new_proc” (I used EMS SQL Manager 2005)

CREATE PROCEDURE `new_proc`()
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY INVOKER
    COMMENT ''
SELECT * FROM `user`; 

3. Setup your PHP code as follows:

Designing For 2 Or More Screen Sizes.

Web design theory calls for a website to appear seamless to every user. The problem, of course, is that every user’s different.

Tackling website dimensions has been a rather simple decision. You can decide to design a static template and then choose one of the typical dimensions: 640 x 480, 800 x 600 or 1024 x 768.