如何在PHP中显示mlm二进制谱系？ [英] How to display an mlm binary genealogy in PHP?

问题描述

美好的一天，你们，我正在尝试在php中为我的项目创建一个mlm二进制谱系，我坚持创建/显示家谱树。我到处搜索并得到了这个代码这就是我想要实现的目标。



我试图用我的函数实现它，到目前为止我无处可去。



这是我的代码。 />


这是我正在使用的数据库。



如果有人能帮我这个并向我解释为什么它不起作用会很精彩而且非常感激。



< b>我尝试了什么：

Hi and good day to you guys, I'm trying to create an mlm binary genealogy in php for my project, I'm stuck at creating/displaying the genealogy tree. I've search everywhere and got this code this is what I'm trying to achieve.

I'v tried to implement it using my function and so far I'm getting nowhere.

This is my code.

This is the database i'm working with.

If anyone could help me with this and explain to me why it's not working would be wonderful and very much appreciated.

What I have tried:

<div class="tree">
  <ul>
    <li>
      <div><input type="checkbox">181210-1-105547-1<br/> <button> Test Btn </button></div>
      <ul>

<?php
    $host = 'localhost';
    $name = 'mlm';
    $user = 'root';
    $pass = '';

    $dsn = 'mysql:host=' .$host .';dbname=' .$name;
    $options = array(
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_PERSISTENT => true
    );
    $conn = new PDO($dsn, $user, $pass, $options);

    function displayChildren($parent) {
        global $conn;

        $stmt = $conn->prepare('SELECT * FROM accounts WHERE sponsorUpline = ?');
        $stmt->bindValue(1, $parent);
        $stmt->execute();
        while($row = $stmt->fetch(PDO::FETCH_OBJ)) {
            echo '<li></div><input type="checkbox">' .$row->serialNumber .'</div></li>';
            displayChildren($row->serialNumber);
        }
  }

    displayChildren('181210-1-105547-1');

?>

      </ul>
    </li>
  </ul>
</div>

推荐答案

host = ' localhost';

host = 'localhost';

name = ' MLM';

name = 'mlm';

user = ' 根;

user = 'root';

这篇关于如何在PHP中显示mlm二进制谱系？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！