PHP: mysqli_real_query - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

mysqli_report mysqli_real_escape_string

Last updated: Fri, 26 Jan 2007

view this page in

# mysqli_real_query

(PHP 5)

mysqli_real_query

(no version information, might be only in CVS)

mysqli->real_query -- Execute an SQL query

## Description

Procedural style

bool mysqli_real_query ( mysqli link, string query )

Object oriented style (method):

class mysqli {
bool real_query ( string query )
}

The mysqli_real_query() function is used to execute only a query against the database represented by the `link` whose result can then be retrieved or stored using the mysqli_store_result() or mysqli_use_result() functions.

> Замечание: In order to determine if a given query should return a result set or not, see mysqli_field_count().

## Возвращаемые значения

Возвращает `TRUE` в случае успешного завершения или `FALSE` в случае возникновения ошибки.

## Смотрите также

mysqli_query(), mysqli_store_result() и mysqli_use_result().

add a note User Contributed Notes
mysqli_real_query
Beeners
07-Jan-2006 12:41
`Stored Procedures.
In order to call a stored procedure that returns a result set, use mysqli_real_query.
Here is a short example:
$mysqli = new mysqli(DBURI,DBUSER,DBPASS,DBNAME);
if (mysqli_connect_errno())
{
printf("Connection failed: %s\n", mysqli_connect_error());
exit();
}
$SQL = "CALL my_procedure($something)";
if (!$mysqli->real_query($SQL))
{
printf("Invalid query: %s\nWhole query: %s\n", $mysqli->error, $SQL);
exit();
}
if ($result = $mysqli->store_result())
{
while ($myrow = $result->fetch_array(MYSQLI_ASSOC))
{
$aValue[]=$myrow["a"];
$bValue[]=$myrow["b"];
}
$result->close();
}
$mysqli->close();
I hope this saves someone some time.`
add a note
mysqli_report mysqli_real_escape_string

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST