php - 当客户进行 Paypal 订阅时，通过 PHP 更新 SQL 表

Question

我正在努力做到这一点，以便当用户通过贝宝订阅进行订阅时，我将能够将订阅日期更新到 SQL 用户表中。我可以在贝宝上订阅没问题，但数据库没有更新日期。连接文件工作正常，我可以通过其他方式更新数据库，只是表单没有启动“POST”代码。

<?php 
$page_title = 'Subscribe' ;
include('includes/navuser.php');
# Access session.
session_start() ;

# Check form submitted.
if ( $_SERVER[ 'REQUEST_METHOD' ] == 'POST' )
{
# Connect to the database.
require ('includes/connect_db.php'); 

# Initialize an error array.
$errors = array();

# On insert to payments database table.
if ( empty( $errors ) ) 
{
$q = "UPDATE users SET subdate = NOW() WHERE username = 
'{$_SESSION[username]}'";
 $r = @mysqli_query ( $link, $q ) ;


 $w = "UPDATE users SET subdate = DATEADD(yyyy,1,subdate) WHERE username = 
 '{$_SESSION[username]}'";
 $s = @mysqli_query ( $link, $w ) ;

# Close database connection.
# mysqli_close($link); 
}  
}
?>

 <form action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post" 
 target="_top">
                <input type="hidden" name="cmd" value="_s-xclick">
                <input type="hidden" name="hosted_button_id" 
value="JHUF6WR4677MN">
                <input type="image" src="https://www.sandbox.paypal.com/en_US/GB/i/btn/btn_subscribeCC_LG.gif" border="0" name="submit" alt="PayPal – The safer, easier way to pay online!">
                <img alt="" border="0" src="https://www.sandbox.paypal.com/en_GB/i/scr/pixel.gif" width="1" height="1">
            </form>

谢谢

标签： phphtmlsqlsessionpaypal