<?php
$id = $_GET['generationId'];
$name = $_GET['name'];
$description = $_GET['description'];
$type1 = $_GET['type1'];
$type2 = $_GET['type2'];
$anim = $_GET['animation'];
$sprite = $_GET['spriteSheet'];
$x = $_GET['ss_x'];
$y = $_GET['ss_y'];

$host = 'localhost';
$user = 'jlcrouch';
$passwd = 'vwccsjlcrouch';
$database = 'jlcrouch';

$connect = mysqli_connect($host, $user, $passwd);

if (is_string($id) && is_string($name) && is_string($description) && is_string($type1) && is_string($type2) && is_string($anim) && is_string($sprite) && is_string($x) && is_string($y) && strlen($id) > 0 && strlen($name) > 0 && strlen($description) > 0 && strlen($type1) > 0 && strlen($type2) > 0 && strlen($anim) > 0 && strlen($sprite) > 0 && strlen($x) > 0 && strlen($y) > 0) {
  mysqli_select_db($connect, $database);
  mysqli_query($connect, "INSERT INTO pokedex (generationId, name, type1, type2, ss, ss_x, ss_y) VALUES ('$id', '$name', '$type1', '$type2', '$sprite', '$x', '$y');");
  mysqli_query($connect, "INSERT INTO descriptions VALUES ('$id', '$description', '$anim');");
} else {
  print "Invalid entry. All columns must be filled out.";
}
?>