ref.sqlite.html
来自「php的帮助文档,涉及到PHP的案例和基本语法,以及实际应用内容」· HTML 代码 · 共 421 行
HTML
421 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>SQLite Functions</title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="book.sqlite.html">SQLite</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.sqlite-array-query.html">sqlite_array_query</a></div> <div class="up"><a href="book.sqlite.html">SQLite</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div><hr /><div> <h1 class="title">SQLite Functions</h1> <div class="partintro"> <div id="sqlite.classes" class="section"> <h2 class="title">Predefined Classes</h2> <div id="sqlite.class.sqlitedatabase" class="section"> <h2 class="title"><b class="classname">SQLiteDatabase</b></h2> <p class="para"> Represents an opened SQLite database. </p> <div id="sqlite.class.sqlitedatabase.constructor" class="section"> <h2 class="title">Constructor</h2> <ul class="itemizedlist"> <li class="listitem"> <p class="para"><a href="function.sqlite-open.html" class="link">__construct</a> - construct a new SQLiteDatabase object</p> </li> </ul> </div> <div id="sqlite.class.sqlitedatabase.methods" class="section"> <h2 class="title">Methods</h2> <ul class="itemizedlist"> <li class="listitem"> <p class="para"><a href="function.sqlite-query.html" class="link">query</a> - Execute a query</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-exec.html" class="link">queryExec</a> - Execute a result-less query</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-array-query.html" class="link">arrayQuery</a> - Execute a query and return the result as an array</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-single-query.html" class="link">singleQuery</a> - Execute a query and return either an array for one single column or the value of the first row</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-unbuffered-query.html" class="link">unbufferedQuery</a> - Execute an unbuffered query</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-last-insert-rowid.html" class="link">lastInsertRowid</a> - Returns the rowid of the most recently inserted row</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-changes.html" class="link">changes</a> - Returns the number of rows changed by the most recent statement</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-create-aggregate.html" class="link">createAggregate</a> - Register an aggregating UDF for use in SQL statements</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-create-function.html" class="link">createFunction</a> - Register a UDF for use in SQL statements</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-busy-timeout.html" class="link">busyTimeout</a> - Sets or disables busy timeout duration</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-last-error.html" class="link">lastError</a> - Returns the last error code of the most recently encountered error</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-column-types.html" class="link">fetchColumnTypes</a> - Return an array of column types from a particular table</p> </li> </ul> </div> </div> <div id="sqlite.class.sqliteresult" class="section"> <h2 class="title"><b class="classname">SQLiteResult</b></h2> <p class="para"> Represents a buffered SQLite result set. </p> <div id="sqlite.class.sqliteresult.methods" class="section"> <h2 class="title">Methods</h2> <ul class="itemizedlist"> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-array.html" class="link">fetch</a> - Fetches the next row from the result set as an array</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-object.html" class="link">fetchObject</a> - Fetches the next row from the result set as an object</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-single.html" class="link">fetchSingle</a> - Fetches the first column from the result set as a string</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-all.html" class="link">fetchAll</a> - Fetches all rows from the result set as an array of arrays</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-column.html" class="link">column</a> - Fetches a column from the current row of the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-num-fields.html" class="link">numFields</a> - Returns the number of fields in the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-field-name.html" class="link">fieldName</a> - Returns the name of a particular field in the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-current.html" class="link">current</a> - Fetches the current row from the result set as an array</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-key.html" class="link">key</a> - Return the current row index</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-next.html" class="link">next</a> - Seek to the next row number</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-valid.html" class="link">valid</a> - Returns whether more rows are available</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-rewind.html" class="link">rewind</a> - Seek to the first row number of the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-prev.html" class="link">prev</a> - Seek to the previous row number of the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-has-prev.html" class="link">hasPrev</a> - Returns whether or not a previous row is available</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-num-rows.html" class="link">numRows</a> - Returns the number of rows in the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-seek.html" class="link">seek</a> - Seek to a particular row number</p> </li> </ul> </div> </div> <div id="sqlite.class.sqliteunbuffered" class="section"> <h2 class="title"><b class="classname">SQLiteUnbuffered</b></h2> <p class="para"> Represents an unbuffered SQLite result set. Unbuffered results sets are sequential, forward-seeking only. </p> <div id="sqlite.class.sqliteunbuffered.methods" class="section"> <h2 class="title">Methods</h2> <ul class="itemizedlist"> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-array.html" class="link">fetch</a> - Fetches the next row from the result set as an array</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-object.html" class="link">fetchObject</a> - Fetches the next row from the result set as an object</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-single.html" class="link">fetchSingle</a> - Fetches the first column from the result set as a string</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-fetch-all.html" class="link">fetchAll</a> - Fetches all rows from the result set as an array of arrays</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-column.html" class="link">column</a> - Fetches a column from the current row of the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-num-fields.html" class="link">numFields</a> - Returns the number of fields in the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-field-name.html" class="link">fieldName</a> - Returns the name of a particular field in the result set</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-current.html" class="link">current</a> - Fetches the current row from the result set as an array</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-next.html" class="link">next</a> - Seek to the next row number</p> </li> <li class="listitem"> <p class="para"><a href="function.sqlite-valid.html" class="link">valid</a> - Returns whether more rows are available</p> </li> </ul> </div> </div> </div> </div> <h2>Table of Contents</h2><ul class="chunklist chunklist_reference"><li><a href="function.sqlite-array-query.html">sqlite_array_query</a> 鈥⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?