Using Crontab to implement PHP script timing tasks under Linux

This article mainly introduces the use of Crontab to implement PHP script timing tasks under Linux. Now I share it with everyone and give a reference to friends in need. Come and take a look together

1. Preparation work. Create a data table "company_test", the fields include employee name, department, contact number, supervisor

DROP TABLE IF EXISTS `company`;
CREATE TABLE `company_test` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `ename` varchar(100) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `charge` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

2. Create a PHP script "insert_test.php ", to implement the operation of inserting into the data table, this script can be placed anywhere. ps: It is recommended not to put it in the wwwroot root directory, because in this case, users can access it through the URL. This is not very secure, but it has some conveniences. We use some of the PHP frameworks that come with it, such as CI. , TP, etc., you can also use some general business classes encapsulated by yourself! Make a decision based on the actual situation.

<?php
 
$con = mysqli_connect("localhost","root","Idodopass01!");
 
if(mysqli_select_db("company_test",$con))
{
	try{
		$result = mysqli_query("insert into company_test (ename,department,phone,charge)values(&#39;A&#39;,&#39;AA&#39;,&#39;xxx xxxx xxxx&#39;,&#39;AAA&#39;)");
	}
	//捕获异常
	catch(Exception $e){
 		echo &#39;Message: &#39; .$e->getMessage();
	}
}
mysql_close($con);
?>

3. View the /etc/crontab file

vim  /etc/crontab

4. Create a Crontab task (the Crontab format is as follows)

***File/etc The description format of each line of tasks in /crontab is as follows:
****minute hour day month dayofweek command
******minute - an integer from 0 to 59
****** hour - an integer from 0 to 23
******day - an integer from 1 to 31 (must be a valid day in the specified month)
******month - from 1 to 12 Integer (or abbreviated month such as Jan or Feb)
******dayofweek - an integer from 0 to 7, 0 or 7 is used to describe Sunday (or represented by the abbreviation of Sun or Mon)
******command - The command that needs to be executed (can be used as ls /proc >> /tmp/proc or the command to execute a custom script)

crontab -e
*/5 * * * * /usr/local/php/bin/php /home/wwwroot/default/insert_test.php // Execute the script to insert SQL every five minutes


Related information:https: //blog.csdn.net/anphper/article/details/79798479

Related recommendations:

How to implement PHP connection to SQL Server2008 on Windows platform

The above is the detailed content of Using Crontab to implement PHP script timing tasks under Linux. For more information, please follow other related articles on the PHP Chinese website!