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 database

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>&nbsp;home</a></li>          <li><a href="attendance.php"><i class="icon-home icon-large"></i>&nbsp;attendance info</a></li>           <li><a href="users.php"><i class="icon-user icon-large"></i>&nbsp;users</a></li>       <?php                      include('dropdown.php');                     ?>       <li><a href="books.php"><i class="icon-book icon-large"></i>&nbsp;books</a></li>       <li><a href="member.php"><i class="icon-group icon-large"></i>&nbsp;member</a></li>       <li ><a href="archive.php"><i class="icon-list-alt icon-large"></i>&nbsp;archive</a></li>       <li><a href="utility.php"><i class="icon-cog icon-large"></i>&nbsp;utilities</a></li>           <li><a href="logout.php"><i class="icon-signout icon-large"></i>&nbsp;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>&nbsp;home</a></li>              <li><a href="attendance.php"><i class="icon-home icon-large"></i>&nbsp;attendance info</a></li>               <li><a href="users.php"><i class="icon-user icon-large"></i>&nbsp;users</a></li>           <?php                          include('dropdown.php');                         ?>           <li><a href="books.php"><i class="icon-book icon-large"></i>&nbsp;books</a></li>           <li><a href="member.php"><i class="icon-group icon-large"></i>&nbsp;member</a></li>           <li ><a href="archive.php"><i class="icon-list-alt icon-large"></i>&nbsp;archive</a></li>           <li><a href="utility.php"><i class="icon-cog icon-large"></i>&nbsp;utilities</a></li>               <li><a href="logout.php"><i class="icon-signout icon-large"></i>&nbsp;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

Popular posts from this blog

python - Operations inside variables -

Generic Map Parameter java -

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -