PHP Script plugin and custom fields.

The membership pro PHP Script plugin documentation states.

"In the PHP script, you can use a variable called $row. It contains all information of the subscription record. For example $row->first_name, $row->last_name, $row->email, $row->plan_id...."

Where can I find the available fields that are included in $row and how does it treat custom fields?

R

Hello Richard

1. If you want to see all the fields which you can access via $row object, you will need to look at #__osmembership_subscribers table. $row is basically, a record from that table

2. Unfortunately, right now, we don't have an easy API for accessing to custom fields data. You can try this code to see whether It works
After that code you can acccess to $data to get value of a custom field

Note that I just wrote that code quickly, haven't tested it myself yet

Regards,

Tuan

I am having trouble getting the proposed solution for custom fields to work.

I tried adding a use statement before it like:
I may need to define the namespace hierarchy as part of that statement but I am not sure how.

If that doesn't work is there perhaps another more explicit way of accessing that data?

Thanks,
Joseph

Hello

You should not have to use use OSMembershipHelper;

When you are using my code, exactly what's the error/problem you are having?

Please let me know so that I can understand and find a solution

Tuan

A flash error message populated on the following screen (subscription complete) that said the PHP is wrong and to contact the administrator. I am one of the administrators. The rest of the view was fine.

Before I had successfully triggered an email using the php plugin, but when I try to use your example code to pull a custom field to replace the to address it breaks. I believe the problem is that OSMembershipHelper is out of scope.

Hello

There was a small typo in the code. Please use this updated code, it should work well:

Regards,

Tuan

Thanks Tuan,

That was the issue.

It may be worth noting that I had to get the values from the keys using bracket syntax like this:

For some reason I originally expected this to work:
Maybe that will save someone some time in the future.

Best,
Joseph

Ah, Yes. $data is an array, so Yes, you will have to use bracket syntax to get value of certain custom fields

Tuan