/**
* @name logTrace
* @param int $p_niveau
* @param string $p_msg
*/
public function logTrace($p_niveau, $p_msg)
{
try {
$params = new stdClass();
$params->sql = "INSERT INTO `" . self::$config->prefixTable . "api_tab_log`\n (`dateTime`,`id_type`,`commentaires`) \n VALUES \n (NOW(), :type, :msg)\n ;";
$params->bindsValue = ["type" => ["value" => $p_niveau], "msg" => ["value" => addslashes($p_msg)]];
$req = $this->connection->prepare($params->sql);
foreach ($params->bindsValue as $key => $value) {
if (!isset($value["type"])) {
if (is_int($value["value"])) {
$param = PDO::PARAM_INT;
} elseif (is_bool($value["value"])) {
$param = PDO::PARAM_BOOL;
} elseif (is_null($value["value"])) {
$param = PDO::PARAM_NULL;
} elseif (is_string($value["value"])) {
$param = PDO::PARAM_STR;
} else {
$param = FALSE;
}
$params->bindsValue[$key]["type"] = $param;
$req->bindValue(":" . $key, $value["value"], $param);
} else {
$req->bindValue(":" . $key, $value["value"], $value["type"]);
}
}
$resultReq = $req->execute();
$req->closeCursor();
$id = $this->connection->lastInsertId();
return $id;
} catch (Exception $ex) {
throw new Exception($ex);
}
}
