Using PHP to swap images from dynamic MySQL data?

bluetiger

1st: I'm completely new to this.
2nd: The scenario-> Using SNMP, a third party software app polls the network status of various routers & switches. It then generates scripts (which can be tailored using K shell/vi) that are to be dumped into a MySQL database. This polling is done at 45-60 second intervals. The various scripts for each device denote whether the device has met a certain threshold for connectivity, usage, etc. The goal is to design a PHP-driven page that refreshes every 60 to 120 seconds that reflects the dynamic state of the network devices. If all devices in a particular building are OK, then an image should show a green color. If there are minor problems, then a yellow image should be displayed. Serious problems would show a red image.
3rd: My task is to use PHP to insert the data from the scripts into the MySQL database & then to pull it back out to show how the network is doing on a constant basis. Make sense? I'm in over my head and need serious help. Will gladly clarify anything I've typed.....😕

weekender

i'm not quite sure what you want... but here goes 🙂

if the scripts are saved in a location accessible to php (i.e. anywhere under /www/ root) then you can use php to pull in the whole file (or, more complex, parts of the file/variables from the file) and then use php to post these into a database.

Then write a section to pull out the details from the database and interpret them, and set one of the page headers to auto-refresh the page every x seconds.

let me know if i can help more

adam

bluetiger

examples of the code that I can learn how to do it myself?....
I don't necessarily want it done for me because I have to learn this in order to maintain it over the long haul.
Essentially, I need PHP to determine from the database if certain values are in a given table and then to display that data as dynamically as the data is put into the table. I have even thought of changing background cell colors based on data instead of trying to load & reload images. Speed, scalability, and reliabbilty are huge factors? Any ideas?

Examples of code, websites, anything that can point me in the right direction would be greatly appreciated.

weekender

sorry, i'm still learning myself. The php help is very good - you can use it online at http://www.php.org or download it from there, and it has some good examples.

i will have a look when i have more time and give you some topics to look at. sorry i can't take more time right now, some guy tried to mug me last night and i'm due at the police station!

bluetiger

So far.....I have set up the database in MySQL without a problem.
I can pull the data out using PHP and display it as a list as well. I'm using a met-refresh tag to keep the page refreshing every 60 seconds. To test out the PHP, I have altered the database so I can ensure that the code is dynamic. So far, so good.

Now, I need to be able to format the data in a table layout, where I can change cell background colors, etc. Until I can perform an actual image swap, maybe I can have cell background colors change as the data changes? Now I need to be able to write PHP code to insert data froma text file into the MySQL database before the web page refreshes the data, and I need to get the data interpreted in PHP for the image/color swap? Any ideas on the next step?

bluetiger

How to put text from a text file into a MySQL database?

bluetiger

anyone??

weekender

sorry... i can't use the site at work and haven't been back to my own place for a few nights!

all i can think of at the moment is using passthru to execute the script and return the output into a variable, which you can then post to a database.

not sure above that... i'd have to know how snmp works - at command line? i need to see it run i think, examples of input and output etc.