connecting php to ms sql server 2005

[sukanya.paul]

hi i h to connect php to ms sql server 2005 and i hv no clue how to do it.. can some1 pls help.. i'll be very greatful
thank in advance..Suk

[codeexploiter]

http://msdn2.microsoft.com/en-us/library/bb264561.aspx
http://in.php.net/mssql

[sukanya.paul]

well i found those links using google but could not really follow them. i'm pretty new to php n was using mysql till now.. can u help with anythin more?please??

[codeexploiter]

Have you got the following code in which they are demonstrating the connection and retrieval data using PHP from an MS SQL DB



<?php
/*Connect to the local server using Windows authentication and specify
the AdventureWorks database as the database in use. */
$serverName = "(local)";
$connectionInfo = array( "Database"=>"AdventureWorks");
if( !($conn = sqlsrv_connect( $serverName, $connectionInfo)))
{
echo "Could not connect.\n";
die( print_r( sqlsrv_errors(), true));
}

/* Set up the T-SQL query. */
$tsql = "SELECT ReviewerName,
ReviewDate,
Rating,
Comments
FROM Production.ProductReview
WHERE ProductID = ?
ORDER BY ReviewDate DESC";

/* Set the parameter value. */
$productID = 709;
$params = array( $productID);

/* Execute the query. */
if( !($stmt = sqlsrv_query($conn, $tsql, $params)))
{
echo "Error in statement execution.\n";
die( print_r( sqlsrv_errors(), true));
}

/* Retrieve and display the data. The first and third fields are
retrieved according to their default types, strings. The second field
is retrieved as a string with 8-bit character encoding. The fourth
field is retrieved as a stream with 8-bit character encoding.*/
while ( sqlsrv_fetch( $stmt))
{
echo "Name: ".sqlsrv_get_field( $stmt, 1 )."\n";
echo "Date: ".sqlsrv_get_field( $stmt, 2,
SQLSRV_PHPTYPE_STRING( SQLSRV_ENC_CHAR))."\n";
echo "Rating: ".sqlsrv_get_field( $stmt, 3 )."\n";
echo "Comments: ";
$comments = sqlsrv_get_field( $stmt, 4,
SQLSRV_PHPTYPE_STREAM(SQLSRV_ENC_CHAR));
fpassthru( $comments);
echo "\n";
}

/* Free statement and connection resources. */
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>

[sukanya.paul]

its giving me the following error:

Fatal error: Call to undefined function sqlsrv_connect()

i think this code is for sql server 2000. i need to connect to 2005