· 9 years ago · Nov 04, 2016, 08:22 AM
1CREATE TABLE IF NOT EXISTS `members` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `regDate` date NOT NULL,
4 `memberID` varchar(20) NOT NULL,
5 `sponsor` int(10) NOT NULL,
6 `position` varchar(5) NOT NULL,
7 `firstname` varchar(50) NOT NULL,
8 `lastname` varchar(50) NOT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;
11
12INSERT INTO `members` (`id`, `regDate`, `memberID`, `sponsor`, `position`, `firstname`, `lastname`) VALUES
13(1, '2016-10-01', 'S0000000', 0, '', 'Fred', NULL),
14(2, '2016-10-02', 'S5483002', 1, '', 'John', NULL),
15(3, '2016-10-03', 'S6182013', 2, 'Lt', 'Innorlito', NULL),
16(4, '2016-10-03', 'S6325681', 18, 'Lt', 'Sarah', NULL),
17(5, '2016-10-04', 'S6329592', 3, 'Lt', 'Imelda', NULL),
18(6, '2016-10-06', 'S6345140', 5, 'Rt', 'Diane', NULL),
19(7, '2016-10-05', 'S6325799', 4, 'Lt', 'John III', NULL),
20(8, '2016-10-05', 'S6356038', 4, 'Rt', 'Myda', NULL),
21(9, '2016-10-07', 'S6358217', 7, 'Lt', 'Rondale', NULL),
22(10, '2016-10-07', 'S6506318', 7, 'Rt', 'Rosana', NULL),
23(11, '2016-10-08', 'S6356151', 8, 'Lt', 'Wiljames', NULL),
24(12, '2016-10-08', 'S6456156', 8, 'Rt', 'Mark', NULL),
25(13, '2016-10-09', 'S6379249', 16, 'Rt', 'Maria Fe', NULL),
26(14, '2016-10-09', 'S6345177', 6, 'Lt', 'Penafrancia', NULL),
27(15, '2016-10-10', 'S6345204', 6, 'Rt', 'Ruth', NULL),
28(16, '2016-10-04', 'S6345083', 5, 'Lt', 'Maricel', NULL),
29(17, '2016-10-11', 'S6345905', 16, 'Lt', 'Elena', NULL),
30(18, '2016-10-18', 'S6320374', 2, 'Rt', 'Myrna', NULL),
31(19, '2016-10-19', 'S6383350', 3, 'Rt', 'Reynaldo', NULL),
32(20, '2016-10-17', 'S6383593', 19, 'Lt', 'Narcisa', NULL),
33(21, '2016-10-17', 'S6510270', 19, 'Rt', 'Juanita', NULL),
34(22, '2016-11-02', 'S6384918', 20, 'Lt', 'Arsenia', NULL),
35(23, '2016-11-02', 'S6385105', 20, 'Rt', 'Zusara', NULL),
36(24, '2016-11-04', 'S6511807', 21, 'Lt', 'Vivian', NULL);
37
38if(!isset($_SESSION['MM_id']) || $_SESSION['MM_id'] == '') {
39 $id=2;
40} else {
41 $id = $_SESSION['MM_id'];
42}
43
44$sql = "SELECT * FROM members WHERE `id`=:id";
45$query = $conn->prepare($sql);
46$query->bindValue(':id', $id, PDO::PARAM_INT);
47$query->execute();
48$result = $query->fetch(PDO::FETCH_ASSOC);
49$totalRows = $query->rowCount();
50
51$sql = "SELECT * FROM members WHERE `id` > :id ORDER BY `sponsor` ASC, `id` ASC";
52$query_rsMembers = $conn->prepare($sql);
53$query_rsMembers->bindValue(':id', $id, PDO::PARAM_INT);
54$query_rsMembers->execute();
55$result_rsMembers = $query_rsMembers->fetch(PDO::FETCH_ASSOC);
56$totalRows_rsMembers = $query_rsMembers->rowCount();
57
58$tree = ''; // create an empty tree variable
59$used = ''; // create an empty used variable
60//echo 'This is the order that the records were pulled<br>';
61do {
62$sid = $result_rsMembers['sponsor'];
63$sql = "SELECT * FROM members WHERE `sponsor` = :sid AND `id` != :used ORDER BY `position`";
64$query_rsTree = $conn->prepare($sql);
65$query_rsTree->bindValue(':sid', $sid, PDO::PARAM_STR);
66$query_rsTree->bindValue(':used', $used, PDO::PARAM_INT);
67$query_rsTree->execute();
68$result_rsTree = $query_rsTree->fetch(PDO::FETCH_ASSOC);
69$totalRows_rsTree = $query_rsTree->rowCount();
70$used = $result_rsTree['id'];
71$tree .= '<div align="center" style="border-style: inset; margin:0 0 10px 10px; font-family:Arial, Helvetica, sans-serif; font-size:12px;"><span>'.$result_rsTree['firstname'].'<br>'.$result_rsTree['memberID'].'<br>'.$result_rsTree['regDate'].'</span></div>';
72//echo $result_rsTree['firstname'].'<br>';
73} while ($result_rsMembers = $query_rsMembers->fetch(PDO::FETCH_ASSOC));
74
75$timenow = time() + 28800;
76
77<!doctype html>
78<html>
79<head>
80<meta charset="utf-8">
81<title>Binary Tree</title>
82<script type="text/javascript" src="inc/wz_jsgraphics.js?v=<?php echo $timenow ?>"></script>
83<script type="text/javascript" src="../js/jquery/jquery-1.12.4.js?v=<?php echo $timenow ?>"></script>
84<script type="text/javascript" src="inc/jquery.btree.js?v=<?php echo $timenow ?>"></script>
85<script type="text/javascript">
86var myTree;
87$(document).ready(function(){
88 myTree = $("#treeDiv").btree()[0];
89});
90
91function mich(){
92 $("#box1").css("left", "");
93 alert($("#box1").css("left") + " - " + $("#box1").css("right"));
94}
95</script>
96</head>
97
98<body>
99<div id="treeDiv" style="vertical-align:text-top; overflow:hidden; min-height:400px; min-width:1000px; border-style:solid; border-width: 3px; border-color: #000000;">
100 <?php echo $tree ?>
101 <div align="center" style="border-style: inset; margin:0 0 10px 10px; font-family:Arial, Helvetica, sans-serif; font-size:12px;" id="box1">
102 <span><?php echo $result['firstname'].'<br>'.$result['memberID'].'<br>'.$result['regDate'] ?></span>
103 </div>
104</div>
105</body>
106</html>