`
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE8" >
`
Use PHP to create, edit and delete crontab jobs?
Below is the code to create cronjob on a server
`
usage: crontab [-u user] file
crontab [-u user] [ -e | -l | -r ]
(default operation is replace, per 1003.2)
-e (edit user's crontab)
-l (list user's crontab)
-r (delete user's crontab)
-i (prompt before deleting user's crontab)
<?
$output = shell_exec('crontab -l');
file_put_contents('/tmp/crontab.txt', $output.'* * * * * NEW_CRON'.PHP_EOL);
echo exec('crontab /tmp/crontab.txt');
?>
`
sorting varchar field which include numbers
`
SELECT id, SUBSTRING_INDEX(name, '-', 1),marks, SUBSTRING_INDEX(name, '-', -1) as code_value ?FROM test ORDER BY code_value
`