Guest User

Untitled

a guest
Nov 1st, 2017
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  1. <section class="target">
  2. <div class="container">
  3. <div class="row">
  4. <div class="col-lg-8">
  5. <h2>Зарегистированно участников:</h2>
  6. <?php
  7. include 'bd.php';
  8.  
  9. $results = mysql_query("SELECT COUNT(1) FROM register_user");
  10. $arrays = mysql_fetch_array($results);
  11.  
  12. while ($arrays = mysql_fetch_array($results)) {
  13. echo ""."<p>".$results."</p>"."";
  14. }
  15. ?>
  16. </div>
  17. </div>
  18. </div>
  19. </section>
  20.  
  21. <section class="target">
  22. <div class="container">
  23. <div class="row">
  24. <div class="col-lg-8">
  25. <h2>Зарегистированно участников:</h2>
  26. <?php
  27. $servername = "localhost";
  28. $username = "username";
  29. $password = "password";
  30. $dbname = "myDB";
  31.  
  32. // Create connection
  33. $conn = new mysqli($servername, $username, $password, $dbname);
  34. // Check connection
  35. if ($conn->connect_error) {
  36. die("Connection failed: " . $conn->connect_error);
  37. }
  38.  
  39. $sql = "SELECT COUNT(1) as Count FROM register_user";
  40. $result = $conn->query($sql);
  41.  
  42. if ($result->num_rows > 0) {
  43. // output data of each row
  44. while($row = $result->fetch_assoc()) {
  45. echo $row["Count"]";
  46. }
  47. } else {
  48. echo "0 results";
  49. }
  50. $conn->close();
  51. ?>
  52. </div>
  53. </div>
  54. </div>
  55. </section>
Add Comment
Please, Sign In to add comment