How can i output the response of PHP shell_exec into a HTML table?

Question

I have a PHP shell_exec command that outputs the following:

Cats
3
Dogs
9
Fish
2

Every second line is a number, that corresponds to the name of the animal on previous line, i would like the output in a HTML table for example:

HTML TABLE
------------
| Cats | 3 |
| Dogs | 9 |
| Fish | 2 |
------------

I think i need to create an array, but i am not sure how to align the animal name and number onto the same line. At the moment i have this:

<?php
    $array1 = array();
    exec( "Command", $Output );

?>
<html>


<table>
  <tr>
    <th>Animal</th>
    <th>Number</th>
  </tr>
  <tr>
    <td>*</td>
    <td>*</td>
  </tr>
  <tr>
    <td>*</td>
    <td>*</td>
  </tr>
  <tr>
    <td>*</td>
    <td>*</td>
  </tr>

  </tr>
</table>

</body>
</html>

How can i put this into a HTML Table?

dWinder · Accepted Answer · 2019-02-17 15:27:00Z

1

You can convert it to array with array-chunk after using explode to convert to array.

$str = 'Cats
3
Dogs
9
Fish
2';

$arr = explode(PHP_EOL, $str); //break each line
$arr = array_chunk($arr,2); // group each pair
foreach($arr as $e)
    $res[$e[0]] = $e[1]; // group each pair as key and value
print_r($res);

This will output:

Array
(
    [Cats] => 3
    [Dogs] => 9
    [Fish] => 2
)

You can now use this more easily to display by looping with foreach($res as $animal => $number)

Your HTML should be:

<table>
  <tr>
    <th>Animal</th>
    <th>Number</th>
  </tr>
<?php foreach($res as $animal => $number)
    echo '<tr><td>'. $animal . '</td><td>' . $number . '</td></tr>'; ?>
</table>

edited Feb 17, 2019 at 15:27

answered Feb 17, 2019 at 15:16

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

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

12 Comments

jonny b Over a year ago

Thanks, How would i enter this into the HTML table?

dWinder Over a year ago

@jonnyb You can add PHP for-loop in the HTML - edited my answer

jonny b Over a year ago

Thanks, i can see this works however i get an error when using it with the output from shell_exec: PHP Notice: Undefined offset: 1 in /var/www/html/user1/examples/test1.php on line 6 PHP Stack trace: PHP 1. {main}() /var/www/html/user1/examples/test1.php:0 Array ( [000000000] => ) <html> <table> <tr> <th>Animal</th> <th>Number</th> </tr> <tr><td>000000000</td><td></td></tr></table> </html>

dWinder Over a year ago

Can you please verify $res contain my output before running the HTML code? (in the PHP section) - Define the array hard-coded as $res = array("Cats" => "3", "Dogs" => "9", "Fish" => "2"); and see if it works

jonny b Over a year ago

I fixed it by changing exec to shell_exec .. Thankyou!

|

Ewald · Accepted Answer · 2019-02-17 15:24:01Z

0

You could use the preg_split() function to split the string along linebreaks into an array, and loop through the array two at a time, shifting the first two off at every loop.

<table>
<?php
$Output = <<< EOF
Cats
3
Dogs
9
Fish
2
EOF;

$animals = preg_split('/[\n\r]+/', trim($Output));

while (!empty($animals)) {
    echo "<tr>\n";
    echo "<td>{$animals[0]}</td>\n";
    echo "<td>{$animals[1]}</td>\n";
    echo "</tr>\n";
    array_shift($animals);
    array_shift($animals);
}
?>
</table>

answered Feb 17, 2019 at 15:24

Ewald

463 bronze badges

2 Comments

jonny b Over a year ago

I am receiving the following error: trim() expects parameter 1 to be string, array given in /test.php on line 4

Ewald Over a year ago

I see. I expected $Output to be a string, but I suppose it is an array, when you use the exec() function. If you'd use the function shell_exec(), as you said under dWinder's answer, it should work.

Collectives™ on Stack Overflow

How can i output the response of PHP shell_exec into a HTML table?

2 Answers 2

12 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related