Query is working in calc element but not in template

[Egocentralis]

Hey,

I want to achieve to get some address details loaded dynammicly in a pdf via a template (dompdf)

First i tried to write the query in a calc element so I had a visual of what is happening.

$bedrijf_id = '{g4e_orakel_factuurid___bedrijf_id}';

$mydb = FabrikWorker::getDbo();
$query = $mydb->getQuery(true);
$query
->select("bedrijfsnaam, straat, huisnummer, postcode, vestiging_plaats, telefoonnummer, email_adres_bedrijf, vol_naam,kvk_nummer btw_nummer, agb_code")
->from("egocentralis_bedrijven")
->where("bedrijf_id = " . $mydb->quote($bedrijf_id));

$mydb->setQuery($query);
$gegevens = $mydb->loadObject();
$adres = " " . $gegevens->bedrijfsnaam . "<br />";
$adres .= " " . $gegevens->vol_naam . "<br />";
$adres .= " " .  $gegevens->straat . " " . $gegevens->huisnummer . "<br />";
$adres .= " " .  $gegevens->postcode . " " . $gegevens->vestiging_plaats . "<br /><br />";
$adres .= " " .  $gegevens->telefoonnummer . "<br />";
$adres .= " " .  $gegevens->mail_adres_bedrijf . "<br /><br />";
$adres .= " " .  $gegevens->kvk_nummer . "<br />";
$adres .= " " .  $gegevens->btw_nummer . "<br />";
$adres .= " " .  $gegevens->agb_code . "<br />";

return $adres;

This is working as expected.



But, when I try the same query directly in the php file of the template of the pdf, its resulting in a 404 error page not found.

<?php
$bedrijf_id = '{g4e_orakel_factuurid___bedrijf_id}';
$mydb = FabrikWorker::getDbo();
$query = $mydb->getQuery(true);
$query
->select("bedrijfsnaam, straat, huisnummer, postcode, vestiging_plaats, telefoonnummer, email_adres_bedrijf, vol_naam,kvk_nummer btw_nummer, agb_code")
->from("egocentralis_bedrijven")
->where("bedrijf_id = " . $mydb->quote($bedrijf_id));

$mydb->setQuery($query);
$gegevens = $mydb->loadObject();
$adres = " " . $gegevens->bedrijfsnaam . "<br />";
$adres .= " " . $gegevens->vol_naam . "<br />";
$adres .= " " .  $gegevens->straat . " " . $gegevens->huisnummer . "<br />";
$adres .= " " .  $gegevens->postcode . " " . $gegevens->vestiging_plaats . "<br /><br />";
$adres .= " " .  $gegevens->telefoonnummer . "<br />";
$adres .= " " .  $gegevens->mail_adres_bedrijf . "<br /><br />";
$adres .= " " .  $gegevens->kvk_nummer . "<br />";
$adres .= " " .  $gegevens->btw_nummer . "<br />";
$adres .= " " .  $gegevens->agb_code . "<br />";

?>

And then on the desired place:

<?php
return $adres;
?>

Probally I miss something or I have to write the query differently in the php file (template)

Can someone point me in the good direction please??

 

[troester]

I think we had this in one of your other threads.
You can't use placeholders {g4e_orakel_factuurid___bedrijf_id} in templates.

You can access single elements like in http://www.fabrikar.com/forums/inde...tes/#creating-a-template-with-single-elements

 

[Egocentralis]

really? ok i am sorry to double post a question.. Now i did it via an element what is hidden on the front end..

 

[Egocentralis]

You can't use placeholders {g4e_orakel_factuurid___bedrijf_id} in templates.

Oh but this is not correct.. because, I made a calc element into the list... did the query for the address... also with some styling.. and in the template file i used

{g4e_orakel_factuurid___address} and it is showing in the pdf correctly.

I think what is not possible is to preload data from the database with a placeholder.