php - How to retrieve the firstname from database using session -
i want display firstname database login in website - not username of user. here's picture of database tried query complains undefined index 
this navbar attendance there's navbar example attendance
navbar_attendance.php
<div class="navbar navbar-fixed-top navbar-inverse"> <div class="navbar-inner"> <div class="container"> <a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse"> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </a> <div class="nav-collapse collapse"> <ul class="nav"> <li><a href="dashboard.php"><i class="icon-home icon-large"></i> home</a></li> <li><a href="attendance.php"><i class="icon-home icon-large"></i> attendance info</a></li> <li><a href="users.php"><i class="icon-user icon-large"></i> users</a></li> <?php include('dropdown.php'); ?> <li><a href="books.php"><i class="icon-book icon-large"></i> books</a></li> <li><a href="member.php"><i class="icon-group icon-large"></i> member</a></li> <li ><a href="archive.php"><i class="icon-list-alt icon-large"></i> archive</a></li> <li><a href="utility.php"><i class="icon-cog icon-large"></i> utilities</a></li> <li><a href="logout.php"><i class="icon-signout icon-large"></i> logout</a></li> </ul> <div class="pull-right"> <div class="admin">welcome: <?php if(isset($_session['id'])){ // dont know put in here } ?></div> </div> </div> </div> </div> </div> <?php include('search_form.php'); ?> session.php
<?php if(!isset($_session)){ session_start(); } ?> <?php if (!isset($_session['id']) || (trim($_session['id']) == '')) { ?> <script>window.location='index.php';</script> <?php exit(); } $session_id=$_session['id']; ?>
hi need put query @ place want show first name.
<?php if(!isset($_session)){ session_start(); } ?> <div class="navbar navbar-fixed-top navbar-inverse"> <div class="navbar-inner"> <div class="container"> <a class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse"> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </a> <div class="nav-collapse collapse"> <ul class="nav"> <li><a href="dashboard.php"><i class="icon-home icon-large"></i> home</a></li> <li><a href="attendance.php"><i class="icon-home icon-large"></i> attendance info</a></li> <li><a href="users.php"><i class="icon-user icon-large"></i> users</a></li> <?php include('dropdown.php'); ?> <li><a href="books.php"><i class="icon-book icon-large"></i> books</a></li> <li><a href="member.php"><i class="icon-group icon-large"></i> member</a></li> <li ><a href="archive.php"><i class="icon-list-alt icon-large"></i> archive</a></li> <li><a href="utility.php"><i class="icon-cog icon-large"></i> utilities</a></li> <li><a href="logout.php"><i class="icon-signout icon-large"></i> logout</a></li> </ul> <div class="pull-right"> <div class="admin">welcome: <?php if(isset($_session['id'])){ $sql="select firstname tablename user_id='$session_id'"; $result=mysqli_query($link,$sql); if(mysqli_num_rows($result)>0) { while($row= mysqli_fetch_assoc($result)){ echo $row['firstname']; } } } ?></div> </div> </div> </div> </div> </div> <?php include('search_form.php'); ?>`
Comments
Post a Comment