PHP script in windows task scheduler

Question

I wrote php script which executed successfully as a web page in the browser. But when I schedule the script using windows task scheduler, the script will run successfully (with no error in windows task scheduler) but result nothing in the database; it should update some rows.

Here is the script:

<?php
$con = mysqli_connect("xxx", "xxx", "xxx");
mysqli_select_db($con, "xxx");

$tns = "  
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = xxx))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = xxx.xxx.xxx.xx)
    )
  )
       ";
if (mysqli_connect_errno())
    {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    };
$conn = oci_connect("xxx", "xxx", $tns);

if (!$conn)
    {
    $m = oci_error();
    echo $m['message'], "\n";
    exit;
    }
  else
    {

    $Orcle_Sql = "select ID,E_OFFICIAL_NAME,Password
                           from xxx";
    $array = oci_parse($conn, $Orcle_Sql);
    oci_execute($array);
    while ($row = oci_fetch_array($array))
        {
        $ID = $row[0];
        $Password = $row[2];

        $sql = "UPDATE students_info set password='$Password' WHERE ID= '$ID'";
        $Update_query = mysqli_query($con, $sql);
        }

    }
mysqli_close($con);
oci_close($conn);
?>

Why does running the script behave different in browser than in windows task scheduler?

Learner · Accepted Answer · 2016-12-06 07:50:16Z

1

I solve it by running my PHP script through batch file.

and scheduling the batch file in Windows task scheduler.

this post helped me so much:

http://www.devside.net/wamp-server/running-php-scripts-as-cron-jobs-on-windows

answered Dec 6, 2016 at 7:50

Learner

6213 gold badges12 silver badges28 bronze badges

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

2 Comments

Learner Over a year ago

Users can't accept their own answer until 23 hours passed :) I wrote a note to do it tomorrow morning :D

David Spector Over a year ago

This post that helped so much is now a dead link.

Collectives™ on Stack Overflow

PHP script in windows task scheduler

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related