mysqli参数分配错误.

Question

要一次给出！
$sql =  "CALL sp_set_simple_account(?, ?, ?, ?, ?, ?, @user_id, @comp_id, @return_code);";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('sssssi',$username,$pwdMD5,$compName,$compType,$email,$shareSpace);

Answer 1

$mysqli = new mysqli($dbhost,$dbuser,$dbpw,$dbname);
     29             if (mysqli_connect_errno()) {
     30                 printf("Connect failed:%s\n",mysqli_connect_error());
     31                 exit;
     32             }
     33             $sql =  "CALL sp_set_simple_account(?, ?, ?, ?, ?, ?, @user_id, @comp_id, @return_code);";
     34             $stmt = $mysqli->prepare($sql);
     35             $stmt->bind_param('sssssi',$username,$pwdMD5,$compName,$compType,$email,$shareSpace);
     36             $result = $stmt->execute();
     37             printf("%d Row inserted.\n", $stmt->affected_rows);
     38             $stmt->close();
     39             $results = $mysqli->query("select @user_id as user_id,@comp_id as comp_id,@return_code as return_code");
     40             $row = $results->fetch_object();