update page now

odbc_do

(PHP 4, PHP 5, PHP 7, PHP 8)

odbc_doAlias of odbc_exec()

Description

This function is an alias of: odbc_exec() .

Found A Problem?

Learn How To Improve This PageSubmit a Pull RequestReport a Bug
+add a note

User Contributed Notes 3 notes

up
0
scottmweaver
18 years ago
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);
 }
?>
up
0
phil.nyc
19 years ago
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.
up
-1
yashkhopade at hotmail dot com
22 years ago
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.
+add a note

AltStyle によって変換されたページ (->オリジナル) /