Re: Conexão adodb com SQL Server

On Tue, Apr 1, 2014 at 11:28 AM, Jim Lucas <lists@cmsws.com> 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 >