php小脚本

<?php

function std_echo($words){
  echo date('Y-m-d H:m:s')."\t".$words."\n";
}

  std_echo ('This is a job.');
  $host = "localhost";
  $username = "cc";
  $password = "cc";
  $database_test = "c0516";

  // 连接到数据库
  $con = mysql_connect($host, $username, $password);
  if (!$con){
    std_echo('Could not connect: '.mysql_error() );
    exit;
  }
  mysql_select_db($database_test, $con);

  // sql
  $add_time = time() - 5*60;
  $sql = ' UPDATE etz_borrow_investor'.
       ' SET close_time = add_time + 300'.
       ' WHERE close_time = 0 AND status = 7'.
       ' AND add_time <'.$add_time;

  // 执行sql
  $step = mysql_query($sql, $con);
  if (false === $step)
    std_echo ('Job Failed: '.mysql_error() );
  else
    std_echo ('Job Succed.');

  // 关闭连接
  mysql_close($con);
  exit;