try
{
//$con = new PDO("odbc:Driver={SQL Server};Server=192.168.1.1;Database=time_trax",'dipen','dipen123');
$con = new PDO("odbc:Driver={SQL Server};Server=192.168.1.1;Database=DBTRAX",'govinda','nepal123');
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
//$sql ="SELECT * FROM EMP_DETAIL WHERE EMP_ID = 1";
$sql = "SELECT
dbo.EMP_DETAIL.EMP_ID,
dbo.EMP_DETAIL.EMP_TITLE,
dbo.EMP_DETAIL.EMP_FIRSTNAME
FROM [dbo].[EMP_DETAIL]
WHERE EMP_ID = '1'" ;
$sth = $con->prepare($sql);
$sth->execute();
$result = $sth->fetchAll();
return $result;
}
catch(Exception $e)
{
return "Error occured" . $e;
}
Wednesday, June 29, 2016
Connecting mssql with php
Subscribe to:
Posts (Atom)