1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / familytree_ /
Filename : save_family.php
back
<?php 
include "config.php";

$id = $_POST['id'];

$family_name = $_POST['family_name'];

if($id){

    $query = sprintf("select * from families where family_name = '%s'",$conn->real_escape_string($family_name));
    $result = $conn->query($query);
    if($result->num_rows > 0){
        $user = $result->fetch_assoc();
        if($user['id'] != $id){
            set_session('familyname_exists',TRUE);
            redirect("add_family.php?id=".$id);
        }
    }
    
    $query = sprintf("update families set family_name = '%s' where id = '%s'",$conn->real_escape_string($family_name),$conn->real_escape_string($id));
    $conn->query($query);

    redirect("families.php");

}else{

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

    if($result->num_rows > 0){
        //exists
        set_session('familyname_exists',TRUE);
        redirect("add_family.php");
    }else{

        //newfamily
        $query = sprintf("insert into families(family_name) values('%s')",$conn->real_escape_string($family_name));
        $conn->query($query);

        redirect("families.php");
    }

}