function.mysql-query.html

/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&nbsp;--&nbsp;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
>&#13;     <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
>&#13;     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
>&#13;     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
>&#13;     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"
>&#60;php
$result = mysql_query("SELECT * WHERE 1=1")
    or die("Invalid query: " . mysql_error());
?&#62;</PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
    </P
><P
>&#13;     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"
>&#60;?php
$result = mysql_query("SELECT my_col FROM my_tbl")
    or die("Invalid query: " . mysql_error());
?&#62;</PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
    </P
><P
>&#13;     <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
>&#13;     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
>&#13;     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
>&#13;     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
>