在php表中显示MSSQL选择数据

发布时间：2020-12-13 17:40:13 所属栏目：PHP教程来源：网络整理

导读：我很遗憾,我错过了一些简单的事情.这是我第一次从MSSQL服务器提取数据并使用php在表中显示它.我以前用 mysql做过这个,但是不能让它与mssql一起工作.这是我目前的代码： ?php $myServer = "server"; $myUser = "user"; $myPass = "password"; $myDB = "mssqld

我很遗憾,我错过了一些简单的事情.这是我第一次从MSSQL服务器提取数据并使用php在表中显示它.我以前用 mysql做过这个,但是不能让它与mssql一起工作.这是我目前的代码：

<?php
 $myServer = "server";
 $myUser = "user";
 $myPass = "password";
 $myDB = "mssqldb"; 

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

 //select a database to work with
      $selected = mssql_select_db($myDB,$dbhandle)
          or die("Couldn't open database $myDB"); 

 //declare the SQL statement that will query the database
     $query = "SELECT col1,col2 ";
     $query .= "FROM sqltable ";

 //execute the SQL query and return records
     $result = mssql_query($query)
         or die('A error occured: ' . mysql_error());

 //Show results in table

 $o = '<table id="myTable">
         <thead>
         <tr>
         <th>Col 1</th>
         <th>Col 2</th>
         </tr>
         </thead><tbody>';

      while ( $record = mssql_fetch_array($result) )
          {
              $o .= '<tr><td>'.$col1.'</td><td>'.$col2.'</td></tr>';
          }               

       $o .= '</tbody></table>';

       echo $o;

    //Show result from sql table separated by comma (commented out)
       /* while ( $record = mssql_fetch_array($result) )
        {
            echo $record["col1"] . "," . $record["col2"] . "<br />";
        } */

    //free result set memory
        mssql_free_result($result);

    //close the connection
        mssql_close($dbhandle);
    ?>

解决方法

while ( $record = mssql_fetch_array($result) )
          {
              $o .= '<tr><td>'.$record ['col1'].'</td><td>'.$record ['col2'].'</td></tr>';
          }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!