#hostingforum.kr
php

bool sqlsrv_send_stream_data ( resource $stmt, string $data )

#hostingforum.kr
php

// SQL Server 연결

$server = 'localhost';

$database = 'mydb';

$username = 'myuser';

$password = 'mypassword';



$connectionInfo = array( "Database"=>$database, "UID"=>$username, "PWD"=>$password);

$conn = sqlsrv_connect($server, $connectionInfo);



if (!$conn) {

    echo "Connection could not be established.
";

    exit;

}



// SQL 명령어 실행

$sql = "INSERT INTO mytable (id, name, age) VALUES (?, ?, ?)";

$params = array(1, 'John Doe', 30);

$stmt = sqlsrv_query($conn, $sql, $params);



if (!$stmt) {

    echo "Error executing query.
";

    exit;

}



// 데이터 전송

$data = file_get_contents('data.txt');

sqlsrv_send_stream_data($stmt, $data);



// 결과셋 반환

$result = sqlsrv_fetch_array($stmt);



// 결과셋 출력

echo "id: " . $result['id'] . "
";

echo "name: " . $result['name'] . "
";

echo "age: " . $result['age'] . "
";



// 리소스 닫기

sqlsrv_free_stmt($stmt);

sqlsrv_close($conn);