Form Help

TOPIC:

using a different database for dropdown select list 5 months 4 weeks ago #274468

  • Topic Author
  • lesjar
  • Offline
  • Fresh Breezer
  • Fresh Breezer
  • Posts: 4
  • Thanks: 0
Firstly I am ok with the concept of doing this with the article crosstec.org/en/support/online-documenta...ct-list-from-db.html

However I want to use data from a table outside of the JOOMLA database , the database is on the same server , so I need to supply dbo user, password ,database etc to be able to do a select for records from a table . Anybody have a solution to add this into the example above and then I will be very happy .

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

using a different database for dropdown select list 5 months 3 weeks ago #274514

  • Mirec's Avatar
  • Mirec
  • Offline
  • Ultimate Breezer
  • Ultimate Breezer
  • Posts: 3265
  • Karma: 2
  • Thanks: 160
Hi,

FORM->Advanced->More Options->FORM PIECES-> Before Form Piece:
$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library
$db = JFactory::getDBO();//Get Database Object
  
//Create your own query here
$db->setQuery('Select username From #__users '); 
  
$result = $db->loadColumn(); //load the result from the query
$test = "";
for ($i = 0; $i < count($result); $i++)
{
     $test .= "0;".$result[$i].";".$result[$i]."\n";
}
 
function ff_setSelectList($name, $value)
{
     global $ff_processor;
     for ($r = 0; $r < $ff_processor->rowcount; $r++)
     {
          $row =& $ff_processor->rows[$r];
          if ($row->name==$name)
          $row->data2 = $value;
          unset($row);
     } // for
} // ff_setSelectList
 
ff_setSelectList('select1', $test);

In this part of code:
$db->setQuery('Select username From #__users '); 
instead of username put name of column from DB which you want to show, and #__users replace with name of wantend DB table.

Please try this solution if isn't work we will try another solution,
if you need an additional explanation with code, please let me know and I will help you


regards,
Mirko
The following user(s) said Thank You: lesjar

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

Last edit: Post by tihana.krivic.
  • Page:
  • 1
Moderators: ForumSupport
Time to create page: 0.043 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!