Forgot your password? Forgot your username? Create an account

 
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Get values from 'message' field in jos_aicontactsafe_messages table

Get values from 'message' field in jos_aicontactsafe_messages table 1 year 10 months ago #12651

Hi Alex, hope things are well with you.
A quick question:
I'm trying to extract some specific values (from custom fields) values from the aicontactsafe_messages table to display on another page and am having trouble because the 'message' field in the database only holds a formatted table. Is there somewhere I can either a) send these particular values to my own table so I can manage using regular php or b) is there a way to walk through your table and extract the values I need?
I have looked at scraping the html using the DOM (kore-nordmann.de/blog/0081_parse_html_ex..._data_from_html.html) but am sure there's an easier way to get the values.
Ideally, I'd prefer to push the values directly into my own database table on submission of the form.
I can modify the plugin/module as necessary, but can't seem to find where to do this.
The dev site is at
ads-local.jrdesign.com.au and the form I'm trying to get is the ONLINE ENTRY page
This is extremely urgent!!
Cheers
JR
The administrator has disabled public write access.

Get values from 'message' field in jos_aicontactsafe_messages table 1 year 10 months ago #12652

  • Alex
  • Alex's Avatar
  • OFFLINE
  • Administrator
  • Posts: 7887
  • Thank you received: 258
  • Karma: 60
Hi,

If you activate "Record the fields of the message separately in the database" in the profile you will have the fields values in the table "jos_aicontactsafe_fieldvalues".
The administrator has disabled public write access.

Get values from 'message' field in jos_aicontactsafe_messages table 1 year 10 months ago #12653

Thanks Alex, and apologies once again for double-posting.
I'll query the fieldvalues table instead.
Cheers - thanks for the lightning-fast response!
The administrator has disabled public write access.

Get values from 'message' field in jos_aicontactsafe_messages table 1 year 10 months ago #12654

  • Alex
  • Alex's Avatar
  • OFFLINE
  • Administrator
  • Posts: 7887
  • Thank you received: 258
  • Karma: 60
Glad I could help. :)
The administrator has disabled public write access.
  • Page:
  • 1