回发执行失败:(2031)没有为prepared语句中的参数提供数据

6yt4nkrj  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(168)

这是我每次显示的postback.php代码
执行失败:(2031)没有为准备语句中的参数提供数据
我不知道我在哪里犯了错误,请帮助我,我已经搜索过了,但没有找到解决办法

define("MYSQL_HOST", "localhost");
define("MYSQL_PORT", "xxxx");
define("MYSQL_DB", "u530xxxx312_tap");
define("MYSQL_TABLE", "taxxx");
define("MYSQL_USER", "u5xxxx312_naxxxb");
define("MYSQL_PASS", "Mcxxxx455");

// Connecting to database, using MySqli
$mysqli = new mysqli(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DB);
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}

// Setup postback variables
$uid            = $_POST['uid'];
$tid            = $_POST['tid'];
$cpid           = $_POST['cpid'];
$api_token      = $_POST['api_token'];
$payout_amount  = $_POST['payout_amount'];
$revenue        = $_POST['revenue'];

// Insert log into database
if (!($stmt = $mysqli->prepare("INSERT INTO ".MYSQL_DB.".".MYSQL_TABLE." (uid, tid, cpid, api_token, payout_amount, revenue) VALUES (?, ?, ?, ?, ?, ?)"))) {
  echo "Preparation failed: (" . $mysqli->errno . ") " . $mysqli->error;
}
$stmt->bind_param('sssssss', $uid, $tid, $cpid, $api_token, $payout_amount, $revenue);

if (!$stmt->execute()) {
  echo "Execution failed: (" . $stmt->errno . ") " . $stmt->error;
} else {
  printf("Added new conversion with uid: ".$uid." .\n");
}

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题