How to run PHP script with Windows Task Scheduler

Question

I am using codeigniter to create some cronjobs I scheduled it using Task schedular in windows 7. It runs every one minute but what i see is it just popup my code in an editor and does not insert any data in my database that I mentioned in index function.

<?php
class Hello extends CI_Controller {
 public function __construct() {
    parent::__construct();
    $this->load->database();
}

public function index() {
     $this->db->query("INSERT INTO test_cron VALUES(null, 'username')");
}
}
?>

How can I really execute it so That it insert data in my database

Thanks

Are you using CPanel? If so checkout this image, you just have to find the cronjob area on your panel. If you're using a linux server without control panel checkout this url, if you are using windows or need any other help let me know and I'll post a guide. — Diogo Raminhos
– Diogo Raminhos, Commented Apr 27, 2012 at 13:05
Oh, you're on Windows. You can forget about cron and that tutorial then. Try to use Windows Scheduler or something. — Mischa
– Mischa, Commented Apr 27, 2012 at 13:10

devdRew · Accepted Answer · 2012-04-27 14:08:39Z

2

IF YOU ARE USING *.NIX:

*nix command:

crontab -e -u USERNAME

If you wanna edit with nano:

env EDITOR=nano crontab -e -u USERNAME where username is the user which will initiate the script.

If you wanna run it hourly:

01 * * * * ...

For Windows 7, as you asked: Start => Accessories => System Tools => Task Scheduler

Create task
Actions
New
choose the path to script and don't forget to add php before script, in order to execute, not just open.

To run script with a specified period or by date, use Triggers tab.

And there configure the task to run you're PHP script.

edited Apr 27, 2012 at 14:08

answered Apr 27, 2012 at 13:08

devdRew

4,6013 gold badges27 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

Faryal Khan Over a year ago

Is it possible to run a codeigniter controller by scheduling a task?

devdRew Over a year ago

Yes, cause in the end running a codeigniter controller is calling script. I've done it for Symfony, say for cron controller, I've just configured task to run cron.php, and in routing defined my homepage for this controller as pointing on cron action.

Faryal Khan Over a year ago

There is no option to run the script after every minute or hour.

Faryal Khan Over a year ago

Yes I found it now I run it every one minute it is running but the quesry is not working... should I edit my question and provide you the code which I want to run ?

devdRew Over a year ago

What do you mean saying query is not running...? Try to improve your code with logging, and if there were errors, - log it, and debug.

|

mishu · Accepted Answer · 2012-04-27 13:07:54Z

1

crontab is a linux program and you say that you are using windows 7; in windows you will have to try a similar thing with scheduled tasks

(that syntax is only for unix)

answered Apr 27, 2012 at 13:07

mishu

5,3971 gold badge24 silver badges41 bronze badges

2 Comments

Faryal Khan Over a year ago

Ny idea about how o run it on windows?

mishu Over a year ago

@FaryalKhan you should google about using windows scheduled tasks; most people here are used to running the applications on unix operating systems; if you say that you are using win 7 you should be able to find what you need if you open the start menu and just type "task scheduler".. you will find a program that allows you to set up "cronjobs" using a GUI.. and your script will run using the full path to the php exe and the path to the script as a parameter

cschorn · Accepted Answer · 2012-04-27 13:09:36Z

0

On your server, you use the command crontab -e, which will open an editor for you where you add the code to your crontab. To have it run every hour, change the line to:

00 * * * * /usr/local/bin/php5 $HOME/system/scripts/clean_cache.php

More details about the crontab format.

answered Apr 27, 2012 at 13:09

cschorn

1,21711 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to run PHP script with Windows Task Scheduler

3 Answers 3

12 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

12 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related