Using Formit to populate a form from a custom database

$sql = "SELECT * FROM `oracle_vault`";

$query = $modx->query($sql);

$rows = array();

if ($query) {
    // loop through the result set and inspect one row at a time
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {

        array_push($rows, $row);

    }
}

echo '<br /><br /><pre>';
        print_r($rows);
echo '</pre>';

$sql = "SELECT * FROM `oracle_vault` WHERE email = '".$email."'";
$stmt= $modx->query($sql);
if ($stmt) {
    $row = $stmt->fetch(PDO_FETCH_ASSOC);
    $modx->setPlaceholders(array(
       'field1' => $row['field1],
       'field2' => $row['field2']
    ),'my.');
}

<input type="hidden" value="[[+my.field1]]">

$sql = "SELECT * FROM `oracle_vault` WHERE email = '".$email."'";
$stmt= $modx->query($sql);
if ($stmt) {
    $row = $stmt->fetch(PDO_FETCH_ASSOC);
    $modx->setPlaceholders(array(
       'field1' => $row['field1'],
       'field2' => $row['field2']
    ),'my.');
}