Switch to standard view 
  Sybase logo
 
 
 



Description:
Retrieving data is done by using sasql_query() to execute a SELECT statement. The result set can be displayed in HTML format by passing it to sasql_result_all().

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<?php
    #*********************************************************************     
    # Description:
    # Retrieving data is done by using sasql_query() to execute a SELECT
    # statement. The result set can be displayed in HTML format by passing
    # it to sasql_result_all().
    #
    #*********************************************************************
 
    # Connect using the default user ID and password
    $conn = sasql_connect ( "UID=DBA;PWD=sql" ) ;
    if ( ! $conn ) {
        echo "sasql_connect failed \n " ;
    } else {
        echo "Connected successfully \n " ;
        # Execute a SELECT statement
        $result = sasql_query ( $conn , "SELECT * FROM Customers" ) ;
        if ( ! $result ) {
            echo "sasql_query failed!" ;
        } else {
            echo "query completed successfully \n " ;
            # Generate HTML from the result set
            sasql_result_all ( $result ) ;
            sasql_free_result ( $result ) ;
        }
        # Close connection
        sasql_close ( $conn ) ;
    }
?>

 

Copyright 1994-2009 iAnywhere Solutions, Inc. All rights reserved. This sample code is provided AS IS, without warranty or liability of any kind.
You may use, reproduce, modify and distribute this sample code without limitation, on the condition that you retain the foregoing copyright notice and disclaimer as to the original iAnywhere code.



Back to Top
© Copyright 2010, Sybase Inc.