<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >fbsql_affected_rows</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="PHP 手册" HREF="index.html"><LINK REL="UP" TITLE="FrontBase Functions" HREF="ref.fbsql.html"><LINK REL="PREVIOUS" TITLE="FrontBase Functions" HREF="ref.fbsql.html"><LINK REL="NEXT" TITLE="fbsql_autocommit" HREF="function.fbsql-autocommit.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=UTF-8"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP 手册</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="ref.fbsql.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.fbsql-autocommit.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.fbsql-affected-rows" ></A >fbsql_affected_rows</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN58169" ></A ><P > (PHP 4 >= 4.0.6, PHP 5)</P >fbsql_affected_rows -- Get number of affected rows in previous FrontBase operation</DIV ><DIV CLASS="refsect1" ><A NAME="AEN58172" ></A ><H2 >说明</H2 >int <B CLASS="methodname" >fbsql_affected_rows</B > ( [resource link_identifier] )<BR ></BR ><P > <B CLASS="function" >fbsql_affected_rows()</B > returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with <CODE CLASS="parameter" >link_identifier</CODE >. </P ><DIV CLASS="note" ><BLOCKQUOTE CLASS="note" ><P ><B >注意: </B > If you are using transactions, you need to call <B CLASS="function" >fbsql_affected_rows()</B > after your INSERT, UPDATE, or DELETE query, not after the commit. </P ></BLOCKQUOTE ></DIV ><P > If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will return zero. </P ><DIV CLASS="note" ><BLOCKQUOTE CLASS="note" ><P ><B >注意: </B > When using UPDATE, FrontBase will not update columns where the new value is the same as the old value. This creates the possibility that <B CLASS="function" >fbsql_affected_rows()</B > may not actually equal the number of rows matched, only the number of rows that were literally affected by the query. </P ></BLOCKQUOTE ></DIV ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN58190" ></A ><H2 >参数</H2 ><P > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" > link_identifier</CODE ></DT ><DD ><P >A FrontBase link identifier returned by <A HREF="function.fbsql-connect.html" ><B CLASS="function" >fbsql_connect()</B ></A > or <A HREF="function.fbsql-pconnect.html" ><B CLASS="function" >fbsql_pconnect()</B ></A >.</P ><P >If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if <A HREF="function.fbsql-connect.html" ><B CLASS="function" >fbsql_connect()</B ></A > was called with no arguments</P ></DD ></DL ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN58203" ></A ><H2 >返回值</H2 ><P > If the last query failed, this function will return -1. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN58206" ></A ><H2 >参见</H2 ><P > <P ></P ><TABLE BORDER="0" ><TBODY ><TR ><TD ><A HREF="function.fbsql-num-rows.html" ><B CLASS="function" >fbsql_num_rows()</B ></A ></TD ></TR ></TBODY ></TABLE ><P ></P > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="ref.fbsql.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >起始页</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.fbsql-autocommit.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >FrontBase Functions</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.fbsql.html" ACCESSKEY="U" >上一级</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >fbsql_autocommit</TD ></TR ></TABLE ></DIV ></BODY ></HTML >