Create and run several web pages that test whether PHP is set up properly.
Task
This procedure applies to all configurations.
- 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.
- 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, set the SAP Sybase IQ environment variables using one of the
supplied scripts.
Depending on which shell you are using, enter the appropriate command to source the
SAP Sybase IQ configuration script from your
SAP Sybase IQ installation directory:
In this shell... |
...use this command |
sh, ksh, or bash |
. /bin32/sa_config.sh |
csh or tcsh |
source /bin32/sa_config.csh |
- At a command prompt, start the iqdemo.db sample database.
- To test that PHP and your web server are working correctly with
SAP Sybase IQ, access the test pages from a browser that
is running on the same computer as the server:
For this test page... |
Use this URL... |
info.php |
http://localhost/info.php |
connect.php |
http://localhost/connect.php |
sa_test.php |
http://localhost/sa_test.php |
The info page displays the output from the phpinfo() call.
The connect page displays the message Connected successfully.
The sa_test page displays the contents of the Employees table.