|
ifx_prepare
Prepare an SQL-statement for execution
()
Prepares a query for later use with ifx_do(). For "select-type" queries a cursor is declared and opened. Non-select queries are "execute immediate". For either query type the number of (estimated or real) affected rows is saved for retrieval by ifx_affected_rows().
If the contents of the TEXT (or BYTE) column allow it, you can also use
With Parameters
See Also
Code Examples / Notes » ifx_prepareicespawn11882
This is an example to use this function $conn = fx_connect( "db", "user", "password" ); $result = ifx_prepare("SELECT customer_num, company FROM customer", $conn); ifx_do($result); ifx_prepare associate an int to the query; we use this int with ifx_do Para Massimiliano |
Change Languageifx_affected_rows ifx_blobinfile_mode ifx_byteasvarchar ifx_close ifx_connect ifx_copy_blob ifx_create_blob ifx_create_char ifx_do ifx_error ifx_errormsg ifx_fetch_row ifx_fieldproperties ifx_fieldtypes ifx_free_blob ifx_free_char ifx_free_result ifx_get_blob ifx_get_char ifx_getsqlca ifx_htmltbl_result ifx_nullformat ifx_num_fields ifx_num_rows ifx_pconnect ifx_prepare ifx_query ifx_textasvarchar ifx_update_blob ifx_update_char ifxus_close_slob ifxus_create_slob ifxus_free_slob ifxus_open_slob ifxus_read_slob ifxus_seek_slob ifxus_tell_slob ifxus_write_slob |