odbc_do()

(PHP 4, PHP 5, PHP 7)

别名odbc_exec()

说明

此函数是该函数的别名：odbc_exec().

To clear up: the SQL standard requires strings to be inside single quotes: 'string'. It simply does not accept double quotes for this purpose.
Furthermore, in PHP, you can have a single quote inside double quotes: "select a from b where c = 'string'" without the need to escape.

Hey guys,
I used the following code to run normal double quotes inside my SQL queries. Hopefully this will save someone else a headache or two-
<?php
  /**
   * Query Function
   * Allows quoted queries to be sent to SQL
   */
  function query($query, $conn)
  {
    odbc_do($conn, 'SET QUOTED_IDENTIFIER OFF');
    return odbc_do($conn, $query);
  }
?>

i have use this function so many times. it works well for my requirements. ok well done...
<?php
     $sqlstr="SELECT bill_no FROM SCROL";
     $queryresult=odbc_do($conn,$sqlstr);
     odbc_fetch_row($queryresult,$bills);
    // if we want to access the records
    // then we have to write the following code
     
    echo $bills[0];
   
?>
the out put for this will:
 1 
which is actullay first record of resultset.