RE: [PHP-WIN] Is this possible?

You could also, for #2, simply record the changes to the database and allow those commands to be recalled and reversed. So, say that someone queried: INSERT INTO table_name (a1, b2, c3, d4) VALUES (joe, john, judy, jackie); You could make an undo available as an include that can parse it as a regexp and see that INSERT needs to be DROP and the (a1, b2, c3, d4) and (joe, john, judy, jackie) need to be WHERE values, so it would parse it as: DROP FROM table_name WHERE a1="joe" AND b2="john" AND c3="judy" AND d4="jackie"; The best idea is to create an include file that can parse simple quireies and create opposite queries to go with them using some CASE statements probably. Hmmm, maybe this will be my next project. Hehehe! It could even go to the point of having a setup where it logs $client as $REMOTE_ADDR for internet or and internal user value for intranet stuff, so that they can back out as many commands as they need to. The nice thing is that you could back out accidental deletes the same way as long as the DROP query contained ALL of the data (the way phpMyAdmin does it). Perhaps the table could be accessed by an admin through a web interface even to backout as many items as may need be. Jesse Williams System Administrator DowNET VoIP Team Electronic Data Systems -----Original Message----- From: Michel Laine [mailto:michel@systemtech.se] Sent: Thursday, July 05, 2001 10:34 AM To: php-windows@lists.php.net Subject: [PHP-WIN] Is this possible? Using PHP 404pl1 / MySQL 3.23.35 / PWS / W98SE if anybody should need to know... The stuff is for an intranet application. 1: To execute php code when a A HREF link is clicked. I have the need to change a session variable depending on which link (of a couple) that is clicked. The link is supposed to call $PHP_SELF which then change its output depending on the value of the session variable. I know that i can solve it by letting the link call different php scripts - which update the session variable and then call back to the first page. If there is another way ( javascript maybe?), i am interested to know about it. 2: To have one undo step on a database update. Do anybody know / seen any example / tutorial on how this kind of function can be implemented? Let me know! I have read most of the stuff at Newbie network, PHPdeveloper, PHPeverywhere, Zend, Devshed, Webmonkey and PHPbuilder - but i have never come across anything like this. -- Michel Laine -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net