PHP EShop\Core Database示例

示例#1

文件： CategoriesRepository.php 项目： Web-Development-PHP/E-Shop

 public function getPromotionsForCategories()
 {
     $promotions = $this->db->getAllEntities(self::PROMO_CATEGORIES_TABLENAME, 'promotedAt');
     $categoriesPromos = [];
     foreach ($promotions as $promo) {
         $promoCategory = new PromoCategory($promo);
         if ($promo['isInPromotion'] == '1') {
             array_push($categoriesPromos, $promoCategory);
         }
     }
     return $categoriesPromos;
 }

示例#2

文件： AppStarter.php 项目： Web-Development-PHP/E-Shop

 public static function registerDbConfigurations()
 {
     \EShop\Core\Database::setInstance(\EShop\Config\DatabaseConfig::DB_INSTANCE, \EShop\Config\DatabaseConfig::DB_DRIVER, \EShop\Config\DatabaseConfig::DB_USER, \EShop\Config\DatabaseConfig::DB_PASSWORD, \EShop\Config\DatabaseConfig::DB_NAME, \EShop\Config\DatabaseConfig::DB_HOST);
 }

示例#3

文件： UsersRepository.php 项目： Web-Development-PHP/E-Shop

 public function changePassword($userId, $newPassword)
 {
     $isChanged = $this->db->updateEntityById(self::USERS_TABLENAME, array("password" => password_hash($newPassword, AppConfig::PASSWORD_CRYPT_METHOD)), $userId);
     return $isChanged;
 }

示例#4

文件： ProductsRepository.php 项目： Web-Development-PHP/E-Shop

 public function remove($id)
 {
     $isDeleted = $this->db->updateEntityById(self::PRODUCTS_TABLENAME, array("is_sold" => 1), $id);
     return $isDeleted;
 }

示例#5

文件： CartsRepository.php 项目： Web-Development-PHP/E-Shop

 public function removeProductsFromCart($cartId, $productId)
 {
     $isRemoved = $this->db->deleteProductFromCart($cartId, $productId);
     return $isRemoved;
 }