PHP mysqli: refresh() function

Last update on August 19 2022 21:50:39 (UTC/GMT +8 hours)

mysqli_refresh function / mysqli::refresh

The mysqli_refresh function / mysqli::refresh — refreshes

Syntax:

Object oriented style

public bool mysqli::refresh ( int $options )

Procedural style

int mysqli_refresh ( resource $link , int $options )

Parameter:

Name	Description		Required/Optional
link	A link identifier returned by mysqli_connect() or mysqli_init()		Required for procedural style only and Optional for Object oriented style
options		The options to refresh, using the MYSQLI_REFRESH_* constants as documented within the MySQLi constants documentation.	Required

Usage: Procedural style

mysqli_refresh(connection,options);

Parameter:

Name	Description	Required / Optional
connection	Specifies the MySQL connection to use	Required
options	The options to refresh. Can be one of more of the following (separated by OR): MYSQLI_REFRESH_GRANT - Refreshes the grant tables MYSQLI_REFRESH_LOG - Flushes the logs MYSQLI_REFRESH_TABLES - Flushes the table cache MYSQLI_REFRESH_HOSTS - Flushes the host cache MYSQLI_REFRESH_STATUS - Resets the status variables MYSQLI_REFRESH_THREADS - Flushes the thread cache MYSQLI_REFRESH_SLAVE - Resets the master server info, and restarts the slave MYSQLI_REFRESH_MASTER - Removes the binary log files in the binary log index, and truncates the index file	Required

Return value:

TRUE if the refresh was a success, otherwise FALSE

Version: PHP 5, PHP 7

Example

<?php
$con=mysqli_connect("localhost","user1","datasoft123","hr");
if (mysqli_connect_errno($con)){
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

mysqli_refresh($con,MYSQLI_REFRESH_LOG);

mysqli_close($con);
?>

See also

PHP Function Reference

Previous: reap_async_query
Next: release_savepoint