mysqli_real_escape_string
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.
mysqli_real_query
mysqli->real_query()
(PHP 5)
mysqli->real_query() — Execute an SQL query
Descrição
Procedural style
bool mysqli_real_query
( mysqli $link
, string $query
)
Object oriented style (method):
mysqli
bool real_query
( string $query
)
Executes a single query against the database 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().
Parâmetros
- link
-
Apenas para estilo de procedimento: Um identificador de conexão retornado por mysqli_connect() or mysqli_init()
- query
-
The query, as a string.
Valor Retornado
Retorna TRUE em caso de sucesso ou FALSE em falhas.
User Contributed Notes
mysqli_real_query
mysqli_real_query
Beeners
07-Jan-2006 06:41
07-Jan-2006 06:41