CSPP552: Internet Programming, PHP part 8

Access to Sybase databases with PHP

You may have already seen something similar to this with Sybase in Leo's class
Function names begin with sybase_
Connect with sybase_connect(); arguments are serverhost, user, and password:
$connection = sybase_connect("skunk", "bri", "blahblah");
Select a database with sybase_select_db():
sybase_select_db("database_name", $connection);
Run some SQL command with sybase_query():
$result = sybase_query("SQL_command", $connection);
Grab a row with sybase_fetch_array():
$row = sybase_fetch_array($result);
In the above, access fields with $row["fieldname"]. etc.
$row evaluates to `false' when there are no more rows to fetch.
Don't use sybase_fetch_row(), seems to be a bug somewhere if you have too many fields.

Example:

<?php
 $c = sybase_connect("skunk", "bri", "blahblah");
 sybase_select_db("pubs2", $c);
 $stuff = sybase_query("select * from titles");
 while ($row = sybase_fetch_array($stuff)) {
    print "$row[title] ..... \$$row[price]<br>";
 }
?>

"; } ?>