Jump to content

Sybase Connection/ Display issues


ellchr3

Recommended Posts

I'm trying to connect to Sybase IQ and just display two columns of a table.  When I try to view the html page it shows some of the php code (attached).  The code is below.  I'm still a noob, especially to the sybase iq part .  I have also verified that the dll exists in the php/ext directory and that it is uncommented in the php.ini .  I have stopped and started Apache as well after I uncommented the dll from php.ini.  

 

  <html>

<body>
<?php
$con = sybase_connect("X","X","X");
if (!$con)
  {
  die('Could not connect: ' . sybase_set_message_handler());
  }
 
sybase_select_db("X", $con);
 
$query = sybase_query("SELECT provider_full_name, provider_id FROM crr.provider_dim");
 
echo '<center>';
echo '<table border="1" cellspacing="0" cellpadding="10">';
echo "\n<tr><td bgcolor='#CCCCCC'>Full Name</td><td>Provider_ID</td></tr>\n";
 
while($row = sybase_fetch_array($query))
  {
  echo "\n<tr><td bgcolor='#CCCCCC'>".$row['provider_full_name']."</td><td>".$row['provider_id']."</td></tr>\n";
  echo "<br />";
  }
 
 
sybase_close($con);
?> 
</body>
</html>
 

post-125972-0-54075800-1364914391_thumb.png

Link to comment
https://forums.phpfreaks.com/topic/276434-sybase-connection-display-issues/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.