ifx_prepare

(PHP 4, PHP 5 < 5.2.1)

ifx_prepare — Prepare an SQL-statement for execution

说明

ifx_prepare ( string $query , resource $link_identifier [, int $cursor_def ], mixed $blobidarray ) : resource

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 ifx_textasvarchar(1) and ifx_byteasvarchar(1). This allows you to treat TEXT (or BYTE) columns just as if they were ordinary (but long) VARCHAR columns for select queries, and you don't need to bother with blob id's.

With ifx_textasvarchar(0) or ifx_byteasvarchar(0) (the default situation), select queries will return BLOB columns as blob id's (integer value). You can get the value of the blob as a string or file with the blob functions (see below).

参数

query: The query string.
link_identifier: The link identifier.
cursor_def: This optional parameter allows you to make this a scroll and/or hold cursor. It's a bitmask and can be either IFX_SCROLL, IFX_HOLD, or both or'ed together.
blobidarray: If you have BLOB (BYTE or TEXT) columns in the query, you can add a blobidarray parameter containing the corresponding "blob ids", and you should replace those columns with a "?" in the query text.

返回值

Returns a valid result identifier for use by ifx_do(), or FALSE on errors.

参见

ifx_do() - Execute a previously prepared SQL-statement

add a note

User Contributed Notes 1 note

down

icespawn11882 at hotmail dot com ¶

14 years ago


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

add a note

官方地址：https://www.php.net/manual/en/function.ifx-prepare.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言开发编程 Linux 科技 Elasticsearch HTML/CSS/XML 面试数据库网络 JAVA NoSQL C/C++ Golang 操作系统 Git 算法正则表达式 Redis 互联网 MySql 软件运维 JavaScript 国际架构设计 Mac OS Excel TCP/IP Windows Oracle Socket Vim VR MongoDB 运营 Python MemCache 商业硬件电子娱乐设计摄影 nginx WordPress 游戏 HTTP 团建数码电器 Docker

php7.3 使用 PDO_DM 扩展连接 DM8 中文乱码 PhpStorm中PHP注释的规范指南使用PHPWord将docx文件转换为html格式 docker-compose启动nginx与php-fpm laravel查看orm生成的sql PHPStorm ESC 会退出命令行 composer install参数 laravel orm中DB::insert方法导致内存泄漏的问题解决方法 php7 安装fileinfo扩展 adodb手册 ADORecordSet对象常用的php ADODB使用方法集锦利用php soap实现web service ADOConnection 公用函数 adodb连接mysql多个数据库的问题 PHP json解析（json_decode）页面工具 PHP注释规范 mysql面试题 Composer的Packagist资源 PHP程序标准注释的规范准则

略微加速

PHP官方手册 - 互联网笔记

ifx_prepare

说明

参数

返回值

参见

User Contributed Notes 1 note