pdo_sqlsrv-dsn(3) [php man page]

PDO_SQLSRV-DSN(3)							 1							 PDO_SQLSRV-DSN(3)

PDO_SQLSRV DSN - Connecting to MS SQL Server and SQL Azure databases

	The PDO_SQLSRV Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix
		- The DSN prefix is sqlsrv:.

	      o APP - The application name used in tracing.

	      o ConnectionPooling - Specifies whether the connection is assigned from a connection pool (1 or TRUE) or not (0 or FALSE).

	      o Database - The name of the database.

	      o Encrypt - Specifies whether the communication with SQL Server is encrypted (1 or TRUE) or unencrypted (0 or FALSE).

	      o Failover_Partner  - Specifies the server and instance of the database's mirror (if enabled and configured) to use when the primary
		server is unavailable.

	      o LoginTimeout - Specifies the number of seconds to wait before failing the connection attempt.

	      o MultipleActiveResultSets - Disables or explicitly enables support for multiple active Result sets (MARS).

	      o QuotedId - Specifies whether to use SQL-92 rules for quoted identifiers (1 or TRUE) or to use  legacy  Transact-SQL  rules  (0	or
		false).

	      o Server - The name of the database server.

	      o TraceFile - Specifies the path for the file used for trace data.

	      o TraceOn - Specifies whether ODBC tracing is enabled (1 or TRUE) or disabled (0 or FALSE) for the connection being established.

	      o TransactionIsolation   -  Specifies  the  transaction  isolation  level.  The  accepted  values  for  this  option  are  PDO::SQL-
		SRV_TXN_READ_UNCOMMITTED, PDO::SQLSRV_TXN_READ_COMMITTED, PDO::SQLSRV_TXN_REPEATABLE_READ, PDO::SQLSRV_TXN_SNAPSHOT, and PDO::SQL-
		SRV_TXN_SERIALIZABLE.

	      o TrustServerCertificate	-  Specifies  whether the client should trust (1 or TRUE) or reject (0 or FALSE) a self-signed server cer-
		tificate.

	      o WSID - Specifies the name of the computer for tracing.

       Example #1

	      PDO_SQLSRV DSN examples

	       The following example shows how to connecto to a specified MS SQL Server database:

	      $c = new PDO("sqlsrv:Server=localhost;Database=testdb", "UserName", "Password");

	       The following example shows how to connect to a MS SQL Server database on a specified port:

	      $c = new PDO("sqlsrv:Server=localhost,1521;Database=testdb", "UserName", "Password");

	       The following example shows how to connecto to a SQL Azure database with server ID 12345abcde. Note that when you  connect  to  SQL
	      Azure with PDO, your username will be UserName@12345abcde (UserName@ServerId).

	      $c = new PDO("sqlsrv:Server=12345abcde.database.windows.net;Database=testdb", "UserName@12345abcde", "Password");

PHP Documentation Group 													 PDO_SQLSRV-DSN(3)

Check Out this Related Man Page

PDO.QUERY(3)								 1							      PDO.QUERY(3)

PDO
::query - Executes an SQL statement, returning a result set as a PDOStatement object

SYNOPSIS

       public PDOStatement PDO::query (string  $statement)

DESCRIPTION

       PDOStatement  PDO::query  (string   $statement,	int   $PDO::FETCH_COLUMN,  int	 $colno)  PDOStatement PDO::query (string  $statement, int
       $PDO::FETCH_CLASS, string  $classname, array   $ctorargs)  PDOStatement	PDO::query  (string   $statement,  int	 $PDO::FETCH_INTO,  object
       $object)

       PDO.query(3)  executes  an  SQL	statement  in  a  single  function  call, returning the result set (if any) returned by the statement as a
       PDOStatement object.

	For a query that you need to issue multiple times, you will realize better performance if you prepare a PDOStatement object using PDO.pre-
       pare(3) and issue the statement with multiple calls to PDOStatement.execute(3).

	If  you  do  not  fetch  all of the data in a result set before issuing your next call to PDO.query(3), your call may fail. Call PDOState-
       ment.closeCursor(3) to release the  database  resources	associated  with  the  PDOStatement  object  before  issuing  your  next  call	to
       PDO.query(3).

       Note

	       Although  this  function  is only documented as having a single parameter, you may pass additional arguments to this function. They
	      will be treated as though you called PDOStatement.setFetchMode(3) on the resultant statement object.

PARAMETERS

	      o $statement
		- The SQL statement to prepare and execute.  Data inside the query should be properly escaped.

RETURN VALUES

       PDO.query(3) returns a PDOStatement object, or FALSE on failure.

EXAMPLES

       Example #1

	      Demonstrate PDO::query

	       A nice feature of PDO.query(3) is that it enables you to iterate over the rowset returned by a successfully executed SELECT  state-
	      ment.

	      <?php
	      function getFruit($conn) {
		  $sql = 'SELECT name, color, calories FROM fruit ORDER BY name';
		  foreach ($conn->query($sql) as $row) {
		      print $row['name'] . "	";
		      print $row['color'] . "	";
		      print $row['calories'] . "
";
		  }
	      }
	      ?>

	      The above example will output:

	      apple   red     150
	      banana  yellow  250
	      kiwi    brown   75
	      lemon   yellow  25
	      orange  orange  300
	      pear    green   150
	      watermelon      pink    90

SEE ALSO

       PDO.exec(3), PDO.prepare(3), PDOStatement.execute(3).

PHP Documentation Group 													      PDO.QUERY(3)

Linux and UNIX Man Pages

pdo_sqlsrv-dsn(3) [php man page]

Check Out this Related Man Page