mysql命令不同步

这个update查询看起来非常错误。试试下面的

你的旧update，

$update = $dbc->prepare("UPDATE table SET field = 'valued' WHERE(field1 = ? AND field2 = ?)LIMIT 1");
mysqli_stmt_bind_param($update, "ss", $value1, $value2);
mysqli_stmt_execute($update);

你的新$update，

$update = mysqli_prepare($dbc, "UPDATE `yourTableName` SET `field` = 'valued' WHERE field1 = ? AND field2 = ?");

LIMIT可以与UPDATE一起使用，但只能使用行数。

编辑1

您似乎将OO MySQLi与procedural混合在一起，请阅读此页

编辑2

你的代码有很多问题。

1. 你试图访问$email和$key时，他们不在if的范围内，所以我添加了新的变量。

2. 您继续(如上所述)将OO与procedural混合。

3. 我在尝试执行$update时添加了一些调试。

   <?php
   $email;
   $key;
   if (isset($_GET['email']) && preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9'._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9'._-]+)+$/', $_GET['email'])) {
       $email = $_GET['email'];
   }
   if (isset($_GET['key']) && (strlen($_GET['key']) == 32)) //The Activation key will always be 32 since it is MD5 Hash
       {
       $key = $_GET['key'];
   }
   
   if (isset($email) && isset($key)) {
       $check_code = mysqli_prepare($dbc, "SELECT Activation FROM members WHERE Email = ?");
       mysqli_stmt_bind_param($check_code, "s", $email);
       mysqli_stmt_execute($check_code);
       mysqli_stmt_bind_result($check_code, $activation);
       mysqli_stmt_fetch($check_code);
       if ($activation == $key) {
           // Update the database to set the "activation" field to null
           $update = mysqli_prepare($dbc, "UPDATE `members` SET `Activation` = 'Activated' WHERE `Email` = ? AND `Activation` = ?");
           mysqli_stmt_bind_param($update, "ss", $email, $key);
           mysqli_stmt_execute($update);
           if (!mysqli_stmt_execute($update) ) {
               die("Error: " . mysqli_stmt_error($update));
           }   
   
           // Print a customized message:
           if (mysqli_affected_rows($dbc) == 1) { //if update query was successfull
               echo '<div class="success">Your account is now active. You may now <a href="login.php">Log in</a></div>';
           } else {
               echo '<div class="errormsgbox">Oops !Your account could not be activated. Please recheck the link or contact the system administrator.</div>';
               echo '<br/> ' . $dbc->error;
           }
           mysqli_close($dbc);
       } else {
           echo "Parameters wrong, wrong link?";
       }
   } else {
       echo '<div class="errormsgbox">Error Occured .</div>';
   }
   ?>
   

首先你混合了过程和面向对象，其次你还没有关闭你的连接，这是另一个错误:)

$check=$dcv->prepare('SELECT field FROM table where field=?');
$check->bind_param('s',$value1);
$check->execute();
$check->bind_result($info);
$check->fetch();
$check->close();
if($info==$static_value){
    $update=$dvc->prepare('UPDTATE table SET field='valued' WHERE field1=? AND field2=?');
    $update->bind_param('ss',$value1,$value2);
    $result=$update->execute();
    $update->close();
}