public function getalldownlineAction()
{
if (isset($this->_params['member_id'])) {
$memberItem = MemberItem::find($this->_params['member_id']);
$downlineArray = $memberItem->getTree();
//return the todo item in array format
return $downlineArray;
}
return array();
}
public static function getmemberAction($username, $userpass)
{
self::_checkIfUserExists($username, $userpass);
//get the array version of this todo item
// $member_array = $this->toArray();
//save the serialized array version into a file
// $servername = "localhost";
// $username = "******";
// $password = "";
// $dbname = "servertest";
// Create connection
$conn = new mysqli(MemberItem::DB_SERVER, MemberItem::DB_USER, MemberItem::DB_PASSWORD, MemberItem::DB_NAME);
//$conn = new mysqli($db_server, $db_user, $db_password, $db_name);// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM members";
$result = $conn->query($sql);
$members = array();
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
$member = new MemberItem();
$member->member_id = $row["member_id"];
$member->username = $row["username"];
$member->name = $row["name"];
$member->tgllahir = $row["tgllahir"];
$member->tglaplikasi = $row["tglaplikasi"];
$member->sponsor_id = $row["sponsor_id"];
$member->introducer_id = $row["introducer_id"];
array_push($members, $member->toArray());
}
} else {
echo "0 results";
}
$conn->close();
return $members;
}
