Hello
This code works inside snippet, but not in de Formit hook, why ?
$modx->invokeEvent('OnHandleRequest');
/*
psQuery
*/
$ps_database_host = $modx->getOption('sconf_psdb-host');
$ps_database_charset = $modx->getOption('sconf_psdb-charset');
$ps_database_name = $modx->getOption('sconf_psdb-name');
$ps_database_prefix = $modx->getOption('sconf_psdb-prefix');
$ps_database_username = $modx->getOption('sconf_psdb-username');
$ps_database_password = $modx->getOption('sconf_psdb-pw');
$ps = new xPDO('mysql:host=' . $ps_database_host .
';dbname=' . $ps_database_name .
';charset=' . $ps_database_charset,
$ps_database_username,
$ps_database_password );
// text connex
//echo
//$o = ($ps->connect()) ? 'Connected' : 'Not Connected';
//echo "<br>";
// Include the xpdo and modx classes
require_once (MODX_CORE_PATH . 'xpdo/xpdo.class.php');
require_once (MODX_CORE_PATH . 'model/modx/modx.class.php');
// Instantiate a new modx object. MODx inherits from xpdo so we can use it
// like an xpdo object, but it has the extra functions needed for saving content.
// Thanks to Shaun McCormick for writing docs on this.
// load package
$can_work_ps = $ps->addPackage('presta',MODX_CORE_PATH.'components/',$ps_database_prefix);
if (!$can_work_ps) die('Prestashop Package could not be loaded.');
$prestafounrid_single = "100136";
//requete sur la table EmailList pout le récuépration des emails
$query = $ps->newQuery('EmailList');
$query->where(array('id' => $prestafounrid_single));
$results2 = $ps->getCollection('EmailList',$query);
//$emails_forunisseurs = $fournisseur = $cat = array();
//$emails_forunisseurs = array();
foreach($results2 as $result2){
$emails_fournisseurs = $result2->get('email_fournisseur');
//$fournisseur[] = $result->get('fournisseur');
//$cat[] = $result->get('categorie');
}
$modx->setPlaceholders(array(
'emailfournisseurinloop' => $emails_fournisseurs,
),'efh.');
// data fournisseurs
return $emails_fournisseurs;