PHP mysqli_refresh() Function
Definition
The mysqli_refresh() function refreshes tables or caches, or resets the replication server information.
Syntax
PHP mysqli_refresh() Function has the following syntax.
mysqli_refresh(connection,options);Parameter
| Parameter | Description |
|---|---|
| connection | Required. Specifies the MySQL connection to use |
| options | The options to refresh. |
options can be one of more of the following (separated by OR):
| Option | Meaning |
|---|---|
| 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 |
Return
It returns TRUE on success and FALSE on failure.
Example
refreshes tables or caches, or resets the replication server information
<?php//www . j av a 2s.com
$con=mysqli_connect("localhost","my_user","my_password","my_db");
if (mysqli_connect_errno($con)){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_refresh($con,MYSQLI_REFRESH_LOG);
mysqli_close($con);
?>