Connection between PHP and SQL server using WAMP new approaches

Question

what is the best way for create a connection between PHP and SQL server that are seperate?(two server: server a SQL and server b PHP) notice that I use wamp.

I read some articles like below but I want to know is there any new idea?

I test this code that works perfectly:

try{
  $user = 'user';
  $password = 'pass';
  $server="localhost";//or server IP
  $database="database";
  $conn = odbc_connect("Driver={SQL Server};Server=$server;Database=$database;", $user, $password);
} catch (PDOException $e) {
  echo "Failed : " . $e->getMessage() . "\n";
  exit;
}

Use PDO with a conenction string that is configured to connect to ANY sql server... — Cagy79
– Cagy79, Commented Dec 14, 2016 at 15:21
Possible duplicate of Connect to SQL Server through PDO using SQL Server Driver — ICE
– ICE, Commented Dec 20, 2016 at 19:51

sdi · Accepted Answer · 2016-12-27 04:29:56Z

I use PDO_ODBC Method:

1- Install ODBC on server that has wamp and enable PHP_PDO_ODBC extension on your wamp

2- Use this code that supports UTF-8:

try{
  $hostname = "IP";
  $dbname = "database";
  $username = "username";
  $pw = "password";

  $pdo = new PDO ("odbc:Driver={SQL Server Native Client 10.0};Server=$hostname;Database=$dbname; Uid=$username;Pwd=$pw;");

} catch (PDOException $e) {
  echo "Failed : " . $e->getMessage() . "\n";
  exit;
}

$query = $pdo->prepare("select field_name from table");
$query->execute();

for($i=0; $row = $query->fetch(); $i++){
  echo iconv("CP1256","UTF-8",  $row['field_name'])."<br>";
}

3- replace these Items with yours:

IP-database-username-password-field_name-table

4- sometimes you need use "SQL SERVER" instead of "SQL Server Native Client 10.0" and sometimes you need use "IP,port" instead of "IP" and sometimes you need use "ISO-8859-6" instead of "CP1256".

Cagy79 · Accepted Answer · 2016-12-15 12:40:56Z

1

From the PHP manual: http://php.net/manual/en/pdo.construct.php

Example #1 Create a PDO instance via driver invocation

<?php
/* Connect to a SQL Server database using driver invocation */
$dsn = "sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password";

try {
    $dbh = new PDO($dsn);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

?>

Just change the HOST ip to the IP and port of your mysql server.

edited Dec 15, 2016 at 12:40

answered Dec 14, 2016 at 15:23

Cagy79

1,6201 gold badge19 silver badges25 bronze badges

4 Comments

rezaSefiddashti Over a year ago

thanks.I have a question: do you connect to mysql? I want to connect to sql server.

Striezel Over a year ago

The procedure for a Microsoft SQL Server is similar with PDO, however the DSN is different. Take a look at the documentation for PDO connections with MSSQL: php.net/manual/en/ref.pdo-sqlsrv.connection.php

Cagy79 Over a year ago

Edited the answer to reflect sqlserver instead of mysql. Please accept the answer if it suited your needs.

rezaSefiddashti Over a year ago

I use a pdo ODBC method for connect to sql server. and I think you should install a software like odbc for sql server and then connect to it. @Cagy79 thanks

Collectives™ on Stack Overflow

Connection between PHP and SQL server using WAMP new approaches

2 Answers 2

Comments

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related