PHP check_if_rack_exists Examples

Example #1

File: power_management.php Project: arjitc/DCIMStack

<?php

include_once 'libraries/general.php';
include_once 'config/db.php';
include_once 'libraries/power.php';
check_if_rack_exists($_GET['rackid']);
//this checks if the rack exists, if the rack does not exist it redirects the user back to index.php
?>

<div class="row">
  <div class="col-md-4">
  	<h4><center>Incoming feeds</center></h4>
  	<hr>
  	<?php 
include realpath(dirname(__FILE__)) . '/../config/db.php';
$rackid = mysqli_real_escape_string($conn, (int) $_GET['rackid']);
$sql = "SELECT * FROM `power_feeds` WHERE `rackid`='{$rackid}'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    // output data of each row
    while ($row = $result->fetch_assoc()) {
        $feedid = $row["feed_id"];
        echo "<div class='panel panel-default' data-toggle='tooltip' data-placement='top' title='Click to Edit'>";
        echo "<div class='panel-heading' href='manage_feeds.php?rackid={$rackid}&feedid={$feedid}' data-remote='false' data-toggle='ajaxModal' data-target='#myModal'>";
        echo "<center><h4>" . $row["feed_type"] . "</center>";
        echo "</div>";
        echo "<div class='panel-body'>";
        echo "<center><p>Power " . $row["feed_power"] . "A</center></p>";
        echo "<center><p>Voltage " . $row["feed_voltage"] . "V</center></p>";
        echo "</div>";
        echo "</div>";

Example #2

File: manage_feeds.php Project: darrentangdt/DCIMStack

<?php

include 'libraries/general.php';
include 'libraries/power.php';
include 'config/db.php';
$rackid = mysqli_real_escape_string($conn, $_GET['rackid']);
$feedid = mysqli_real_escape_string($conn, $_GET['feedid']);
check_if_rack_exists($rackid);
check_if_feed_exists($feedid);
$sql = "SELECT * FROM `rackspace` WHERE `rackid`='{$rackid}'";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $rackid = $row["rackid"];
        $rack_name = $row["rack_name"];
        $rack_size = $row["rack_size"];
        $rack_size_used = $row["rack_size_used"] . "U";
        $rack_city = $row["rack_city"];
        $rack_country = $row["rack_country"];
    }
}
?>
<div class="modal-dialog">
    <div class="modal-content">
        <div class="modal-header">
            <button type="button" class="close" data-dismiss="modal">&times;</button>
            <h4 class="modal-title">
                <i class="fa fa-plug"></i> Manage power feed - <?php 
echo power_feed_name($feedid);
?>
 - <?php