public function registerInterest($data, $connect)
{
$db = new db_config();
$dbCheck = new db_config();
$email_data = $data['@email'];
$sqlCheck = $dbCheck->mquery("SELECT * FROM register_interest WHERE email = '" . $email_data . "'", $connect);
$num = $dbCheck->numhasrows($sqlCheck);
$row = $dbCheck->fetchobject($sqlCheck);
if ($num == 0) {
$sql = $db->mquery_insert("dbo.registerInterest", $data, $connect);
header("location: confirmation?register_success=true");
} else {
$sql = $db->mquery_insert("dbo.registerInterest", $data, $connect);
header("location: confirmation?register_success=true");
//note: for the meantime duplicates are okay
//header ("location: index.php?emailcheck=true");
}
}
include 'protected/library/validation_library.php';
include 'protected/models/users.php';
$db = new db_config();
$formelem = new FormElem();
$UsersModel = new UsersModel();
$connect = $db->connect();
$brand_name = $_SESSION['brand_name'];
if (isset($_POST['btn-create'])) {
$data['email'] = $_POST['email'];
$data['username'] = $_POST['username'];
$data['brand_name'] = $_POST['brandname'];
$data['password'] = $_POST['password'];
$data['backup_password'] = $_POST['password'];
$data['is_admin'] = $_POST['isAdmin'];
$data['date_created'] = date("Y-m-d H:i:s");
$db->mquery_insert("tbl_users", $data, $connect);
}
if (isset($_POST['update-record'])) {
$id = $_POST['id'];
$email = $_POST['email'];
$username = $_POST['username'];
$brandname = $_POST['brandname'];
$is_admin = $_POST['isadmin'];
$user_item_update_sql = "UPDATE tbl_users SET id = '" . $id . "', email = '" . $email . "', username = '******', brand_name = '" . $brandname . "' WHERE id = '" . $id . "'";
$user_item_update = mysqli_query($connect, $user_item_update_sql) or die(mysqli_error($connect));
header('location: /user.php?record_updated=true');
}
?>
<!DOCTYPE html>
<html lang="en">
