database query element value

[leblancphil]

Hello
There is something I really dont understand.
I try to put some information in my form intro
I get a element value (default value from url opening the form
in exemple the admin3_compta___scol_id is 11004

{admin3_compta___scol_id_raw}<br /> 
<?php
$scol = '{admin3_compta___scol_id_raw}';
echo $scol;

I have the right result
11004
11004
but when I try after

$myDb = JFactory::getDbo(); 
$myQuery = $myDb->getQuery(true);
$myQuery 
->select('r_a_p') 
->from('admin3_scolarites') 
->where('admin3_scolarites.id = '.$scol); 
$myDb->setQuery($myQuery); 
$rap = $myDb->loadResult();
return $rap;

I get the 1064 error
....WHERE admin3_scolarites.id = {admin3_compta___scol_id_raw}....
Why ?
Thanks

 

[marcq]

Hi,

You can use sourcerer which is a great Joomla extension for this kind of code and it is free :

Query

{source} [[?php $candidateid = '{gprh_fabrik_user_enrollment___id}'; $db = JFactory::getDbo(); $query = $db->getQuery(true); $query ->select (array('gprh_fabrik_user_enrollment.id', 'gprh_fabrik_user_training.intitule', 'gprh_fabrik_user_training_124_repeat.nom_formation', 'gprh_fabrik_user_training_124_repeat.intitule_session', 'gprh_fabrik_user_training_124_repeat.intitule_prix')) ->from('gprh_fabrik_user_enrollment') ->leftJoin('gprh_fabrik_user_enrollment_repeat_choix_formation ON gprh_fabrik_user_enrollment.id = gprh_fabrik_user_enrollment_repeat_choix_formation.parent_id') ->leftJoin('gprh_fabrik_user_training_124_repeat ON gprh_fabrik_user_enrollment_repeat_choix_formation.choix_formation = gprh_fabrik_user_training_124_repeat.id') ->leftJoin('gprh_fabrik_user_training ON gprh_fabrik_user_training_124_repeat.parent_id = gprh_fabrik_user_training.id') ->having('gprh_fabrik_user_enrollment.id = ' . $db->quote($candidateid)) ->group('gprh_fabrik_user_enrollment.id, gprh_fabrik_user_training_124_repeat.nom_formation, gprh_fabrik_user_training.intitule'); $db->setQuery($query); $row = $db->loadObjectList(); echo "
"; foreach ($row as $item) { echo $item->nom_formation; echo " | "; echo $item->intitule_session; echo " | "; echo $item->intitule_prix; } echo "
"; ?]] {/source}

Date alteration

{source} [[?php setlocale (LC_TIME, 'fr_FR.utf8','fra'); $date = '{gprh_fabrik_user_enrollment___date_time}'; echo utf8_encode(strftime("%d-%m-%Y",strtotime($date))); ?]] {/source}

Other stuff

{source} [[?php $civilite = '{gprh_fabrik_user_enrollment___civilite_raw}'; if ($civilite == "1") { echo 'Madame'; } else if ($civilite == "2") { echo 'Mademoiselle'; } else if ($civilite == "3") { echo 'Monsieur'; } else if ($civilite == "0") { echo 'Non renseign?'; } else {}; ?]] {/source}

Do not forget to allow Joomla plugins into the form Options (Options tab).

Cheers,

Marc