From 40940b95aaefd87f9af96439669cc6cb184d69ef Mon Sep 17 00:00:00 2001 From: Christophe Nowicki Date: Thu, 16 Sep 2004 15:57:55 +0000 Subject: New logging system with a web interface. --- php/Attic/examples/sample-idp/user_add.php | 30 ++++++++++++++++++++++-------- 1 file changed, 22 insertions(+), 8 deletions(-) (limited to 'php/Attic/examples/sample-idp/user_add.php') diff --git a/php/Attic/examples/sample-idp/user_add.php b/php/Attic/examples/sample-idp/user_add.php index c763d3de..014677b1 100644 --- a/php/Attic/examples/sample-idp/user_add.php +++ b/php/Attic/examples/sample-idp/user_add.php @@ -1,6 +1,6 @@ addElement('header', null, 'Add New User'); @@ -37,18 +49,20 @@ if ($form->validate()) { - $config = unserialize(file_get_contents('config.inc')); - $db = &DB::connect($config['dsn']); - if (DB::isError($db)) - die($db->getMessage()); - - $query = "INSERT INTO users (user_id, username, password) VALUES(nextval('user_id_seq'),'"; - $query .= $form->exportValue('username') . "','" . $form->exportValue('password') . "')"; + $query = "INSERT INTO users (user_id, username, password) VALUES(nextval('user_id_seq'),"; + $query .= $db->quoteSmart($form->exportValue('username')) . ","; + $query .= $db->quoteSmart($form->exportValue('password')) . ")"; $res =& $db->query($query); if (DB::isError($res)) + { + $logger->log("DB Error :" . $db->getMessage(), PEAR_LOG_ERR); + $logger->log("DB Error :" . $db->getDebugInfo(), PEAR_LOG_DEBUG); die("username exist!"); + } + + $logger->log("Create User '" . $form->exportValue('username') . "'", PEAR_LOG_NOTICE); $db->disconnect(); ?>