<?php
include'sqlconnect.php';




$expansion = $_POST['expansion'];
$name = $_POST['name'];
$rare = $_POST['rare'];
$number = $_POST['number'];
$type = $_POST['type'];
$hp = $_POST['hp'];
$stage = $_POST['stage'];
$evolFrom = $_POST['evolFrom'];
$pType = $_POST['pType'];
$retreatCost = $_POST['retreatCost'];
$ability = $_POST['ability'];
$weakness = $_POST['weakness'];
$resisitance = $_POST['resistance'];
$Trainner = $_POST['Trainner'];
$eType = $_POST['eType'];
$eSpecial = $_POST['eSpecial'];
$img =$_POST['img'];



$sql = "INSERT INTO Card (Type_id, Rarity, Expansion, CNum, Cname, img) VALUES ( '$type', '$rare', '$expansion', '$number', '$name','$img');";


if ($conn->query($sql) === TRUE) {
    $last_id = $conn->insert_id;
    echo "New record created successfully. Last inserted ID is: " . $last_id;
  }else{
      echo "Error: " . $sql . "<br>" . $conn->error;
}
//type diffrence
if ($type === '1') {
    $sql= "INSERT INTO Card_Pokemon (C_id, Pokemon_Type, HP, Weakness, Resistance, E_From, R_Cost, Ability, Stage) VALUES ( '$last_id', '$pType', '$hp', '$weakness', '$resisitance', '$evolFrom','$retreatCost','$ability','$stage');";

    if ($conn->query($sql) === TRUE) {
        $last_id = $conn->insert_id;
        echo "<br>New Pokemon Record created successfully." ;
    }else{
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
}elseif ($type === '2') {
    $sql= "INSERT INTO Card_Trainer (C_id, Trainer_Type) VALUES ( '$last_id', '$Trainner');";
    if ($conn->query($sql) === TRUE) {
      $last_id = $conn->insert_id;
      echo "<br>New Trainer Record created successfully. ";
      }else{
        echo "Error: " . $sql . "<br>" . $conn->error;
        }
  }elseif ($type === '3') {
      $sql= "INSERT INTO Card_Energy (C_id, Energy_Type,special) VALUES ( '$last_id', '$eType','$eSpecial');";
      if ($conn->query($sql) === TRUE) {
        $last_id = $conn->insert_id;
        echo "<br>New Energy Record created successfully.";
        }else{
          echo "Error: " . $sql . "<br>" . $conn->error;
          }
    }else {
      echo "Error: " . $sql . "<br>" . $conn->error;
    }


$conn->close();




?>