public static function display($iId)
{
$sQuery = " update product ";
$sQuery .= "set active = 1";
$sQuery .= " WHERE id = " . $iId;
$iRetExec = DBOperation::exec($sQuery);
if (null !== ($sLastSqlError = DBOperation::getLastSqlError())) {
throw new \Exception($sLastSqlError);
}
}
public static function updatePassword($oUser)
{
$sQuery = " update user ";
$sQuery .= " SET password = '******'";
$sQuery .= " WHERE email = '" . $oUser->getEmail() . "'";
$iRetExec = DBOperation::exec($sQuery);
if (null !== ($sLastSqlError = DBOperation::getLastSqlError())) {
throw new \Exception($sLastSqlError);
}
}
public static function validate(Product $oProduct, User $oUser)
{
$sQuery = " update comment";
$sQuery .= " SET validated = 1";
$sQuery .= " WHERE product_id = " . $oProduct->getId();
$sQuery .= " AND user_email = '" . $oUser->getEmail() . "'";
$iRetExec = DBOperation::exec($sQuery);
if (null !== ($sLastSqlError = DBOperation::getLastSqlError())) {
throw new \Exception($sLastSqlError);
}
}
public static function remove($iId)
{
$sQuery = " DELETE FROM category ";
$sQuery .= " WHERE id = " . $iId;
$iRetExec = DBOperation::exec($sQuery);
if (null !== ($sLastSqlError = DBOperation::getLastSqlError())) {
throw new \Exception($sLastSqlError);
}
}
