Code: Select all
// connect to database as administrator
$conn = dbConnect('admin');
// check for duplicate username
$checkDuplicate = "SELECT donkey FROM donkeys WHERE email = '$email'";
$result = $conn->query($checkDuplicate) or die(mysqli_error($conn));
$numRows = $result->num_rows;
// if $numRows is positive, the username is already in use
if ($numRows) {
$message[] = "$email is already in use. Please choose another username.";
}
// otherwise, it's OK to insert the details into the database
else {
// add an encryption key
$key = 'key';
// insert details into database
$insert = "INSERT INTO donkeys (donkey, lastName, firstName, email, passWord, phone) VALUES ('', '$lastName', '$firstName', '$email', '$passWord', AES_ENCRYPT('$passWord', '$key'), '$phone')";
// execute the query
$result = $conn->query($insert) or die(mysqli_error($conn));
if ($result) {
$message[] = "Account created for $email.";
}
else {
$message[] = "There was a problem creating an account for $email.";
}
}
}Code: Select all
CREATE TABLE IF NOT EXISTS `donkeys` (
`donkey` int(3) unsigned NOT NULL auto_increment,
`lastName` varchar(24) NOT NULL,
`firstName` varchar(24) NOT NULL,
`email` varchar(36) NOT NULL,
`passWord` varchar(12) NOT NULL,
`phone` varchar(12) default NULL,
PRIMARY KEY (`donkey`),
UNIQUE KEY `email` (`email`),
KEY `lastName` (`lastName`,`firstName`,`email`)
)Thanks for any help...