Sophie: php-manual-ro-0:20051028-1 noarch

php-manual-ro-20051028-1.noarch.rpm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML
><HEAD
><TITLE
>msql_query</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="Manual PHP"
HREF="index.html"><LINK
REL="UP"
TITLE="mSQL Functions"
HREF="ref.msql.html"><LINK
REL="PREVIOUS"
TITLE="msql_pconnect"
HREF="function.msql-pconnect.html"><LINK
REL="NEXT"
TITLE="msql_regcase"
HREF="function.msql-regcase.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-2"></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"
>Manual PHP</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.msql-pconnect.html"
ACCESSKEY="P"
>Înapoi</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.msql-regcase.html"
ACCESSKEY="N"
>Înainte</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.msql-query"
></A
>msql_query</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN66213"
></A
><P
>    (PHP 3, PHP 4 , PHP 5)</P
>msql_query&nbsp;--&nbsp;Send mSQL query</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN66216"
></A
><H2
>Description</H2
>resource <B
CLASS="methodname"
>msql_query</B
> ( string query [, resource link_identifier])<BR
></BR
><P
>&#13;     <B
CLASS="function"
>msql_query()</B
> sends a query to the currently
     active database on the server that's associated with the
     specified link identifier.  If the link identifier 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.msql-connect.html"
><B
CLASS="function"
>msql_connect()</B
></A
> was called, and use it.
    </P
><P
>&#13;     Returns a positive mSQL query identifier on success, or <TT
CLASS="constant"
><B
>FALSE</B
></TT
> on
     error.
    </P
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN66232"
></A
><P
><B
>Exemplu 1. <B
CLASS="function"
>msql_query()</B
> example</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB">&lt;?php <br />$link </font><font color="#007700">= </font><font color="#0000BB">msql_connect</font><font color="#007700">(</font><font color="#DD0000">"dbserver"</font><font color="#007700">)<br />&nbsp;&nbsp;&nbsp;or die(</font><font color="#DD0000">"unable to connect to msql server: " </font><font color="#007700">. </font><font color="#0000BB">msql_error</font><font color="#007700">());<br /></font><font color="#0000BB">msql_select_db</font><font color="#007700">(</font><font color="#DD0000">"db"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">)<br />&nbsp;&nbsp;&nbsp;or die(</font><font color="#DD0000">"unable to select database 'db': " </font><font color="#007700">. </font><font color="#0000BB">msql_error</font><font color="#007700">());<br /><br /></font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">msql_query</font><font color="#007700">(</font><font color="#DD0000">"SELECT * FROM table WHERE id=1"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br />if (!</font><font color="#0000BB">$result</font><font color="#007700">) {<br />&nbsp;&nbsp;&nbsp;die(</font><font color="#DD0000">"query failed: " </font><font color="#007700">. </font><font color="#0000BB">msql_error</font><font color="#007700">());<br />}<br /><br />while (</font><font color="#0000BB">$row </font><font color="#007700">= </font><font color="#0000BB">msql_fetch_array</font><font color="#007700">(</font><font color="#0000BB">$result</font><font color="#007700">)) {<br />&nbsp;&nbsp;&nbsp;&nbsp;echo </font><font color="#0000BB">$row</font><font color="#007700">[</font><font color="#DD0000">"id"</font><font color="#007700">];<br />}<br /></font><font color="#0000BB">?&gt;</font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
><P
>&#13;     See also 
     <A
HREF="function.msql-db-query.html"
><B
CLASS="function"
>msql_db_query()</B
></A
>,
     <A
HREF="function.msql-select-db.html"
><B
CLASS="function"
>msql_select_db()</B
></A
>, and
     <A
HREF="function.msql-connect.html"
><B
CLASS="function"
>msql_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.msql-pconnect.html"
ACCESSKEY="P"
>Înapoi</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Acas&#227;</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.msql-regcase.html"
ACCESSKEY="N"
>Înainte</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>msql_pconnect</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.msql.html"
ACCESSKEY="U"
>Sus</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>msql_regcase</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>