On Tue, Apr 1, 2014 at 11:28 AM, Jim Lucas <lists@xxxxxxxxx> wrote:
> On 04/01/2014 05:07 AM, Edson David wrote:
>>
>> 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
>
>
> As the other Jim said, enable error reporting and display_errors and you
> might get something. Be warned, if it a parse error that is causing this
> issue, you will need to enable the above two settings in your php.ini file
> instead of placing those options in your script.
>
> What I do sometimes when doing the above it too much hassle is to remove the
> all but the first line, then add back each line. Always keep an echo
> '!done!'; at the end to make sure that the script is finishing. My guess is
I myself am not a great php programmer, so I try to use the "or
die()" thingie (kinda like try/except in python?) so I know a given
statement worked or went boink. For instance, if it did not connect to
the database, why continue?
> going to be that it is something in your include'd file or the
> adonewconnection() function call.
>
>
>> 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>");
>>
>
>
> --
> Jim Lucas
>
> http://www.cmsws.com/
> http://www.cmsws.com/examples/
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
