<?php
$db_host = 'localhost';
$db_name = "dados";
$mysql_charset = "utf8";
$db_username = "root";
$db_password = "";
$teste = 1;

//conexão com o host
try{
  $PDO = new PDO('mysql:host='.$db_host.';dbname='.$db_name.';charset='.$mysql_charset, $db_username, $db_password);
}catch(PDOException $e){
  echo($e->getMessage());
}

$stmt = $PDO->prepare("SELECT * FROM thiago WHERE id = :id");
$stmt->bindParam(':is', $teste);
$stmt->execute();
$exec = $stmt->fetchAll();

foreach ($exec as $row) {
?>

<?php
$prosMostrar = $row['pros'];
$contrasMostrar = $row['contras'];
$ratingMostrar = $row['rating'];
?>
<?php echo "Nome: ".$nomeMostrar; ?><br>
<?php echo "Pros: ".$prosMostrar; ?><br>
<?php echo "Contras: ".$contrasMostrar; ?><br>
<?php echo "Rating: ".$ratingMostrar; ?><br>

<?php
}
?>