Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.00 KB | None | 0 0
  1. $query= mysqli_query($link, "SELECT StationaryCustomersInfo.C_ID,
  2. StationaryCustomersInfo.C_RequestingDate, Employees.EMP_Fname, Employees.EMP_Mname, Employees.EMP_Lname, Employees.EMP_ipPhone, Employees.EMP_officeNo FROM StationaryCustomersInfo inner join Employees WHERE EMP_ID=$i");
  3.  
  4. while($row=mysqli_fetch_assoc($query)){
  5. ?>
  6.  
  7.  
  8. <br><br><table align="center" border='0' style=" line-height:30px; border-color: #020B58; font-size:25px;">
  9. <tr>
  10. <!-- &nbsp it's only for add space between the HTML words -->
  11. <!-- one &nbsp equal one, so the number of spaces depends on the number of &nbsp you entering -->
  12. <th style="width:800px; text-align:right;">ID:&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</th>
  13. <td style="width:800px;"><?php echo $row['C_ID']; ?></td>
  14. </tr>
  15. <tr>
  16. <th style="width:800px; text-align:right;">Name:&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</th>
  17. <td style="width:800px;"><?php echo $row1['EMP_Fname']." ".$row1['EMP_Mname']." ".$row1['EMP_Lname'];; ?></td>
  18. </tr>
  19. <tr>
  20. <th style="width:800px; text-align:right;">IP Phone:&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</th>
  21. <td style="width:800px;"><?php echo $row1['EMP_ipPhone']; ?></td>
  22. </tr>
  23. <tr>
  24. <th style="width:800px; text-align:right;">Office Number:&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</th>
  25. <td style="width:800px;"><?php echo $row1['EMP_officeNo']; ?></td>
  26. </tr>
  27. <tr>
  28. <th style="width:800px; text-align:right;">Requesting Date:&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp</th>
  29. <td style="width:800px;"><?php echo $row['C_RequestingDate']; ?></td>
  30. </tr>
  31.  
  32.  
  33.  
  34.  
  35. <?php
  36.  
  37. if(!$query){
  38.  
  39.  
  40. // die('Could not update data:');
  41.  
  42. echo '<script type="text/javascript">';
  43. echo "There is no Informations!";
  44. echo ' </script>';
  45.  
  46.  
  47. }else{
  48.  
  49.  
  50.  
  51.  
  52. }}
  53.  
  54. C_ID | EMP_Fname EMP_Mname EMP_Lname | EMP_ipPhone | EMP_officeNo | C_RequestingDate
  55. | | | |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement