BEST HOME INVENTORY MANAGEMENT SOFTWARE FREE AND EASY

Functions

OK since I included functions.php on the previous page, then we will discuss it here.  Notice I included the config file here. That is my connection to the database. I wanted to use pagination on the details page so I created a function to get the next and previous page.

<?php 
include_once('config.php');

function getnextid($var){
  global $con;
  global $uid;
  $result = $con->query("SELECT user, id FROM merch WHERE user='$uid' AND id>'$var' ORDER BY id ASC") ;
  $total=$result->num_rows;
  if($total>0){
  while ($row = $result->fetch_assoc()) {
  $usernextitem= $row['id'];
  }
  }else{
    $usernextitem=0;
  }
  return $usernextitem;
}

function getprevid($var){
  global $con;
  global $uid;
  $result = $con->query("SELECT user, id FROM merch WHERE user='$uid' AND id<'$var' ORDER BY id ASC") ;
  $total=$result->num_rows;
  if($total>0){
  while ($row = $result->fetch_assoc()) {
  $usernextitem= $row['id'];
  }
  }else{
    $usernextitem=0;
  }
  return $usernextitem;
}
?>

Footer

In the footer I wanted to see if we set a session. If so, I wanted to show a different menu for logged in users and logged out users. I handle this with CSS and PHP.

<?php
    if (isset($_SESSION['id'])) {
    echo '<style> 
    #hidee{display:none;}
    #show{display:block;}
    </style>';
    }else{
    echo '<style> 
    #hidee{display:block;}
    #show{display:none;}
    </style>';
  }
 ?>
</div>
</body>
</html>

Menu

Of course I am using bootstrap because it’s outstanding for mobile and desktops. However, notice the class names of hidee and show. If you look at the footer.php script above you will see that we are hiding menu items for logged in and logged out users.

<nav class="navbar navbar-default">
  <div class="container-fluid">
    <!-- Brand and toggle get grouped for better mobile display -->
    <div class="navbar-header">
      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
        <span class="sr-only">Toggle navigation</span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
        <span class="icon-bar"></span>
      </button>
      <a class="navbar-brand" href="index.php"><?php echo $name; ?></a>
    </div>

    <!-- Collect the nav links, forms, and other content for toggling -->
    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
      <ul class="nav navbar-nav">
        <li><a href="index.php">Home <span class="sr-only">(current)</span></a></li>
        <li><a href="login.php" id="hidee">Log In</a></li>
    <li><a href="signup.php" id="hidee">Signup</a></li>
    <li><a href="inventory.php" id="show">Inventory</a></li>
    <li><a href="enterinventory.php" id="show">Enter Inventory</a></li>
        <li id="hidee"><a href="lostpass.php">Lost Password</a></li>
        <li id="show"><a href="logout.php">Log Out</a></li>
      </ul>
      <form class="navbar-form navbar-right" method="post" action="search.php">
        <div class="form-group">
          <input type="text" name="search" class="form-control" placeholder="Search">
        </div>
        <button type="submit" class="btn btn-default">Submit</button>
      </form>
    </div><!-- /.navbar-collapse -->
  </div><!-- /.container-fluid -->
</nav>