Before you can run the sample, you will need to create the employee table in your Sybase account.
create table employee ( id varchar(5), name varchar(30), primary key (id))
In this example, we assume the Sybase account id is 'example' and password is 'sample'.
<?php // connect and set option $str = "UID=example;PWD=sample;". "commlinks=tcpip{host=sundbl.comp.nus.edu.sg};eng=course"; $conn = sqlanywhere_connect($str); sqlanywhere_set_option($conn, 'auto_commit', 'off'); // insert if (sqlanywhere_execute($conn, "insert into employee values ('10', 'John')")) echo "<p>Successfully added an employee.</p>"; else echo "<p>Error adding an employee.</p>"; // select $result = sqlanywhere_query($conn, "select id, name from employee"); while ($row = sqlanywhere_fetch_array($result)) { echo "<p>Id = ", $row[id], ", Name = ", $row[name], "</p>\n"; } // delete if (sqlanywhere_execute($conn, "delete from employee")) echo "<p>Succcessfully deleted all employees.</p>"; else echo "<p>Error deleting employees.</p>"; // commit sqlanywhere_commit($conn); // disconnect sqlanywhere_disconnect($conn); ?>