Guest User

Untitled

a guest
Dec 13th, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. <div class="tree">
  2. <ul>
  3. <li>
  4. <div><input type="checkbox">181210-1-105547-1<br/> <button> Test Btn </button></div>
  5. <ul>
  6.  
  7. <?php
  8. $host = 'localhost';
  9. $name = 'mlm';
  10. $user = 'root';
  11. $pass = '';
  12.  
  13. $dsn = 'mysql:host=' .$host .';dbname=' .$name;
  14. $options = array(
  15. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  16. PDO::ATTR_PERSISTENT => true
  17. );
  18. $conn = new PDO($dsn, $user, $pass, $options);
  19.  
  20. function displayChildren($parent) {
  21. global $conn;
  22.  
  23. $stmt = $conn->prepare('SELECT * FROM accounts WHERE sponsorUpline = ?');
  24. $stmt->bindValue(1, $parent);
  25. $stmt->execute();
  26. while($row = $stmt->fetch(PDO::FETCH_OBJ)) {
  27. echo '<li></div><input type="checkbox">' .$row->serialNumber .'</div></li>';
  28. displayChildren($row->serialNumber);
  29. }
  30. }
  31.  
  32. displayChildren('181210-1-105547-1');
  33.  
  34. ?>
  35.  
  36. </ul>
  37. </li>
  38. </ul>
  39. </div>
Add Comment
Please, Sign In to add comment