The following instructions apply to all configurations.
To test whether PHP is set up properly, the following procedure describes how to create and run a web page that calls phpinfo. phpinfo is a PHP function that generates a page of system setup information. The output tells you whether PHP is working properly.
For information about installing PHP, see http://us2.php.net/install.
To create a PHP information test page
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() ?>
Alternatively, once PHP is properly installed and configured, you can also create a test web page by issuing the following command at a command prompt.
php -I > info.html
This confirms that your installation of PHP and your web server are working together properly.
At a command prompt, enter the following command to start the SQL Anywhere sample database (if you have not already done so):
To test that PHP and your web server are working correctly with SQL Anywhere:
Connected successfully should appear.
To create the query page that uses the SQL Anywhere PHP module
Create a file containing the following PHP code in your root web content directory named sa_test.php.
Insert the following PHP 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 ); ?>
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|