Waiting on Responce

I wasn’t able to accomplish what I wanted without writing my own PHP code.

I used PHP code to connect the the RM mySQL DB tables.

Here’s a snippet

<p style=”margin: 0in; font-family: Calibri; font-size: 11.0pt;”>[RM_Login]</p>
<?php
$con = mysqli_connect(‘www.xyz.com’, ‘fitnevq7_a8e’, ‘0700DFBc45p73h’, ‘fitnevq7_a8e’);
// Check connection
if ($con->connect_error) {
die(“Connection failed: ” . $con->connect_error);
}
$sql = “SELECT submission_id FROM a8e_rm_submission_fields”;
$result = $con->query($sql);
//simce the Registration Magic User registrations are in special RM tables we need to
//do special PHP scripting to get the user field we want
//This is the beginning of that scripting
$items = array();
$count = 0;

$previousnum=$result->fetch_assoc();

while ($row = $result->fetch_assoc()){
//This gets all unique submission IDs. Which is the number in the RM submission fiels DB
if ($row != $previousnum) {
$count++;
$items[$count] = ($row[‘submission_id’]);
}
$previousnum = $row;
}

$subids = array_unique($items);

$lastSubID=$subids[$count];
//echo “lastsubid = $lastSubID”;
$sql = “SELECT * FROM a8e_rm_submission_fields WHERE submission_id=$lastSubID”;
$result = $con->query($sql);

while ($row = $result->fetch_assoc()){

if ($row[‘field_id’] == 50) {
$clientUsername = $row[‘value’] ;
}

Thank you, I will pass this on to the developer that is working on this. I’m sure he will be able to know what this does.

Thanks again!

The person in support who replied to me basically said those tables are not meant to be accessed.

I might not understand what you want exactly, but can’t you just use a simple $_POST to get the info from the fields and store it in your database somewhere?

Hi,

Thank you for contacting us.

As per support ticket, we are replying here as well. To get the issue resolved, you can use following code:

$view_data->user = $service->get_user_by(‘id’, $request->req[‘user_id’]);

to resolve it.

Let us know if you have any other questions.