/** * Execute * * @param string $sql * @throws Exception\RuntimeException * @return mixed */ public function execute($sql) { if (!$this->isConnected()) { $this->connect(); } if (!$this->driver instanceof Sqlsrv) { throw new Exception\RuntimeException('Connection is missing an instance of Sqlsrv'); } if ($this->profiler) { $this->profiler->profilerStart($sql); } $returnValue = sqlsrv_query($this->resource, $sql); if ($this->profiler) { $this->profiler->profilerFinish($sql); } // if the returnValue is something other than a Sqlsrv_result, bypass wrapping it if ($returnValue === false) { $errors = sqlsrv_errors(); // ignore general warnings if ($errors[0]['SQLSTATE'] != '01000') { throw new Exception\RuntimeException('An exception occurred while trying to execute the provided $sql', null, new ErrorException($errors)); } } $result = $this->driver->createResult($returnValue); return $result; }
/** * Execute * * @param array|ParameterContainer $parameters * @throws Exception\RuntimeException * @return Result */ public function execute($parameters = null) { if (!$this->isPrepared) { $this->prepare(); } /** START Standard ParameterContainer Merging Block */ if (!$this->parameterContainer instanceof ParameterContainer) { if ($parameters instanceof ParameterContainer) { $this->parameterContainer = $parameters; $parameters = null; } else { $this->parameterContainer = new ParameterContainer(); } } if (is_array($parameters)) { $this->parameterContainer->setFromArray($parameters); } if ($this->parameterContainer->count() > 0) { $this->bindParametersFromContainer(); } /** END Standard ParameterContainer Merging Block */ $resultValue = sqlsrv_execute($this->resource); if ($resultValue === false) { $errors = sqlsrv_errors(); // ignore general warnings if ($errors[0]['SQLSTATE'] != '01000') { throw new Exception\RuntimeException($errors[0]['message']); } } $result = $this->driver->createResult($this->resource); return $result; }
/** * Execute * * @param array|ParameterContainerInterface $parameters * @return type */ public function execute($parameters = null) { if (!$this->isPrepared) { $this->prepare(); } if ($parameters !== null) { if (is_array($parameters)) { $parameters = new ParameterContainer($parameters); } if (!$parameters instanceof ParameterContainerInterface) { throw new \InvalidArgumentException('ParameterContainer expected'); } $this->parameterContainer = $parameters; } if ($this->parameterContainer) { $this->bindParametersFromContainer(); } $resultValue = sqlsrv_execute($this->resource); if ($resultValue === false) { $errors = sqlsrv_errors(); // ignore general warnings if ($errors[0]['SQLSTATE'] != '01000') { throw new \RuntimeException($errors[0]['message']); } } $result = $this->driver->createResult($this->resource); return $result; }
/** * Execute * * @param string $sql * @return mixed */ public function execute($sql) { if (!$this->isConnected()) { $this->connect(); } $returnValue = sqlsrv_query($this->resource, $sql); // if the returnValue is something other than a Sqlsrv_result, bypass wrapping it if ($returnValue === false) { $errors = sqlsrv_errors(); // ignore general warnings if ($errors[0]['SQLSTATE'] != '01000') { throw new \RuntimeException($errors[0]['message']); } } $result = $this->driver->createResult($returnValue); return $result; }