<?php

$dsn = 'mysql:host=localhost;port=3307;dbname=testdb';
$username = 'username';
$password = 'password';
$options = array();
$db = new PDO($dsn, $username, $password, $options);

$name = $_GET['name'];

$query = $db->prepare("SELECT id,gender,skincolor,eyes,face,hair FROM characters WHERE name=?");
$query->execute([$name]);
$row = $query->fetch();
$id = $row[0];
$gender = $row[1];
$skincolor = $row[2];
$eyes = $row[3];
$face = $row[4];
$hair = $row[5];

$items = [];
$query = $db->prepare("SELECT itemid FROM inventoryitems WHERE characterid=? AND inventorytype=-1");
$query->execute([$id]);
$rows = $query->fetchAll(PDO::FETCH_ASSOC);
foreach ($query as $row) {
    $items[] = $row[0];
}

// Took from somewhere else??
$chr->id = $id;
$chr->gender = $gender;
$chr->skincolor = $skincolor;
$chr->eyes = $eyes;
$chr->face = $face;
$chr->hair = $hair;
$chr->items = $items;

$chrJSON = json_encode($chr);

echo $chrJSON;