Simple php page that only shows chosen status

Feature Requests
1

Is it possible to make an easy php page that only shows chosen status on all of the screens?

So you can easily check a smartphone for example. I administrate about 30 screens and I travet a lot. It’s so complicated to work with it by the normal HomePage with my smartphone.

/Nicklas

2

image.png1136×640 56.4 KB

Tadaaaa :smile:

2 Likes
3

Nice.

Would you mind sharing the code of what you did for others with a little explanation?

4 
<?php

error_reporting(0); //To avoid seeing that I am using an old SQL function

$conn = mysql_connect("user","password","") or die ("Problem"); //Connection to mySQL

mysql_select_db("database_name", $conn); //Connection to your database Xibo

$query = "SELECT * FROM display"; 
$result = mysql_query($query, $conn) or die(mysql_error()); 
if ($result) { 
echo "Svenska Batterilagret Status tv-apparater:<br><p></p>"; //The heading at the top of the page

echo "<table width=90% align=center border=1><tr> 

//Columns to be displayed
<td align=center bgcolor=#00FFFF>Index</td> 
<td align=center bgcolor=#00FFFF>Skärm</td> 
<td align=center bgcolor=#00FFFF>Licens</td> 
<td align=center bgcolor=#00FFFF>Inloggad</td> 
</tr>";

while ($r = mysql_fetch_array($result)) 
{
//Data from the table to be retrieved
$idx = $r["displayid"]; 
$f = $r["display"]; 
$e = $r["licensed"]; 
$a = $r["loggedin"];
echo "<tr> 
<td>$idx</td> 
<td>$f</td> 
<td>$e</td> 
<td>$a</td> 
</tr>"; 
} 
echo "</table>"; 
} else { 
echo "No data."; 
}
?>

Sorry for my bad english, have a nice weekend! :slight_smile:

1 Like
5

In 1.8 you’d replace this bit with an API call so that upgrades don’t break your code.

As a general point, do people think there is a “demand” for an Android/iOS app which shows this sort of “admin” data? We’ve had one planned for a long time (when I say “planned” I mean “it goes through my head occasionally”)

6

We would find an app for phones that can show us this information as being useful. Especially if it could alert us on the phone to a problem. I know there is currently email, but I think this would allow for better alerts and system health information much more quickly.

1 Like
7

I have a small problem.

For the database to be updated, if a screen is online or not, I have to log in and press “screens”.

Is it possible to cheat the system to update without logg in? Perhaps by calling any built in php file or similar?

Tnx /Nicklas

8

It’s uppdateing by itself then the screen go ONLINE, but not then it goes OFFLINE.

/Nicklas

9

You need to ensure you’ve setup the maintenance script to run per the instructions in the CMS Post Installation Guide:

https://community.xibo.org.uk/t/xibo-cms-post-installation-setup-guide/522

10

It should have been done, but I will check again.
Then I could let my php page calling the Script before I read the database, just for safe, knowing the information is updated.

11

It was a probleme with the maintenance script. Now its working :smile:

1 Like