it.vsesobe.ru

$host = '127.0.0.1';
    $db   = 'test';
    $user = 'root';
    $pass = '';
    $charset = 'utf8';

    $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
    $opt = [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   => false,
    ];
    $pdo = new PDO($dsn, $user, $pass, $opt);


/*$stmt = $pdo->query('SELECT name FROM post');
while ($row = $stmt->fetch())
{
    echo $row['name'] . "\n";
    echo '<br>';
}*/

$id=1;

$stmt = $pdo->prepare('SELECT name FROM post WHERE id = ?');
$stmt->execute(array($id));

/*$stmt = $pdo->prepare('SELECT name FROM post WHERE id = :id');
$stmt->execute(array('id' => $id));*/
while ($row = $stmt->fetch())
{
    echo $row['name'] . "\n";
    echo '<br>';
}