Ejemplo n.º 1
0
$products = ProductModel::findByExample($db, $example, true, $sort);
listProducts($products);
// query with filter
echo ' -> get all products with a purchase cost of at least 1000' . "\n";
$filter = new DFC(ProductModel::FIELD_PURCHASE_COST, 1000, DFC::NOT | DFC::SMALLER);
$products = ProductModel::findByFilter($db, $filter, true, $sort);
listProducts($products);
echo ' -> get all products with a purchase cost smallther than 1000 and the description containg Computer' . "\n";
$filter = array(new DFC(ProductModel::FIELD_PURCHASE_COST, 1000, DFC::SMALLER), new DFC(ProductModel::FIELD_DESCRIPTION, 'Computer', DFC::CONTAINS));
$products = ProductModel::findByFilter($db, $filter);
listProducts($products);
// query with SQL
$sql = "SELECT * FROM PRODUCT WHERE DESCRIPTION LIKE '%Sound%'";
echo ' -> get by SQL: ' . $sql . "\n";
$products = ProductModel::findBySql($db, $sql);
listProducts($products);
// insert new product
$product = new ProductModel();
$product->setProductId(123)->setManufacturerId(123)->setProductCode('HW')->setPurchaseCost(1234567890)->setQuantityOnHand(1)->setMarkup(1234567891)->setAvailable('TRUE')->setDescription('Test Product');
$product->insertIntoDatabase($db);
// update product
$product->setPurchaseCost(100);
$product->setMarkup(120);
$product->setQuantityOnHand(200);
// get changed fields
var_dump($product->getFieldsValuesChanged());
$product->updateToDatabase($db);
// delete product
$product->deleteFromDatabase($db);
// dom functions
echo $product->toDOM()->saveXML();
Ejemplo n.º 2
0
          <li><a href="shop.php">Shop</a></li>
          <li><a href="cart.php">Cart</a></li>

        </ul>
        <ul class="pull-right">
          <li><a href="accessories.html">Accessories</a></li>
          <li><a href="AboutUs.html">About Us</a></li>
        </ul>
      </div>
    </div>
    <div class="table">
      <table align="center" border="2">
        <tr>
    <?php 
require_once "connection.php";
listProducts();
?>

    <!--    
    <tr>
        <th><img src="Products/Prod1.jpg" alt="SegWay" height="275" width="350"/></th>
        <th><img src="Products/Prod2.jpg" alt="SegWay" height="275" width="350"/></th>
        <th><img src="Products/Prod3.jpg" alt="SegWay" height="275" width="350"/></th>
    </tr>
    <tr>
        <td>Classic Black <strong>&#3647;5500  </strong></td>
        <td>Classic Blue <strong>&#3647;5500 </strong></td>
        <td>Classic White <strong>&#3647;5500 </strong></td>
    </tr>
    <tr>
        <th><img src="Products/Prod4.jpg" alt="SegWay" height="275" width="350"/></th>
Ejemplo n.º 3
0
    } elseif ($type & Upgrade) {
        echo "Upgrade\n";
    } elseif ($type & Ability) {
        echo "Ability\n";
    }
    foreach (Product::$all as $product) {
        if (($product->type & $type) == $type && !empty($product->name)) {
            echo $product . "\n";
        }
    }
    echo "\n";
}
// Protoss
listProducts(Protoss | Structure);
listProducts(Protoss | Morph);
listProducts(Protoss | Unit);
listProducts(Protoss | Upgrade);
listProducts(Protoss | Ability);
// Terran
listProducts(Terran | Structure);
listProducts(Terran | Morph);
listProducts(Terran | Unit);
listProducts(Terran | Upgrade);
listProducts(Terran | Ability);
// Zerg
listProducts(Zerg | Structure);
listProducts(Zerg | Morph);
listProducts(Zerg | Unit);
listProducts(Zerg | Upgrade);
listProducts(Zerg | Ability);