如何从INSERT中的两个输入中获取值？

Question

How do a get the value of select name= 'type' included with the INSERT of 'description'???

Array ( 
  [0] => 23000 
  [1] => 1452 
  [2] => Cannot add or update a child row: a foreign key constraint fails (`dblabb`.`items`, CONSTRAINT `fk_items_itemtypes_id` FOREIGN KEY (`type`) REFERENCES `itemtypes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) 
)
  if(isset($_POST['addItem'])){
  $query = "INSERT INTO items(type,description)  VALUES (':type:id', ':desc')";
  $name = filter_input(INPUT_POST,'desc',FILTER_SANITIZE_SPECIAL_CHARS);

  $sth = $db->prepare($query);
     if($sth->execute(array(':desc' =>$name)``)){

        echo "<h4>Item added</h4>";

      }else{
        echo "<h4>Error</h4>";
        echo "<pre>" . print_r($sth->errorInfo()) . "</pre>";
   }

   <form action="dblabb3.php" method="post">
   <select name="type">
        <?php

        $query = "SELECT * FROM itemtypes ORDER BY name ASC";
        if ($result = $db->query($query)) {
              while ($row = $result->fetch(PDO::FETCH_NUM)) {
                    echo '<option value="' . $row['0'] . '">' .
                            $row['1'] . '</option>';
              }
        } ?>
    </select>
    <input type="text" name="desc" placeholder="description">
    <input type="submit" name="addItem" value="Submit">
    </form>

Answer 1

Your execute statement has only one element in the array [desc] but type is required as well.

Should rather look like:

if($sth->execute(array(':type:id'=>$TYPE,':desc' =>$name){}