<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >sybase_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="Sybase Functions" HREF="ref.sybase.html"><LINK REL="PREVIOUS" TITLE="Sybase Functions" HREF="ref.sybase.html"><LINK REL="NEXT" TITLE="sybase_close" HREF="function.sybase-close.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.sybase.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.sybase-close.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.sybase-affected-rows" ></A >sybase_affected_rows</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN232632" ></A ><P > (PHP 3 >= 3.0.6, PHP 4, PHP 5)</P >sybase_affected_rows -- Gets number of affected rows in last query</DIV ><DIV CLASS="refsect1" ><A NAME="AEN232635" ></A ><H2 >Description</H2 >int <B CLASS="methodname" >sybase_affected_rows</B > ( [resource link_identifier] )<BR ></BR ><P > <B CLASS="function" >sybase_affected_rows()</B > returns the number of rows affected by the last INSERT, UPDATE or DELETE query on the server associated with the specified link identifier. If the link identifier isn't specified, the last opened link is assumed. </P ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN232646" ></A ><P ><B >例 1. Delete-Query</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><code><font color="#000000"> <font color="#0000BB"><?php<br /></font><font color="#FF8000">/* connect to database */<br /></font><font color="#0000BB">sybase_connect</font><font color="#007700">(</font><font color="#DD0000">'SYBASE'</font><font color="#007700">, </font><font color="#DD0000">''</font><font color="#007700">, </font><font color="#DD0000">''</font><font color="#007700">) or<br />die(</font><font color="#DD0000">"Could not connect"</font><font color="#007700">);<br /></font><font color="#0000BB">sybase_select_db</font><font color="#007700">(</font><font color="#DD0000">"db"</font><font color="#007700">);<br /><br /></font><font color="#0000BB">sybase_query</font><font color="#007700">(</font><font color="#DD0000">"DELETE FROM sometable WHERE id < 10"</font><font color="#007700">);<br /></font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"Records deleted: %d\n"</font><font color="#007700">, </font><font color="#0000BB">sybase_affected_rows</font><font color="#007700">());<br /></font><font color="#0000BB">?></font> </font> </code></TD ></TR ></TABLE ><P >上例将输出:</P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><PRE CLASS="screen" >Records deleted: 10</PRE ></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ><P > This command is not effective for SELECT statements, only on statements which modify records. To retrieve the number of rows returned from a SELECT, use <A HREF="function.sybase-num-rows.html" ><B CLASS="function" >sybase_num_rows()</B ></A >. </P ><P > See also <A HREF="function.sybase-num-rows.html" ><B CLASS="function" >sybase_num_rows()</B ></A >. </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.sybase.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.sybase-close.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Sybase Functions</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.sybase.html" ACCESSKEY="U" >上一级</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >sybase_close</TD ></TR ></TABLE ></DIV ></BODY ></HTML >