#hostingforum.kr
php

// PDO 연결 설정

$dsn = 'sqlsrv:Server=localhost;Database=mydb';

$user = 'myuser';

$password = 'mypassword';



try {

    $pdo = new PDO($dsn, $user, $password);

    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);



    // SQL 문 작성

    $sql = "

        SELECT TOP 1000 * 

        FROM mytable

        ORDER BY id

    ";



    // PDOStatement 객체 생성

    $stmt = $pdo->query($sql);



    // ROWSET 기능 사용

    $stmt->setFetchMode(PDO::FETCH_ASSOC);

    $rowset = $stmt->fetchAll();



    // PDOStatement::nextRowset 사용

    while ($rowset = $stmt->nextRowset()) {

        echo "Next Rowset:
";

        foreach ($rowset as $row) {

            echo $row['id'] . "	" . $row['name'] . "
";

        }

    }

} catch (PDOException $e) {

    echo 'Error: ' . $e->getMessage();

}