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"]];