public $param_value;
public function getHello()
{
return "Hello : " . $this->param_name;
}
}
$params = new OdaPrepareReqSql();
$params->sql = "SELECT *\n FROM `api_tab_parametres` a\n WHERE 1=1\n AND a.`param_name` = :param_name\n;";
$params->bindsValue = ["param_name" => ["value" => "nom_site", "type" => \PDO::PARAM_STR]];
$params->typeSQL = OdaLibBd::SQL_GET_ONE;
$params->className = "\\Oda\\objRetour";
$retour = $INTERFACE->BD_ENGINE->reqODASQL($params);
$params = new stdClass();
$params->label = "resultat_class";
$params->value = $retour->data->getHello();
$INTERFACE->addDataStr($params);
//--------------------------------------------------------------------------
//EXEMPLE EXEC
$params = new OdaPrepareReqSql();
$params->sql = "CREATE TEMPORARY TABLE coucou (\n `idElem` int(11) NOT NULL,\n `nature` varchar(100),\n PRIMARY KEY(`idElem`)\n)\n SELECT a.`id` as 'idElem', a.`param_name` as 'nature' FROM `api_tab_parametres` a\n;";
$params->typeSQL = OdaLibBd::SQL_SCRIPT;
$retour = $INTERFACE->BD_ENGINE->reqODASQL($params);
$params = new \stdClass();
$params->label = "resultat_exec";
$params->value = $retour->nombre;
$INTERFACE->addDataStr($params);
//--------------------------------------------------------------------------
//EXEMPLE INSERT 1 DATA
$params = new OdaPrepareReqSql();
$params->sql = "INSERT INTO `coucou` (\n `idElem` ,\n `nature` \n )\n VALUES (\n 99 , :nature\n )\n;";
$params->bindsValue = ["nature" => ["value" => "coucou"]];
