1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| <html>
<?php include("connexionbdd.php");
$sql1="CREATE TRIGGER users_bu BEFORE UPDATE
ON users
FOR EACH ROW
BEGIN
-- mise à jour des informations courantes dans la table users
-- par modification de la ligne en cours (variable NEW)
SET NEW.user_lastmod_dt = NOW();
SET NEW.user_lastmod_db_user = CURRENT_USER;
SET NEW.user_lastmod_user_id = @current_user_id";
$res=mysql_query($sql11) or die ("Erreur de blabla : ".mysql_error());
$sql12="INSERT INTO users_history (
user_id,
user_lastmod_dt,
user_name,
user_level,
user_comment,
user_lastmod_db_user,
user_lastmod_user_id)
VALUES (
OLD.user_id,
OLD.user_lastmod_dt,
OLD.user_name,
OLD.user_level,
OLD.user_comment,
OLD.user_lastmod_db_user,
OLD.user_lastmod_user_id
);
END";
$res1=mysql_query($sql12) or die ("Erreur de blabla : ".mysql_error());
$sql14="SET @current_user_id = 1"; $res3=mysql_query($sql14) or die ("Erreur de blabla : ".mysql_error());
$sql13="INSERT INTO users (user_name, user_level) VALUES ('Admin',2)"; $res13=mysql_query($sql13) or die ("Erreur de blabla : ".mysql_error());
$sql15="SET @current_user_id = 2"; $res15=mysql_query($sql15) or die ("Erreur de blabla : ".mysql_error());
$sql16="UPDATE users SET user_level = 1, user_comment = 'Pistonné' WHERE user_id = 3"; $res16=mysql_query($sql16) or die ("Erreur de blabla : ".mysql_error());
?> |
Partager