Jump to content

Jimmy85

Members
 View Profile  See their activity

  • Posts

    15

  • Joined

  • Last visited

Jimmy85's Achievements

Member

Member (2/5)

0

Reputation

  1. Jimmy85
    I am a bit confused on how to get the functions sorted as your example only show one line of html in $tdata where I have multiple lines for example how would i do $table = <tbody> <tr> <td>IP Address: {$ip['ip']}</td> <td VALIGN = Middle Align = Center>Unit Name: {$ip['name']}</td> </tr> <tr> <td>Status is: $successValue</td> <td VALIGN = Middle Align = Center>" . ($successValue == "UP" ? "<img src='/Images/GTick.jpg'>" ."<span style='color:#FFFFFF'>". $SC++ ."</span>" : "<img src='/Images/RTick.jpg'>" . "<span style='color:#FFFFFF'>".$FC++ ."</span>"). "</td> </tr> </tbody> "; } "</table>"; Like your $tdata variable
  2. Jimmy85
    Sorry Barand, I am confused by what your saying, basically i would like to keep the array as it is but move the System online and system offline count above the array at the top of page. Sorry to be annoying but I am trying to self teach PHP for a project.
  3. Jimmy85
    Would there be anyway of getting the count at the top of the page at all?
  4. Jimmy85
    Hi, As promised here is the code this is my functions.php: <?php //$GLOBAL Variables //$GLOBALS['SC'] = 0; //$GLOBALS['FC'] = 0; //$GLOBALS['countup'] = 0; //$GLOBALS['countdown'] = 0; function completedJC(){ //completed call count include 'SqlConn.php'; $sql = "Select Count(Status) from EXCELMACRO...Jobs$ where Status = 'Completed'"; $stmt = $conn->query($sql); $stmt->execute(); $resultCompleted = $stmt->fetchColumn(); echo $resultCompleted; } function inprogressJC(){ //In-progress call count include 'SqlConn.php'; $sql = "Select Count(Status) from EXCELMACRO...Jobs$ where Status = 'In-Progress'"; $stmt = $conn->query($sql); $stmt->execute(); $resultInprogress = $stmt->fetchColumn(); echo $resultInprogress; } function OnHoldJC(){ //On-hold call count include 'SqlConn.php'; $sql = "Select Count(Status) from EXCELMACRO...Jobs$ where Status = 'ON-HOLD'"; $stmt = $conn->query($sql); $stmt->execute(); $resultOnHold = $stmt->fetchColumn(); echo $resultOnHold; } function CriticalSystem(){ //array for critical devices //Black #000000 //White #FFFFFF $SC = 0; $FC = 0; $countup = 0; $countdown = 0; $systems = array( array('ip' => '192.168.9.254', 'name' => 'Tech Swtich'), array('ip' => '192.168.9.205', 'name' => 'Printer'), array('ip' => '192.168.9.200', 'name' => 'Sales Printer'), array('ip' => '192.168.9.201', 'name' => 'Admin Printer'), array('ip' => '192.168.9.1', 'name' => 'KVM'), array('ip' => '192.168.9.2', 'name' => 'Office Data 24 Port'), array('ip' => '192.168.9.3', 'name' => 'Office Data 48 Port'), array('ip' => '192.168.9.4', 'name' => 'Office Voice 48 Port'), array('ip' => '192.168.9.7', 'name' => 'Warehouse Switch'), array('ip' => '192.168.9.13', 'name' => 'Foundry Canteen Switch'), ); //Result to search for to give success result $good = "Received = 1"; $successValue; //troubleshooting to see if being re-freshed //echo "<h1>Site Status ".date("h:i:s")."</h1>"; echo "<table border='0' class='table'>"; // foreach loop to ping IP and check if alive or dead & dispaly result foreach ($systems as $ip) { unset($result); $successValue = "DOWN"; exec("ping -n 1 $ip[ip]", $result); foreach($result as $line) { if (strpos($line,$good) == TRUE){ $successValue = "UP"; //$count = $successValue; } } echo "<tbody> <tr> <td>IP Address: {$ip['ip']}</td> <td>Unit Name: {$ip['name']}</td> </tr> <tr> <td>Status is: $successValue</td> <td>" . ($successValue == "UP" ? "<img src='/Images/GTick.jpg'>" ."<span style='color:#000000'>". $SC++ ."</span>" : "<img src='/Images/RTick.jpg'>" . "<span style='color:#000000'>".$FC++ ."</span>"). "</td> </tr> </tbody> "; } echo"</table>"; //debug dispaly full result of ping request //var_dump($result); $countup = array($SC); $countdown = array($FC); print_r($countup); //Print_r($countdown); } function countupdown(){ global $SC, $FC, $countup, $countdown; echo "<center>"; echo "<br></br>"; echo "<img src='/Images/GTick.jpg'>". " " . "Systems Online = ".$countup; echo "<br></br>"; echo "<img src='/Images/RTick.jpg'>". " ". "Systems Offline = ".$countdown; echo "</center>"; print_r($countup); } ?> Here is my index.php <!doctype html> <html lang="en"> <?php //Function Scripts //SqlConn include 'SqlConn.php'; //Completed Job Count include 'Functions.php'; ?> <head> <title>Support Desk</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content="James Stirling"> <meta name="generator" content="Hugo 0.98.0"> <meta http-equiv="refresh" content="5" <link rel="apple-touch-icon" sizes="180x180" href="/apple-touch-icon.png"> <link rel="icon" type="image/png" sizes="32x32" href="favicon/favicon-32x32.png"> <link rel="icon" type="image/png" sizes="16x16" href="favicon/favicon-16x16.png"> <link rel="manifest" href="favicon/site.webmanifest"> <link rel="mask-icon" href="favicon/safari-pinned-tab.svg" color="#5bbad5"> <meta name="msapplication-TileColor" content="#da532c"> <meta name="theme-color" content="#ffffff"> <link rel="canonical" href="https://getbootstrap.com/docs/5.2/examples/features/"> <link href="/docs/5.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-0evHe/X+R7YkIZDRvuzKMRqM+OrBnVFBL6DOitfPri4tjfHxaWutUpFmBp4vmVor" crossorigin="anonymous"> </head> <!-- <title>Support Desk</title> --> <body> <style> .btn-primary { --bs-btn-color: #fff; --bs-btn-bg: #007A53; --bs-btn-focus-shadow-rgb: 49, 132, 253; --bs-btn-active-shadow: inset 0 3px 5px rgba(0, 0, 0, 0.125) } .b-divider { height: 3rem; background-color: rgba(0, 0, 0, .1); border: solid rgba(0, 0, 0, .15); border-width: 1px 0; box-shadow: inset 0 .5em 1.5em rgba(0, 0, 0, .1), inset 0 .125em .5em rgba(0, 0, 0, .15); } </style> <main> <!-- Calls Logged --> <div class="container px-4 py-5" id="hanging-icons"> <center> <h2 class="pb-2 border-bottom">Hargreaves Foundry & Drainage Critical System Status Page</h2> </center> </div> <div class="container px-4 py-5" id="hanging-icons"> <h2 class="pb-2 border-bottom">Open Calls: View all status of IT faults</h2> <div class="row g-4 py-5 row-cols-1 row-cols-lg-3"> <div class="col d-flex align-items-start"> <div class="icon-square bg-light text-dark d-inline-flex align-items-center justify-content-center fs-4 flex-shrink-0 me-3"> </div> <div> <h2>Completed: (<?php completedJC();?>)</h2> <p>Number of all calls that have been completed for each department and staff member.</p> </div> </div> <div class="col d-flex align-items-start"> <div class="icon-square bg-light text-dark d-inline-flex align-items-center justify-content-center fs-4 flex-shrink-0 me-3"> </div> <div> <h2>In-Progress: (<?php inprogressJC();?>)</h2> <p>Number of open calls and the progress of the call for a department or staff member.</p> </div> </div> <div class="col d-flex align-items-start"> <div class="icon-square bg-light text-dark d-inline-flex align-items-center justify-content-center fs-4 flex-shrink-0 me-3"> </div> <div> <h2>ON-HOLD: (<?php OnHoldJC();?>)</h2> <p>Number of calls placed ON-HOLD for what ever reason or awaiting input from a third party.</p> </div> </div> </div> </div> <div class="b-divider"></div> <!-- Critical Systems --> <div class="container px-4 py-5" id="hanging-icons"> <h2 class="pb-2 border-bottom">Critical Systems Online\Offline Count</h2> <?php countupdown(); ?> </div> <div class="b-divider"></div> <!-- Critical Systems --> <div class="container px-4 py-5" id="hanging-icons"> <h2 class="pb-2 border-bottom">Critical Systems Ping Check</h2> <?php CriticalSystem(); ?> </div> </main> <div class="b-divider"></div> <script src="/docs/5.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-pprn3073KE6tl6bjs2QrFaJGz5/SUsLqktiwsUTF55Jfv3qYSDhgCecCxMW52nD2" crossorigin="anonymous"></script> </body> <footer class="py-3 my-4"> <ul class="nav justify-content-center border-bottom pb-3 mb-3"> </ul> <p class="text-center text-muted">© 2022 Hargreaves Foundry & Drainage, Inc</p> <center> <img src="docs/5.2/images/image1.png" style="width:40px;height:40px;margin-top:20px" /> </center> </footer> </html> Any question please ask. Thanks James
  5. Jimmy85
    I will post full code tommorow as OOF at the moment and no access to my test pc.
  6. Jimmy85
    Basically the numbers function was only a example to see if I could do what I require. The $sc (successfully count) and $fc (failed count) increments after each field is populated from an array I would like to count the $sc and $fc numbers using a separate function Using: $countup = array($SC); $countdown = array($FC); Works fine in my other function but I want to pull $sc and $fc value into my other function populating the number of ok pings and failed pings
  7. Jimmy85
    Hi Barand, I have extended your code you kindly changed for me and i am wanting to count how many successful pings i have and how many unsuccessful pings i have using <td>" . ($successValue == "UP" ? "<img src='/Images/GTick.jpg'>" ."<span style='color:#000000'>". $SC++ ."</span>" : "<img src='/Images/RTick.jpg'>" . "<span style='color:#000000'>".$FC++ ."</span>"). "</td> then $countup = array($SC); $countdown = array($FC); With a separate function function countupdown(){ global $SC, $FC, $countup, $countdown; echo "<center>"; echo "<br></br>"; echo "<img src='/Images/GTick.jpg'>". " " . "Systems Online = ".$countup; echo "<br></br>"; echo "<img src='/Images/RTick.jpg'>". " ". "Systems Offline = ".$countdown; echo "</center>"; } Then possibly use the array count values to get the numbers for the attached image
  8. Jimmy85
    Hi, Can you have a function for example <?php function Numbers(){ $SC = 0; $FC = 0; $countup = 0; $countdown = 0; $countup = array($SC); $countdown = array($FC); } ?> Then using the global call a variable from the above function function countupdown(){ global $countup, $countdown; echo "<center>"; echo "<br></br>"; echo . "Systems Online = ".$countup; echo "<br></br>"; echo . "Systems Offline = ".$countdown; echo "</center>"; } ?> Or is this bad practice and what is good practice to do what i am trying to achieve.
  9. Jimmy85
    Thanks Barand, Is there anyway I could count the number of up services and down services i am currently doing some research on how to do this but coming up with blanks I appreciate the assistance so far.
  10. Jimmy85
    Hi, my table is built up of array items basically the array item is the table isn't like the others and i cannot work it out. (I have attached a image to show you what it looks like) Here is my code:
  11. Jimmy85
    Hi, Basically I have written this PHP script to ping address on my network and then I would like to add the name that defines that IP after my image if successful or not. I am struggling on the name part can anyone assist? My code is below: <?php $systems = array("192.168.9.254","192.168.9.205","192.168.9.200","192.168.9.201","192.168.9.1","192.168.9.2","192.168.9.3","192.168.9.4","192.168.9.7","192.168.9.13"); $Sysname = array("Item1","Item2","Item3","Item4","Item5","Item6","Item7","Item8","Item9"); $good = "Received = 1"; $successValue; //echo "<h1>Site Status ".date("h:i:s")."</h1>"; echo "<br><br>"; foreach ($systems as $ip) { unset($result); $successValue = "DOWN"; exec("ping -n 1 $ip", $result); foreach($result as $line) { if (strpos($line,$good) == TRUE){ $successValue = "UP"; } } echo "IP Address: ".$ip." "; If ($successValue == "UP") { echo "System is ".$successValue. "&nbsp;"."<img src='/Images/GTick.jpg'>"."&nbsp;"; }else{ echo "System is ".$successValue. "&nbsp;"."<img src='/Images/RTick.jpg'>"."&nbsp;"; } echo "<br><br>"; //var_dump($result); } ?> Cheers James
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.