Pastable version of User Registration Function

<pre class='prettyprint' language='php'>&lt;?php

public static function addUser($username, $email, $password)
{
	try
	{
		$db = Database::getInstance();

$sql = sprintf(&quot;INSERT INTO `users` (`name`, `email`, `password`, `date`, `role_id`, `active`, `new`)
			VALUES ('%s', '%s', '%s', NOW(), %d, %d, %d)&quot;, $db-&gt;real_escape_string($username), $db-&gt;real_escape_string($email), md5($password), _ROLE_USER, 0, 1);
		$resultset = $db-&gt;query($sql);

if (!$resultset) // Database error
		{
			throw new Exception(i18n::t(&quot;MySQL error&quot;).&quot;: &quot;.$db-&gt;error, _EXCEPTION_ERROR);
		}
		else
		{
			return true;
		}
	}
	catch (Exception $e)
	{
		Messages::registerMessage($e-&gt;getMessage(), $e-&gt;getCode());
		return false;
	}
}

?&gt;</pre>
<a href="http://www.refactormycode.com/codes/966-user-registration-function" style="color:#fff" title="As seen on RefactorMyCode.com"><img alt="Small_logo" src="http://www.refactormycode.com/images/small_logo.gif" style="border:0" /></a>

Refactor :my => 'code'

Recent

Popular

Pastable version of User Registration Function