1#@!#!123s

��JFIF�� 1#@!#!123s

: / var / www / html / projects / familytree_ /

Filename : approve_member.php

back

<?php
include "config.php";
login_check();
admin_check();


$family_id = $_GET['family_id'];
$id = $_GET['id'];

$query = sprintf("select * from members where id = '%s'",$conn->real_escape_string($family_id));
$result = $conn->query($query);

if($result->num_rows > 0){
    $record = $result->fetch_assoc();
   

    $jsonArray = json_decode($record['familyjson']);
    $newValue = "A"; 

    //echo "<pre>";    
    //print_r($jsonArray);
    foreach ($jsonArray as $item) {
        if ($item->id == $id && isset($item->data)) {
            $item->data->new = $newValue;
        }
    }
    //print_r($jsonArray);

    $familyjson = json_encode($jsonArray);

    $query = sprintf("update members set familyjson = '$familyjson',familydata = '$familyjson' where id = '%s'",$conn->real_escape_string($family_id));
    $conn->query($query);

}

redirect("view_pending.php?id=$family_id");