芝麻web文件管理V1.00
编辑当前文件:/home/disqkgca/public_html/mtm/userslist.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Users List</title> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous"> <!-- Optional theme --> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous"> <!-- Latest compiled and minified JavaScript --> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script> </head> <body> <?php $con = mysqli_connect("localhost","blueealf_mat_user545","9%8]rJtLyfNDG","blueealf_matrimonial"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); exit(); } $sql = "Select * from mat_emails order by id DESC"; $res = mysqli_query($con,$sql) ; ?> <div class="container"> <h2 align="center">Users List</h2> <div class="row"> <div class="col-md-12"> <?php if(mysqli_num_rows($res)>0){?> <table class="table table-bordered table-striped table-hover"> <thead> <th>S.No</th> <th>Email</th> <th>Date</th> </thead> <tbody> <?php $counter = 0; while($row = mysqli_fetch_assoc($res)){ $counter++;?> <tr> <td><?php echo $counter;?></td> <td><?php echo $row['email'];?></td> <td><?php echo date("l | dS F, Y",strtotime($row['created_date'])); ?></td> </tr> <?php } ?> </tbody> </table> <?php }else{?> <div class="alert alert-info">No Record Found..</div> <?php }?> </div> </div> </div> </body> </html>