• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to Register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

How to connect MS SQL database server with PHP?

Collapse

Unconfigured Ad Widget

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Chris85
    replied
    Re: How to connect MS SQL database server with PHP?

    I also need help in same problem.and this thread help me.thanks to all.

    Last edited by admin; 01-11-2011, 09:50 AM.

    Leave a comment:


  • Shane
    replied
    Re: How to connect MS SQL database server with PHP? Without DNS

    Sample 3: DSN Less Connection String

    <?php
    $myServer = "localhost";
    $myUser = "your_name";
    $myPass = "your_password";
    $myDB = "examples";

    $conn = new COM ("ADODB.Connection")
    or die("Cannot start ADO");

    $connStr = "PROVIDER=SQLOLEDB;SERVER=".$myServer.";UID=".$myU ser.";PWD=".$myPass.";DATABASE=".$myDB;
    $conn->open($connStr); //Open the connection to the database

    $query = "SELECT * FROM cars";

    $rs = $conn->execute($query);

    $num_columns = $rs->Fields->Count();
    echo $num_columns . "<br>";

    for ($i=0; $i < $num_columns; $i++) {
    $fld[$i] = $rs->Fields($i);
    }

    echo "<table>"; while (!$rs->EOF)
    {
    echo "<tr>";
    for ($i=0; $i < $num_columns; $i++) {
    echo "<td>" . $fld[$i]->value . "</td>";
    }
    echo "</tr>";
    $rs->MoveNext(); //move on to the next record
    }


    echo "</table>";

    //close the connection and recordset objects freeing up resources
    $rs->Close();
    $conn->Close();

    $rs = null;
    $conn = null;
    ?>

    Thanks,

    Shane G.
    AccuWebHosting.Com

    Leave a comment:


  • Shane
    replied
    Re: How to connect MS SQL database server with PHP? - With DSN Connection

    Sample 2: With DSN Connection

    <?php

    $conn = odbc_connect('myDSN','','');

    if ($conn)
    {
    $query = "select * from cars";
    $result=odbc_exec($conn, $query);

    echo "<table border=\"1\"><tr>";

    $colName = odbc_num_fields($result);
    for ($j=1; $j<= $colName; $j++)
    {
    echo "<th>";
    echo odbc_field_name ($result, $j );
    echo "</th>";
    }

    while(odbc_fetch_row($result))
    {
    echo "<tr>";
    for($i=1;$i<=odbc_num_fields($result);$i++)
    {
    echo "<td>";
    echo odbc_result($result,$i);
    echo "</td>";
    }
    echo "</tr>";
    }

    echo "</td> </tr>";
    echo "</table >";

    //close the connection
    odbc_close ($conn);
    }
    else echo "odbc not connected";
    ?>

    Thanks,

    Shane G.
    AccuWebHosting.Com

    Leave a comment:


  • Shane
    started a topic How to connect MS SQL database server with PHP?

    How to connect MS SQL database server with PHP?

    Hello All,

    In order to connect MS SQL server with front end as PHP one need to use below mentioned sample connection code:

    <?php
    $myServer = "localhost";
    $myUser = "database_username";
    $myPass = "User_password";
    $myDB = "Database_Name";

    $dbhandle = mssql_connect($myServer, $myUser, $myPass)
    or die("Couldn't connect to SQL Server on $myServer");

    $selected = mssql_select_db($myDB, $dbhandle)
    or die("Couldn't open database $myDB");

    $query = "SELECT id, name, year ";
    $query .= "FROM cars ";
    $query .= "WHERE name='BMW'";

    $result = mssql_query($query);

    $numRows = mssql_num_rows($result);
    echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";

    while($row = mssql_fetch_array($result))
    {
    echo "<li>" . $row["id"] . $row["name"] . $row["year"] . "</li>";
    }
    mssql_close($dbhandle);
    ?>

    That’s it!

    Thanks,

    Shane G.
    AccuWebHosting.Com
Working...
X

Sign up for a News Letter Click here to sign up