oh sorry.....no problem.
//config.inc.php
<?php
$host = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'userreg';
$table = 'user_auth';
$db = mysql_connect('localhost','root','') or die("error=could not connect to $host");
$db = mysql_select_db('userreg');
if ($db)
{
echo "database connected";
}
if(!$db)
{
print "error=could not connect to $dbname table";
}
?>
//user_auth.php
<?php
error_reporting(E_ALL);
require_once('conf.inc.php');
require_once('function.php');
// --------------------
// registering new user
// --------------------
function register($username,$pass,$email,$question,$answer)
{
$username = trim($username);
$pass = trim($pass);
$email = trim($email);
$question = addslashes(trim($question));
$answer = addslashes(trim($answer));
$validEmail = valid_email($email);
$validName = valid_userName($username);
$validPass = valid_password($pass);
if(!$validName) return "error=invalid name";
if(!$validPass) return "error=invalid password";
if(!$validEmail) return "error=invalid email";
$pass = md5(trim($pass));
// all checks ok
$query = @mysql_query("INSERT INTO user_auth (userName,userPassword,userMail,userQuestion,userAnswer) VALUES "
."('$username','$pass','$email','$question','$answer')");
if(!$query)
{
return "error=" . mysql_error();
} else {
return "user=ok";
}
}
my database is called userreg.
CREATE TABLE user_auth (
userID int(20) unsigned NOT NULL auto_increment,
userName varchar(15) NOT NULL default '0',
userPassword varchar(32) NOT NULL default '0',
userMail varchar(255) NOT NULL default '',
userQuestion varchar(255) NOT NULL default '',
userAnswer varchar(255) NOT NULL default '',
PRIMARY KEY (userID),
UNIQUE KEY userMail(userMail),
UNIQUE KEY userName(userName)
) TYPE=MyISAM;
