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">