<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> <title>TableUpdate class</title> </head> <body><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="mysql-xdevapi-tableselect.where.html">TableSelect::where</a></div> <div class="next" style="text-align: right; float: right;"><a href="mysql-xdevapi-tableupdate.bind.html">TableUpdate::bind</a></div> <div class="up"><a href="book.mysql-xdevapi.html">Mysql_xdevapi</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div><hr /><div id="class.mysql-xdevapi-tableupdate" class="reference"> <h1 class="title">TableUpdate class</h1> <div class="partintro"><p class="verinfo">(PECL mysql-xdevapi >= 8.0.11)</p> <div class="section" id="mysql-xdevapi-tableupdate.intro"> <h2 class="title">Introduction</h2> <p class="para"> A statement for record update operations on a Table. </p> </div> <div class="section" id="mysql-xdevapi-tableupdate.synopsis"> <h2 class="title">Class synopsis</h2> <div class="classsynopsis"> <div class="ooclass"></div> <div class="classsynopsisinfo"> <span class="ooclass"> <strong class="classname">mysql_xdevapi\TableUpdate</strong> </span> <span class="oointerface">implements <span class="interfacename"><a href="class.mysql-xdevapi-executable.html" class="interfacename">mysql_xdevapi\Executable</a></span> </span> {</div> <div class="classsynopsisinfo classsynopsisinfo_comment">/* Methods */</div> <div class="methodsynopsis dc-description"> <span class="modifier">public</span> <span class="type">mysql_xdevapi\TableUpdate</span> <span class="methodname"><strong>bind</strong></span> ( <span class="methodparam"><span class="type">array</span> <code class="parameter">$placeholder_values</code></span> )</div> <div class="methodsynopsis dc-description"> <span class="modifier">public</span> <span class="type">mysql_xdevapi\TableUpdate</span> <span class="methodname"><strong>execute</strong></span> ( <span class="methodparam">void</span> )</div> <div class="methodsynopsis dc-description"> <span class="modifier">public</span> <span class="type">mysql_xdevapi\TableUpdate</span> <span class="methodname"><strong>limit</strong></span> ( <span class="methodparam"><span class="type">integer</span> <code class="parameter">$rows</code></span> )</div> <div class="methodsynopsis dc-description"> <span class="modifier">public</span> <span class="type">mysql_xdevapi\TableUpdate</span> <span class="methodname"><strong>orderby</strong></span> ( <span class="methodparam"><span class="type"><a href="language.pseudo-types.html#language.types.mixed" class="type mixed">mixed</a></span> <code class="parameter">$orderby_expr</code></span> [, <span class="methodparam"><span class="type"><a href="language.pseudo-types.html#language.types.mixed" class="type mixed">mixed</a></span> <code class="parameter">$...</code></span> ] )</div> <div class="methodsynopsis dc-description"> <span class="modifier">public</span> <span class="type">mysql_xdevapi\TableUpdate</span> <span class="methodname"><strong>set</strong></span> ( <span class="methodparam"><span class="type">string</span> <code class="parameter">$table_field</code></span> , <span class="methodparam"><span class="type">string</span> <code class="parameter">$expression_or_literal</code></span> )</div> <div class="methodsynopsis dc-description"> <span class="modifier">public</span> <span class="type">mysql_xdevapi\TableUpdate</span> <span class="methodname"><strong>where</strong></span> ( <span class="methodparam"><span class="type">string</span> <code class="parameter">$where_expr</code></span> )</div> }</div> </div> </div> <h2>Table of Contents</h2><ul class="chunklist chunklist_reference"><li><a href="mysql-xdevapi-tableupdate.bind.html">TableUpdate::bind</a> — Bind update query parameters</li><li><a href="mysql-xdevapi-tableupdate.construct.html">TableUpdate::__construct</a> — TableUpdate constructor</li><li><a href="mysql-xdevapi-tableupdate.execute.html">TableUpdate::execute</a> — Execute update query</li><li><a href="mysql-xdevapi-tableupdate.limit.html">TableUpdate::limit</a> — Limit update row count</li><li><a href="mysql-xdevapi-tableupdate.orderby.html">TableUpdate::orderby</a> — Set sorting criteria</li><li><a href="mysql-xdevapi-tableupdate.set.html">TableUpdate::set</a> — Add field to be updated</li><li><a href="mysql-xdevapi-tableupdate.where.html">TableUpdate::where</a> — Set search filter</li></ul> </div> <hr /><div class="manualnavbar" style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="mysql-xdevapi-tableselect.where.html">TableSelect::where</a></div> <div class="next" style="text-align: right; float: right;"><a href="mysql-xdevapi-tableupdate.bind.html">TableUpdate::bind</a></div> <div class="up"><a href="book.mysql-xdevapi.html">Mysql_xdevapi</a></div> <div class="home"><a href="index.html">PHP Manual</a></div> </div></body></html>