title: Insert values in table with foreign key in php
body: <p>I am new to PHP and SQL. I simply want to register a user after a team of users has been created.
  Tables that i have used - </p>
  
  <p><strong>team</strong></p>
  
  <pre><code>idTeam int(11) PK + AI
  teamName varchar(25)
  </code></pre>
  
  <p><strong>user</strong></p>
  
  <pre><code>idUser int(11) PK + AI
  name varchar(30)
  username varchar(30)
  password varchar(30)
  team int(11) FK
  </code></pre>
  
  <p>I have used the following code-</p>
  
  <pre><code>&lt;?php
  session_start();
  include('conn.php');
  
  $name=$_POST['name'];
  $team=$_POST['team'];
  $username=$_POST['username'];
  $password=$_POST['password'];
  
  $qry="SELECT * FROM team WHERE idTeam='$team";
  
  if(mysqli_query($con,$qry)){
    mysqli_query("INSERT INTO user(name, team, username, password)VALUES('$name', '$team', '$username', '$password')");
  
    header("location: add_user.php?remarks=success"); 
    mysqli_close($con);
  }
  else 
  mysqli_error($con); 
  ?&gt;
  </code></pre>
  
  <p>i used to get error- Mysql error 1452 - Cannot add or update a child row: a foreign key constraint failsMysql error 1452 - Cannot add or update a child row: a foreign key constraint fails</p>
  
  <p><strong>Example</strong> - I have pre-entered the contents of <strong>team</strong> table- </p>
  
  <pre><code>idTeam - teamName
    1      Arsenal
    2      Chelsea
    3      Liverpool
  </code></pre>
  
  <p>Now if i want to add a user then I would add him by entering in <strong>user</strong> table-</p>
  
  <pre><code>idUser   team   name   username  password
    1        2    abc    root      pass
  </code></pre>
  
  <p>So here i am unable to figure out what query should i use in PHP code? </p>