Archive for the 'Code Bank' Category



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:

Create a valid CSS alert/noscript message

If used properly, alert messages guide a user to make the proper descicions on your site. Let it be the purchasing of a product or the task of enabling Javascript for full functionality. The problem is that most "styled" messages cause validation errors. Alert Message

Form Field Hints with CSS and JS

Form Tooltips Using CSS and JS