Hallo,
wie kan mij helpen met het php script om de data van formulieren (#__facileforms_subrecords) zichtbaar te maken met een php querie (Flexi Custom Code)?
Op dit moment heb ik onderstaande code:
Code:
<?php
$db = JFactory::getDBO();
$query = "SELECT * FROM #__facileforms_subrecords";
$db->setQuery($query);
$result = $db->loadObjectList();
print_r($result);
?>
Na uitvoeren ontvang ik onderstaande resultaat op het scherm:
Code:
stdClass Object ( [id] => 501 [record] => 152 [element] => 82 [title] => Activiteit [name] => actnaam [type] => Select List [value] => Eifelhike 2018 [storage_id] => 3 [user_id] => 0 [created] => 2018-06-19 18:32:49 [created_by] => [modified_user_id] => 0 [modified] => 0000-00-00 00:00:00 [modified_by] => ) [498] => stdClass Object ( [id] => 502 [record] => 152 [element] => 72 [title] => Voornaam [name] => vnaam [type] => Text [value] => Jan [storage_id] => 3 [user_id] => 0 [created] => 2018-06-19 18:32:49 [created_by] => [modified_user_id] => 0 [modified] => 0000-00-00 00:00:00 [modified_by] => ) [499] => stdClass Object ( [id] => 503 [record] => 152 [element] => 73 [title] => Achternaam [name] => anaam [type] => Text [value] => Aarts [storage_id] => 3 [user_id] => 0 [created] => 2018-06-19 18:32:49 [created_by] => [modified_user_id] => 0 [modified] => 0000-00-00 00:00:00 [modified_by] => ) [500] => stdClass Object ( [id] => 504 [record] => 152 [element] => 74 [title] => Emailadres [name] => email [type] => Text [value] => sjeng@lijbrandt.nl [storage_id] => 3 [user_id] => 0 [created] => 2018-06-19 18:32:49 [created_by] => [modified_user_id] => 0 [modified] => 0000-00-00 00:00:00 [modified_by] => ) [501] => stdClass Object ( [id] => 505 [record] => 152 [element] => 75 [title] => Telefoonnr [name] => telnr [type] => Text [value] => 06-29032810 [storage_id] => 3 [user_id] => 0 [created] => 2018-06-19 18:32:49 [created_by] => [modified_user_id] => 0 [modified] => 0000-00-00 00:00:00 [modified_by] => ) [502] => stdClass Object ( [id] => 506 [record] => 152 [element] => 76 [title] => Speltak [name] => speltakkeuze [type] => Select List [value] => Explorers [storage_id] => 3 [user_id] => 0 [created] => 2018-06-19 18:32:49 [created_by] => [modified_user_id] => 0 [modified] => 0000-00-00 00:00:00 [modified_by] => ) [503] => stdClass Object ( [id] => 507 [record] => 152 [element] => 77 [title] => Akkoord [name] => okmetinschr [type] => Checkbox [value] => checked [storage_id] => 3 [user_id] => 0 [created] => 2018-06-19 18:32:49 [created_by] => [modified_user_id] => 0 [modified] => 0000-00-00 00:00:00 [modified_by] => ) ) enz
Ik wil echter een tabel tonen met alleen de waarden van de velden Activiteit, Voornaam, Achternaam en Speltak.
Wie oh wie wil mij helpen met deze code?
Thanx
Sjeng
Edit Jelle: Ik heb de code tussen codetags geplaatst, volgende keer graag zelf doen.
Heeft onderwerp gestart
