$query = $dbh->exec("TRUNCATE TABLE resources");

$query = "INSERT INTO resources (ip, resource) VALUES ";

for ($i = 0; $i < sizeof($data); $i++)
{
    $resources = $data[$i]['Data']['resources'];
    $ip        = $data[$i]['EndPoint'];

    for ($j = 0; $j < sizeof($resources); $j++)
    {
        $query .= "('" . $ip  . "','" . $resources[ $j ] ."'),";
    }
}

$query = substr( $query, 0, strlen( $query ) - 1 );
$stmt = $dbh->prepare( $query );
$stmt->execute();