Sophie

Sophie

distrib > PLD > ac > amd64 > media > dist > by-pkgid > dd8ef74e7a184506d40e4328053fb785 > files > 1961

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML
><HEAD
><TITLE
>mysql_error</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="MySQL Functions"
HREF="ref.mysql.html"><LINK
REL="PREVIOUS"
TITLE="mysql_errno"
HREF="function.mysql-errno.html"><LINK
REL="NEXT"
TITLE="mysql_escape_string"
HREF="function.mysql-escape-string.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.mysql-errno.html"
ACCESSKEY="P"
>Înapoi</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.mysql-escape-string.html"
ACCESSKEY="N"
>Înainte</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.mysql-error"
></A
>mysql_error</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN66926"
></A
><P
>    (PHP 3, PHP 4 , PHP 5)</P
>mysql_error&nbsp;--&nbsp;
     Returns the text of the error message from previous MySQL
     operation
    </DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN66929"
></A
><H2
>Description</H2
>string <B
CLASS="methodname"
>mysql_error</B
> ( [resource link_identifier])<BR
></BR
><P
>&#13;     Returns the error text from the last MySQL function, or
     <VAR
CLASS="literal"
>''</VAR
> (the empty string) if no error occurred. 
     If no link is explicitly passed to the function, the last
     successful open link will be used to retrieve the error message
     from the MySQL server.
    </P
><P
>&#13;     Errors coming back from the MySQL database backend no longer
     issue warnings. Instead, use <B
CLASS="function"
>mysql_error()</B
> to
     retrieve the error text. Note that this function only returns the
     error text from the most recently executed MySQL function (not
     including <B
CLASS="function"
>mysql_error()</B
> and
     <A
HREF="function.mysql-errno.html"
><B
CLASS="function"
>mysql_errno()</B
></A
>), so if you want to use it, make
     sure you check the value before calling another MySQL function.
     <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN66943"
></A
><P
><B
>Exemplu 1. <B
CLASS="function"
>mysql_error()</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">mysql_connect</font><font color="#007700">(</font><font color="#DD0000">"localhost"</font><font color="#007700">, </font><font color="#DD0000">"mysql_user"</font><font color="#007700">, </font><font color="#DD0000">"mysql_password"</font><font color="#007700">);<br /><br /></font><font color="#0000BB">mysql_select_db</font><font color="#007700">(</font><font color="#DD0000">"nonexistentdb"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br />echo </font><font color="#0000BB">mysql_errno</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">) . </font><font color="#DD0000">": " </font><font color="#007700">. </font><font color="#0000BB">mysql_error</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">). </font><font color="#DD0000">"\n"</font><font color="#007700">;<br /><br /></font><font color="#0000BB">mysql_select_db</font><font color="#007700">(</font><font color="#DD0000">"kossu"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br /></font><font color="#0000BB">mysql_query</font><font color="#007700">(</font><font color="#DD0000">"SELECT * FROM nonexistenttable"</font><font color="#007700">, </font><font color="#0000BB">$link</font><font color="#007700">);<br />echo </font><font color="#0000BB">mysql_errno</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">) . </font><font color="#DD0000">": " </font><font color="#007700">. </font><font color="#0000BB">mysql_error</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">) . </font><font color="#DD0000">"\n"</font><font color="#007700">;<br /></font><font color="#0000BB">?&gt;</font>
</font>
</code></TD
></TR
></TABLE
><P
>&#13;       The above example would produce the following output:
      </P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="screen"
>1049: Unknown database 'nonexistentdb'
1146: Table 'kossu.nonexistenttable' doesn't exist</PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
    </P
><P
>&#13;     See also <A
HREF="function.mysql-errno.html"
><B
CLASS="function"
>mysql_errno()</B
></A
> and
     <A
HREF="http://dev.mysql.com/doc/mysql/en/Error-messages.html"
TARGET="_top"
>MySQL error messages</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-errno.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.mysql-escape-string.html"
ACCESSKEY="N"
>Înainte</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>mysql_errno</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.mysql.html"
ACCESSKEY="U"
>Sus</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>mysql_escape_string</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>