python output not coming properly while being called from php

Question

I have the following python code:

open_file=open("path to a file",'r')
from prettytable import PrettyTable
import csv
table1=PrettyTable(["COLUMN1","COLUMN2","COLUMN3"])
for lines in open_file:
    temp=(lines.split("%")[1])
    get_severity_no=temp.split(":")[0]
    Description=temp.split(":")[1]
    if "3" in get_severity_no:
        GET_DATE=lines.split(";")[0]
        table1.add_row([GET_DATE,get_severity_no,Description])
print(table1)

This code will simply print the desired output in a table format. Sample output shown below:

Now I'm calling this script from php. Here is the php code.

<?php

$mystring = system('python get_files.py');
echo $mystring
?>

Now this is the output that I'm getting.

All the formatting has been lost. Could u please let me know what I should do to make this proper? I'm very new to php but comfortable with python.

Aaron Gillion · Accepted Answer · 2016-04-08 05:36:28Z

1

Use <pre> tags around your output, as so:

<pre>
 <?php
  $mystring = system('python get_files.py');
  echo $mystring;
 ?>
</pre>

pre stands for "preformatted text", and pre tags render "plain text" exactly how it was entered, which is widely used for displaying code, command output, and other ASCII formatted tables & shapes (like yours) on webpages. Pre tags treat new-line's as <br>'s, conserves repetitive spaces (like you have in your table), treats < and > literally and not as HTML tags, and uses a fixed-width font.

You won't want to use pre tags all the time, because HTML tags inside of it, such as <img>, won't even be rendered. It displays any text literally as it was entered.

Hope this helps,

edited Apr 8, 2016 at 5:36

answered Apr 8, 2016 at 3:49

Aaron Gillion

2,2753 gold badges22 silver badges31 bronze badges

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

3 Comments

soma Over a year ago

It helped. Thanks !!

soma Over a year ago

What's a pre tag??

Aaron Gillion Over a year ago

@soma It renders plain text in readable form, treating new-line's as <br>'s, conserves repetitive spaces (like you have in your table), treats < and > literally and not as HTML tags, and uses a fixed-width font.

Adrien · Accepted Answer · 2016-04-08 03:51:03Z

1

There's a difference in how the console and the browsers actually format outputs.

The console represents new line with \n while browsers need proper HTML tags <br>. Same thing for spaces. The console will print as many spaces as there are but browsers/HTML removes consecutive spaces (so that only one remains).

So if you want to have exactly the same output, you'll need to convert your line breaks from \n to <br> - you can use the nl2br function for that. Regarding spaces, you'll probably want to convert all spaces to non-breakable spaces, to tell the browsers to render consecutive spaces. You can do that with a regex: preg_replace('/ /', ' ', $str);

answered Apr 8, 2016 at 3:51

Adrien

1,9451 gold badge14 silver badges23 bronze badges

Collectives™ on Stack Overflow

python output not coming properly while being called from php

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related