首页 >函数列表 >ibase_execute

ibase_execute

ibase_execute

(PHP 4, PHP 5)

ibase_executeExecute a previously prepared query

说明

resource ibase_execute ( resource $query [, mixed $bind_arg [, mixed $... ]] )

Execute a query prepared by ibase_prepare().

This is a lot more effective than using ibase_query() if you are repeating a same kind of query several times with only some parameters changing.

参数

query

An InterBase query prepared by ibase_prepare().

bind_arg

...

返回值

If the query raises an error, returns FALSE. If it is successful and there is a (possibly empty) result set (such as with a SELECT query), returns a result identifier. If the query was successful and there were no results, returns TRUE.

Note:

In PHP 5.0.0 and up, this function returns the number of rows affected by the query (if > 0 and applicable to the statement type). A query that succeeded, but did not affect any rows (e.g. an UPDATE of a non-existent record) will return TRUE.

范例

Example #1 ibase_execute() example

<?php

$dbh 
ibase_connect($host$username$password);

$updates = array(
    
=> 'Eric',
    
=> 'Filip',
    
=> 'Larry'
);

$query ibase_prepare($dbh"UPDATE FOO SET BAR = ? WHERE BAZ = ?");

foreach (
$updates as $baz => $bar) {
    
ibase_execute($query$bar$baz);
}

?>

参见


  • ibase_add_user
  • ibase_affected_rows
  • ibase_backup
  • ibase_blob_add
  • ibase_blob_cancel
  • ibase_blob_close
  • ibase_blob_create
  • ibase_blob_echo
  • ibase_blob_get
  • ibase_blob_import
  • ibase_blob_info
  • ibase_blob_open
  • ibase_close
  • ibase_commit
  • ibase_commit_ret
  • ibase_connect
  • ibase_db_info
  • ibase_delete_user
  • ibase_drop_db
  • ibase_errcode
  • ibase_errmsg
  • ibase_execute
  • ibase_fetch_assoc
  • ibase_fetch_object
  • ibase_fetch_row
  • ibase_field_info
  • ibase_free_event_handler
  • ibase_free_query
  • ibase_free_result
  • ibase_gen_id
  • ibase_maintain_db
  • ibase_modify_user
  • ibase_name_result
  • ibase_num_fields
  • ibase_num_params
  • ibase_param_info
  • ibase_pconnect
  • ibase_prepare
  • ibase_query
  • ibase_restore
  • ibase_rollback
  • ibase_rollback_ret
  • ibase_server_info
  • ibase_service_attach
  • ibase_service_detach
  • ibase_set_event_handler
  • ibase_timefmt
  • ibase_trans
  • ibase_wait_event
  • PHP MySQL HTML CSS JavaScript MSSQL AJAX .NET JSP Linux Mac ASP 服务器 SQL jQuery C# C++ java Android IOS oracle MongoDB SQLite wamp 交通频道