Threaded Mode | Linear Mode

Kanibal · 12-27-2016 11:04 PM

Create somewhere (not in www directory) php script, and launch it every N hours/minutes/seconds from command line

Code:

<?php

$link = mysqli_connect("127.0.0.1", "user", "password", "db_name");

if (!$link) {

    echo "Error: Unable to connect to MySQL." . PHP_EOL;

    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;

    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;

    exit;

}

$fp = @fsockopen("127.0.0.1", 2593, $errno, $errstr, 10);

if (!$fp) {

  $result = mysqli_query($link, "UPDATE `server_status` SET online='Offline'");

}else{

  $result = mysqli_query($link, "UPDATE `server_status` SET online='Online'");

  fclose($fp);

}

mysqli_close($link);

?>

P.S. You can use crontab (see attachment) or use .bat file

Code:

start "C:\PHP\php.exe" -f C:\scripts\sphere_status_update.php

P.P.S. I cant add attachment something is wrong with forum? Confused

Threaded Mode \| Linear Mode [TUTORIAL] Sphere web status
Author	Message