I always check my scripts with php -l filename before tearing my hair out
over an error. It catches syntax errors before they bite you.
Jomali
On Tue, Apr 1, 2014 at 12:18 PM, Jim Giner <jim.giner@xxxxxxxxxxxxxxxxxx>wrote:
> On 4/1/2014 12:10 PM, Mauricio Tavares wrote:
>
>> 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
>>>
>>> Yes - but even that can fail you if a syntax error occurs prior to it
> and causes the script to stop or never even begin. The kind of coding you
> mention is a necessary and proper thing but during development one should
> always have error checking turned on to catch those nasty little glitches
> that occur constantly.
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
