我最近开始开发，并希望在可能的情况下进行一些帮助。首先，我的目标[项目范围]是执行以下操作：
1. Connect to the shopify API via an external web app [Done this Successfully]
2. Fetch a list of all products in that specific store [Struggling with this]
3. Insert (or update there after) in to a MySQL database [Can do this successfully]
目前，我可以按照Shopify的API限制为250个产品的API限制，并回应了这一点。我做了一些研究，发现我需要在商店中对产品的总数[5000个产品/250种产品]分页。从中，我可以循环浏览每个页面，并回响所有产品。当我运行这个循环时，我会一遍又一遍地回荡着商店中产品的整体计数(很抱歉，如果措辞似乎有些模糊，则很抱歉，因为我对API的php都是全新的。/p>
我的问题是：我如何循环并回应所有产品，所有页面和所有页面都回荡到我创建的" list-products.php"的页面？
我当前的代码如下：
get-products.php//连接到shopify api。
<?php
session_start();
$username = $_SESSION['username'];
if(empty($_SESSION['username']))
{
header("Location: loginpage.php");
die("Redirecting to login.php");
}
$api_url = 'https://apikey:password@store.myshopify.com';
$products_obj_url = $api_url . '/admin/products.json?limit=250&page='.($i+1);
$products_content = @file_get_contents( $products_obj_url );
$products_json = json_decode( $products_content, true );
$products = $products_json['products'];
?>
get-product-count.php//计算商店中当前列出的产品数量。
<?php
session_start();
$username = $_SESSION['username'];
if(empty($_SESSION['username']))
{
header("Location: loginpage.php");
die("Redirecting to login.php");
}
$api_url = 'https://apikey:password@store.myshopify.com';
$count_obj_url = $api_url . '/admin/products/count.json';
$count_content = @file_get_contents( $count_obj_url );
$count_json = json_decode( $count_content, true );
$count = $count_json['count'];
?>
list-products.php//echos out商店中所有产品的列表
<!DOCTYPE html>
<?php
include('../get-products.php');
include('../get-product-count.php');
?>
<html>
<head>
<title>List Products</title>
<link rel="stylesheet"href="https://cdnjs.cloudflare.com/ajax/libs/uikit/3.0.0-beta.40/css/uikit.min.css" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/uikit/3.0.0-beta.40/js/uikit.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/uikit/3.0.0-beta.40/js/uikit-icons.min.js"></script>
</head>
<body>
<?php include('../header.php'); ?>
<div class="uk-alert-success uk-margin-medium-left uk-margin-medium-right" uk-alert>
<a class="uk-alert-close" uk-close></a>
<p>All products.</p>
<table class="uk-table uk-table-small uk-table-striped uk-table-divider uk-margin-small uk-margin-small-left uk-text-small" uk-grid="">
<tr>
<td>Product ID</td>
<td>Product Title</td>
<td>Product SKU</td>
<td>Variant Title</td>
<td>Price</td>
<td>Inventory</td>
</tr>
<?php
// Loop through each page and pull all products. Reason being, Shopify API call limit is 250 calls at once.
// This currently display the first 250 products on the first page for the full product count.
$i = 0;
$pages = ceil($count/250); // Count products / 250 from get-products.php = to amount of pages rounded up.
for($i = 0; $i < $pages; $i++){
foreach($products as $product){
echo "<tr>
<td>". $product['variants'][0]['product_id'] . "</td>
<td>". $product['title']. "</td>
<td>". $product['variants'][0]['title'] . "</td>
<td>". $product['variants'][0]['sku'] . "</td>
<td>". $product['variants'][0]['price'] . "</td>
<td>". $product['variants'][0]['old_inventory_quantity'] . "</td>
</tr>";
}
}
?>
</table>
<?php include('../footer.php'); ?>
</body>
</html>
结束：对此的任何帮助将不胜感激。
您非常接近。
您需要继续获取循环内的下一个250个产品：
for($i = 0; $i < $pages; $i++){
// not sure if this exact example will work 100% for you but you need to re-execute the code from this file on every iteration
// By placing this here, get-products.php will become aware of the incrementing $i and fetch the next page of products
require( '../get-products.php' );
foreach($products as $product){
echo "<tr>
<td>". $product['variants'][0]['product_id'] . "</td>
<td>". $product['title']. "</td>
<td>". $product['variants'][0]['title'] . "</td>
<td>". $product['variants'][0]['sku'] . "</td>
<td>". $product['variants'][0]['price'] . "</td>
<td>". $product['variants'][0]['old_inventory_quantity'] . "</td>
</tr>";
}
}