PHP Oda OdaLibInterface::addDataStr Examples

Example #1

File: insertLog.php Project: Happykiller/ODA_FW_SERVER

<?php

namespace Oda;

require '../../../../../header.php';
require '../../../../../vendor/autoload.php';
require '../../../../../config/config.php';
use stdClass, Oda\SimpleObject\OdaPrepareInterface, Oda\SimpleObject\OdaPrepareReqSql, Oda\OdaLibBd;
//--------------------------------------------------------------------------
//Build the interface
$params = new SimpleObject\OdaPrepareInterface();
$params->arrayInput = array("type", "msg");
$ODA_INTERFACE = new OdaLibInterface($params);
//--------------------------------------------------------------------------
// vendor/happykiller/oda/resources/api/insertLog.php?milis=123450&type=0&msg=wtf
//--------------------------------------------------------------------------
$id = $ODA_INTERFACE->BD_ENGINE->logTrace($ODA_INTERFACE->inputs["type"], addslashes($ODA_INTERFACE->inputs["msg"]));
//---------------------------------------------------------------------------
$params = new \stdClass();
$params->label = "resultatInsert";
$params->value = $id;
$ODA_INTERFACE->addDataStr($params);

Example #2

File: exemple.php Project: Happykiller/ODA_RING

    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 = "\\Ring\\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"]];