/kdewebdev-3.5.10/php/function.mysql-query.html
HTML | 496 lines | 496 code | 0 blank | 0 comment | 0 complexity | 8797e44544afe883d4248b8a78dc6adf MD5 | raw file
Possible License(s): AGPL-1.0, CC-BY-SA-3.0, GPL-2.0
- <HTML
- ><HEAD
- ><TITLE
- >mysql_query</TITLE
- ><META
- NAME="GENERATOR"
- CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
- REL="HOME"
- TITLE="PHP Manual"
- HREF="index.html"><LINK
- REL="UP"
- TITLE="MySQL Functions"
- HREF="ref.mysql.html"><LINK
- REL="PREVIOUS"
- TITLE="mysql_ping"
- HREF="function.mysql-ping.html"><LINK
- REL="NEXT"
- TITLE="mysql_real_escape_string"
- HREF="function.mysql-real-escape-string.html"><META
- HTTP-EQUIV="Content-type"
- CONTENT="text/html; charset=ISO-8859-1"></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 Manual</TH
- ></TR
- ><TR
- ><TD
- WIDTH="10%"
- ALIGN="left"
- VALIGN="bottom"
- ><A
- HREF="function.mysql-ping.html"
- ACCESSKEY="P"
- >Prev</A
- ></TD
- ><TD
- WIDTH="80%"
- ALIGN="center"
- VALIGN="bottom"
- ></TD
- ><TD
- WIDTH="10%"
- ALIGN="right"
- VALIGN="bottom"
- ><A
- HREF="function.mysql-real-escape-string.html"
- ACCESSKEY="N"
- >Next</A
- ></TD
- ></TR
- ></TABLE
- ><HR
- ALIGN="LEFT"
- WIDTH="100%"></DIV
- ><H1
- ><A
- NAME="function.mysql-query"
- ></A
- >mysql_query</H1
- ><DIV
- CLASS="refnamediv"
- ><A
- NAME="AEN59375"
- ></A
- ><P
- > (PHP 3, PHP 4 )</P
- >mysql_query -- Send a MySQL query</DIV
- ><DIV
- CLASS="refsect1"
- ><A
- NAME="AEN59378"
- ></A
- ><H2
- >Description</H2
- >resource <B
- CLASS="methodname"
- >mysql_query</B
- > ( string query [, resource link_identifier [, int result_mode]])<BR
- ></BR
- ><P
- > <B
- CLASS="function"
- >mysql_query()</B
- > sends a query to the currently
- active database on the server that's associated with the
- specified link identifier. If
- <TT
- CLASS="parameter"
- ><I
- >link_identifier</I
- ></TT
- > isn't specified, the last
- opened link is assumed. If no link is open, the function tries
- to establish a link as if <A
- HREF="function.mysql-connect.html"
- ><B
- CLASS="function"
- >mysql_connect()</B
- ></A
- > was
- called with no arguments, and use it.
- </P
- ><P
- > The optional <TT
- CLASS="parameter"
- ><I
- >result_mode</I
- ></TT
- > parameter
- can be MYSQL_USE_RESULT and MYSQL_STORE_RESULT. It
- defaults to MYSQL_STORE_RESULT, so the result is buffered.
- See also <A
- HREF="function.mysql-unbuffered-query.html"
- ><B
- CLASS="function"
- >mysql_unbuffered_query()</B
- ></A
- > for the
- counterpart of this behaviour.
- </P
- ><DIV
- CLASS="note"
- ><BLOCKQUOTE
- CLASS="note"
- ><P
- ><B
- >Note: </B
- >
- The query string should not end with a semicolon.
- </P
- ></BLOCKQUOTE
- ></DIV
- ><P
- > Only for SELECT,SHOW,EXPLAIN or DESCRIBE statements
- <B
- CLASS="function"
- >mysql_query()</B
- >
- returns a resource identifier or <TT
- CLASS="constant"
- ><B
- >FALSE</B
- ></TT
- > if the query was
- not executed correctly. For other type of SQL statements,
- <B
- CLASS="function"
- >mysql_query()</B
- > returns <TT
- CLASS="constant"
- ><B
- >TRUE</B
- ></TT
- > on success
- and <TT
- CLASS="constant"
- ><B
- >FALSE</B
- ></TT
- > on error. A non-<TT
- CLASS="constant"
- ><B
- >FALSE</B
- ></TT
- > return value
- means that the query was legal and could be executed by
- the server. It does not indicate anything about the number of
- rows affected or returned. It is perfectly possible for a query
- to succeed but affect no rows or return no rows.
- </P
- ><P
- > The following query is syntactically invalid, so
- <B
- CLASS="function"
- >mysql_query()</B
- > fails and returns <TT
- CLASS="constant"
- ><B
- >FALSE</B
- ></TT
- >:
- <TABLE
- WIDTH="100%"
- BORDER="0"
- CELLPADDING="0"
- CELLSPACING="0"
- CLASS="EXAMPLE"
- ><TR
- ><TD
- ><DIV
- CLASS="example"
- ><A
- NAME="AEN59411"
- ></A
- ><P
- ><B
- >Example 1. <B
- CLASS="function"
- >mysql_query()</B
- ></B
- ></P
- ><TABLE
- BORDER="0"
- BGCOLOR="#E0E0E0"
- CELLPADDING="5"
- ><TR
- ><TD
- ><PRE
- CLASS="php"
- ><php
- $result = mysql_query("SELECT * WHERE 1=1")
- or die("Invalid query: " . mysql_error());
- ?></PRE
- ></TD
- ></TR
- ></TABLE
- ></DIV
- ></TD
- ></TR
- ></TABLE
- >
- </P
- ><P
- > The following query is semantically invalid if
- <TT
- CLASS="literal"
- >my_col</TT
- > is not a column in the table
- <TT
- CLASS="literal"
- >my_tbl</TT
- >, so <B
- CLASS="function"
- >mysql_query()</B
- >
- fails and returns <TT
- CLASS="constant"
- ><B
- >FALSE</B
- ></TT
- >:
- <TABLE
- WIDTH="100%"
- BORDER="0"
- CELLPADDING="0"
- CELLSPACING="0"
- CLASS="EXAMPLE"
- ><TR
- ><TD
- ><DIV
- CLASS="example"
- ><A
- NAME="AEN59420"
- ></A
- ><P
- ><B
- >Example 2. <B
- CLASS="function"
- >mysql_query()</B
- ></B
- ></P
- ><TABLE
- BORDER="0"
- BGCOLOR="#E0E0E0"
- CELLPADDING="5"
- ><TR
- ><TD
- ><PRE
- CLASS="php"
- ><?php
- $result = mysql_query("SELECT my_col FROM my_tbl")
- or die("Invalid query: " . mysql_error());
- ?></PRE
- ></TD
- ></TR
- ></TABLE
- ></DIV
- ></TD
- ></TR
- ></TABLE
- >
- </P
- ><P
- > <B
- CLASS="function"
- >mysql_query()</B
- > will also fail and return <TT
- CLASS="constant"
- ><B
- >FALSE</B
- ></TT
- >
- if you don't have permission to access the table(s) referenced by
- the query.
- </P
- ><P
- > Assuming the query succeeds, you can call
- <A
- HREF="function.mysql-num-rows.html"
- ><B
- CLASS="function"
- >mysql_num_rows()</B
- ></A
- > to find out how many rows
- were returned for a SELECT statment or
- <A
- HREF="function.mysql-affected-rows.html"
- ><B
- CLASS="function"
- >mysql_affected_rows()</B
- ></A
- > to find out how many
- rows were affected by a DELETE, INSERT, REPLACE, or UPDATE
- statement.
- </P
- ><P
- > Only for SELECT,SHOW,DESCRIBE or EXPLAIN statements,
- <B
- CLASS="function"
- >mysql_query()</B
- >
- returns a new result identifier that you can pass to
- <A
- HREF="function.mysql-fetch-array.html"
- ><B
- CLASS="function"
- >mysql_fetch_array()</B
- ></A
- > and other
- functions dealing with result tables. When you are done with the
- result set, you can free the resources associated with it by
- calling <A
- HREF="function.mysql-free-result.html"
- ><B
- CLASS="function"
- >mysql_free_result()</B
- ></A
- >. Although, the
- memory will automatically be freed at the end of the script's
- execution.
- </P
- ><P
- > See also: <A
- HREF="function.mysql-num-rows.html"
- ><B
- CLASS="function"
- >mysql_num_rows()</B
- ></A
- >,
- <A
- HREF="function.mysql-affected-rows.html"
- ><B
- CLASS="function"
- >mysql_affected_rows()</B
- ></A
- >,
- <A
- HREF="function.mysql-unbuffered-query.html"
- ><B
- CLASS="function"
- >mysql_unbuffered_query()</B
- ></A
- >,
- <A
- HREF="function.mysql-free-result.html"
- ><B
- CLASS="function"
- >mysql_free_result()</B
- ></A
- >,
- <A
- HREF="function.mysql-fetch-array.html"
- ><B
- CLASS="function"
- >mysql_fetch_array()</B
- ></A
- >,
- <A
- HREF="function.mysql-fetch-row.html"
- ><B
- CLASS="function"
- >mysql_fetch_row()</B
- ></A
- >,
- <A
- HREF="function.mysql-fetch-assoc.html"
- ><B
- CLASS="function"
- >mysql_fetch_assoc()</B
- ></A
- >,
- <A
- HREF="function.mysql-result.html"
- ><B
- CLASS="function"
- >mysql_result()</B
- ></A
- >,
- <A
- HREF="function.mysql-select-db.html"
- ><B
- CLASS="function"
- >mysql_select_db()</B
- ></A
- >, and
- <A
- HREF="function.mysql-connect.html"
- ><B
- CLASS="function"
- >mysql_connect()</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="function.mysql-ping.html"
- ACCESSKEY="P"
- >Prev</A
- ></TD
- ><TD
- WIDTH="34%"
- ALIGN="center"
- VALIGN="top"
- ><A
- HREF="index.html"
- ACCESSKEY="H"
- >Home</A
- ></TD
- ><TD
- WIDTH="33%"
- ALIGN="right"
- VALIGN="top"
- ><A
- HREF="function.mysql-real-escape-string.html"
- ACCESSKEY="N"
- >Next</A
- ></TD
- ></TR
- ><TR
- ><TD
- WIDTH="33%"
- ALIGN="left"
- VALIGN="top"
- >mysql_ping</TD
- ><TD
- WIDTH="34%"
- ALIGN="center"
- VALIGN="top"
- ><A
- HREF="ref.mysql.html"
- ACCESSKEY="U"
- >Up</A
- ></TD
- ><TD
- WIDTH="33%"
- ALIGN="right"
- VALIGN="top"
- >mysql_real_escape_string</TD
- ></TR
- ></TABLE
- ></DIV
- ></BODY
- ></HTML
- >