Skip to content

# Connecting with SQL Server

Following code snippet connect PHP Grid Framework to SQL Server.

    $db_conf = array();
    $db_conf["type"] = "mssqlnative";
    $db_conf["server"] = "(local)\sqlexpress";
    $db_conf["user"] = null;
    $db_conf["password"] = null;
    $db_conf["database"] = "master";

    $g = new jqgrid($db_conf);

    ...

    $g->table = "[msdb].[dbo].[syscategories]";

### Resources

- Sample Code
- You can check this demo in archive `demos/loading/db-layer-sqlsvr.php`

Connecting Azure database:

    $db_conf = array();
    $db_conf["type"] = "mssqlnative";
    $db_conf["server"] = "phpgrid.database.windows.net"; // ip:port
    $db_conf["user"] = "admin_phpgrid";
    $db_conf["password"] = "xxxxx";
    $db_conf["database"] = "griddemo";

    include("../../lib/inc/jqgrid_dist.php");
    $g = new jqgrid($db_conf);

Using PDO for SQL Server Azure:

    $db_conf = array();
    $db_conf["type"] = "pdo";
    $db_conf["server"] = "sqlsrv:Server=phpgrid.database.windows.net";
    $db_conf["user"] = "admin_phpgrid"; // username
    $db_conf["password"] = "xxxxx"; // password
    $db_conf["database"] = "griddemo"; // database

    include("../../lib/inc/jqgrid_dist.php");
    $g = new jqgrid($db_conf);

### Resources

- Sample Code
- You can check this demo in archive `demos/loading/db-layer-sqlsvr-azure.php`