|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg  odbc_do
Synonym for odbc_exec
(PHP 4, PHP 5)
Examples ( Source code ) » odbc_do
Code Examples / Notes » odbc_dophil.nyc
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. nmaskell
Some of you may be having problems with Access SQL. I got "Too few parameters" many times before I figured this out. MS Access does not like double quotes in a SQL string like this: <?php $sql = 'INSERT INTO table (field1,field2,field3,field4) VALUES ("text value 1", "text 2",3,"text 4")'; ?> This resulted in an obscure error: Too few parameters. So - The following should work much better: <?php $sql = "INSERT INTO table (field1,field2,field3,field4) VALUES ('text value 1', 'text 2',3,'text 4')"; ?> yashkhopade
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. scottmweaver
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); } ?> stalker
$sql = INSERT INTO table (field1,field2,field3,field4) VALUES ("text value 1", "text 2",3,"text 4")"; of cos u will get an error fro php due to double quotes inside double quotes. The correct way of doing that is $sql = "INSERT INTO table (field1, field2, field3, field4) VALUES (\"text1\", \"text2\", \"text3\", \"text4\")"; Dont forget the backslash when u want to insert a " within double quotes. |
Change Language
odbc_autocommit odbc_binmode odbc_close_all odbc_close odbc_columnprivileges odbc_columns odbc_commit odbc_connect odbc_cursor odbc_data_source odbc_do odbc_error odbc_errormsg odbc_exec odbc_execute odbc_fetch_array odbc_fetch_into odbc_fetch_object odbc_fetch_row odbc_field_len odbc_field_name odbc_field_num odbc_field_precision odbc_field_scale odbc_field_type odbc_foreignkeys odbc_free_result odbc_gettypeinfo odbc_longreadlen odbc_next_result odbc_num_fields odbc_num_rows odbc_pconnect odbc_prepare odbc_primarykeys odbc_procedurecolumns odbc_procedures odbc_result_all odbc_result odbc_rollback odbc_setoption odbc_specialcolumns odbc_statistics odbc_tableprivileges odbc_tables |
