/** *Function that updates images informations *@params int $psIdImage, int $psIdImage, string $coloranalysis, string $md5Digest, *string $imgPath */ public function updateImageInformation($psIdProduc, $psIdImage, $colorAnalysis, $md5Digest, $imgPath) { $productExist = $this->_ifProductExist($psIdProduc); $imageExist = $this->ifImageExist($psIdImage); if (!$productExist) { $this->logger->postMessage("Il prodotto {$psIdProduc} non esiste", "WARNING"); return; } if ($imageExist === true) { $oldPath = $this->getImageInformation($psIdImage); $connection = connectionServer(); $sql = "UPDATE ps_tmp_image SET color_analysis ='" . $colorAnalysis . "' ,md5_digest = '" . $md5Digest . "' , new_path = '" . $imgPath . "',old_path = '" . $oldPath["newPath"] . "', status = '0' WHERE ( ps_id = \n '" . $psIdImage . "')"; $res = mysql_query($sql, $connection); if ($res) { //se l'inserimento è stato completato } else { $errno = mysql_errno($connection); $error = mysql_error($connection); switch ($errno) { case 1062: throw new HandleOperationsException($error); break; default: throw MySQLException($error, $errno); break; } } } closeConnectionServer($connection); }
public static function TestQuery($sSql) { try { $oResult = self::$m_oMysqli->query($sSql); } catch (mysqli_sql_exception $e) { MySQLException('Failed to issue SQL query', array('query' => $sSql, $e)); } if ($oResult === false) { throw new MySQLException('Failed to issue SQL query', array('query' => $sSql)); } if (is_object($oResult)) { $oResult->free(); } return ''; }