SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:29 AM
| ||||
| ||||
 help: store php session variable in mysql trigger... dear all, i'm newbie using trigger, but i need to create trigger to help me audit a table. i'm using mysql 5 in xampp. i need to store php session data in log table. i have try to define it when create trigger. this is my code: ==== DELIMITER $$ DROP TRIGGER /*!50033 IF EXISTS */ `sample_audit`$$ CREATE TRIGGER `sample_audit` BEFORE UPDATE on `sampel_name` FOR EACH ROW BEGIN DECLARE mychanged INT DEFAULT 0; IF NEW.name != OLD.name THEN INSERT INTO sampel_name_audit SET fld_name = 'name', chg_by = '$_session[user_email]', /* just what i want to store */ chg_ip = '$_server[remote_addr]', /* just what i want to store */ oldval = OLD.name, newval = NEW.name; END IF; END$$ DELIMITER ; ==== the problem is, when i see the log table, column chg_by and ch_ip still empty. it doesn't filled by $_session[user_email] nor ip. how to make it? thanks. rm      |
 |
« Is there a quick way to copy database information?
|
Counting number of associated many-to-many items »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 07:54 AM.
