android - 我试图从 android 将数据插入 mysql 数据库

Question

拜托，我希望有人告诉我我的代码出了什么问题，当我执行它时，数据库中没有任何反应。我不知道我的请求有问题还是其他什么问题。

1. 我有一个名为 expedition 的表，其中包含以下列:ide、bordereau、agenceorig、nomexped、numexped、nomdestin、numdestin、destination emballage 和 valeur。

2. 我有一个表格，其中包含:$bordereau、$username、$nomexped、$numexped、$nomdestin、$numdestin、$destination、$emballage、$valeur

3. 当我使用按钮验证表单时，我会使用私有(private)函数 isexpedition($bordereau) 检查 $bordereau 是否已存在，如果不存在，我会将数据插入表中。

当我执行代码时，我收到以下消息:{"error":true,"message":"Une erreur est survenue, veillez recommencer"}，显示数据尚未插入数据库。

/*CRUD -> C -> CREATE*/
public function expedition($nomexped,$numexped,$nomdestin,$numdestin,$destination,$emballage,$bordereau,$valeur){
    if($this-> isexpedition($bordereau)){
        return 0;
    }else{

        $stmt = $this->con->prepare("INSERT INTO expedition (ide,bordereau,agenceorig,nomexped,numexped,nomdestin,numdestin,destination,emballage,valeur) VALUES (NULL,?,?,?,?,?,?,?,?,?)");
        $stmt->bind_param("sssssssss",$Bordereau,$username,$Nomexped,$Numexped,$Nomdestin,$Numdestin,$Destination,$Emballage,$Valeur);

        if($stmt->execute()){
            return 1;    
        }else{
            return 2;
        }    
    }
}

private function isexpedition($bordereau){
    $stmt = $this->con->prepare("SELECT ide FROM expedition WHERE bordereau=? ");
    $stmt->bind_param("s",$bordereau);
    $stmt->execute();
    $stmt->store_result();
    return $stmt->num_rows>0;
    }
}

Answer 1

$stmt = $conn->prepare("INSERT INTO users (username,password, email, gender) VALUES (?, ?, ?, ?)");
  $stmt->bind_param("ssss", $username, $password, $email, $gender);

  //if the user is successfully added to the database 
  if($stmt->execute()){

  //fetching the user back 
  $stmt = $conn->prepare("SELECT id, id, username, email, gender FROM users WHERE username = ?"); 
  $stmt->bind_param("s",$username);
  $stmt->execute();
  $stmt->bind_result($userid, $id, $username, $email, $gender);
  $stmt->fetch();

  $user = array(
  'id'=>$id, 
  'username'=>$username, 
  'email'=>$email,
  'gender'=>$gender
  );

  $stmt->close();

  //adding the user data in response 
  $response['error'] = false; 
  $response['message'] = 'User registered successfully'; 
  $response['user'] = $user; 
  }