PHP 连接 DNS

最新推荐文章于 2024-06-11 09:35:47 发布

lzquan2010

最新推荐文章于 2024-06-11 09:35:47 发布

阅读量302

点赞数

CC 4.0 BY-SA版权

分类专栏： PHP 文章标签： PHP SQL UP J# Microsoft

本文链接：https://blog.youkuaiyun.com/lzquan2010/article/details/83320743

PHP 专栏收录该内容

15 篇文章

订阅专栏

本文介绍了如何使用DSN（数据源名称）和DSN-less连接到数据库的方法。通过PHP示例展示了如何建立连接、执行查询并显示结果。同时对比了两种连接方式的特点。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

DSN and DSN-less connections

DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. If you do not know how to set up a system DSN read our tutorial How to set up a system DSN .

For our example below lets assume that our DSN points to an Access database called 'examples.mdb' and that we will be selecting records from the table 'cars'.

<?php

//connect to a DSN "myDSN"
$conn = odbc_connect('myDSN','','');

if ($conn)
{
//the SQL statement that will query the database
$query = "select * from cars";
//perform the query
$result=odbc_exec($conn, $query);

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

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

//fetch tha data from the database
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";
?>

Remember that 'myDSN' above is name of the DSN. Also note that you can change the table name from 'cars' to the name of your table and point the DSN to whatever database you like. One other thing to remember is that you can set up a DSN on your own machine though if you are using a hosting company you may have to ask the webmaster.

DSN-less connection

DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. We will now see how to connect to a database via PHP using Connection String in place of DSN name.

<?php

//create an instance of the ADO connection object
$conn = new COM ("ADODB.Connection")
or die("Cannot start ADO");

//define connection string, specify database driver
$connStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source= c:\inetpub\wwwroot\db\examples.mdb";
  $conn->open($connStr); //Open the connection to the database

//declare the SQL statement that will query the database
$query = "SELECT * FROM cars";

//execute the SQL statement and return records
$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) //carry on looping through while there are records
{
    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;
?>