PHP Script Development

This section describes how to write PHP scripts that use the SAP Sybase IQ PHP extension to access SAP Sybase IQ databases.

The source code for these and other examples is located in the SDK\PHP\Examples subdirectory of your SAP Sybase IQ installation.

• How to Connect to a Database Using PHP
  To make a connection to a database, pass a standard SAP Sybase IQ connection string to the database server as a parameter to the sasql_connect function. The <?php and ?> tags tell the web server that it should let PHP execute the code that lies between them and replace it with the PHP output.
• How to Retrieve Data from a Database Using PHP
  One use of PHP scripts in web pages is to retrieve and display information contained in a database. The following examples demonstrate some useful techniques.
• Web Forms
  PHP can take user input from a web form, pass it to the database server as a SQL query, and display the result that is returned. The following example demonstrates a simple web form that gives the user the ability to query the sample database using SQL statements and display the results in an HTML table.
• BLOBs in PHP Applications
  SAP Sybase IQ databases can store any type of data as a binary large object (BLOB). If that data is of a type readable by a web browser, a PHP script can easily retrieve it from the database and display it on a dynamically generated page.