TOPIC:

Display data from database giving id. 1 week 4 days ago #252426

  • Topic Author
  • vagabe
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 15
  • Thanks: 0
Hello
Do you have any example where i give the id then the BF search it in database and display data. Before it registry was add.

Thanks

Please Log in or Create an account to join the conversation.

Display data from database giving id. 1 week 4 days ago #252441

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 2935
  • Karma: 3
  • Thanks: 255
Hi,

basically, the database is structured so that #__facileforms_records holds a line for each record that was made and #__facileforms_subrecords has a line for each element from the forms.

E.g. you can assign value from database to textfield
In this topic is example:
crosstec.org/en/forums/1-forums/91076-as...ext-field.html#91076

Let me know if you need more help

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Display data from database giving id. 1 week 3 days ago #252493

  • Topic Author
  • vagabe
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 15
  • Thanks: 0
unfortunately it is an example for joomla.

I cant do it in wordpress.

Please Log in or Create an account to join the conversation.

Display data from database giving id. 1 week 3 days ago #252512

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 2935
  • Karma: 3
  • Thanks: 255
Hi,

this you can do in wordpress too.
The only difference is name of DBtable for wordpress.

Go to your form->Advanced->More options->Form pieces->Before form->check custom and put this (the code from link from message above):
$this->execPieceByName('ff_InitLib');
$record_id= JRequest::getVar('record_id');

global $database, $record;
$database->setQuery("SELECT * FROM wp_facileforms_subrecords WHERE record = '$record_id'");
$row = $database->loadObjectList();
$record = $row[0];
ff_setValue('ElementName', $record->value);

Please find database for wordpress in phpmyadmin and check if your name for this table is: wp_facileforms_subrecords

Also, please replace ElementName with name of your element in which you want show this (not title)

Let me know if you need more help

Regards,
Tihana

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.047 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!