How to use PHP to connect to sql server

Question

I want to use PHP to connect to sql server database   I installed xampp 1 7 0 php 5 2  and SQLSRV20   I ve added the extensions in php ini and I get this error   Warning  mssql connect    function mssql-connect   Unable to connect to  server  10 85 80 229 in C  xampp htdocs xampp test php on line 07   Code    lt  php  myServer    10 85 80 229    myUser    root    myPass    pass    myDB    testdb     dbhandle   mssql connect  myServer   myUser   myPass    or die  Couldn t connect to SQL Server on  myServer       gt    What does this error message mean and how do I connect to SQL Server

User · Answer

Try this one     servername    10 85 80 229    username    root    password    pass       Create connection  conn   mysqli connect  servername   username   password       Check connection if    conn    die  Connection failed      mysqli connect error       echo  Connected successfully

User · Answer

Use localhost instead of your IP address   e g    myServer    localhost     And also double check your mysql username and password

User · Answer

server name    your server name     database name    your database name    try         conn   new PDO  sqlsrv Server  server name Database  database name ConnectionPooling 0    user name    password        conn- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION      catch PDOException  e          e- gt getMessage

User · Answer

dbhandle   sqlsrv connect  myServer   myUser   myPass    or die  Couldn t connect to SQL Server on  myServer       Hope it help

User · Answer

Try this to be able to catch the thrown exception    server name    your server name    database name    your database name   try       conn   new PDO  sqlsrv Server  server name Database  database name ConnectionPooling 0    user name    password        conn- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION     catch PDOException  e         e- gt getMessage

User · Answer

I ve been having the same problem  well I hope the same    Anyways it turned out to be my version of ntwdblib dll  which was out of date in my PHP folder   http   dba fyicenter com faq sql server 2 Finding ntwdblib dll Version 2000 80 194 0 html

User · Answer

enable mssql in php ini   extension php mssql dll  to  extension php mssql dll

User · Answer

lt  php    serverName    ServerName     uid    sqlusername       pwd    sqlpassword      databaseName    DBName      connectionInfo   array   UID   gt  uid                                                        PWD   gt  pwd                                                        Database   gt  databaseName        Connect using SQL Server Authentication        conn   sqlsrv connect   serverName   connectionInfo       tsql    SELECT id  FirstName  LastName  Email FROM tblContact         Execute the query         stmt   sqlsrv query   conn   tsql      if    stmt              echo  Statement executed  lt br gt  n          else             echo  Error in statement execution  n          die  print r  sqlsrv errors    true              Iterate through the result set printing a row of data upon each iteration       while   row   sqlsrv fetch array   stmt  SQLSRV FETCH NUMERIC              echo  Col1     row 0    n          echo  Col2     row 1    n          echo  Col3     row 2    lt br gt  n          echo  ----------------- lt br gt  n             Free statement and connection resources       sqlsrv free stmt   stmt     sqlsrv close   conn       gt      http   robsphp blogspot ae 2012 09 how-to-install-microsofts-sql-server html

User · Answer

Try this code   serverName    serverName sqlexpress     serverName instanceName  connectionInfo   array   Database   gt  dbName    UID   gt  userName    PWD   gt  password     conn   sqlsrv connect   serverName   connectionInfo

User · Answer

first download below software https   www microsoft com en-us download details aspx id 30679 - need to install  https   www microsoft com en-us download details aspx id 20098 - when you run this software   it will extract dll file  and paste two dll file php pdo sqlsrv 55 ts dll extension php sqlsrv 55 ts dll  this location C  wamp bin php php5 6 40 ext   pls make sure your current version  2 edit php ini file add below line extension php pdo sqlsrv 55 ts dll extension php sqlsrv 55 ts dll Please refer screenshort  add dll in your php ini file

User · Answer

for further investigation  print out the mssql error message    dbhandle   mssql connect  myServer   myUser   myPass  or die  Could not connect to database    mssql get last message        It is also important to specify the port  On MS SQL Server 2000  separate it with a comma    myServer    10 85 80 229 1443     or    myServer    10 85 80 229 1443

User · Answer

if your using  sqlsrv connect you have to download and install MS sql driver for your php  download it here http   www microsoft com en-us download details aspx id 20098 extract it to your php folder or ext in xampp folder then add this on the end of the line in your php ini file  extension php pdo sqlsrv 55 ts dll extension php sqlsrv 55 ts dll   im using xampp version 5 5 so its name  php pdo sqlsrv 55 ts dll  amp   php sqlsrv 55 ts dll  if you are using xampp version 5 5  dll files is not included in the link   hope it helps

User · Answer

For the following code you have to enable mssql in the php ini as described at this link  http   www php net manual en mssql installation php   myServer    10 85 80 229    myUser    root    myPass    pass    myDB    testdb     conn   mssql connect  myServer  myUser  myPass   if    conn       die  Not connected       mssql get last message         db selected   mssql select db  myDB   conn   if    db selected       die   Can  t use db       mssql get last message

User · Answer

MS SQL connect  to php  Install the drive from microsoft link https   www microsoft com en-us download details aspx id 20098  After install you will get some files  Store it in your system temp folder  Check your php version   thread or non thread   and window bit - 32 or 64  Thread or non thread   this is get you by phpinfo      According to your system  amp  xampp configration  php version and all   copy 2 files  php sqlsrv  amp  php pdo sqlsrv  to xampp php ext folder    Add to php ini file extension php sqlsrv 72 ts x64   php sqlsrv 72 ts x64 dll  is your file which your copy in 4th step    extension php pdo sqlsrv 72 ts x64   php pdo sqlsrv 72 ts x64 dll  is your file which your copy in 4th step     Next Php Code  serverName   quot DESKTOP-me MSSQLSERVER01 quot    servername instanceName     Since UID and PWD are not specified in the  connectionInfo array     The connection will be attempted using Windows Authentication   connectionInfo   array  quot Database quot   gt  quot testdb quot   quot CharacterSet quot   gt  quot UTF-8 quot     conn   sqlsrv connect   serverName   connectionInfo   if   conn       echo  quot Connection established  quot    else  echo  quot Connection could not be established  quot   die  print r  sqlsrv errors    true         sql    quot INSERT INTO dbo master   name   VALUES   test   quot    sql    quot SELECT    FROM dbo master quot    stmt   sqlsrv query   conn   sql    while   row   sqlsrv fetch array   stmt  SQLSRV FETCH ASSOC      echo  row  id    quot    quot   row  name    quot  quot     sqlsrv free stmt   stmt

[php] How to use PHP to connect to sql server

Examples related to php

Examples related to sql

Examples related to sql-server

Examples related to database-connection