Conexão adodb com SQL Server
| From: | Edson David | Date: | Tue, 01 Apr 2014 12:07:35 +0000 |
| Subject: | Conexão adodb com SQL Server | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-323126@lists.php.net to get a copy of this message | ||
Guys, I'm trying to make the connection to the SQL Server database using adodb, but when I run
the lines below, the page is blank, not returning any rows. The problem from what I dectetei, is
when the connection attempt is made with the server and the table data.
Thank you in advance.
<?php
// Include the library
include('adodb/adodb.inc.php');
$conn = &ADONewConnection('mssql');
$conn->Connect('192.168.1.2:1433','','','siscom'); //
Connection to the database
$sql = "SELECT * FROM agenda"; // Select the table columns calendar
$consulta = $conn->Execute($sql);
// Displaying Data
echo("<table width='250' border='1'>
<tr>
<td>ID</td>
<td>Name</td>
</tr>");
while(!$query->EOF) {
echo("<tr>
<td>" . $query->fields[0] . "</td>
<td>" . $query->fields[1] . "</td>
</tr>");
$query->MoveNext();
}
// Number of table records
$tot_register = $consulta->RecordCount();
echo("<tr><td colspan='2'> Total record (s): " . $tot_register .
"</td></tr>");
echo("</table>");