PHP - Isolate Text Into Diferent Variables.

select * from fallLeague10 as f1
join fallLeague10 as f2

where f1.nameFirst = f2.nameFirst
and f1.nameLast = f2.nameLast
and f1.confirm='1'
and f1.id <> f2.id


order by f1.nameLast, f1.nameFirst

Hi all,

I have a table that shows data from an xml response that has been converted to an array.

I have successfully managed to get that to work but it's showing more items than I want.

I'm trying to isolate the items by state. There are 11 or so different states, of which I only want 7. 

I've tried the following with a while loop but I keep getting the message "undefined index: job_status"  

Here's my code (partial)

$projects = array();    
    
        $xml=simplexml_load_string($response) or die("Error: Cannot create object");
     
    foreach($xml->Jobs->Job as $item) {
     
    $projects[] = array(
                     'job_no'          => (string)$item->ID,
                     'job_name'        => (string)$item->Name,
                     'job_due'         => (string)$item->DueDate,
                     'job_status'      => (string)$item->State,
                     'job_staff'       => (string)$item->Assigned->Staff->Name,
                    );
     }
     
 usort($projects, function($a,$b) {return $a['job_due'] <=> $b['job_due']; } );

$projects = array_reverse($projects);
     
while ($projects['job_status'] == ('Feasibility') 
          && ('Measure Up') 
          && ('Model Drawing') 
          && ('Concept Design') 
          && ('Developed Design') 
          && ('Resource Consent') 
          && ('Construction Documentation')) {
    
foreach ($projects as $proj) {
$formatted = date('d/m/Y', strtotime($proj['job_due'])); 
    $job_no ="{$proj['job_no']}";
    $job_name ="{$proj['job_name']}";
    $job_due ="$formatted";
    $job_status ="{$proj['job_status']}";
    $job_staff ="{$proj['job_staff']}";

Any help would be much appreciated thanks. 

<?php

shell_exe ("172.18.9.25\photoshop\photoshop.exe");

?>

When I run this from the server computer program opening. But  when i tried from a diferent computer it is only downloading the exe file to the client computer. How can I open the application from a diferent computer in the same network.

so far I have:

$crawler->filter('li.date, dt > a, li.style')->each(function ($node) {
                $output = $node->text()."\n";

                $array = explode("\n", $output);

                $data = array_chunk($array, 3);
//                print_r($data);
                foreach ($data as $row) {
                    [$date, $title, $type] = array_pad($row, 3, null);

                    // here you have your variables
                    print 'Date: '.$date;

                    print 'Title: '.$title;

                    print 'Type: '.$type;
                }

            });

and this outputs:

Date: Saturday 13th Jun 2020Title: Type: Date: Alice in Chains UKTitle: Type: Date: Metal/ RockTitle: Type: Date: Monday 29th Jun 2020Title: Type: Date: Cage the ElephantTitle: Type: Date: Funk/ RockTitle: Type: Date: Friday 31st Jul 2020Title: Type: Date: The CureheadsTitle: Type: Date: Indie/ RockTitle: Type: Date: Thursday 20th Aug 2020Title: Type: Date: CreeperTitle: Type: Date: PunkTitle: Type: Date: Saturday 22nd Aug 2020Title: Type: Date: Fleetwood BacTitle: Type: Date: Pop/ RockTitle: Type: Date: Monday 31st Aug 2020Title: Type: Date: GZATitle: Type: Date: Hip HopTitle: Type: Date: Saturday 5th Sep 2020Title: Type: Date: Cock SparrerTitle: Type: Date: 

Only $date variable is set for each?! please help??

it should be:

Date: Saturday 13th Jun 2020Title: Alice in Chains UKType: Metal/ Rock

Date: Monday 29th Jun 2020Title: Cage the ElephantType: Funk/ Rock  and so on....