Cron PHP script sheduller

## 1. Create php file ##

// your code to run via cron
// Updates stock
< ? php

$dbhost="localhost";// YOUR HOST NAME USUALLY LOCALHOST
$dbuser="root"; // YOUR DATA BASE USER NAME USUALLY ROOT
$dbpass="pass"; // YOUR DATA BASE PASSWORD
$dbname="";// YOUR DATA BASE NAME

mysql_connect($dbhost, $dbuser, $dbpass) or die("CANNOT CONNECT TO DB-HOST");
mysql_select_db($dbname) or die("DATABASE NAME PROBLEM");

$sql = "UPDATE accountinfo a set TAG = (SELECT b.location FROM ocsweb.frisianipmapping b , ocsweb.hardware c where b.IPmapping =c.IPADDR and a.hardware_Id=c.id)";
mysql_query($sql) or die("SQL ERROR:

---

".$sql);


?>


## 2. SETTING ENVIRONMENT ##

- click mycomputer >> properties >> environmen, then add the variable of 'PATH' with ";C:\xampp\php\"

## 3. CREATE BATCH FILE ##

@echo off
echo schedulle_running
php update.location.php

## 4. SETTING CRON SCHEDULE ##

start >> control panel >> schedule, choose the batch file