25 lines
544 B
PHP
25 lines
544 B
PHP
<?php
|
|
set_time_limit(0);
|
|
|
|
error_reporting(E_ERROR);
|
|
$username="corey";
|
|
$password="41945549";
|
|
$database="controls";
|
|
|
|
$con=mysqli_connect('192.168.0.2',$username,$password,$database);
|
|
|
|
for ($con;;) {
|
|
$query = "(SELECT * FROM milling ORDER BY id DESC LIMIT 1)";
|
|
$result=mysqli_query($con,$query);
|
|
|
|
while ($row=mysqli_fetch_array($result, MYSQLI_ASSOC)) {
|
|
$secavg=($row['WTONSHR']/3600);
|
|
mysqli_query($con, "INSERT INTO secavg (`secavg`) VALUES ('$secavg')");
|
|
}
|
|
sleep(1);
|
|
}
|
|
if (connection_aborted()==1) {
|
|
mysqli_close($con);
|
|
}
|
|
?>
|