PHP Manuál | ||
---|---|---|
Predchádzajúci | Nasledujúci |
mysql_query() sends a query (to the currently active database on the server that's associated with the specified link_identifier).
A SQL query
The query string should not end with a semicolon.
A link identifier, as returned by mysql_connect().
If 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 mysql_connect() was called with no arguments, and use it. The result of the query is buffered.
For SELECT, SHOW, DESCRIBE or EXPLAIN statements, mysql_query() returns a resource on success, and FALSE on error.
For other type of SQL statements, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success and FALSE on error.
The returned result resource should be passed to mysql_fetch_array(), and other functions for dealing with result tables, to access the returned data.
Use mysql_num_rows() to find out how many rows were returned for a SELECT statement or mysql_affected_rows() to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.
mysql_query() will also fail and return FALSE if the user does not have permission to access the table(s) referenced by the query.
Príklad 2. Valid Query The following query is valid, so mysql_query() returns a resource.
|
mysql_connect() |
mysql_error() |
mysql_real_escape_string() |
mysql_result() |
mysql_fetch_assoc() |
mysql_unbuffered_query() |
Predchádzajúci | Domov | Nasledujúci |
mysql_ping | Hore | mysql_real_escape_string |