Laravel, executing class function from PHP wrapper file

Question

I have a Laravel application where I have two PHP files, one of which is basically a wrapper with text lines and a call to a function in the other file.

When I go into powershell and run php refresh.php, it runs the below file but only prints out the lines, it doesn't execute the classes function, it only prints the lines out.

How can I run this refresh file so that it properly executes the refresh function in Q_Temp.php?

Refresh.php

    <? php require_once ('Q_temp.php');


    echo "start \n\n";
    echo Q::refresh();
    echo "\n done \n";
    ?>

Q_temp.php

    Class Q {
      function refresh()
        {
            $sql = "select C, S, P, Q FROM tbl1";
            $result_set = Iseries::runQuery_simple($sql);
            $log = "";
            foreach ($rr as $row) {
                $log .= "EXECUTING: $sql -- ";
                $res = $this->add_new($row['S'], $row['P'], $row['Q'], $row['C']);
                $log .= "$res \n";
            }
            return $log;
          }
        }

I think that the "correct way" to do this is creating a new Artisan Command. Then run it as php artisan mycommand — CarlosCarucce
– CarlosCarucce, Commented Jan 28, 2020 at 14:39

leek · Accepted Answer · 2020-01-28 14:36:18Z

1

$rr in your foreach loop is undefined.

It should be something like this:

Class Q {
  static function refresh()
    {
        $sql = "select C, S, P, Q FROM tbl1";
        $result_set = Iseries::runQuery_simple($sql);
        $log = "";
        foreach ($result_set as $row) {
            $log .= "EXECUTING: $sql -- ";
            $res = $this->add_new($row['S'], $row['P'], $row['Q'], $row['C']);
            $log .= "$res \n";
        }
        return $log;
      }
    }

answered Jan 28, 2020 at 14:36

leek

12.2k8 gold badges48 silver badges61 bronze badges

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

2 Comments

Geoff_S Over a year ago

Ah I see that now! So fixing that would allow this to run with my original command?

Geoff_S Over a year ago

Ok I did fix that but now it's telling me that on line 6 of the refresh file it can't find class 'Q'

Collectives™ on Stack Overflow

Laravel, executing class function from PHP wrapper file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related