Pull value list in custom field of article

  • Ralph.Buechle
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0

Ralph.Buechle created the topic: Pull value list in custom field of article

Hi I'd like to get the value from a custom field (list of dates) that belongs to the article, from where the form was being submitted.

I read through CAPTURE URL THE FORM WAS SUBMITTED FROM and AUTO-POPULATE A SELECT LIST FROM DATABASE TABLE. so somehow it should be possible, but I don't know too much about php coding.

I would need a code like:

$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library
$db = JFactory::getDBO();//Get Database Object

//Create your own query here
$db->setQuery('Select custom_field From article where id=1234 ');


so I would need to get 1234 from article before...

something like (?):

$page_id = $_SERVER["[color=red]page_id[/color]"];
$this->execPieceByName('ff_InitLib');
$db->setQuery('Select custom_field From article where id=page_id ');
$result = $db->loadColumn()


Can anyone help me on that?
#213591
  • Ralph.Buechle
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0

Ralph.Buechle replied the topic: Pull value list in custom field of article

I got this far now

$this->execPieceByName('ff_InitLib'); //Include BreezingForms Library

$articleID = htmlentities(JRequest::getVar('id'));
ff_setValue('articleID', $articleID);

$db = JFactory::getDBO();//Get Database Object

//Create your own query here
$db->setQuery('Select value From njaqd_fields_values where item_id=$articleID AND field_id=4 ');

$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);


My problem seems to be that:

$db->setQuery('Select value From njaqd_fields_values where item_id=$articleID AND field_id=4 ');


Has anyone input for that?
#213601
  • Ralph.Buechle
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 5
  • Thank you received: 0

Ralph.Buechle replied the topic: Pull value list in custom field of article

solved... not as hard, but not as easy
#213625
Moderators: ForumSupporttomeperica
Time to create page: 0.065 seconds

New Icon Packs Category!

Crosstec is now offering icon packs.

If you are a paying subscriber, icon packs are automatically added to your account.

Check out our icon packs page!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Summer Sale!

50% discount on all of our extension subscription plans, templates and icon packs!

Get Your Subscription Here

News and Updates

Get informed about new downloads, updates and more in our News and Updates newsletter.

All Extensions Subscription

Get 1 year access to all of our current and future products and 1 year of professional support -- 99 for just 49! (Summer Sale)

No support per domain or website installation limits! Includes all of our current and future Joomla!® extensions, Joomla!® templates for the duration of your membership. This means, by purchasing an All Extensions Subscription you'll have it all covered!

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!

Live Support Chat Opened!

Join our Discord chat here to receive live support and talk directly to the team!

Community Reward

Help us to create new extensions and plugins! With only $5 you help us a lot and get unlimited download access to all of our products, professional support and even more. Get your reward now!

Read More Here