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); } }