function __construct($db) { $this->db = $db; $stmt = SqlQuery::select($db, 'site_globals'); $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { $this[$row['site_global_name']] = $row['site_global_value']; } $stmt->close(); }
static function select($db, $table_name, $where = null, $bindings = null, $types = null, $paging = null, $orderby = null) { $list = []; $stmt = SqlQuery::select($db, $table_name, $where, $bindings, $types, $paging, $orderby); if ($stmt) { $result = $stmt->get_result(); $class = get_called_class(); while ($row = $result->fetch_assoc()) { $model = new $class($db); $model->setData($row); $list[] = $model; } $stmt->close(); } return $list; }
$category->data['category_parent_id'] = $parent->ival('category_id'); } $new++; } else { $updated++; } // update existing category $category->data['category_name'] = myTrim(convertEncoding($row['cat_name'])); $category->save(); } $stmt->close(); } */ $stmt = SqlQuery::select($cube_db, 'cubecart_inventory'); if ($stmt) { $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { $product = new Product($db); $product->loadByExtId($row['productId']); // import new product if (!$product->is_loaded) { $product->data['product_ext_id'] = $row['productId']; $product->data['product_name'] = myTrim(convertEncoding($row['name'])); $product->data['product_price'] = parseFloat($row['price']); $category = loadCategory($row['cat_id']); if (isset($category)) { $product->data['product_category_id'] = $category->ival('category_id'); } $new++;