I wanted a simple method to allow user registration in order to advise of program updates. I created this plugin in WordPress to make a registration table and I have detailed below the VBA code used from the access database to send the registration details to the WordPress.
User Registration
When the user clicks register the system will try and load the user registration page passing the details as parameters in the URL. If the user hasn’t already registered the details are then added to the WordPress database which is available in the admin module.
Function Register()
On Error Resume Next ' IF THE USER ISNT CONNECTED TO THE WEB JUST IGNORE THIS
'User Registration anything access
DoCmd.Hourglass True
Dim http As Object
Dim url As String
Dim response As String
' Specify the URL you want to call
url = "https://yourdomain.com/registration/?User=" & Me.txtName & "&email_add=" & Nz(Me.txtEmail, "no Email") & "&contact_no=" & Nz(Me.txtContact, "No Phone") & "&web_add=" & Nz(Me.txtWeb, "no Web")
' Create the XMLHTTP object
Set http = CreateObject("MSXML2.XMLHTTP")
' Open a GET request
http.Open "GET", url, False
' Send the request
http.Send
' Capture the response (optional)
response = http.responseText
' Log the response to the Immediate Window (Debug Window)
Debug.Print response
' Clean up
Set http = Nothing
DoCmd.Hourglass False
End Function
In WordPress in the admin panel you will see user registration and can edit or delete entries as required.
I used ChatGPT to generate the code for the plugin and went through a number of iterations to get it implemented as required.
<?php
/**
* Plugin Name: User Registration
* Description: A plugin to check a for USer Registration using WP and VBA
* Version: 1.0
* Author: Anything Access
* Author URI: https://AnythingAccess.com
*/
// Prevent direct access
if (!defined('ABSPATH')) {
exit;
}
// Add admin functionality only if in admin area
if (is_admin()) {
add_action('admin_menu', 'software_registration_admin_menu');
add_action('admin_post_update_software_registration', 'update_software_registration');
}
/**
* Add the admin menu.
*/
function software_registration_admin_menu() {
add_menu_page(
'Software Registrations', // Page title
'Registrations', // Menu title
'manage_options', // Capability
'software-registrations', // Menu slug
'software_registration_admin_page', // Callback
'dashicons-database', // Icon
20 // Position
);
}
/**
* Display the admin page.
*/
function software_registration_admin_page() {
global $wpdb;
$table_name = $wpdb->prefix . 'software_registration';
if (isset($_GET['action'])) {
if ($_GET['action'] == 'edit' && isset($_GET['id'])) {
$id = intval($_GET['id']);
$entry = $wpdb->get_row($wpdb->prepare("SELECT * FROM $table_name WHERE id = %d", $id));
if ($entry) {
echo '<div class="wrap">';
echo '<h1>Edit Registration</h1>';
echo '<form method="post" action="' . admin_url('admin-post.php') . '">';
echo '<input type="hidden" name="action" value="update_software_registration">';
echo '<input type="hidden" name="id" value="' . esc_attr($entry->id) . '">';
echo '<table class="form-table">';
echo '<tr><th><label for="user_name">User Name</label></th>';
echo '<td><input type="text" name="user_name" id="user_name" value="' . esc_attr($entry->user_name) . '" class="regular-text"></td></tr>';
echo '<tr><th><label for="email_add">Email Address</label></th>';
echo '<td><input type="email" name="email_add" id="email_add" value="' . esc_attr($entry->email_add) . '" class="regular-text"></td></tr>';
echo '<tr><th><label for="contact_no">Contact Number</label></th>';
echo '<td><input type="text" name="contact_no" id="contact_no" value="' . esc_attr($entry->contact_no) . '" class="regular-text"></td></tr>';
echo '<tr><th><label for="web_add">Website Address</label></th>';
echo '<td><input type="url" name="web_add" id="web_add" value="' . esc_attr($entry->web_add) . '" class="regular-text"></td></tr>';
echo '</table>';
echo '<p><input type="submit" class="button-primary" value="Save Changes"></p>';
echo '</form></div>';
} else {
echo '<div class="error"><p>Entry not found.</p></div>';
}
return;
} elseif ($_GET['action'] == 'delete' && isset($_GET['id'])) {
$id = intval($_GET['id']);
$wpdb->delete($table_name, ['id' => $id], ['%d']);
echo '<div class="updated"><p>Entry deleted successfully.</p></div>';
}
}
$entries = $wpdb->get_results("SELECT * FROM $table_name ORDER BY created_at DESC");
echo '<div class="wrap">';
echo '<h1>Software Registrations</h1>';
echo '<table class="wp-list-table widefat fixed striped">';
echo '<thead><tr>';
echo '<th>ID</th><th>User Name</th><th>Email</th><th>Contact No</th><th>Website</th><th>Created At</th><th>Actions</th>';
echo '</tr></thead><tbody>';
foreach ($entries as $entry) {
echo '<tr>';
echo '<td>' . esc_html($entry->id) . '</td>';
echo '<td>' . esc_html($entry->user_name) . '</td>';
echo '<td>' . esc_html($entry->email_add) . '</td>';
echo '<td>' . esc_html($entry->contact_no) . '</td>';
echo '<td>' . esc_html($entry->web_add) . '</td>';
echo '<td>' . esc_html($entry->created_at) . '</td>';
echo '<td>';
echo '<a href="' . admin_url('admin.php?page=software-registrations&action=edit&id=' . esc_attr($entry->id)) . '">Edit</a> | ';
echo '<a href="' . admin_url('admin.php?page=software-registrations&action=delete&id=' . esc_attr($entry->id)) . '" onclick="return confirm(\'Are you sure you want to delete this entry?\');">Delete</a>';
echo '</td></tr>';
}
echo '</tbody></table></div>';
}
/**
* Handle form submissions for updates.
*/
function update_software_registration() {
global $wpdb;
if (isset($_POST['id'], $_POST['user_name'], $_POST['email_add'], $_POST['contact_no'], $_POST['web_add'])) {
$id = intval($_POST['id']);
$user_name = sanitize_text_field($_POST['user_name']);
$email_add = sanitize_email($_POST['email_add']);
$contact_no = sanitize_text_field($_POST['contact_no']);
$web_add = esc_url_raw($_POST['web_add']);
$table_name = $wpdb->prefix . 'software_registration';
$wpdb->update(
$table_name,
[
'user_name' => $user_name,
'email_add' => $email_add,
'contact_no' => $contact_no,
'web_add' => $web_add,
],
['id' => $id],
['%s', '%s', '%s', '%s'],
['%d']
);
}
wp_redirect(admin_url('admin.php?page=software-registrations'));
exit;
}
/**
* Add shortcode for front-end use.
*/
add_shortcode('software_registration', 'software_registration_frontend');
function software_registration_frontend() {
global $wpdb;
$user = isset($_GET['User']) ? sanitize_text_field($_GET['User']) : null;
$email_add = isset($_GET['email_add']) ? sanitize_email($_GET['email_add']) : null;
$contact_no = isset($_GET['contact_no']) ? sanitize_text_field($_GET['contact_no']) : null;
$web_add = isset($_GET['web_add']) ? esc_url_raw($_GET['web_add']) : null;
$output = '';
if ($user) {
$table_name = $wpdb->prefix . 'software_registration';
$existing_entry = $wpdb->get_row($wpdb->prepare(
"SELECT * FROM $table_name WHERE user_name = %s",
$user
));
if ($existing_entry) {
$output .= '<p>User already exists in the database.</p>';
} else {
if ($email_add && $contact_no && $web_add) {
$wpdb->insert(
$table_name,
['user_name' => $user, 'email_add' => $email_add, 'contact_no' => $contact_no, 'web_add' => $web_add, 'created_at' => current_time('mysql')],
['%s', '%s', '%s', '%s', '%s']
);
$output .= '<p>New user data inserted into the database.</p>';
} else {
$output .= '<p>Insufficient parameters to insert data.</p>';
}
}
} else {
$output .= '<p>No User parameter provided.</p>';
}
return $output;
}
You can review the sample application for offline lotto to see how this was implemented.
Other wordpress plugin posts on this site
You could enhance this by adding some application protection if its a licensed product