PHP + MsSQL

[choco.cheese]

---

Mga master? unsay mga paagi para ma connect nako ang duha? nag dagan na ang akong mssql Through SQL Express 2005.. any suggestions?

[choco.cheese]

Sure ko mag ask mo nganu MSSQL ako gi pares sa PHP...


ani na xa.. Gipaconvert mi ug website from COLDFUSION + MsSQL to PHP + MsSQL


im not new to MsSQL pero .NET man to akong gamit oy.. hahaha

mssql_connect sab kay dili maka connect..

[ingkiang]

try daw use ug PDO bro...basin sayop imong connection string...

[messerchtmitt]

You can use the mySqli or PDO but I would suggest using PDO because it offers exceptions where you can put it in try catch. PHP Data Objects is included with PHP 5.1, provides OOP interface. It also provides a consistent interface that's portable between other database servers such as Oracle, DB2, MS SQL Server, and PostgreSQL. The code looks like this,

 
try {

     $db = new PDO($dsn, $username, $password, $options);

}catch (PDOExceptions $e) {

     $error_message = $e->getMessage();
     exit;
}

Where your $dsn should look like this "sqlsrv:server=hostname_or_ip;Database=database_na me;"

As for the "$options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);"

Hope this help...

[choco.cheese]

try daw use ug PDO bro...basin sayop imong connection string...

dili nia mabasa ang function nga mssql_connect taya hasola ane oy

[ingkiang]

post daw sa error message bro...

[ondoy]

try daw check if na load nimo ang driver?..padagani ug phpinfo daw

[choco.cheese]

post daw sa error message bro...

mao ning error Call to undefined function mssql_connect() in C:\xampp\htdocs\eodev\test.php






nag try kog Uncomment sa mga mssql sa php.ini. tas ga download kog .dll para sa mssql dili man gihapon.. dili ba kaha ni sa OS? win 7 here.

[choco.cheese]

try daw check if na load nimo ang driver?..padagani ug phpinfo daw

naka DL nakog .dll para sa mssql. then pag phpinfo nako wala may mssql.

unsay lain paagi ani?

[ingkiang]

naka DL nakog .dll para sa mssql. then pag phpinfo nako wala may mssql.

unsay lain paagi ani?

adto sa php.ini na file bro, then e uncomment ang mssql.dll na extension...kuhaa lang ang semicolon

sample
;extension=php_mssql.dll --> extension=php_mssql.dll
;extension=php_pdo_mssql.dll --> extension=php_pdo_mssql.dll