Unable to run php file in background

Question

I want to run a php file in background which has some mysql commands, I am unable to do so. Is it that php file based on cakephp framework doesnot run in background? To run a php file n background do i need to write it basic php format I am a beginner. I have tried commands like:

php filename.php
php filename.php &
php -a
exec( '/usr/bin/php -f /my/path/to/filename.php > /dev/null &' );

followed this tutorial "http://www.xphp.info/background-processing-with-php/"

please tell me.

the code is:

<?php


include_once "a_file.php";


class Calci{


    var $ft = 350;
    var $fl = 130;
    var $lt = 60;    
    var $fbCount = 0;
    var $liCount = 0;
    var $twCount = 0;
    var $nodeId = 0;

    function index() {   
        App::import('model', 'User');
        $user_model = new User();

        $entry = $user_model->find("all", array("conditions" => array("not" => array("User.id" => null))));
        foreach($entry as $e) {
            $user_id = $e["User"]["id"];
            $tr=$this->getTrUser($user_id);
            $this->$e["User"]["id"]=$user_id;
            $this->$e["User"]["true_reach"]=$tr;
            $this->$e["User"]->save();
        }    
    }
    function getTrUser($id) {
// some calculation

}

}    

?>

It may or may not be cakephp dependent. Depends what is the content in your `filename.php` — Dipen Shah, Jul 10 '15 at 12:13
I am using that file to update a row in table it fetches all the rows from the tables and updates them. — Ravik Hachi, Jul 10 '15 at 12:14
It would make more sense to post the code of the file here rather than abstractly explaining what's happening inside the file. — Dipen Shah, Jul 10 '15 at 12:15
http://stackoverflow.com/questions/45953/php-execute-a-background-process — Inform-all, Jul 10 '15 at 12:17

score 0 · Answer 1 · answered Jul 10 '15 at 12:19

0

You need to use php-cli, to execute php script using exec

exec('php-cli /var/www/gohachi-git/app/services/hachicalci.php > /dev/null &');

answered Jul 10 '15 at 12:19

kamal pal

4,187
5
25
40

in the php interpreter – Ravik Hachi Jul 10 '15 at 12:26
bash: syntax error near unexpected token `'php-cli /var/www/gohachi-git/app/services/hachicalci.php > /dev/null &'' – Ravik Hachi Jul 10 '15 at 12:54

score 0 · Answer 2 · answered Jul 10 '15 at 12:43

0

If your using SSH / Terminal use:

nohup php /my/path/to/filename.php &

answered Jul 10 '15 at 12:43

Danny Broadbent

1,199
1
9
21

it didnt work it gave the contents of the file as output to nohup.out – Ravik Hachi Jul 10 '15 at 12:50

score 0 · Answer 3 · answered Jul 10 '15 at 14:39

0

I think the best approach is to use the Mysql Event Scheduler and Stored Procedures for run this queries.

answered Jul 10 '15 at 14:39

An4Th3mA

39
2

Unable to run php file in background

3 Answers3