开发商回应-回款.PHP——让我发疯


Developer Response - Payment Callback. PHP - Making me go crazy

好的,所以我正在尝试在我正在开发的应用程序中设置付款,我有一个对话框可以工作,它可以确认物品的购买。我不知道它在这里之后会做什么,我读了一篇又一篇的文章,但没有快乐。我需要关于如何在购买时更新mysql数据库的信息。我知道这个问题很模糊,但任何指导都将不胜感激!

到目前为止,我的代码如下。

if ($request_type == 'payments_get_items') {
  // Get order info from Pay Dialog's order_info.
  // Assumes order_info is a JSON encoded string.
  $order_info = json_decode($request['credits']['order_info'], true);
  // Get item id.
  $item_id = $order_info['item_id'];
  // Simulutates item lookup based on Pay Dialog's order_info.
  if ($item_id == '10Kremeggs') {
    $item = array(
      'title' => '10 Kremeggs',
      'description' => 'Spend Kremeggs in Alien Abduction.',
      // Price must be denominated in credits.
      'price' => 5,
      'image_url' => 'https://afternoon-snow-5267.herokuapp.com/images/bung.png',
      'product_url' => 'https://afternoon-snow-5267.herokuapp.com/Purchase/10xKremeggs.php'
    );
    // Construct response.
    $response = array(
                  'content' => array(
                                 0 => $item,
                               ),
                  'method' => $request_type,
                );
    // Response must be JSON encoded.
    $response = json_encode($response);
  }
} else if ($request_type == "payments_status_update") {
  // Get order details.
  $order_details = json_decode($request['credits']['order_details'], true);
  // Determine if this is an earned currency order.
  $item_data = json_decode($order_details['items'][0]['data'], true);
  $earned_currency_order = (isset($item_data['modified'])) ?
                             $item_data['modified'] : null;
  // Get order status.
  $current_order_status = $order_details['status'];
  if ($current_order_status == 'placed') {
    // Fulfill order based on $order_details unless...
    if ($earned_currency_order) {
      // Fulfill order based on the information below...
      // URL to the application's currency webpage.
      $product = $earned_currency_order['product'];
      // Title of the application currency webpage.
      $product_title = $earned_currency_order['product_title'];
      // Amount of application currency to deposit.
      $product_amount = $earned_currency_order['product_amount'];
      // If the order is settled, the developer will receive this
      // amount of credits as payment.
      $credits_amount = $earned_currency_order['credits_amount'];
    }
    $next_order_status = 'settled';
    // Construct response.
    $response = array(
                  'content' => array(
                                 'status' => $next_order_status,
                                 'order_id' => $order_details['order_id'],
                               ),
                  'method' => $request_type,
                );
    // Response must be JSON encoded.
    $response = json_encode($response);
  } else if ($current_order_status == 'disputed') {
    // 1. Track disputed item orders.
    // 2. Investigate user's dispute and resolve by settling or refunding the order.
    // 3. Update the order status asychronously using Graph API.
  } else if ($current_order_status == 'refunded') {
    // Track refunded item orders initiated by Facebook. No need to respond.
  } else {
    // Track other order statuses.
  }
}

以上是支付回调的一部分

<? mysql_query("UPDATE users SET Kremeggs = Kremeggs+10 WHERE Facebook_id = '$PurchaseUpdate'");
header ("Location: http://apps.facebook.com/alien_abduction/purchaseComplete.php");
?>
</body>
</html>

以上就是我需要付款的地方。

听起来您正试图在一个文件(第二个代码示例)中同时处理流程的两个非常独立的部分。您发布的第一个代码示例(看起来像他们的示例代码,这很好)是奖励用户的合适位置——您的mysql查询位于第43行(if ($current_order_status == 'placed') {)开始的块中。我会把细节留给你来解决。

您想要做的后半部分(将用户重定向到确认页面)是否不属于该回调,而是属于具有付款对话框的页面。如果您也在那里使用示例代码,那么它属于js_callback函数内部-尝试window.location.href='purchase_complete.php'(确保这只发生在成功的订单上,ofc)。

希望这能让你指向正确的方向!

else if ($request_type == "payments_status_update") {mysql_query("update users_table set payment_column='isok' where kulid like 'getFacebookUserId'");}