Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere PHP API » Running PHP test scripts in your web pages

 

Creating PHP test pages

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 [external link] http://us2.php.net/install.

To create a PHP information test page

  1. 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:

    • If you are the System Administrator on a Mac OS X system, use /Library/WebServer/Documents.
    • If you are a Mac OS X user, place the file in /Users/your-user-name/Sites/.
  2. 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.

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

    dbeng11 samples-dir\demo.db
  4. To test that PHP and your web server are working correctly with SQL Anywhere:

    1. Copy the file connect.php from your PHP examples directory to your root web content directory.
    2. From a web browser, access the connect.php page.

      The message Connected successfully should appear.

To create the query page that uses the SQL Anywhere PHP module

  1. Create a file containing the following PHP code in your root web content directory named sa_test.php.

  2. 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 );
    ?>