Create a file in your root web content directory named info.php.

If you are not sure which directory to use, check your web server's configuration file. In Apache installations, the content directory is often called htdocs. If you are using Mac OS X, the web content directory name may depend on which account you are using:

Insert the following code into this file:

<?php phpinfo(); ?>

The PHP function, phpinfo, generates a page of system setup information. This confirms that your installation of PHP and your web server are working together properly.

Copy the file connect.php from the sdk\php\examples directory to your root web content directory. This confirms that your installation of PHP and SQL Anywhere are working together properly.

Create a file in your root web content directory named sa_test.php and insert the following code into this file:

<?php
  $conn = sasql_connect( "UID=DBA;PWD=sql" );
  $result = sasql_query( $conn, "SELECT * FROM Employees" );
  sasql_result_all( $result );
  sasql_free_result( $result );
  sasql_disconnect( $conn );
?>

The sa_test page displays the contents of the Employees table.

Start your web server if it is required.

For example, to start the Apache web server, run the following command from the bin subdirectory of your Apache installation:

apachectl start

On Linux or Mac OS X, set the SQL Anywhere environment variables using one of the supplied scripts.

Depending on which shell you are using, enter the appropriate command to source the SQL Anywhere configuration script from your SQL Anywhere installation directory:

At a command prompt, run the following command to start the SQL Anywhere sample database (if you have not already done so):

dbsrv16 "%SQLANYSAMP16%\demo.db"

To test that PHP and your web server are working correctly with SQL Anywhere, access the test pages from a browser that is running on the same computer as the server: